Savings Tracker · Free · No account
Track savings towards a target and date.
The workbook includes a Goals sheet, a Money in and out sheet and a Summary. Type a target and a date for each goal, log what goes in or comes out, and the workbook works out what is needed each month.
- Excel 2016 and later
- Calculations checked in LibreOffice and Google Sheets
- Choose the starting goalsStart from one goal, three goals, an emergency fund or sinking funds, or none. Decide whether to add Source and Priority columns.
- Set targets and datesDownload the workbook and, on the Goals sheet, type each goal, its target and the date you want it by. Add anything already saved.
- Log each amountOn Money in and out, pick the goal from the list and type the amount under Added, or under Taken out when you spend it.
Build your workbook
Preview: Several goals. Change the selected dates, categories or layout to update the preview.
JavaScript is required to use the builder. The workbook is made in your browser.
What you get
What it takes
Still to save, shared across the months left, so the monthly figure is clear.
Forecasts from recorded savings
Money taken out counts, and the pace is what you actually saved over the last three months.
On track or behind
✓ On track, or ◐ Behind with how many months it would take at this pace.
One goal or many
A deposit, an emergency fund, or sinking funds for the yearly costs that always come round.
The Several goals example
Three example goals with a priority each: Emergency fund, Holiday and New laptop. The Goals sheet shows Saved, Still to save, Needed a month and an On track? check. The Summary adds saved money month by month.
Sheets included (6)
- Start HereHow the workbook works, what each sheet is for and the settings used.
- GoalsEach goal once, with what is saved, left and needed.
- Money in and outEach amount saved, or taken out, one per row. The Goals sheet adds them up.
- SummaryTotals across your goals, what is due next and what was saved each month.
- ListsEdit the white lists to change dropdown choices. Shaded lists are fixed because formulas use those names.
- SettingsValues used by the workbook, such as reminder windows. Change them here.
File details
- Made for
- Excel 2016 and laterThe download is an .xlsx workbook.
- LibreOffice
- No calculation errors in our testLibreOffice recalculated every formula in the workbook with no error values, such as #VALUE! or #N/A.
- Google Sheets
- Calculations matched Excel in our testGoogle Sheets removes sheet protection and repeated print headings.
- Apple Numbers
- Some calculations do not workMany calculations on the Goals sheet and the Summary sheet do not work in Apple Numbers. Numbers converts list-based dropdowns to plain cells and removes colour markers, sheet protection, frozen headings and number and date validation. Use Excel for these calculations and features.
- Calculations
- The Start Here sheet lists the calculations used in this workbook. Results update from the entries you add.
- Builder privacy
- The builder runs in your browser. The entries used to make the workbook stay on your device. How the utilities work
Examples
Emergency fund tracker
People building emergency savings for rent, bills and food who want to see how many months away the target is.
Sinking fund tracker
Households who want yearly and irregular costs spread across the year instead of landing in one month.
Savings goals tracker
Anyone saving for a holiday, a laptop and a rainy day at the same time and deciding which matters most.
House deposit savings tracker
People saving towards one large target, such as a deposit, who want a clear monthly figure and a date.
Questions
Are my builder entries sent to Due Form?
No. The builder uses them in your browser to make the workbook on your device.
Information is sent to Due Form when you submit a form or use another service described on the How it works page.
How does it decide whether I am on track?
It compares the amount still needed against your saving pace over the last three months. It shows On track, or Behind with the number of months it would take at that pace.
What happens when I take money out?
Enter it under Taken out on Money in and out. It is subtracted from the goal, and it lowers the recent pace, so withdrawals reduce the forecast.
Can I print it?
Yes. The Goals sheet is set to print landscape and the Summary prints on one page, so you can file a copy each month.
Does it give savings advice?
No. The forecast uses your targets, dates and recorded savings. Update those figures when they change.
Request a tool or send feedback
Request a tool or report a problem
Tell us what you would like to add, change or fix in the Savings Tracker builder.