Free CSV to QBO Converter (QuickBooks Web Connect)

Turn a plain CSV of bank transactions into a .qbo Web Connect file you can import into QuickBooks Desktop, or a generic .ofx file for other accounting software. Everything runs in your browser: the file you drop here is parsed locally and never uploaded to any server.

Why you need .qbo instead of CSV

QuickBooks Online can import bank transactions from a CSV. QuickBooks Desktop cannot: its bank feeds only accept Web Connect files, which use the .qbo extension and the OFX format underneath. If your bank only gives you a CSV export, or you exported transactions from another system, you need to convert that CSV into a .qbo file before QuickBooks Desktop will take it.

That is exactly what this tool does. The .ofx download is the same data in the generic OFX flavor, which suits Xero, GnuCash, and other software that reads OFX but not the QuickBooks-specific variant.

How the tool works

1. Upload your CSV. The first row is treated as headers.
2. Confirm the column mapping. The tool guesses your date, description, and amount columns, and you can correct any of them. Both layouts are supported: a single signed amount column, or separate debit and credit columns (credits become positive, debits negative).
3. Set the account details. Pick the currency, an optional account label, and the account type (checking, savings, or credit line).
4. Review the preview. Rows with a date or amount the tool cannot read are listed as skipped, never silently dropped. Ambiguous dates like 03/04/2026 stay skipped until you pick a day/month order, so nothing is guessed for you.
5. Download the .qbo file for QuickBooks Desktop, or the .ofx file for everything else.

What FITID means and why duplicates stay out

Every transaction in an OFX file carries a FITID, a unique ID for that transaction. QuickBooks remembers the FITIDs it has already imported and skips any transaction it has seen before. This tool derives each FITID deterministically from the transaction's date, amount, description, and position, so converting the same CSV twice produces the same IDs, and re-importing the file will not create duplicate transactions.

A note on bank IDs

Real Web Connect files identify the issuing bank with Intuit-specific IDs. This tool writes a generic placeholder ID, which imports in most QuickBooks Desktop versions. Your bank's own Web Connect download remains the canonical source, so if your bank offers a direct .qbo export, prefer it and use this converter for the accounts that only export CSV.

Limitations

• CSV in, not PDF. This tool reads CSV files only. If you are starting from a PDF statement, including a scanned one, run it through the bank statement converter first, then bring the CSV here.
• Messy files. If your CSV has stray blank rows or inconsistent dates, the bank CSV cleaner can tidy it up before converting.
• One account per file. Each .qbo file describes a single account, so export and convert each account's transactions separately.