Sinking Fund Calculator
Add each thing you are saving for, how much you need, how much you already have and when you need it. You get the amount to set aside each month, per goal and in total.
Total to set aside each month
0.00
Want every goal tracked month by month in one spreadsheet? See our Excel household budget template (USD 7) or open it on Gumroad (USD 7).
Monthly: - · Months left: - · Still needed: -
What is a sinking fund?
A sinking fund is money you put aside a little at a time for a cost you already know is coming: a yearly insurance bill, car repairs, holidays, school fees, a new laptop. Instead of paying the whole amount out of one month's income, you divide it over the months you have left, so the bill is covered when it arrives. Many people keep one fund per goal so each balance is easy to check.
Multiple goals, one monthly total
The page starts with two goals; use "+ Add a goal" for more and "Remove" for any you do not need. Each goal gets its own monthly amount from its own target date, so a bill due in 3 months and one due in 18 months are not averaged together. The total under the list adds up the monthly amounts of all goals: the one number to move into savings each month.
How the calculator works
For each goal it uses exactly these rules:
Still needed = max(0, Target amount - Saved so far)
Months left = (target year - this year) x 12 + (target month - this month)
Monthly = Still needed / Months left
Total monthly = sum of Monthly over all goals
- Months are counted as calendar months from this month to the target month, so November to December is 1 month. The day of the month is not used.
- "This month" comes from your device's date.
- If the target month is this month or already past, Months left is 0 and the whole amount still needed is shown as the monthly amount.
- If Saved so far is equal to or more than the target, the goal shows as reached and adds 0 to the total.
- Amounts are plain numbers, so any currency works. Results are rounded to 2 decimals for display; the total is summed before rounding.
- There is no interest. Money in a savings account may earn a little, so this is a slightly cautious estimate.
Worked example
Say today is 2 November 2026. Your car insurance of 1,800 is due on 15 November 2027 and you have already saved 300.
- Still needed = 1,800 - 300 = 1,500.
- Months left = (2027 - 2026) x 12 + (11 - 11) = 12.
- Monthly = 1,500 / 12 = 125.00.
Add a second goal, a 900 holiday in May 2027 with nothing saved: Months left = (2027 - 2026) x 12 + (5 - 11) = 6, so 900 / 6 = 150.00. The total to set aside is 125.00 + 150.00 = 275.00 a month.
Common questions
How much should I save each month for each goal by its target date?
Enter each goal's target amount, what you have saved and the target month. Each goal shows (target - saved) / months left, and the total under the list is the one amount to move into savings each month.
Can it put one goal ahead of the others?
No. Every goal gets exactly what it needs for its own date. If the total is more than you can save, move a target date later or lower a target and the monthly amounts update at once.
What it does not do
- It does not track deposits over time; update Saved so far whenever you check.
- It does not remember your goals. Nothing is stored, so write the numbers down or use a spreadsheet if you want to keep them.
- It does not tell you whether you can afford the total. Compare it with what is left of your income after bills.
Want this as a reusable Excel sheet?
The Household Budget & Expense Tracker template has a Sinking Funds sheet for up to 30 goals that uses the same month rule, next to a transaction list, monthly and annual summaries and a payday budget. No macros.
Household Budget template on Gumroad · USD 7Opens the Gumroad product page. The price shown there is the one that applies.
Screenshots and details of the Household Budget template
How to make a sinking funds tracker in Excel (free step-by-step guide)
How to make a household budget in Excel (free step-by-step guide)
All English templates, including free lite editionsAbout this tool
- Made with AI (Claude). The calculation is checked by automated tests, including the worked example above.
- A planning aid with simple arithmetic. Not financial, tax or investment advice.
- This page collects no personal data. No ads, no cookies and no browser storage; your inputs never leave your browser. Cloudflare Web Analytics (cookieless) counts page loads. The server only counts daily page views and buy-button clicks per page and referring site (no IP address, no user agent).