When a savings goal is finished, retire it by changing its status and moving it out of sight, never by deleting the rows. The contributions, dates and final outcome stay in your records, and your active list shows only goals that still need attention.
Use one log, not many scattered notes
The simplest set-up is a single sheet with one row per contribution: Date, Goal, Amount, Note. A second small sheet has one row per goal: Goal, Target, Status, Finish date. Because all goals share the log, retiring one means changing one cell in the second sheet, and the history stays intact.
How to retire a goal in this set-up
- Add a final row to the log for any last payment or withdrawal.
- Change the goal's Status from Active to Done and fill in the finish date.
- Add a filter to the goal list so Active is the default view.
- Write one line in the Note column about what the money was used for.
- Save a copy of the file with the date in its name.
A worked example in pounds
Say the goal is a holiday, target £2,000. You paid in £150 for 12 months, which is £1,800, and added £200 of birthday money, making £2,000. The trip cost £1,860, leaving £140.
| Line | Amount (£) |
|---|---|
| Twelve contributions of £150 | 1,800 |
| Birthday money | 200 |
| Total saved | 2,000 |
| Trip cost | 1,860 |
| Returned to general savings | 140 |
Check: 12 × 150 = 1,800; 1,800 + 200 = 2,000; 2,000 − 1,860 = 140.
How do I count a leftover?
Treat it as a transfer out of the goal into general savings. Do not delete it from the goal, because then the log would show £2,000 in and only £1,860 out, with the difference unexplained. A leftover line of £140 makes the goal balance exactly zero, which is how you know it is closed.
A quick audit before you hide it
- Does the goal's balance now equal zero?
- Do the contributions add to the total you expect?
- Does the Done status appear in the list but stay out of the Active view?
Goals that were abandoned, not finished
Not every goal ends well, and those need archiving too. If you stopped saving for a car because your plans changed, record the final balance, mark the status as Stopped rather than Done, and note in a line why. Move any money back to general savings with its own log row. The record of a goal you stopped is useful, because it shows how your priorities shifted and what you spent the money on instead.
- Use a different status for stopped goals.
- Write the reason in the Note column.
- Check the balance is zero before you hide it.
A final suggestion is to review the archive once a year with a simple question: which goals were finished on time, and what slowed the others down? If your holiday goal ran two months late because of one expensive month, note the cause. Over a few years the archive becomes a guide to your own habits, and you can plan the next target with more realism. Keep the archive in the same file as the active goals, so a single search covers both, and back the file up somewhere you control.
Reviewing finished goals
Once or twice a year, open the Done list and compare target with actual cost. If your holiday came in £140 under budget, that is a useful number for planning the next one, and you only have it because you kept the record.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

