If you began tracking part-way through a month, the most common reason the tracker's balance differs from the bank's is that the opening balance and the first imported transaction do not describe the same day. Choose one anchor date, line both up to it, and the gap usually disappears.
One date, one balance
An opening balance is only meaningful with a date attached. It says: on this day, after the last transaction of the day, the account held this much. Every transaction you load must be dated after that day, never on or before it.
Say a couple share a household account and decide on 15 May to start tracking. They read the statement balance at the end of 14 May: €3,420.55. If they type that as the opening balance and then import the whole of May, including 1 to 14 May, those first fourteen days are applied on top of a balance that already includes them.
Worked example with euros
| Item | Amount |
|---|---|
| Bank balance at close of 14 May (typed as opening balance) | €3,420.55 |
| Net movement 1 to 14 May (out €1,012.30, in €400.00) | -€612.30 |
| Net movement 15 to 31 May | -€845.10 |
| Real bank balance on 31 May (3,420.55 - 845.10) | €2,575.45 |
| Tracker balance (3,420.55 - 612.30 - 845.10) | €1,963.15 |
| Gap (2,575.45 - 1,963.15) | €612.30 |
The gap is exactly the net movement for 1 to 14 May. That pattern, a gap equal to the net of a block of days, points to an overlap between the opening balance date and the import range.
Which of the two should I change?
You have two clean options, and only one of them needs the same fix each time.
- Keep the opening balance of €3,420.55 and delete or skip the transactions dated 1 to 14 May.
- Or keep the full May import and change the opening balance to the balance at the close of 30 April. Here that is 3,420.55 + 612.30 = €4,032.85.
- Whichever you choose, write the anchor date next to the opening balance so you remember what it means.
Why does a shared account go wrong more often?
Two people tend to enter things independently. One imports the statement; the other adds a cash payment by hand that the bank never sees, so the tracker then shows an outflow the bank does not. Standing orders and direct debits that the other partner set up can also surprise the person who does the tracking. Agree who owns the statement import, and put hand-entered cash in a separate cash account rather than in the bank account.
What if the gap is small, not a block of days?
A gap of a few euros is usually a single row. Compare the gap with individual amounts on the statement. If it equals one amount, look for a duplicate or a missing row; if it equals twice one amount, look for a row recorded in the wrong direction. A card payment that settles a day later than you recorded it can also open a small temporary difference at month end.
A short checklist
- Write down the anchor date and the bank balance at the close of that day.
- Enter that balance as the opening balance, dated the same day.
- Import only transactions dated after the anchor date.
- At the first month end, compare closing balances. Fix any gap before the second month begins.
- Repeat the closing balance comparison every month, because errors left alone are harder to trace later.
If the numbers still disagree after all this, ask your bank for a fresh statement covering the whole period and compare totals of money in and money out. A bank's own rules on statement layouts vary, so read the headings on your own file rather than assuming.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


