How to reconcile a bank CSV export with your statement

By Andrii Furmanets, founder of FolioFlux. Questions: hello@folioflux.com.

An export is only useful if it holds every transaction the statement does, once each. Reconciling is how you prove that. The test is simple arithmetic: the opening balance, plus everything in the file, must equal the closing balance.

What you need

  • The statement for the period, with its opening and closing balance.
  • The CSV export for the same account and the same dates.
  • A spreadsheet, or a tool that shows a running balance.

Five steps

  1. Check the date range. The first and last row of the file should fall inside the statement period, and no day should be missing at either end.
  2. Check the signs. Decide which way the file writes money out: a minus sign, a separate debit column, or a positive charge on a card export.
  3. Add it up. Opening balance plus money in, minus money out, should equal the closing balance to the cent.
  4. If it does not, compare the row count with the statement’s transaction count, then look for the difference as a single amount.
  5. Fix the export, not the total. Download the range again if rows are missing; remove pending rows if the statement does not include them.

Reading the difference

What the size of a reconciliation difference tells you
The difference isLook for
Exactly one transactionA missing or duplicated row of that amount
Twice one transactionA row with the wrong sign
A round numberA transfer or an opening balance typed wrong
Small and oddA fee, interest or a currency conversion on its own row
Divisible by 9Two digits swapped when a figure was typed by hand

Things exports do that statements do not

  • Include pending rows that later change amount or disappear.
  • Repeat the header after a page break, or end with a totals line.
  • Write dates day-first in one bank and month-first in another.
  • Use a comma as the decimal mark and a space between thousands.
  • Leave the year out of the date. An export like that cannot be read safely.

Reconciling in FolioFlux

When you import a CSV export, FolioFlux shows a preview of every row, with the balances where the file has them, before any entry is added. Check the preview against your statement, then confirm the import or discard it. An import is all-or-nothing, and a saved import can be undone.

You can sign up at folioflux.com/sign-up

Not financial, tax or legal advice.