What is a QBO file, and what application opens it?

QBO the file versus QBO the product

Bookkeepers often write QBO for QuickBooks Online, so a question like “how do I get my bank statement into QBO” is usually about the product, not the file. A .qbo file is the bank download. Intuit’s own upload guide adds to the confusion by describing it as a QuickBooks Online data (QBO) file, yet the same file type is what QuickBooks Desktop’s Web Connect reads.

A .qbo file is also different from a QuickBooks company file. It holds transactions for one bank or card account, ready to import, not your books.

What is inside a .qbo file

Open a .qbo file in a text editor and you see OFX: a header, a sign-on block, the account number in ACCTID, one STMTTRN block per transaction with its date, signed amount, description and FITID, and a ledger balance. The OFX file guide explains each tag with an annotated example.

Intuit says every account and transaction inside a Web Connect file has a unique identifier, that QuickBooks stores those IDs when transactions are added or matched, and that it will not import a transaction with the same ID twice.

Why banks offer QBO downloads

Intuit describes Web Connect as a connection that starts in your online banking: you download a .qbo (QuickBooks) or .qfx (Quicken) file and import it, without entering bank credentials in QuickBooks. Intuit lists QuickBooks Desktop, QuickBooks Online and Quicken as products that support Web Connect.

A bank needs a contract with Intuit, or with its online banking provider, to offer Web Connect, and each connection is tied to a contracted Intuit Branding ID (BID). That is why the QuickBooks option appears at some banks and not others, and why Intuit’s troubleshooting article allows for banks that no longer use Web Connect.

How QuickBooks Desktop uses a QBO file

For QuickBooks Desktop, the .qbo file is the only route for Web Connect. Intuit’s troubleshooting article says to download the file directly from your bank, not from inside QuickBooks, to make sure it is a .qbo file, “the only type Web Connect can read,” and that importing .qbo files requires you to sign in to your Intuit Account within QuickBooks Desktop.

The same article lists the errors you may see when something is wrong with the file or the bank’s setup.

• “QuickBooks found an error. We can’t read the file [Your financial institution] sent.”
• “QuickBooks is unable to verify the Financial Institution information for this download.”
• “Your data was not imported into QuickBooks.”
• QuickBooks seems stuck and asks you to select a new or existing account when you try to download.

How QuickBooks Online uses a QBO file

QuickBooks Online is less strict. In Bank transactions, choose Link account, then Upload from file, and select the file. Intuit lists .csv, .txt, .qbo and .ofx for this upload, and its file guidelines suggest a QBO file. Each upload can include up to 1,000 lines, and the file guidelines set a 350 KB limit.

So if you use QuickBooks Online, you do not need a .qbo file. A bank OFX or a well-formed CSV works too, and QuickBooks Online can also read a PDF or image statement.

When a QBO import fails

Work through these in order.

• “Nothing imported. Account up to date.”: this is the message QuickBooks Desktop for Mac shows. Intuit says QuickBooks ignores transactions whose IDs it has already stored. Restoring a backup from before the earlier import is Intuit’s first suggested fix; it also documents a careful workaround that edits the ACCTID in the file, with a warning about duplicates.
• Unable to verify the financial institution: Intuit says Web Connect errors can come from incomplete bank files, incompatible formats or changes at your bank. It suggests checking your bank’s messages and, if the problem is the file, asking a bank representative familiar with QuickBooks Bank Feeds to confirm your account is set up for Web Connect.
• A renamed file: changing an .ofx or .csv extension to .qbo does not make it a Web Connect file from your bank, so Desktop may still reject it.
• Problems with one company file only: Intuit suggests importing into a test company file to see whether the issue is the file or your settings.

Opening or converting a QBO file

To read the transactions without QuickBooks, open the file in a text editor or convert it. Xero also imports QuickBooks bank files, though it recommends OFX where your bank offers it. The free OFX to CSV converter on this site reads .qbo files in your browser without uploading them, and gives one row per transaction for Excel or Google Sheets.

If you only have a PDF statement

A converter cannot give a PDF the bank’s Web Connect registration, so QuickBooks Desktop users should ask the bank for a .qbo download of the period. QuickBooks Online users have more choices. Fulla Ledger converts a PDF statement into rows you review against the source page, then exports OFX or CSV for Upload from file. Fulla does not create .qbo files, and its OFX files are for QuickBooks Online and Xero.