How to convert a bank CSV to a QBO file
A .QBO file is Intuit's Web Connect format. QuickBooks Desktop imports one directly, and because the format has explicit named fields there is nothing left for QuickBooks to guess at. That is why "convert the CSV to QBO first" is the standard answer when a CSV import keeps failing.
🔒 Convert your CSV now — free, runs in your browser, nothing uploaded.
The steps
- Export a CSV from your bank. Any layout. Comma, semicolon or tab separated is fine, and a preamble above the headers is fine.
- Drop it into the converter. QBOKit works out the delimiter, finds the header row, and guesses which columns hold the date, the description and the amount.
- Check the three columns it picked. This is the one step worth your attention — in particular whether the dates are day-first or month-first.
- Pick your institution settings if QuickBooks has complained about the financial institution before. See below.
- Download the .QBO and import it in QuickBooks via File → Utilities → Import → Web Connect Files.
What a QBO file actually contains
A QBO file is OFX (Open Financial Exchange) data wrapped in a header that identifies the bank. Stripped down, one transaction looks like this:
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260401120000
<TRNAMT>-82.40
<FITID>20260401-82.40-ACME
<NAME>DIRECT DEBIT ACME LTD
</STMTTRN>Each field is named, so there is no column-mapping step and no ambiguity about which number is the amount or how to read the date. That is the whole advantage over a CSV.
FID and INTU.BID, and the "cannot verify the financial institution" error
The QBO header carries two identifiers, FID and INTU.BID, which name the bank the file came from. QuickBooks checks them against its own internal list of institutions, and when it does not like them it refuses the file with a generic error that says nothing about the cause. Supplying values QuickBooks will accept is, in practice, most of what a paid CSV-to-QBO converter does for you.
If you hit that error, open the institution settings in the converter and try a different value. We do not invent these identifiers — guessing one means a failed import.
Why FITIDs matter if you import twice
Every transaction carries a FITID, a unique id the accounting software uses to recognise a transaction it has already seen. Get these wrong and re-importing an overlapping date range silently duplicates everything. QBOKit derives each FITID from the date, amount and description, so the same transaction always produces the same id and a re-import is deduplicated rather than doubled.
QBO, OFX or QIF?
| Format | Use it for |
|---|---|
| .QBO | QuickBooks Desktop, via Web Connect import. The usual choice. |
| .OFX | Xero, and most other accounting software. Same data, no Intuit-specific header. |
| .QIF | Older software and some personal finance tools. |
| Clean CSV | QuickBooks Online, which takes CSV directly — it just wants a tidy one. |
Importing into QuickBooks Online? You do not need a QBO file. QBO Web Connect import is a Desktop feature. For QuickBooks Online, use the cleaned-CSV output and see the CSV format requirements.