QBO vs CSV vs OFX: which bank file to import into QuickBooks, Quicken or Xero

The four formats at a glance

.qbo, .qfx and .ofx are the same format underneath

All three are Open Financial Exchange (OFX) files: a short header, then one block per transaction with a type, a posted date, a signed amount, a transaction ID (FITID) and a payee name. This is one transaction:

<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260903120000
<TRNAMT>-42.10
<FITID>5d1c0e7a9b2f4c3d8e6a1f0b7c9d2e4a
<NAME>GROCERY MART
</STMTTRN>

A .qbo file adds an Intuit tag, INTU.BID, that QuickBooks reads as the bank label. A .qfx file adds the tags Quicken looks for. A plain .ofx file has neither, which is what Xero and most other tools want. Because the amount is signed and the date has a fixed layout, the software never has to guess which column is which.

Why the transaction ID matters

The FITID is how accounting software spots a row it has seen before. If you download the same statement twice and import both files, the IDs match and QuickBooks treats the second copy as already imported. FastOCR gives each row the same ID every time you download the same statement.

The ID only protects you within files. A row from your file and the same row from a live bank feed have different IDs, so the software may list both. Import by file only for dates your bank feed does not cover.

When CSV is the better choice

A CSV is a plain table you can open in Excel or Google Sheets. That makes it the right pick when you need to fix a description, split a statement, or delete rows before importing. The price is mapping: you tell the software which column is the date, which is the description and how money out is shown.

QuickBooks Online accepts a three-column CSV (Date, Description, Amount, with money out negative) or a four-column one (Date, Description, Credit, Debit). The FastOCR QuickBooks CSV uses the three-column layout. A CSV has no row IDs, so importing it twice adds the rows twice.

Which one to pick

• QuickBooks Online: .qbo. Use the CSV if you need to edit rows first.
• QuickBooks Desktop: .qbo, imported from File > Utilities > Import > Web Connect Files.
• Quicken: .qfx.
• Xero: .ofx, from the bank account’s Import a Statement option.
• Wave and other tools: .ofx if the import page lists OFX, otherwise CSV.

None of these files carries categories, creates a bank connection, or proves the statement is right. Check the balances before you import. On FastOCR the result says whether the statement reconciles, and you can get all four files from one upload on the bank statement to QuickBooks page.