QBO vs CSV vs OFX: Which File Format to Import into QuickBooks
For importing bank transactions into QuickBooks, QBO is the best format: it needs no column mapping, detects duplicates automatically, and has no size limit. CSV works but requires manual mapping and is capped at about 350 KB. OFX and QFX are usable alternatives but less consistent than QBO.
QuickBooks accepts four bank-import formats: QBO, CSV, OFX, and QFX. They are not equal. QBO is purpose-built for QuickBooks and imports with zero configuration, while CSV trades convenience for flexibility. Here is how to choose.
QBO (Web Connect): the gold standard
QBO is the format QuickBooks was designed to read. It skips column mapping entirely, automatically detects duplicate transactions through unique transaction IDs, and has no practical size limit, so you can import a full year in one file. If you can produce a QBO file, use it.
CSV: flexible but fiddly
- Requires manual column mapping every time (Date, Description, Amount, or separate Credit and Debit columns).
- Capped at roughly 350 KB, about 1,000 to 1,500 transactions, in QuickBooks Online.
- Every bank formats CSV differently, so some files need cleanup before they import.
- No native CSV banking import in QuickBooks Desktop.
OFX and QFX: the middle ground
OFX is the open standard QBO is based on; QFX is Quicken's flavour. Both can import into QuickBooks, but QFX sometimes drops merchant detail and OFX support varies by bank. When a bank offers QFX or OFX but not QBO, converting your PDF statement to QBO usually gives a cleaner result.
The bottom line
- If you can get or create a QBO file, use it. It is the most reliable.
- Use CSV when you only have spreadsheet data and the volume is small.
- Only fall back to OFX or QFX when QBO is not available.
Starting from a PDF? You can convert your statement straight to QBO and skip the format question altogether. If you specifically need a spreadsheet, convert to CSV instead. Already have a CSV? See how to convert CSV to QBO.
Convert your first bank statement free
No account needed. Upload a PDF and get clean, structured data in under 60 seconds.
Try Documentric FreeFAQ
Is QBO better than CSV for QuickBooks?
Yes, in almost every case. QBO needs no column mapping, detects duplicates automatically, has no size limit, and works in QuickBooks Desktop, none of which CSV offers.
What is the difference between QBO and OFX?
QBO is QuickBooks' branded version of the OFX standard. They are structurally similar, but QBO includes QuickBooks-specific routing data, so it imports more reliably into QuickBooks.
Can I convert a CSV to QBO?
Yes. If you already have a CSV, you can convert it to QBO so it imports without mapping. This is common for regional banks and credit unions that only export CSV.