Every bank statement opens with the balance the previous one closed with. If the chain breaks between two statements you have imported, the statement in between is the one you are missing. This check needs only a pen and the first and last lines of each file.
Why the chain works
The balance on the last day of one period is the balance on the first day of the next, because money does not vanish overnight. So for any two consecutive statements, closing balance of the earlier one must equal the opening balance of the later one. If it does not, there is activity between them that you have not loaded.
Try it on four statements
Say you have imported these statements for a current account.
| Statement | Opening balance | Closing balance | Chain check |
|---|---|---|---|
| January | £1,100.00 | £1,240.10 | Start of chain |
| February | £1,240.10 | £1,055.60 | Opens where January closed: fine |
| April | £1,318.25 | £940.80 | Break: February closed at £1,055.60 |
| May | £940.80 | £1,205.00 | Opens where April closed: fine |
February closes at £1,055.60, but April opens at £1,318.25, so March is absent. The net movement during March must have been 1,318.25 - 1,055.60 = +£262.65. That figure is useful: once you import March, its rows should add up to exactly that.
What if the numbers do not line up for another reason?
- The opening balance on a file may be on the first day, before or after the first transaction. Read the heading for what it says.
- Some exports leave out balance lines. Compute the balance yourself from a known statement.
- Two statements that overlap will show the same closing and opening dates but different balances at the join. Look at the dates, not only the figures.
- A change of account number or a new card can start a new chain; link the old and new chains by hand.
How do I fill the gap once I find it?
- Request or download the missing statement, covering the stated dates.
- Check its opening balance equals £1,055.60 and its closing balance equals £1,318.25.
- Import it and compare the sum of its money in and money out with the +£262.65 you worked out.
- If those two do not agree, look for duplicates or rows left out.
- Re-run the chain check across all five statements.
What if the bank no longer offers the old statement?
Different banks keep statements online for different lengths of time, so check your own banking pages or ask your bank how far back they can supply copies. If an old statement truly cannot be fetched, you can still keep your books honest: add a single dated entry labelled as the net movement for the missing period, using the two balances either side. Mark it clearly as an estimate, so no one mistakes it for itemised spending.
The chain check also helps when you are about to start a fresh set of books. Write down the statement dates and balances you have on a single page, with the opening and closing figure of each, and keep it with the files. It makes any future gap visible in seconds, and it is a good thing to hand to anyone helping you tidy your records, since it shows precisely which periods are covered and which are not.
Be gentle with yourself about older periods. You do not need a perfect history to get value from a tracker; a clean record from a known date forward is often enough, provided you write down that start date.
Make it a habit
When you import a new statement, spend ten seconds comparing its opening balance with the previous closing. A break shows up at once, while the missing file is still easy to download. Record the pair in a notes column or in your coverage sheet; it will save you a long hunt a year from now.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


