Formats and workflows

QBO file: what it is and how to open or import one

A QBO file is the QuickBooks Web Connect bank download, built on OFX. What is inside, how to import it into QuickBooks, and how to open or check one.

By Updated Last verified

On this page
  1. What is inside a QBO file
  2. QBO, QFX and OFX
  3. How to import a QBO file into QuickBooks
  4. How to open a QBO file without QuickBooks
  5. When QuickBooks won't import a QBO file
  6. Getting a QBO file from a PDF statement
  7. Sources

A QBO file (.qbo) is the bank transaction file QuickBooks imports through Web Connect: you download it from your bank's website and import it into QuickBooks (Intuit (opens in a new tab)). Despite the name, it is not QuickBooks Online itself, which is also often shortened to QBO. To see what a file contains, open it in the free QBO viewer; to check it before importing, use the QBO file validator.

What is inside a QBO file

QBO files are based on Open Financial Exchange (OFX), with extra QuickBooks-specific information that identifies the financial institution (FileInfo (opens in a new tab)). OFX is a specification that Intuit, Microsoft and CheckFree created jointly in 1997, and that Quicken and QuickBooks use to exchange financial data with other software (Intuit (opens in a new tab)).

Under the OFX specification, each transaction has a posting date, an amount signed from the customer's point of view, and an ID (FITID) that must be unique within the account so that software can detect duplicates. A ledger balance block gives the balance amount and the date it applies to (OFX specification (opens in a new tab)).

A single transaction looks like this in an OFX 1.x file (example values):

<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260903120000
<TRNAMT>-1850.00
<FITID>20260903-0002
<NAME>RENT SEPTEMBER
</STMTTRN>

Check a QBO, QFX or OFX file

See whether a bank file is well formed before you import it: dates, amounts, transaction IDs and the account block. Free, no account, nothing stored.

Open the file checker Convert a PDF statement

QBO, QFX and OFX

Intuit describes Web Connect as a file the user downloads from online banking: a .qbo file for QuickBooks or a .qfx file for Quicken (Intuit (opens in a new tab)). Other software reads these files too. Xero, for example, imports OFX, QFX and QuickBooks files, and recommends OFX over QIF, QFX, CSV or QuickBooks files where the bank offers it (Xero Central (opens in a new tab)).

How to import a QBO file into QuickBooks

QuickBooks Desktop for Windows. Go to Banking, then Bank Feeds, then Import Web Connect Files, and choose the file. QuickBooks asks whether to use an existing account or create a new one (Intuit (opens in a new tab)). Intuit's QuickBooks Desktop help says a .qbo file is the only type Web Connect can read, and that importing one requires you to sign in to your Intuit Account within QuickBooks Desktop (Intuit (opens in a new tab)). An import cannot be undone, so back up the company file first (Intuit (opens in a new tab)).

QuickBooks Desktop for Mac. Go to Banking, then Downloaded Transactions, then Import File, and pick the .qbo file (Intuit (opens in a new tab)).

QuickBooks Online. In Bank transactions, open the Link account menu and choose Upload from file. Intuit's US help says QBO, QFX and CSV uploads must be 350 KB or less, and a .csv, .qbo or .ofx upload can have up to 1,000 lines (one transaction each), so split a long period into smaller files (Intuit (opens in a new tab)).

How to open a QBO file without QuickBooks

Xero describes OFX, QFX and QuickBooks files as text file formats (Xero Central (opens in a new tab)), so a text editor shows tags like the ones above. For a readable table:

  • The QBO viewer lists every transaction with its date, type, name, memo and amount.
  • OFX to CSV turns the file into a spreadsheet with one row per transaction and the FITID kept.
  • The QBO file validator checks the header, account block, dates, amounts and transaction IDs.

None of these store the file.

When QuickBooks won't import a QBO file

"QuickBooks is unable to verify the Financial Institution information for this download." This QuickBooks Desktop error appears for Web Connect files. Intuit's fixes are to use a supported version of QuickBooks Desktop, sign in to your Intuit Account in QuickBooks, and ask the bank to confirm your accounts are set up for Web Connect (Intuit (opens in a new tab)). Intuit's partner pages (opens in a new tab) say Web Connect is tied to a contracted Intuit BID (Branding ID). QuickBooks Desktop 2023 was discontinued after May 31, 2026, and Intuit says uploading transactions is discontinued on it too (Intuit (opens in a new tab)).

"Nothing imported. Account up to date." QuickBooks for Mac stores the ID of every transaction it adds or matches and ignores transactions with an ID it has already seen, to prevent duplicate entries (Intuit (opens in a new tab)). The message means QuickBooks has already stored the IDs of the transactions in the file.

A problem inside the file. Intuit lists incomplete bank files and incompatible formats among the causes of Web Connect issues. The QBO file validator checks the file's structure, dates, amounts and transaction IDs and names the transactions affected. A file that passes can still be refused for the reasons above.

Getting a QBO file from a PDF statement

When the bank only gives you a PDF, a converter can build the QBO file. StatementLoom reads text PDF statements, checks that the opening balance plus every transaction equals the closing balance, and only then lets you download a QBO file (PDF to QBO). The free converter reads up to 10 pages a day without an account and downloads Excel or CSV; QBO downloads need a free account.

Sources

Tools for this

Frequently asked questions

Is a QBO file the same as QuickBooks Online?

No. QBO is also short for QuickBooks Online, but a .qbo file is a bank download of transactions that QuickBooks Desktop and QuickBooks Online can import.

Can I open a QBO file without QuickBooks?

Yes. It is a text file, so a text editor shows its contents, and a QBO viewer lists the transactions in a table or converts them to CSV.

Why does QuickBooks import nothing from my QBO file?

QuickBooks for Mac ignores transactions whose IDs it has already stored, so a file that was imported before brings nothing in and shows Nothing imported. Account up to date.

How do I get a QBO file when my bank only gives me a PDF?

Convert the PDF statement to a QBO file with a converter, check that its transactions add up to the statement balances, then import it like a bank download.

Check a QBO, QFX or OFX file

See whether a bank file is well formed before you import it: dates, amounts, transaction IDs and the account block. Free, no account, nothing stored.

Open the file checker Convert a PDF statement