Why won't my bank CSV amounts import?

Currency symbols, thousands commas or Dr/Cr suffixes stop the value parsing. Accounting software expects a plain number.

How do I clean the amount column automatically?

StatementFlow strips symbols and commas, converts Dr/Cr to signed numbers, and handles split debit/credit columns — no manual editing.

Guides / Bank CSV amounts won't import

CSV import fix

Bank CSV amounts won't import (£ signs, commas, Dr/Cr)

If your amounts import as blanks, zeros or errors, the amount column almost certainly contains characters your accounting software can't parse — a £ sign, a thousands comma, or a Dr/Cr suffix.

Why it happens

Xero and QuickBooks expect a plain number in the amount column. Bank exports dress it up: £1,240.00, 1,240.00 Cr, -£142.00, or debits and credits split across two columns. Any of those stops the value parsing, so the figure imports wrong or not at all.

The manual fix

Manually you'd strip the symbols and commas, convert Dr/Cr suffixes to signed numbers, and — if your bank splits debits and credits — combine them into one signed column, all without rounding errors.

The faster way

StatementFlow cleans the amount column automatically — removes symbols and commas, turns Dr/Cr into signed values, and can split or combine debit/credit columns to match what your software needs. Every figure imports, correct to the penny.

Fix it in one click

Drop your CSV, pick your bank and accounting software, download a file that imports first time. Free to start, client-side, nothing uploaded.

Get started free →