A retried savings deposit gets counted twice when your tracker treats every attempt as a new event instead of asking whether it has seen that deposit before. The remedy is a rule you can follow by hand: each deposit carries a unique reference, and a reference may appear only once. Here are the questions worth asking before you touch a single line.
Did the money actually move twice?
Always the first question. Open the account history itself, not the tracker. Count the credits into the savings account for the period. If the history shows one A$300 credit and your tracker shows two, the issue is the record. If the history shows two credits, you have a real double payment, which is a different problem to raise with your bank.
Is the same deposit coming from two sources?
Many people feed a tracker twice without realising: they type the deposit right after sending it, and later import or paste the statement. Neither is wrong, but together they create pairs.
- Typed note plus statement import for the same day.
- A scheduled transfer plus a manual top-up that was meant to replace it.
- A shared account where both partners record the same contribution.
- A pasted statement that overlaps with last month's paste by a few days.
What does a unique reference look like?
Something nobody would reuse by accident. A good reference joins the date, the goal and the amount, for example 2025-03-07-ROOF-300. If you are keeping a spreadsheet, put that in its own column and let the sheet shout when it sees a repeat.
- Put references in column A, starting at A2.
- In column B beside each, enter =IF(COUNTIF($A$2:$A$500, A2)>1, "duplicate", "ok") and fill down.
- Sort so every row marked duplicate sits together and compare each against the bank history.
- Delete only the surplus lines, never every row in the group.
A worked example for a roof-repair fund
Say you aim for A$3,000 and pay A$300 each month. After six months the pot should hold 6 × A$300 = A$1,800. Your tracker reports A$2,400, a difference of A$600, which is two lines of A$300. The sheet flags two references twice. The bank history confirms six credits only, so you remove the two surplus lines and the tracker settles at A$1,800. Progress toward the goal is A$1,800 ÷ A$3,000 = 60 per cent, not the 80 per cent the inflated figure suggested.
| View | Total | Progress toward A$3,000 |
|---|---|---|
| Tracker before cleaning | A$2,400 | 80 per cent |
| Bank history | A$1,800 | 60 per cent |
| Tracker after cleaning | A$1,800 | 60 per cent |
Does it matter if I use a phone note or a sheet?
Not for the principle. A phone note works if every line has its reference and you scan for repeats once a week. A sheet simply does the scanning for you. What matters is that there is one list of deposits, that each line is tied to a bank entry you can point to, and that you never add a line you cannot trace. When a tracker holds only lines you can trace, an inflated total becomes rare and easy to explain.
What should I do when a transfer fails halfway?
Pause. A failed or timed-out transfer might still have gone through. Look in the account history before logging anything, and look again after a few minutes, because some lines appear late. Add the deposit only once you can see it.
A short routine to keep it reliable
- Log deposits from the statement line, not from memory.
- Keep one monthly day for matching the tracker total with the account balance.
- Treat any difference as a question to answer, not a number to patch.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


