How do I check that a bank statement balances?

Take the opening balance, add every deposit, subtract every withdrawal, and compare the result with the closing balance. This tool does that sum exactly and, when the export has a running balance column, repeats it for every row so it can say where a difference starts.

My export is off by an amount. How do I find the transaction?

Include the balance column when you export, and the checker reports the first row whose balance does not follow from the one before. The missing or extra transaction sits just before that row, and its amount is usually the difference shown.

What if my file has no balance column?

Then only the totals can be checked. Type the opening and closing balances printed on the statement, and the checker compares them with the sum of the transactions.

Does it work for credit card statements?

Yes, as long as the amounts are signed from your side, with charges negative. If your export writes charges as positive, tick “Money out is written as a positive number” when mapping the columns, and enter the balances as negatives, since money is owed.

Which files can it read?

CSV exports from any bank, and OFX, QBO, QFX, and QIF files. An OFX-family file's closing balance is read from the file itself.

Is my statement uploaded?

No. The file is read and checked in your browser. Nothing is sent anywhere.

Bankflow

Free tool

Does the statement actually add up?

Check that every balance in a converted statement follows from its transactions, and see where it stops.

Drop your statement export hereor browse a file from your device.csv.ofx.qbo.qfx.qifUp to 20 MB per file · One file at a time

Read in your browser. Never uploaded.

Include the running balance column if the export has one: it lets every row be checked, not just the total.

Two checks, and what each one catches

The running balance, row by row

When the export has a balance column, every row must equal the balance before it plus its own amount. The first row where that fails is where the problem is, to the line.

Missing and doubled rows

A break with a difference equal to one transaction's amount means that transaction is missing just before the row, or appears twice. The difference and its direction are spelled out.

Flipped signs

When a balance only works with an amount's sign reversed, the row is reported as money in written as money out, or the other way round, the usual fault of a hand-built conversion.

Opening plus net equals closing

Whatever the file holds, the opening balance plus the sum of every amount must reach the closing balance. Balances come from the file where it has them, or from the figures you type in from the PDF.

Newest first or oldest first

Banks export in either order. The balances are followed in whichever direction they actually chain, so a newest-first file is not reported as broken on every row.

Checked to the cent

Every amount is compared in whole cents, so a correct statement never shows a phantom 0.01 difference from floating-point rounding.

Questions

How do I check that a bank statement balances?: Take the opening balance, add every deposit, subtract every withdrawal, and compare the result with the closing balance. This tool does that sum exactly and, when the export has a running balance column, repeats it for every row so it can say where a difference starts.
My export is off by an amount. How do I find the transaction?: Include the balance column when you export, and the checker reports the first row whose balance does not follow from the one before. The missing or extra transaction sits just before that row, and its amount is usually the difference shown.
What if my file has no balance column?: Then only the totals can be checked. Type the opening and closing balances printed on the statement, and the checker compares them with the sum of the transactions.
Does it work for credit card statements?: Yes, as long as the amounts are signed from your side, with charges negative. If your export writes charges as positive, tick “Money out is written as a positive number” when mapping the columns, and enter the balances as negatives, since money is owed.
Which files can it read?: CSV exports from any bank, and OFX, QBO, QFX, and QIF files. An OFX-family file's closing balance is read from the file itself.
Is my statement uploaded?: No. The file is read and checked in your browser. Nothing is sent anywhere.

More free tools

All free tools

Month-end close

Statement PDFs

Import files

The numbers

Get statements that balance before you import

Bankflow checks every statement it reads against the opening and closing balances printed on it, and flags anything that does not reconcile for review before you export.

Convert a statement free Reconciliation

50 free page credits · No card