Cards and UPI

Tracker balance not matching your UK bank? Find the gap in ten minutes

Your expense tracker balance and your bank balance disagree. Here is how to measure the gap in pounds and tell a wrong opening balance from a missing row.

Editorial illustration for Tracker balance not matching your UK bank? Find the gap in ten minutes

When your tracker says one balance and your bank says another, the cause is nearly always one of three things: the opening balance you typed in, a transaction that is missing or counted twice, or a date cut-off that differs between the two. Measure the gap first, then test each cause in turn. Most people finish in ten minutes.

Start with the gap, not a guess

Pick one statement period and write down two numbers: the closing balance printed on the bank statement, and the balance your tracker shows for the same last day. Subtract the smaller from the larger and note which way round it is.

Say your current account closed March at £1,846.20 according to the statement, but the tracker shows £1,611.20. The gap is £235.00, with the tracker running low. A round, exact figure like that is a clue in itself: errors from one stray transaction tend to match a real amount on the statement, and errors from the opening balance tend to match the difference between two balances you can look up.

How do I tell whether the opening balance is the problem?

The opening balance is the balance on the day before the first transaction your tracker holds. The statement gives you a clean test: opening balance plus money in, minus money out, must equal closing balance.

  • Statement opening balance: £2,100.00
  • Money in during March: £2,450.00
  • Money out during March: £2,703.80
  • Check: 2,100.00 + 2,450.00 - 2,703.80 = £1,846.20, which matches the bank.

Now look at what you typed into the tracker as the opening balance. If it is £1,865.00 (an older figure you had in your head), the tracker computes 1,865.00 + 2,450.00 - 2,703.80 = £1,611.20. The difference between the two opening balances, 2,100.00 minus 1,865.00, is exactly £235.00, which is the gap. When the gap equals the opening difference to the penny, the transactions are fine and only the starting figure is wrong.

What if the gap is not the opening difference?

Then a row is probably wrong. Compare the gap with the amounts on the statement.

Gap looks likeLikely causeWhat to do
Exactly one transaction amount, e.g. £47.50That row is counted twice, or one row is missingSearch the tracker for the amount; delete the duplicate or add the missing row
Exactly twice a transaction amount, e.g. £95.00A payment in was recorded as a payment out, or the reverseFind the £47.50 row and flip its direction
Small odd figure, e.g. £3.99A card payment or a subscription that settled after you lookedCompare dates; add the late item
Large round figureOpening balance, or a whole file imported twiceRe-run the opening balance test above

Is it a timing difference rather than an error?

Card payments can appear in your app instantly yet settle on the statement a day or two later. If you compare on the very last day of the month, a purchase made on the 30th may sit on one side and not the other. Compare at a date a few days after the last transaction, or compare statement to statement, where both sides use the same cut-off.

A ten-minute routine for every month

  1. Download the statement for the month and note its opening and closing balances.
  2. Check that this month's opening balance equals last month's closing balance.
  3. Compare the total of money in and money out on the statement with the same totals in your tracker.
  4. If both totals agree, the opening balance is the problem; fix it once, at the earliest date.
  5. If they disagree, use the gap table above to hunt the row, then recheck the closing balance.

When to ask someone else

If you have matched the totals, ruled out duplicates and the gap still stands, ask your bank for a copy of the statement for that period and compare it line by line with the one you have. Never share online banking logins or card details with anyone who offers to help; a statement file is all a bookkeeper or friend needs. Rules about what a bank must show you differ by provider, so check your own statement pages for the layout.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports