CSV vs QBO vs OFX for QuickBooks / Quicken
CSV is universal but drops metadata. QBO is QuickBooks-native and dedupes on re-import. OFX is the open sibling of QBO. Here's the decision matrix.
QuickBooks accepts three bank-import formats, and they behave very differently. CSV is universal but strips FITIDs (so re-imports create duplicates). QBO is QuickBooks-native — it dedupes on FITID and preserves account type. OFX is the open OFX-family sibling of QBO; QuickBooks needs it converted first. Pick based on how often you import and how much metadata you need to preserve.
Candidates
One-off imports, simple 3-4 column bank exports
- Every bank exports it
- Opens in Excel/Sheets
- No conversion tool needed for the smallest cases
- No FITID → duplicates on re-import
- Column-mapping errors are silent
- No account type or currency metadata
Regular bank imports into QuickBooks Online or Desktop
- Dedupe on FITID
- Preserves account type (Checking/Savings/Credit Card)
- Imports in one click via Banking → Upload from File
- Not all banks export it directly
- Needs the correct FID/BID header to be accepted
Non-QuickBooks accounting tools (GnuCash, Sage, personal finance apps)
- Open format supported by 100s of apps
- Same FITID dedupe as QBO
- Available from many banks that don't offer QBO
- QuickBooks rejects raw OFX with 'invalid file'
- Needs converting to QBO for QuickBooks
Decision matrix
| Use case | Pick | Why |
|---|---|---|
| Importing to QuickBooks Online, one-off | CSV (if 3-4 columns) or QBO | QBO dedupes; CSV works for tiny files. |
| Importing to QuickBooks Online, monthly | QBO | Dedupe on FITID prevents monthly duplicate cleanup. |
| Importing to QuickBooks Desktop | QBO or IIF | QBO for bank transactions; IIF if you need splits/journal entries. |
| Importing to GnuCash / KMyMoney | OFX or QIF | GnuCash accepts both natively. |
| Importing to Quicken | QFX | Quicken's native Web Connect format. |
| Auditor asks for a readable file | CSV or Excel | Machine-readable formats are opaque to non-accountants. |
FAQs
Yes — Convert Bank Statements converts CSV ↔ QBO ↔ OFX ↔ QFX ↔ IIF ↔ QIF ↔ Excel ↔ PDF in every direction.
OFX/QBO/QFX — they all carry FITIDs, account types and currency. CSV drops all of it unless you add columns manually.
QuickBooks validates the file signature and requires a QuickBooks-specific FID/BID block. Convert the OFX to QBO.