February 22, 2026 · 4 min read
Convert a Bank Statement to QBO for QuickBooks Online
Why QuickBooks rejects your CSV — and how to produce a QBO file that imports cleanly.
QuickBooks Online reads OFX, QFX, and QBO files — not Excel. If you're stuck pasting CSV and getting duplicate transactions, it's because QBO dedupes on a stable transaction ID that CSV doesn't carry.
The QBO format
A QBO file is a flavour of OFX. It wraps transactions in SGML-style tags with a unique FITID per line. QuickBooks uses that ID to skip duplicates on re-import.
What goes in
Minimum required: posted date, amount (signed), memo/payee, and a unique FITID. Our PDF to QBO converter generates the FITID deterministically from date + amount + description, so re-uploading the same statement doesn't create duplicates.
How to import into QuickBooks Online
- Banking → Link account → Upload transactions
- Choose the QBO file produced here
- Match transactions to accounts — QuickBooks auto-categorises the obvious ones
- Review and accept
That's it. The whole flow takes under a minute for a typical monthly statement. If you're hitting errors at the import step, see our guide to common QuickBooks import errors.