Sinking Funds: What They Are and How to Track Them
Build a sinking funds spreadsheet in Google Sheets: one formula works out your monthly contribution from a target date, plus progress bars and examples.
In short
A sinking fund is money you set aside each month for a known future cost, like car insurance, holiday gifts or a vacation. A sinking funds spreadsheet lists each fund with a target amount and a due date, then divides what's still missing by the months left. The monthly amount updates itself as you save.
A sinking fund is money you put aside every month for a cost you know is coming: car insurance in August, gifts in December, a vacation next summer. A sinking funds spreadsheet gives each fund a target and a due date, then works out the monthly contribution for you: what's still missing divided by the months left. When the bill arrives, the money is already there.
What is a sinking fund?
The term comes from corporate finance, where a company sets money aside on a schedule to pay off a bond. In a household budget it means the same thing on a smaller scale: you break a big future cost into equal monthly amounts and save them ahead of time.
A sinking fund has three parts:
- A purpose. One specific cost, such as "Car insurance" or "Christmas", not general savings.
- A target amount. What the cost will be, or your best estimate.
- A due date. When you'll need the money.
The difference from ordinary saving is the deadline. "Save more" is a wish. "$1,080 by 15 August" is a monthly number you can put in your budget.
Sinking fund vs emergency fund
| Sinking fund | Emergency fund | |
|---|---|---|
| Pays for | Costs you can predict | Costs you can't predict |
| Amount known? | Yes, or a close estimate | No, so you aim for 3–6 months of expenses |
| When you spend it | On schedule, when the bill is due | Only when something goes wrong |
| After you spend it | It starts again for next time | You rebuild it |
| Example | Annual car insurance | A job loss or a medical bill |
Many "emergencies" are really unfunded sinking-fund costs. A car that needs new tires, or a dog that needs its yearly vet check, isn't a surprise. It's a bill whose date you didn't write down. Sinking funds take those costs out of the emergency fund so it's still there for real emergencies.
Sinking fund examples
Look back at the last 12 months of spending and find the costs that didn't come every month. Those are your first funds. Common ones:
| Fund | Typical target | Due | Monthly (12 months out) |
|---|---|---|---|
| Car insurance (annual) | $1,080 | Once a year | $90 |
| Car maintenance and tires | $720 | Whenever, so keep a balance | $60 |
| Holiday gifts | $600 | December | $50 |
| Vacation | $1,800 | Summer | $150 |
| Annual subscriptions | $240 | Spread across the year | $20 |
| Pet vet and boarding | $480 | Yearly check-up | $40 |
| New phone or laptop | $900 | Every 3 years | $25 (over 36 months) |
| Property tax or HOA dues | Varies | Set dates | Target ÷ months |
Two kinds show up in that list. Dated funds (insurance, gifts, vacation) have a deadline, so the monthly amount is worked out from the date. Running funds (car maintenance, vet) have no fixed date. You pay in a fixed amount and spend from it when something comes up.
If your yearly subscriptions are scattered across the calendar, our subscription tracker spreadsheet lists every renewal date, which tells you exactly what the Annual subscriptions fund needs.
How do I track sinking funds in a spreadsheet?
You need two tabs in one Google Sheet: a Funds tab with one row per fund, and a Fund log tab where every deposit and withdrawal is a row. The log is the source of truth. The Funds tab only adds it up.
Fund log tab, starting in row 2:
| Column | Header | Example |
|---|---|---|
| A | Date | 12/1/2026 |
| B | Fund | Car insurance |
| C | Amount | 120 (a deposit) or −1080 (paying the bill) |
| D | Note | Monthly transfer |
Funds tab, starting in row 2:
| Column | Header | What goes in it |
|---|---|---|
| A | Fund | Name, spelled exactly as in the log |
| B | Target | The amount you need |
| C | Due date | When you need it (leave blank for running funds) |
| D | Planned | The monthly amount you committed to at the start |
| E | Saved | Formula |
| F | Months left | Formula |
| G | Monthly needed | Formula |
| H | Progress | Formula |
| I | Status | Formula |
Fill A to D yourself. The rest are the formulas below. Make the Fund column on the log a dropdown that reads from Funds!A2:A, so a typo can't create a fund that doesn't exist. Our guide to dropdown categories in Google Sheets shows how.
Step 1: Saved so far
In E2, add up every deposit and withdrawal for the fund:
=SUMIFS('Fund log'!C:C, 'Fund log'!B:B, A2)
Deposits are positive and withdrawals negative, so this is the fund's current balance.
Step 2: The monthly contribution formula
This is the formula that works from the target date. In F2, count how many monthly contributions you have left. That's the number of 1sts between now and the due month:
=IF(C2="", "", MAX(1, (YEAR(C2)-YEAR(TODAY()))*12 + MONTH(C2) - MONTH(TODAY())))
In G2, divide what's still missing by those months:
=IF(C2="", D2, MAX(0, B2-E2) / F2)
Fill both down. What they do:
- The monthly number goes down as you save. Every deposit raises Saved, so the remaining gap shrinks.
- A missed month shows up straight away. Skip December and Saved stays the same while Months left drops by one, so Monthly needed goes up.
- It never divides by zero.
MAX(1, …)treats a due date in the current month, or one already past, as one month left, so the whole remaining gap shows as due now. - Running funds just use Planned. No due date means no deadline, so G2 shows your fixed contribution.
Worked example. It's mid-November 2026 and car insurance of $1,080 is due on 15 August 2027. Months left = (2027 − 2026) × 12 + 8 − 11 = 9, for contributions on 1 December through 1 August. With nothing saved, Monthly needed = $1,080 ÷ 9 = $120. After three deposits ($360 saved, six months left) it's still $720 ÷ 6 = $120. If you skip one, it becomes $840 ÷ 6 = $140.
Step 3: Your total monthly sinking-fund bill
Under the last fund, add up column G:
=SUM(G2:G20)
That one number goes in your monthly budget as a single line, "Sinking funds", the same way rent does. In a zero-based budget spreadsheet, it's one of the jobs every dollar gets assigned to before the month starts.
Tracking progress
A target with no feedback is easy to ignore. Two columns give you a visual check without building charts.
Progress bar. In H2:
=SPARKLINE(MIN(1, MAX(0, E2/B2)), {"charttype","bar"; "max",1; "color1","#2e7d32"})
Each fund gets a small green bar that fills toward its target.
On track or behind. In I2:
=IF(E2>=B2, "Funded", IF(C2="", "Running", IF(G2<=D2, "On track", "Behind")))
If Monthly needed is still at or below what you planned, you're on track. If it has gone up because you missed or shortened a deposit, the fund shows Behind, and G tells you exactly how much to put in to catch up. Add conditional formatting on column I (green for Funded and On track, amber for Behind) and you can see where you stand in a second. The same sparkline bars work on a monthly budget dashboard in Google Sheets if you want your funds and your spending categories on one screen.
When the bill arrives
- Pay the bill from your main account as normal and log it as an expense.
- Log a withdrawal on the Fund log for the same amount, as a negative number. Saved drops to roughly zero.
- Roll the due date forward for yearly costs: replace C2 with
=EDATE(date, 12)or just type next year's date. Months left resets to about 12 and Monthly needed recalculates. - Deal with the difference. If the bill came in under target, leave the extra in the fund. It lowers next year's monthly amount. If it came in over, raise the target.
Where to keep the money
The spreadsheet tracks how much of your savings belongs to each fund. The money itself can sit in one savings account, with the Funds tab as the ledger. If your bank offers savings "buckets" or free sub-accounts, you can mirror the funds there too, but you don't need to. Once a month, check that the total of column E matches your savings balance. If it doesn't, a deposit or withdrawal is missing from the log.
Sinking funds in the Voice Sheet template
Sinking funds fit next to whatever budget method you already use. In an envelope budget spreadsheet they're the same idea as Roll envelopes, which build up instead of resetting. In the 50/30/20 budget they count as savings.
If you use Voice Sheet's free Personal Finances template, add the Funds and Fund log tabs to the same spreadsheet. Then add "Sinking funds" as a category on the Monthly Budget tab, with a budget equal to your total from Step 3. Your monthly transfer shows on the budget dashboard next to Food and Rent, so a skipped contribution stands out like any other gap in the budget.
To keep the deposits regular, set a monthly entry reminder on the Fund log for the 1st. The notification opens an entry already dated today, so logging the transfer takes a few seconds. You can also say it, for example "car insurance fund 120", and it's added as a row (3 voice entries a day free, unlimited with Premium). Voice Sheet doesn't connect to your bank or move money, so you make the transfer yourself and the sheet records it. That's the same approach as tracking expenses without linking your bank: the numbers in your sheet are the ones you chose to record.
Start with the three costs that hurt most last year, give each a due date, and let the formula tell you the monthly amount. By next December, the gift money will already be there.
Frequently asked questions
What is a sinking fund?
A sinking fund is savings set aside a little at a time for a specific cost you know is coming, such as an annual insurance bill, holiday gifts or new tires. You divide the cost by the months until it's due and save that amount each month, so the bill is already covered when it arrives.
How do I calculate how much to put in a sinking fund each month?
Subtract what you've already saved from the target, then divide by the number of months until the due date. A $1,080 insurance bill due in nine months with nothing saved needs $120 a month. In Google Sheets, a month-count formula keeps this figure correct as time passes and as you save.
What's the difference between a sinking fund and an emergency fund?
A sinking fund pays for a cost you can predict, so you know the amount and roughly when it's due. An emergency fund covers what you can't predict, like a job loss or a medical bill. You spend a sinking fund on schedule. An emergency fund stays untouched until something goes wrong.
Do I need a separate bank account for each sinking fund?
No. Many people keep all their sinking funds in one savings account and use a spreadsheet as the ledger that says how much of the balance belongs to each fund. Separate accounts or bank buckets make the split visible in your banking app, but they aren't required for the method to work.
How many sinking funds should I have?
Start with three to five, covering the irregular costs that have caught you out before, such as car repairs, annual bills and gifts. More funds mean more contributions to keep up with. Add a new fund when a predictable cost surprises you, and merge small funds that are due around the same time.
