How to find missing bank statements before year-end

Satwinder Singh · 28 October 2026 · 4 min read

When you're handed a folder of bank statements for a year of bookkeeping, the first question isn't what's in them. It's whether they're all there. A missing month doesn't announce itself. It just leaves the year's figures quietly wrong.

You can prove a set of statements is complete with two columns of information you already have.

Make a list: period and balances

For each statement, write down four things in a simple table, one row per statement, sorted by start date:

Then run two checks down the list.

Check 1: each period starts where the last one ended

Each statement's start date should be the day after the previous statement's end date. In the example, February ends on 28 February and the next statement starts on 1 April. March is missing.

Watch for overlaps too. If one statement ends on 15 March and the next starts on 10 March, the transactions in between appear in both files and will be imported twice unless your software removes duplicates.

Check 2: each opening balance equals the last closing balance

This is the stronger check, because it catches gaps that dates alone miss. February closes at 5,120.40 but April opens at 4,876.02, so money moved in a period you don't have a statement for.

The balance check also catches cases where the dates look continuous but something is still wrong:

• Two accounts mixed together. Statements from a second account at the same bank slipped into the folder. The dates look fine, but the balances jump between two sequences.
• A replaced or corrected statement. The bank reissued a month, and you have the old version.
• An interim statement. Some banks issue a statement when you ask for one mid-month, which splits a month into two periods.

Don't forget pages

A statement can be present but incomplete: page 3 of 5 didn't scan, or the PDF was saved before it finished downloading. Look for page labels ("Page 3 of 5") and make sure every number appears. The closing-balance check catches this as well, because the missing page's transactions won't add up to the printed closing balance.

A year in a few minutes

For a single account with monthly statements, this takes a few minutes in a spreadsheet and saves a long hunt later. If you'd rather not build the table by hand, I built a free missing statement checker: upload the PDF statements and it runs these checks, flagging missing months and pages, overlaps and balances that don't carry over.