Complete QBO to IIF Conversion Guide

A step-by-step tutorial for converting your bank's QBO or OFX files to IIF format for QuickBooks® Desktop.

In This Guide

1Downloading QBO Files from Your Bank
2Uploading to Our Converter
3Configuring Account Settings
4Selecting Transactions
5Downloading Your IIF File
6Importing into QuickBooks® Desktop

1. Downloading QBO Files from Your Bank

Most banks offer QBO or OFX file downloads through their online banking portal. Here's how to find them:

Chase

Bank of America

Wells Fargo

Capital One

Tip: Look for options labeled "Web Connect", "QuickBooks®", "QBO", or "OFX". These are all compatible with our converter.

2. Uploading to Our Converter

Once you have your QBO or OFX file, upload it to our converter:

Go to the Converter

Navigate to our QBO to IIF Converter page

Upload Your File

Drag and drop your .qbo or .ofx file, or click to browse

Wait for Processing

The file is parsed instantly in your browser

Security Note: Your file is processed entirely in your browser. No data is uploaded to any server — your financial information stays on your computer.

3. Configuring Account Settings

Before converting, configure the account names that will be used in QuickBooks®:

Bank Account Name

Enter the exact name of your bank account as it appears in your QuickBooks® Chart of Accounts. For example: "Chase Checking", "Business Savings", or "Operating Account".

Default Expense Account

Choose where expenses will be categorized by default. You can use a catch-all like "Uncategorized Expense" or "Ask My Accountant", then recategorize in QuickBooks® later.

Important: Account names must match exactly with your QuickBooks® Chart of Accounts. If an account doesn't exist, QuickBooks® will create it during import.

4. Selecting Transactions

Review the parsed transactions and select which ones to include:

Select All — Use the checkbox in the header to select/deselect all transactions
Individual Selection — Check or uncheck individual transactions
Review Details — Verify dates, amounts, and descriptions look correct

Tip: Exclude transactions you've already entered in QuickBooks® to avoid duplicates.

5. Downloading Your IIF File

Once you've configured settings and selected transactions:

Click "Download IIF"

The converter generates your IIF file

Save the File

Choose a location you can easily find, like your Desktop

Verify the Download

Open the .iif file in a text editor to spot-check the content

6. Importing into QuickBooks® Desktop

To import your IIF file into QuickBooks® Desktop:

Open QuickBooks® Desktop

Make sure you're in single-user mode

Go to File Menu

Select File → Utilities → Import → IIF Files

Select Your File

Browse to and select the downloaded .iif file

Review Import

Check the imported transactions in your register

Best Practice: Before importing, create a backup of your company file. Go to File → Back Up Company → Create Local Backup.

Ready to Convert?

Try our free QBO to IIF converter now. Just create a quick free account to get started.

Start Converting Free

Loading converter...

All Guides