Sinking funds · monthly need · Excel
Sinking funds tracker — save for Christmas, car repairs, and vacation at once
Short answer. Give each known expense its own target, current balance, and deadline. Goals: up to 12 funds with target, saved balance, deadline, priority and status (Goals sheet).
- Review targets and balances every 30 daystype the date
Check your own case.
A planning rhythm, not a financial deadline or forecast.
Start typing right in the document — no sign-up. It stays in this browser; save it to your free Layers account to keep it, open it on your phone and share it.
Lida, Layers template assistant
Separate named goals are easier to review than one unexplained savings balance.
When the monthly need is too high, change the amount, date, or plan explicitly.
Deadlines
The rules, with the source
| What | Deadline | Source |
|---|---|---|
| Goals | Up to 12 funds with target, saved balance, deadline, priority and status | Goals sheet |
| Plan | Months left, monthly need, remaining balance and progress calculate automatically | Goals + Dashboard |
| Follow-through | Monthly deposit log, target-vs-saved chart, and printable trackers | Contributions + Printable |
The workbook uses the editable as-of date and does not assume investment returns. Verify balances, account rules, fees, taxes, and access restrictions.
Step by step
What to do, in order
1
Name each expense
Use separate funds for known costs such as Christmas, repairs, travel, insurance, or gifts.
2
Set the target
Enter the amount already saved and a realistic deadline; review the calculated monthly need.
3
Track deposits
Record contributions, reconcile balances, and change a target or date openly when the plan no longer fits.
Questions
Is this sinking-funds tracker free?
Yes. Fill and download the Excel workbook without signing in; a free account is only for saving a copy in Layers.
What is a sinking fund?
Money set aside over time for a known future expense, kept visible as its own goal.
How is the monthly amount calculated?
Remaining target divided by the number of months from the editable as-of date to the deadline, with a minimum of one month.
Can I track several goals at once?
Yes. The workbook supports 12 funds and totals the target, saved amount, remaining balance, and monthly need.
Does the tracker guarantee I will reach the goal?
No. It is a planning tool and does not predict income, returns, fees, or unexpected expenses.
Other documents
Keep the papers in one place
Letters, receipts and notices in one folder you can share with family or a lawyer. The templates and the editor are free; Layers is free for up to 20 people.
Planning template only — not investment, tax, accounting, or debt advice, and not a guarantee. Verify balances and account rules.