Free tool

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.

Updated 2026-11-02. Runs in your browser: what you type is not sent anywhere or saved, and is gone when you close the page.

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).

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

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.

  1. Still needed = 1,800 - 300 = 1,500.
  2. Months left = (2027 - 2026) x 12 + (11 - 11) = 12.
  3. 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

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 7

Opens 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 editions

About this tool