How we check every page

A spreadsheet looks just as tidy when a number was misread. So before you download, we check what we read against the balances printed on your statement.

Bank statements: every page has to add up

Each page of a bank statement prints an opening and a closing balance. We take the opening balance, add the money in, subtract the money out, and compare the result with the closing balance. They have to match exactly, to the cent.

Then we check that the pages fit together: each page has to start where the one before it ended.

If your statement prints a balance on every row, we also check that each row follows from the one above it, and highlight any that don’t. Pages without transactions, like a summary or a legal notice, are skipped.

Credit card statements: every currency adds up

Card statements don’t print a balance on every page, so we check the whole statement instead: the previous balance, plus charges, minus payments, has to equal the new balance. We do it separately for each currency on the statement.

If the statement has no totals to compare against, we tell you it couldn’t be checked, and you can enter the totals yourself.

What you see before you download

Each page gets one of these labels on the review page:

Adds up
The page balances.
Off by 25.00
The page is off by that amount. A row may be missing or misread.
Doesn’t match page 2
The page balances on its own, but it doesn’t start where page 2 ended.
Balance check unavailable
The page doesn’t print an opening or closing balance, so there’s nothing to check it against.

The Excel file includes a Summary sheet with each page’s figures and whether it balanced.

When a page doesn’t add up

Open the page, compare it with your copy of the statement, and fix what was read wrong: an amount, a missing row, or a balance. When you save, the check runs again.

You can also download it as it is. The Excel Summary sheet shows which pages didn’t balance.

What the check can’t catch

A date or a description read wrong doesn’t change any balance, so the check can’t see it. And in rare cases, two mistakes can cancel each other out. That’s why we suggest a quick look at the table before you download.

Convert a statement