“QuickBooks Online will not accept my CSV upload”
QuickBooks Online accepts a narrow set of CSV shapes and rejects everything else without explaining which rule was broken. Knowing the accepted layouts turns a guessing game into a five-minute edit.
Symptoms
The upload is refused with a generic formatting message The column-mapping screen will not let you continue Dates or amounts are flagged as invalid even though they look normal
What actually causes it
A layout outside the accepted shapes
The supported forms are three columns (date, description, amount) or four columns (date, description, credit, debit). Exports carrying balances, running totals, reference numbers and category columns fall outside both.
Currency symbols or thousands separators in amounts
Amount cells must be plain numbers. "$1,234.56" is text as far as the importer is concerned.
Mixed or ambiguous date formats
One date format must be used consistently, and it must match the format you select during upload. A file mixing 01/08/2026 and 2026-08-02 will fail somewhere in the middle.
Preamble rows and blank lines
Account headers above the data, and blank separator rows inside it, both break the expected structure.
How to fix it
- Run the file through the checker below to see its real delimiter, column count and any misaligned rows.
- Delete preamble rows, blank rows and every column except the ones the accepted layouts allow.
- Strip currency symbols and thousands separators from the amount column.
- Upload again and pick the date format that matches the file exactly.
Related import problems
Skip the manual edit — fix it automatically
The checker removes blank rows and semicolon delimiters automatically, and lists the exact lines whose column count does not match the header. Free, no signup, no upload.
Open the fixer