What is inside a QBO file
A QBO file is plain text in the OFX format (Open Financial Exchange). Most start with header lines such as
OFXHEADER:100 and VERSION:102, then hold:
- a sign-on section with the server date and Intuit’s bank ID tag (
INTU.BID), - the account: routing number, account number and type, or a card number for credit cards,
- every transaction, each with a type, posting date, amount, unique ID (
FITID), name and optional memo, - the ledger balance and the date it applies to.
The bank ID tells QuickBooks which bank the file came from, and the unique IDs let QuickBooks skip transactions it has already imported. Names are short (up to 32 characters), which is why long bank descriptions are often cut.
Reading a transaction in the raw file
Open a QBO file in a text editor and each transaction looks like this:
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260103120000
<TRNAMT>-84.23
<FITID>20260103d37be02aa201351a
<NAME>Corner Grocery #112
</STMTTRN>TRNTYPE is the kind of transaction (DEBIT, CREDIT, CHECK, FEE and so on), DTPOSTED the posting date written
year first, TRNAMT the amount with a minus sign for money out, FITID the transaction’s unique ID and NAME
the description. The file also holds your account number, so keep it as private as a bank statement.
Where QBO files come from
You download them from your bank’s website, usually from a download option for QuickBooks (Web Connect) in the account’s activity or download area. In QuickBooks Desktop, Banking › Bank Feeds › Bank Feeds Center › Download Transactions opens your bank’s website for the same purpose. Banks decide which formats they offer; if yours only offers CSV or Excel, the CSV to QBO converter makes a QBO file from it.
How to open or convert a QBO file
- Drop the QBO file into the viewer above.
- Check the transactions. The File contents panel shows the file’s own text, so you can see exactly what the bank sent.
- Choose CSV or Excel (or QFX, QIF or OFX) and download.
How to import a QBO file into QuickBooks
- QuickBooks Desktop for Windows: Banking › Bank Feeds › Import Web Connect Files, pick the file, then choose an existing account or create one. Intuit requires you to be signed in to your Intuit account inside QuickBooks.
- QuickBooks Desktop for Mac: Banking › Downloaded Transactions › Import File.
- QuickBooks Online: Bank transactions › Link account › Upload from file. Intuit’s help suggests QBO files for these uploads.
The full steps, with what to do when QuickBooks asks about the account, are in how to import a QBO file into QuickBooks Desktop.
When QuickBooks won’t import a QBO file
QuickBooks is strict about the file’s structure and its bank ID. If an import fails, drop the file into the QBO file checker: it reports a missing or unknown bank ID, missing or repeated transaction IDs, wrong date and amount formats and over-long names, and it can rebuild a clean copy. The QBO import errors guide explains QuickBooks’ error messages.