Updated: July 2026
Choose a clear transaction layout
A practical export includes Date, Amount, Payee, Description and Reference. Keep each transaction on one row. Remove running balances, page headings and statement totals that are not individual transactions.
Use a consistent amount direction
Signed amounts are straightforward: money received is positive and money spent is negative. When the source has debit and credit columns, convert them carefully and test a few known transactions before importing the whole file.
Protect useful descriptions
Descriptions help matching and reconciliation. Combine a short bank description, payee and memo only when that improves clarity. Avoid stripping references that may later be needed to identify transfers or payments.
Check date order and statement range
Sort by date if the bank export is reversed, and verify the first and last transaction dates. Avoid overlapping a range that has already been imported unless you are prepared to remove duplicates.
Validate after import
Compare the number of imported transactions and the statement balance with the source. If the account balance does not match, look for reversed signs, skipped blank amounts, duplicate rows or a missing opening period.
Useful tools
Bank Statement Converter · QuickBooks CSV Formatter · Xero CSV Formatter