QuickBooks CSV import not working? Here's why — and the fix

QuickBooks Online rejects bank CSVs for a handful of predictable reasons. Here are the most common ones, each with a fix — and a one-step way to skip the whole struggle.

QuickBooks Online only accepts a CSV in a strict layout, so a raw bank export usually fails. The usual culprits:

1. Wrong number of columns

QuickBooks wants exactly a 3-column (Date, Description, Amount) or 4-column (Date, Description, Credit, Debit) layout. Bank exports have extra columns (balance, reference, type). Remove everything except the required columns. See the exact format.

2. Date format mismatch

Dates must match your QuickBooks region setting (often MM/DD/YYYY in the US). Mixed or DD/MM dates cause "invalid date" errors. Normalize every date to one consistent format.

3. A balance column is present

A running-balance column confuses the amount mapping. Delete it before importing.

4. Amounts with currency symbols or text

Remove "$", "£", "USD", "DR/CR" and thousands separators that break parsing. Amounts should be plain numbers, negative for money out.

5. Blank rows, headers, or footer/summary lines

Delete blank rows and any summary lines (opening/closing balance, totals). Keep one clean header row.

Skip all of that

Instead of hand-editing in Excel, drop your bank file into the free converter — it auto-detects the columns and outputs a clean 3-column or 4-column CSV (or a .QBO for Desktop) that QuickBooks accepts. Nothing is uploaded.