If a savings transfer shows up twice in your tracker, the money almost certainly moved once and was written down twice. The fix is to give every contribution a unique reference and to check for that reference before you add a line. That habit has a name, idempotent tracking: doing the same action twice leaves you with the same result as doing it once.
How does one transfer turn into two entries?
Say you move €150 into a holiday pot on the first of the month. The banking app hangs on a spinner, so you tap again. The bank processes one transfer, but you noted it in your tracker both times, or you noted it by hand and then loaded a statement that lists it as well.
- You typed the entry yourself and later loaded the statement that contains the same transfer.
- A pending line and the settled line for the same payment were both recorded.
- A standing instruction and a manual top-up were both logged as the one monthly contribution.
- A retry after a failed screen created a second note while the first attempt had in fact gone through.
What is idempotent tracking in plain words?
Think of a light switch marked ON. Pressing it a second time does not make the room brighter. Your ledger should behave the same way: recording the same contribution twice should change nothing. To get there, build a reference from facts that do not change between attempts: the date the money left, the pot name, the amount, and the reference text on your bank line.
| Date | Pot | Bank reference | Amount | Keep? |
|---|---|---|---|---|
| 01 Mar | Holiday | HOL-MAR | €150 | Yes |
| 01 Mar | Holiday | HOL-MAR | €150 | No, same reference |
| 01 Apr | Holiday | HOL-APR | €150 | Yes |
| 15 Apr | Holiday | TOPUP-15 | €40 | Yes, different reference |
The second row is the retry. It carries the same date, pot, reference and amount as the first, so it is the same event and should not count.
A worked example with real arithmetic
Suppose your target is €1,800 by December and you plan €150 a month from January. After five months you should hold 5 × €150 = €750. Your tracker says €900. The gap is €900 − €750 = €150, exactly one contribution, which is a strong sign of a single duplicate rather than a vague error. Open your bank balance for the pot: if it shows €750, the tracker is wrong, not the bank.
How do I spot duplicates in a spreadsheet?
- Keep one row per contribution with date in column A, pot in B, reference in C and amount in D.
- In column E enter =COUNTIFS($A$2:$A$500, A2, $B$2:$B$500, B2, $C$2:$C$500, C2, $D$2:$D$500, D2) and fill down.
- Filter column E for values above 1. Every row in that list belongs to a repeated group.
- Keep the first row of each group, mark the others as duplicates in a notes column, then delete them once you have compared with the bank figure.
This works in Excel and Google Sheets. COUNTIFS counts rows where every pair of range and value matches, so a count of 2 means two identical lines.
What if I really did pay the same amount twice?
It happens: two €50 top-ups on the same day because a bill came in. The difference is the reference. Give each real payment its own short note, such as TOPUP-AM and TOPUP-PM, before you save. If you cannot tell them apart, trust the bank statement and never delete a line only because it looks similar.
A five-minute weekly check
- Add contributions only from the bank line, never from memory of tapping the button.
- After a failed or slow transfer, wait for the confirmation in your bank history before noting it.
- Run the duplicate column once a week and clear anything above 1.
- On the first of each month, compare tracker total with the pot balance and write the difference, even if it is zero.
Useful ideas start with a clearer picture of your own spending.
Explore your reports
