Skip to content
Safitab

Clean a bank statement CSV

Every bank exports a little differently: account details above the table, dates in day-first or month-first order, amounts with currency signs, paid-out and paid-in in separate columns, and a “balance brought forward” line that isn’t a transaction.

The table is found under the account details, dates and amounts get real types, and the opening balance line is set aside. The running balance is then used to check every single row, so a missed or duplicated transaction shows up immediately.

Drop files here

or browse your files

XLSX, XLS, CSV, TXT, PDF · up to 25 MB · 1 file without an account

Or try a sample:

Example: before and after

Account details and “Balance brought forward” are set aside, “£222.89” is a number in Paid out, and the balance was checked on every row.

Before14_uk_bank_statement.csv
1Account Name:MR J GRANT
2Sort Code:27-95-36
3Account Number:43815526
4
5DateTypeDescriptionPaid outPaid inBalance
601/03/2026 Balance brought forward £2,145.20
701/03/2026CHQCHEQUE 000318£222.89 £1,922.31
802/03/2026CHQCHEQUE 000318£955.85 £966.46
903/03/2026CHQCHEQUE 000318£171.57 £794.89
After4 rows
DateTypeDescriptionPaid outPaid inBalance
03/01/2026CHQCHEQUE 000318222.891,922.31
03/02/2026CHQCHEQUE 000318955.85966.46
03/03/2026CHQCHEQUE 000318171.57794.89
03/04/2026DDTHAMESIDE COURIER DD318.40476.49

How to do it

  1. 1Drop the statement CSV (PDF statements work too).
  2. 2Check the balance verification and any flagged rows.
  3. 3Download XLSX for your bookkeeping, or CSV in the layout your accounting software imports.

Questions

Do you support UK and European banks?
Yes. DD/MM/YYYY dates, £ and € amounts, comma decimals, semicolon separators and Windows encodings are all recognised from the file itself.
What is the running balance check?
Each row’s balance is compared with the previous balance plus money in minus money out. Any row that breaks the chain is highlighted.
Will the next statement from the same bank be cleaned the same way?
Yes. The layout is remembered after the first file, so later statements are cleaned automatically, with your corrections.

Related tasks

See all tools