QuickBooks reads only two shapes: a 3-column layout (Date, Description, Amount) or a 4-column layout (Date, Description, Credit, Debit). Bank exports rarely match — they add Balance, Reference, Category, Counterparty and their own column names — so QuickBooks can't tell which column is which and rejects the file.
Manually, you open the CSV in Excel, delete the extra columns, rename the headers to what QuickBooks expects, reorder them, and re-save as CSV — without breaking the date or amount formatting in the process. Every bank needs a slightly different fix, every month.
StatementFlow maps your bank's columns to one of QuickBooks' accepted layouts automatically. Pick your bank → QuickBooks preset, drop the file, and download a CSV QuickBooks accepts first time. Build it once as a recipe and reuse it every month.
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 →