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.

Download Excel template (.xlsx) 71 KB · no macros · Excel 2016+ and Google Sheets · v1.0, 31 Oct 2026

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.

Preview: the Example Funds tab (fictional data), as of 1 Nov 2026. Balances include the deposits and withdrawals on the Example Log tab. Monthly needed = still needed ÷ months left.
$3,870.00saved of $8,590.00 in targets (45.1%)
$861.90to set aside in Nov 2026 (plan: $850.00)
$4,720.00total needed over the next 12 months
1 · 3 · 4funded · on track · behind (plus 1 no plan, 1 past due)
FundTargetDueBalanceStill neededMonths leftMonthly neededPlanned% fundedStatus
Car insurance (6-month premium)$720.0015 Mar 2027$500.00$220.004$55.00$100.0069.4%On track
Holidays and gifts$900.0010 Dec 2026$700.00$200.001$200.00$200.0077.8%On track
Car repairs and maintenance$1,200.0031 Oct 2027$230.00$970.0011$88.18$80.0019.2%Behind
Annual subscriptions$240.0020 Jan 2027$120.00$120.002$60.00$40.0050.0%Behind
Summer vacation$2,400.001 Jul 2027$1,100.00$1,300.008$162.50$250.0045.8%On track
Home maintenance$1,500.0030 Sep 2027$460.00$1,040.0010$104.00$100.0030.7%Behind
Pet care (vet check-up)$500.001 May 2027$60.00$440.006$73.33$60.0012.0%Behind
Back-to-school$350.0015 Aug 2027$0.00$350.009$38.89–0.0%No plan
Phone replacement$600.0028 Feb 2027$600.00$0.003$0.00$75.00100.0%Funded
Car registration$180.0015 Oct 2026$100.00$80.000$80.00$20.0055.6%Past due
Total$8,590.00$3,870.00$4,720.00$861.90$925.0045.1%
Example Dashboard: % funded for each of the ten fictional funds as of 1 Nov 2026. Car insurance (6-month premium) 69.4%; Holidays and gifts 77.8%; Car repairs and maintenance 19.2%; Annual subscriptions 50.0%; Summer vacation 45.8%; Home maintenance 30.7%; Pet care (vet check-up) 12.0%; Back-to-school 0.0%; Phone replacement 100.0%; Car registration 55.6%.0%25%50%75%100%Car insurance (6-month premium)69.4% · On trackHolidays and gifts77.8% · On trackCar repairs and maintenance19.2% · BehindAnnual subscriptions50.0% · BehindSummer vacation45.8% · On trackHome maintenance30.7% · BehindPet care (vet check-up)12.0% · BehindBack-to-school0.0% · No planPhone replacement100.0% · FundedCar registration55.6% · Past dueFundedOn trackBehindPast dueNo plan

Chart: % funded from the same tab. The workbook's Dashboard draws this as a native bar chart, plus a column chart of the total to set aside each month.

What's inside the spreadsheet

TabWhat you typeWhat it calculates
Start hereNothingSteps, how the maths works, colour key, limits, disclaimer
FundsUp 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
LogDate, fund (dropdown), Deposit or Withdrawal, amount, note; 500 rowsTotal deposits and withdrawals, and a check on every row (unknown fund, missing type or amount)
PlanNothingThe amount for each fund in each of the next 12 months, the total needed per month, your planned total and the difference
DashboardNothingTotals, 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 DashboardAlready filledTen 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

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. Read Plan for the total to set aside this month and over the next 12 months, and Dashboard for totals, status counts and charts.
  6. 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.

FieldFormula
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

MonthNov 26Dec 26Jan 27Feb 27Mar 27Apr 27May 27Jun 27Jul 27Aug 27Sep 27Oct 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

Limits

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

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.