CSV to QBO Converter

What is a QBO file?

A QBO file is a bank statement in QuickBooks' Web Connect format — a flavor of the OFX standard that banks use to exchange transaction data. Inside is a plain-text statement: the account type, an account identifier, and one record per transaction with its date, amount, payee, and a unique transaction ID (the FITID). When you import a QBO file, QuickBooks reads it exactly the way it reads a direct bank feed, so transactions arrive ready to categorize and reconcile.

Why QuickBooks won't import CSV directly

QuickBooks Desktop only accepts Web Connect (.qbo) files for bank imports, and while QuickBooks Online has a CSV upload, it is picky about layouts and frequently misreads dates, signs, and debit/credit columns. CSV is just a grid of text — nothing in the file says which column is the date, whether 03/04/2025 is March or April, or whether a positive number is money in or money out. The QBO format encodes all of that explicitly, which is why converting your CSV to QBO is the reliable path: you resolve the ambiguity once, here, instead of letting an importer guess.

How to convert CSV to QBO

1. Drop your CSV above — exports from Chase, Wells Fargo, credit unions, and UK/EU banks all work, with or without a header row. The file is parsed on your device and never uploaded.
2. Check the detected column mapping. The converter guesses the date, description, and amount (or debit/credit) columns and shows its confidence; correct anything with the dropdowns.
3. Pick the account type: checking, savings, or credit card.
4. Preview the normalized transactions, confirm the date format if prompted, and download your .qbo file.
5. In QuickBooks, use File → Utilities → Import → Web Connect Files (Desktop) or the file upload in Banking (Online), then pick the account to import into.

Troubleshooting: why won't my QBO import?

Why does QuickBooks say the account type doesn't match?

A QBO file declares whether it belongs to a checking, savings, or credit card account, and QuickBooks refuses the import when that declaration doesn't match the account you selected. Re-download the file with the correct account type chosen in step 2, or import into an account of the matching type.

Why are transactions missing after I import my QBO file?

QuickBooks skips transactions it believes it has already imported, and some versions ignore transactions dated far outside the statement range. Check the date range in the preview before downloading, and confirm the date format if your file uses ambiguous dates like 03/04/2025.

Why does QuickBooks treat my transactions as duplicates?

Every transaction in a QBO file carries a unique ID called a FITID. QuickBooks silently skips any FITID it has seen before on that account. This converter generates FITIDs deterministically from each transaction's date, amount, and description, so re-importing the same file (or overlapping exports) dedupes cleanly instead of creating doubles.

Is this CSV to QBO converter really free?

Yes — files with up to 100 transactions convert free, with no signup and no upload; everything runs in your browser. A one-time $19 license removes the transaction limit — and unlocks every other LegacyFile tool too.