QBO vs OFX vs QIF — which file format do you need?
Three formats, one job: getting bank transactions into your accounting software. Here's the difference in plain language.
The quick answer
Use QBO for QuickBooks Desktop (it accepts nothing else), OFX for Xero, Wave, GnuCash and most other software, and QIF only for Quicken or legacy tools. All three carry the same transactions — they're just different containers, and you can generate any of them from a bank CSV with our free browser converter.
| Format | Stands for | Used by | Type | When to pick it |
|---|---|---|---|---|
| QBO | QuickBooks Web Connect | QuickBooks Desktop | OFX + Intuit tags | Importing into QuickBooks Desktop |
| OFX | Open Financial Exchange | Xero, Wave, GnuCash, Money | Open standard | Almost everything that isn't QuickBooks/Quicken |
| QIF | Quicken Interchange Format | Quicken, legacy software | Plain text, older | Only when nothing newer is accepted |
What is a QBO file?
A QBO file is QuickBooks Desktop’s Web Connect format for importing bank transactions — an OFX-based file with Intuit-specific tags. It is the only bank-transaction format QuickBooks Desktop imports directly (File → Utilities → Import → Web Connect Files).
What is an OFX file?
OFX (Open Financial Exchange) is the open standard for exchanging bank transactions, used by Xero, Wave, GnuCash, Microsoft Money and many others. QBO is essentially OFX with extra Intuit branding tags.
What is a QIF file?
QIF (Quicken Interchange Format) is the older plain-text format used by Quicken and much legacy finance software. Simpler than OFX but with weaker date/currency handling — use it only when your software accepts nothing newer.
QBO vs OFX — which should I use?
QBO if you import into QuickBooks Desktop (it requires it). OFX for almost everything else — Xero, Wave, GnuCash and most modern accounting apps. They contain the same transaction data.
Does QuickBooks Online accept QBO files?
QuickBooks Online prefers direct bank feeds or CSV in its own expected layout. QBO Web Connect files are primarily for QuickBooks Desktop. If QuickBooks Online rejects your bank’s CSV, reformatting the CSV columns often fixes it.
How do I create a QBO, OFX or QIF file from a CSV?
Use a converter: drop your bank’s CSV export on staysprivate.com/csv-to-qbo, map the date, description and amount columns, and download any of the three formats. Conversion runs in your browser, so bank data is never uploaded. Free up to 100 transactions.
The QuickBooks Desktop import path
Once you have a QBO file: File → Utilities → Import → Web Connect Files, choose the file, pick the account, done. For Xero and Wave, look for "Import bank statement" and choose the OFX.
Convert your bank CSV now — free
Last updated: