Skip to content
Banking Converter
Convert

What is a QBO file?

By the Banking Converter editorial team

Published

A QBO file is a bank statement download in Intuit's Web Connect format for QuickBooks. It is an OFX version 1.02 document with three Intuit-specific requirements: an FI block naming the bank (ORG and FID), an INTU.BID identifier registered with Intuit, and the .qbo extension. QuickBooks refuses files whose INTU.BID it does not recognise, which is why a QBO file cannot be created for an arbitrary bank without those ids.

How a QBO file differs from OFX

QBO header and sign-on block (ORG, FID and INTU.BID are placeholders here)
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRSV1><SONRS>
<STATUS><CODE>0<SEVERITY>INFO</STATUS>
<DTSERVER>20260901120000
<LANGUAGE>ENG
<FI><ORG>Example Bank<FID>12345</FI>
<INTU.BID>12345
</SONRS></SIGNONMSGSRSV1>
<BANKMSGSRSV1><STMTTRNRS> … </STMTTRNRS></BANKMSGSRSV1>
</OFX>
  • Version 1.02 SGML syntax rather than XML.
  • <FI><ORG>…<FID>…</FI> identifies the institution. FID is Intuit's numeric id for the bank.
  • <INTU.BID> is the Intuit bank id; QuickBooks validates it against its list of Web Connect banks.
  • Everything else, including the FITID per transaction and the ledger balance, is standard OFX. See what is an OFX file.

Finding your bank's identifiers

  1. Download a QBO file from your own online banking, if the bank offers Web Connect. Open it in a text editor and copy ORG, FID and INTU.BID from the sign-on block. This is the most reliable source because the ids are the bank's own.
  2. In QuickBooks Desktop, the Bank Feeds setup lists Web Connect banks; the id is not shown, but the bank's presence confirms it is supported.
  3. Community-maintained lists of INTU.BID values exist online, but they go stale; treat them as a starting point and verify with a downloaded file.

The QBO converter asks you to select or enter these values. It will not fill in a well-known bank's ids on your behalf, because a wrong id can attach transactions to the wrong institution or be rejected outright.

Importing a QBO file

  • QuickBooks Desktop: File, Utilities, Import, Web Connect Files. Select the file, then choose the QuickBooks account to link.
  • QuickBooks Online: Transactions, Bank transactions, Link account, Upload from file.
  • Duplicates: QuickBooks skips transactions whose FITID it has already imported for that account. Deterministic ids from the converter make re-imports safe.

A full walkthrough is in importing bank transactions into QuickBooks.

Common import errors

  • "QuickBooks found an error. We can't read the file": usually a malformed header, a non-1.02 version or a missing INTU.BID.
  • "This bank is not supported" or OL-xxx errors: the INTU.BID is not on Intuit's list or the bank's Web Connect support has lapsed.
  • Transactions land in the wrong account: the ACCTID in the file does not match the account you linked; QuickBooks remembers the mapping after the first import.

Frequently asked questions

Is QBO the same as QFX?

They are siblings. Both are OFX 1.02 with Intuit identifiers; QBO is for QuickBooks and QFX for Quicken. The internal identifier requirements differ slightly and the extensions are not interchangeable.

Can I edit a QBO file by hand?

It is plain text, so yes, but every transaction needs a unique FITID and amounts must be correctly signed. Editing the extracted rows in the converter before exporting is safer.

Other bank statement converters

Bank statement to QBOBank statement to OFX

About the author

The Banking Converter editorial team is the engineering group that builds and tests the conversion engine: the parsers for regional date and number formats, the reconciliation checks and the CSV, Excel, JSON, OFX and QBO exporters. Guides describe what the software does and what the formats require; they are not financial, legal or tax advice.