Home › Templates › Sinking funds tracker
Sinking Funds Tracker
A free sinking funds tracker for Excel and Google Sheets: list up to 15 planned costs with a target and a due date, log what you put in and take out, and the sheet shows each fund's balance, the monthly amount needed to be ready on time, % funded, an on-track status and a 12-month plan of how much to set aside in total.
Use it in Google Sheets: choose File → Import → Upload in Sheets and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. No sign-up, no add-on, no bank connection: you type the numbers yourself.
| Fund | Target | Due | Balance | Still needed | Months left | Monthly needed | Planned | % funded | Status |
|---|---|---|---|---|---|---|---|---|---|
| Car insurance (6-month premium) | $720.00 | 15 Mar 2027 | $500.00 | $220.00 | 4 | $55.00 | $100.00 | 69.4% | On track |
| Holidays and gifts | $900.00 | 10 Dec 2026 | $700.00 | $200.00 | 1 | $200.00 | $200.00 | 77.8% | On track |
| Car repairs and maintenance | $1,200.00 | 31 Oct 2027 | $230.00 | $970.00 | 11 | $88.18 | $80.00 | 19.2% | Behind |
| Annual subscriptions | $240.00 | 20 Jan 2027 | $120.00 | $120.00 | 2 | $60.00 | $40.00 | 50.0% | Behind |
| Summer vacation | $2,400.00 | 1 Jul 2027 | $1,100.00 | $1,300.00 | 8 | $162.50 | $250.00 | 45.8% | On track |
| Home maintenance | $1,500.00 | 30 Sep 2027 | $460.00 | $1,040.00 | 10 | $104.00 | $100.00 | 30.7% | Behind |
| Pet care (vet check-up) | $500.00 | 1 May 2027 | $60.00 | $440.00 | 6 | $73.33 | $60.00 | 12.0% | Behind |
| Back-to-school | $350.00 | 15 Aug 2027 | $0.00 | $350.00 | 9 | $38.89 | – | 0.0% | No plan |
| Phone replacement | $600.00 | 28 Feb 2027 | $600.00 | $0.00 | 3 | $0.00 | $75.00 | 100.0% | Funded |
| Car registration | $180.00 | 15 Oct 2026 | $100.00 | $80.00 | 0 | $80.00 | $20.00 | 55.6% | Past due |
| Total | $8,590.00 | $3,870.00 | $4,720.00 | $861.90 | $925.00 | 45.1% |
What's inside the spreadsheet
| Tab | What you type | What it calculates |
|---|---|---|
| Start here | Nothing | Steps, how the maths works, colour key, limits, disclaimer |
| Funds | Up to 15 funds: name, target amount, due date, starting balance, planned monthly amount (optional); an as-of date (optional) | Deposits and withdrawals from the log, balance, still needed, months left, monthly needed, % funded, status, monthly gap; totals; a duplicate-name check |
| Log | Date, fund (dropdown), Deposit or Withdrawal, amount, note; 500 rows | Total deposits and withdrawals, and a check on every row (unknown fund, missing type or amount) |
| Plan | Nothing | The amount for each fund in each of the next 12 months, the total needed per month, your planned total and the difference |
| Dashboard | Nothing | Totals, overall % funded, this month's set-aside, the next unfunded due date, status counts, a % funded bar chart and a 12-month column chart |
| Example Funds, Example Log, Example Plan, Example Dashboard | Already filled | Ten fictional funds and 16 log rows, so you can see every formula working |
A sinking fund covers a cost you can see coming. For costs you cannot plan, keep a separate cushion and track it with the emergency fund tracker. To find the irregular bills in the first place, start from your spending in the budget spreadsheet.
How to use it
- List your irregular costs. Go through 12 months of bank and card statements and note every bill that is not monthly: insurance premiums, gifts, car upkeep, subscriptions, school costs, travel.
- Open Funds. Type each fund's name, target amount, due date and the money already set aside for it (yellow cells). Make every name unique; E4 says OK when they are.
- Optional: type in column E how much you plan to move into each fund per month. Status then shows On track or Behind, and column N shows the monthly gap.
- Open Log. Each time you move money in, add a Deposit row; each time you spend from a fund, add a Withdrawal row. Pick the fund from the dropdown. Column F flags rows that need a fix.
- Read Plan for the total to set aside this month and over the next 12 months, and Dashboard for totals, status counts and charts.
- When a bill is paid, log the withdrawal, then type the next due date (and a new target if the price changed). The fund starts filling again from what is left.
Leave Funds!B4 blank and the sheet uses today's date. Type a date there to see the numbers as of that day, for example the first of next month.
Why sinking funds help
Irregular bills are easy to forget when you plan month by month. The CFPB's "Behind on bills? Start with one step" booklet (part of its Your Money, Your Goals toolkit) includes a bill calendar with this reminder: "Don’t forget things like birthday, holiday, and school expenses, or bills that are due every few months or once a year."
The FDIC gives similar advice in FDIC Consumer News (February 2021): "Be sure to take a look at the expenses you need to pay annually or semiannually, such as taxes or insurance premiums, and make sure to include them in your plan." On saving, it suggests: "Treat your savings like a bill and pay yourself first, even if it doesn’t seem like that much."
A sinking fund turns each of those bills into a small monthly amount. The tracker does the division for you and redoes it every month from the real balance, so a skipped month shows up as a higher monthly amount instead of a surprise on the due date.
Sinking fund or emergency fund? The CFPB's guide to building an emergency fund defines it as "a cash reserve that’s specifically set aside for unplanned expenses or financial emergencies." A sinking fund is the opposite: the cost, the amount and the date are known. Keeping them apart stops a planned bill from emptying the emergency cushion.
The formulas, explained
Exact formulas from the file (row 8 on Funds, row 5 on Plan, row 6 on Log). On Funds, A is the fund name, B the target, C the due date, D the starting balance and E the planned monthly amount; $B$5 is the date used. The log reads rows 6 to 505.
| Field | Formula |
|---|---|
| Date used (Funds!B5) | =IF(B4="",TODAY(),B4) |
| Deposits from the log (F) | =IF(A8="","",SUMIFS('Log'!$D$6:$D$505,'Log'!$B$6:$B$505,A8,'Log'!$C$6:$C$505,"Deposit")) |
| Withdrawals from the log (G) | =IF(A8="","",SUMIFS('Log'!$D$6:$D$505,'Log'!$B$6:$B$505,A8,'Log'!$C$6:$C$505,"Withdrawal")) |
| Balance (H) | =IF(A8="","",N(D8)+F8-G8) |
| Still needed (I) | =IF(A8="","",MAX(0,N(B8)-H8)) |
| Months left (J) | =IF(OR(A8="",C8=""),"",MAX(0,(YEAR(C8)-YEAR($B$5))*12+MONTH(C8)-MONTH($B$5))) |
| Monthly needed (K) | =IF(J8="","",IF(I8=0,0,I8/MAX(1,J8))) |
| % funded (L) | =IF(OR(A8="",N(B8)<=0),"",H8/B8) |
| Status (M) | =IF(A8="","",IF(N(B8)<=0,"Add target",IF(H8>=B8,"Funded",IF(C8="","Add due date",IF(C8<$B$5,"Past due",IF(E8="","No plan",IF(N(E8)+0.005>=K8,"On track","Behind"))))))) |
| Monthly gap (N) | =IF(OR(K8="",E8=""),"",MAX(0,K8-N(E8))) |
| Plan: month header (B4) | =DATE(YEAR('Funds'!$B$5),MONTH('Funds'!$B$5)+B$3,1) |
| Plan: amount for a fund in a month (B5) | =IF(OR($A5="",'Funds'!$K8=""),"",IF(B$3<MAX(1,'Funds'!$J8),'Funds'!$K8,0)) |
| Plan: planned total for the month (B21) | =SUMIFS('Funds'!$E$8:$E$22,B5:B19,">0") |
| Log: row check (F6) | =IF(AND(B6="",D6=""),"",IF(COUNTIF('Funds'!$A$8:$A$22,B6)=0,"Fund not found",IF(AND(C6<>"Deposit",C6<>"Withdrawal"),"Pick a type",IF(N(D6)<=0,"Amount?","OK")))) |
| Funds: duplicate-name check (E4) | =IF(COUNTA(A8:A22)=0,"Add your first fund in row 8",IF(SUMPRODUCT((A8:A22<>"")/COUNTIF(A8:A22,A8:A22&""))<COUNTA(A8:A22),"Two funds share a name: make each name unique","OK")) |
| Dashboard: next due fund (B12) | =IF(COUNT(H16:H30)=0,"None",INDEX(A16:A30,MATCH(MIN(H16:H30),H16:H30,0))) |
Months left counts calendar months from the as-of month up to, but not including, the due month. A bill due on 15 Mar 2027, seen on 1 Nov 2026, gets four contributions: November, December, January and February. That keeps the money in place before the bill arrives, whatever day of the month it falls on. If the due month is the current month or has passed, months left is 0 and the whole shortfall is needed now.
N() turns a blank cell into 0, so an empty input never breaks a formula. The status check allows half a cent of rounding before it says Behind.
Worked example from the sample data
The Example tabs use ten made-up funds as of 1 Nov 2026. Starting balances were typed on the Funds tab; the Log tab adds two months of transfers and two withdrawals.
Car insurance: on track
Target $720.00, due 15 Mar 2027. Starting balance $300.00 plus two $100.00 deposits = $500.00, so $220.00 is still needed. Months left: (2027 − 2026) × 12 + 3 − 11 = 4. Monthly needed: $220.00 ÷ 4 = $55.00. The plan is $100.00 a month, so the status is On track and the fund will be full before March.
Car repairs: behind after a withdrawal
Target $1,200.00, due 31 Oct 2027. $250.00 + $160.00 of deposits − $180.00 for two tyres = $230.00. Still needed $970.00 over 11 months = $88.18 a month. The plan is $80.00, so the status is Behind and the monthly gap is $8.18. The withdrawal did its job, and the sheet shows the cost of refilling.
Annual subscriptions: behind because time is short
$120.00 saved of $240.00, due 20 Jan 2027: 2 months left, so $60.00 a month is needed against a $40.00 plan, a $20.00 gap.
Car registration: past due
Due 15 Oct 2026 with $100.00 of $180.00 saved. The due date is before the as-of date, so the status is Past due and the full $80.00 shortfall lands in November on the Plan tab.
Phone replacement: funded
$450.00 + $150.00 = $600.00, equal to the target. Status Funded, monthly needed $0.00, and it drops out of the plan.
The 12-month plan
| Month | Nov 26 | Dec 26 | Jan 27 | Feb 27 | Mar 27 | Apr 27 | May 27 | Jun 27 | Jul 27 | Aug 27 | Sep 27 | Oct 27 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Total needed | $862 | $582 | $522 | $522 | $467 | $467 | $394 | $394 | $231 | $192 | $88 | $0 |
| Planned (column E) | $850 | $630 | $590 | $590 | $490 | $490 | $430 | $430 | $180 | $180 | $80 | $0 |
| Planned − needed | −$12 | +$48 | +$68 | +$68 | +$23 | +$23 | +$36 | +$36 | −$51 | −$12 | −$8 | $0 |
November needs $861.90 because the past-due registration and the December holidays fund both need money now; the planned $850.00 is $11.90 short. From December to June the plan runs ahead of what is needed, mostly because car insurance and the vacation fund are planned above their minimum. From July it falls short again: back-to-school has no plan, and car repairs and home maintenance need slightly more than their plans. The 12-month total needed is $4,720.00, which equals the total still needed, because every example fund is due within 12 months.
Common mistakes
- Names that don't match. The log matches funds by exact name. "Car insurance" and "Car Insurance " (with a space) are different. Use the dropdown; Log column F flags unknown names.
- Typing withdrawals as negative numbers. Amounts are always positive; the Type column decides whether money goes in or out.
- Counting deposits twice. The starting balance is what you had before the first log row. Don't also log that amount as a deposit.
- Forgetting to roll the due date. After paying a yearly bill, type next year's due date. Otherwise the fund shows Past due or Funded and stops asking for money.
- Using the sinking fund as an emergency fund. If you dip into the car insurance fund for something unplanned, log it as a withdrawal so the monthly amount goes up.
- Targets from last year's prices. Premiums and subscriptions change. Check the renewal notice and update the target.
Limits
- No interest is added to balances, and one currency is assumed.
- Months left uses calendar months, not days. A bill due on the 1st and one due on the 28th of the same month get the same number of contributions.
- The plan covers 12 months. A fund due later keeps needing its monthly amount after the window (Funds column K).
- Log rows count whatever their date, including future-dated rows.
- Recurring bills are not repeated automatically; you type the next due date after each payment.
FAQ
What is a sinking fund?
A sinking fund is money you set aside in small amounts for a cost you know is coming: an insurance premium, holiday gifts, car repairs, an annual subscription. When the bill arrives, the money is already there. The CFPB's bill calendar tool reminds people not to forget "bills that are due every few months or once a year"; a sinking fund is one way to cover them.
How do you calculate how much to save for a sinking fund?
Subtract what you have saved from the target, then divide by the number of months until the bill is due. In the example, car insurance needs $720.00 by 15 Mar 2027 and has $500.00 saved, so $220.00 ÷ 4 months (Nov to Feb) = $55.00 a month. The spreadsheet does this for every fund and recalculates each month from the real balance.
What is the difference between a sinking fund and an emergency fund?
A sinking fund is for a known cost with a date and an amount. An emergency fund is for costs you cannot plan: the CFPB describes it as "a cash reserve that’s specifically set aside for unplanned expenses or financial emergencies." Many people keep both, so a planned bill does not drain the emergency money. Track the emergency side with the emergency fund tracker.
How many sinking funds should I have?
There is no official number. Start with the irregular bills you already pay: go through 12 months of bank and card statements and list everything that is not monthly. The template holds up to 15 funds; fewer, larger funds are easier to manage than many small ones.
Should sinking funds be in a separate bank account?
That is a personal choice. Some people use one savings account and track each fund in a spreadsheet like this one; others open several accounts or use labelled savings buckets. If you use a bank, check that it is FDIC-insured: FDIC deposit insurance covers $250,000 per depositor, per FDIC-insured bank, for each account ownership category.
Can I use this sinking funds tracker in Google Sheets?
Yes. In Google Sheets choose File → Import → Upload and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. The formulas use SUMIFS, COUNTIF, SUMPRODUCT, INDEX, MATCH, DATE, YEAR, MONTH and IF, which work in Excel 2016+, Google Sheets and LibreOffice. There are no macros and no dynamic arrays.
Related tools and templates
- Emergency fund trackerFor costs you can't plan
- Budget spreadsheetFind your irregular bills
- Net worth trackerAssets minus debts over time
- Compound interest spreadsheetGrowth with regular deposits
- FIRE calculator spreadsheetYears to financial independence
- All templatesFree spreadsheets
Educational template only, not financial advice. Example data is fictional: the funds, amounts, dates and transfers are made up to show the formulas and are not a recommendation. CFPB and FDIC material was retrieved on 31 October 2026.