Your goal says $700 but you only moved $500. That usually means one deposit was entered twice: a screen froze, you tapped again, or a transfer was retried and both attempts were logged. The cure is a simple idea called idempotency: give every contribution a unique reference, and refuse to record the same reference twice.
How does a deposit get counted twice?
- You press save, nothing seems to happen, and you press it again.
- A bank transfer shows 'pending', so you repeat it and later both clear.
- You paste last week's rows into the sheet along with this week's.
- Two household members log the same deposit.
In each case, the money may have moved once but the tracker recorded it twice.
What does idempotent tracking mean?
It means doing the same operation twice has the same result as doing it once. For savings, each contribution carries a unique reference, such as the date plus the amount plus a short tag. If a second entry arrives with the same reference, it is recognised as a retry and ignored. Your total only moves when the reference is new.
| Reference | Date | Amount | Counted? |
|---|---|---|---|
| 2025-03-01-goal-car-100 | 1 March | $100 | Yes |
| 2025-03-01-goal-car-100 | 1 March | $100 (retry) | No, same reference |
| 2025-03-08-goal-car-100 | 8 March | $100 | Yes, new date |
How do you do this in a spreadsheet?
Add a reference column and a duplicate check. If references are in column A, rows 2 to 500, put this in column E to flag repeats: =COUNTIF($A$2:$A$500, A2)>1. It returns TRUE for any reference that appears more than once. Filter for TRUE and delete the extra rows.
Check the total separately: =SUMIF($B$2:$B$500, "goal-car", $C$2:$C$500) adds the amounts tagged goal-car in column B. If it differs from your account balance, look at the TRUE rows first.
What do you do after you find a double count?
- Confirm with your bank or account history how many times the money actually moved.
- Delete or reverse the extra entry, leaving a note with the date and reason.
- Recheck the goal total against the account balance.
- Add the reference column going forward.
How do you prevent it next time?
Log after the money moves, not before. If you are unsure whether a transfer went through, check your account history before entering it again. Keep one person in charge of logging, or add a column for who entered each row. Ten seconds of checking beats an hour of reconciliation.
What if both entries were real?
Sometimes you really did move $100 twice, for example once from each paycheck in the same week. The reference approach still works: the references differ because the dates or sources differ, so both count. The goal is to catch accidental duplicates, not to stop genuine repeats.
When two similar deposits happen on the same day, add a short note such as second paycheck or birthday money. That note becomes part of the reference and protects the real entry from being deleted in a later clean-up. A tracker that cannot tell a retry from a repeat will either double count or drop real money, and only a clear reference solves both.
A simple prevention checklist
- Check your bank history before re-entering a deposit
- Give every deposit a reference
- Flag repeated references automatically
- Log from one place only
- Reconcile the goal with the account every month
This describes a general record-keeping approach, and it does not claim any particular app does this automatically; check how yours handles repeated entries. Nothing here is financial advice.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

