Sinking Funds Tracker With Free Monthly Savings Calculator

A sinking funds tracker is a spreadsheet that turns big, predictable costs (car repairs, holiday gifts, an annual insurance premium) into small monthly amounts and shows how close each fund is to its goal. You set a goal and a monthly amount, log each contribution, and the tracker tells you what is left and when you will get there. It suits anyone whose budget keeps getting knocked over by bills that arrive once or twice a year.

What the sinking funds tracker records

The sinking funds tab in our budget spreadsheet keeps one row per fund and works out the rest from what you type:

• Goal: the total you need, such as $1,200 for holiday gifts.
• Monthly goal: what you plan to put in each month.
• Contributions: each amount you move into the fund, logged as you go.
• Amount left: the goal minus everything saved so far.
• Progress: how much of the goal you have reached.
• Months left: how long the rest takes at your monthly goal.
• Estimated finish date: when the fund will be full at that pace.

The tab is a standalone tool, separate from the monthly budget tabs. When you move money into a fund, you log the contribution in the sinking funds tab and record the transfer in that month’s budget as savings. That way the monthly tabs know the money is spoken for, and the fund knows it arrived.

Sinking fund example: $1,200 in 10 months

The calculator above opens with this example: a $1,200 goal, $150 already saved and 10 months until you need the money. That leaves $1,050 to save, and $1,050 ÷ 10 = $105 a month.

The calculator also shows about $48 from each bi-weekly paycheck and about $24 a week. Those spread the same yearly total ($105 × 12 = $1,260) over 26 paychecks or 52 weeks, so they work even though some months have three paydays. The headline names the month you reach the goal, counted from today.

Say the fund is for holiday gifts. Here is the contribution log for the first four months, with a tight month in month 4:

Month	Contribution	Saved	Left	Progress	Months left at $105
Start		$150	$1,050	12.5%	10
1	$105	$255	$945	21.3%	9
2	$105	$360	$840	30.0%	8
3	$105	$465	$735	38.8%	7
4	$50	$515	$685	42.9%	7

Month 4 is where a tracker earns its place. You still need $685 and the plan has six months left, but at $105 a month it takes seven ($685 ÷ $105 is about 6.5, rounded up). The estimated finish date has slipped one month past the holidays.

You have two fixes. Raise the monthly goal to about $114 ($685 ÷ 6) for the rest of the plan, or keep $105, end with $1,145 and trim the gift list by $55. Without the log, you would only find out when the shopping starts.

How to set up sinking funds in the spreadsheet

1. List every irregular cost you expect in the next 12 months with its amount and due month. Last year’s bank and card statements are the fastest source.
2. Open the sinking funds tab and add one fund per cost with its goal.
3. Set each monthly goal: what is still needed divided by the months until it is due. Say your car insurance is $900, paid in one go in 9 months: that is $100 a month. With a full year to go, it would be $75.
4. On the setup tab, add a category in the savings group for these transfers, so every monthly tab budgets the total.
5. Each time you move money, log the contribution in the sinking funds tab and record the transfer in that month’s budget.
6. Once a month, check the amount left, progress, months left and estimated finish date. If a finish date passes the due date, raise that fund’s monthly goal.
7. When the bill is paid, set the goal for the next cycle so the fund keeps running.

The method: save first, spend on schedule

A sinking fund is money set aside in advance for a cost you can see coming. The formula is short: (goal minus what you have saved) ÷ months until you need it. The discipline is paying into it every month, even when nothing is due. Our guide to what sinking funds are covers the definition, where to keep the money and a worked setup for three funds.

Deciding which funds to run is the harder part. The list of sinking fund categories groups ideas by area (car, home, holidays, health, pets, kids, gifts) and shows how to size each from its annual cost. For households with children, the family budget guide covers funds for birthdays, school costs and activities.

If you are paid every two weeks, contributing per paycheck is often easier than per month. How to budget biweekly paychecks shows how to fit fund transfers around bill due dates, and the biweekly budget template page shows the paycheck view in the same spreadsheet. Annual bills you already know about also appear in the bill tracker spreadsheet calendar, which makes them easy to spot when you list your funds. And if you are paying off cards, sinking funds keep the next car repair from landing back on one; the debt snowball spreadsheet handles the payoff side.

Build your own sinking funds tracker

A working tracker needs two tabs. On a Log tab, put the date in column A, the fund name in B and the amount in C, one row per contribution.

On a Funds tab, use these columns from row 2: A Fund, B Goal, C Due date, D Saved, E Left, F Monthly goal (typed), G Progress, H Months left, I Estimated finish, J Needed per month. These formulas work the same in Google Sheets and Excel:

• Saved (D2): =SUMIF(Log!B:B,A2,Log!C:C)
• Left (E2): =MAX(0,B2-D2)
• Progress (G2): =IF(B2=0,0,MIN(1,D2/B2)), formatted as a percent
• Months left at your monthly goal (H2): =IF(E2=0,0,ROUNDUP(E2/F2,0))
• Estimated finish (I2): =EDATE(TODAY(),H2), formatted as a date
• Needed per month to finish by the due date (J2): =E2/MAX(1,(YEAR(C2)-YEAR(TODAY()))*12+MONTH(C2)-MONTH(TODAY()))

Include any amount you already have as the first row of the log. To flag a fund that is running late, add conditional formatting with the custom formula =$I2>$C2. In Google Sheets that is Format > Conditional formatting > Custom formula is; in Excel it is Home > Conditional Formatting > New Rule > Use a formula.

Progress bars are where the two apps differ:

• Google Sheets: =SPARKLINE(G2,{"charttype","bar";"max",1}) draws a bar inside the cell.
• Excel: there is no SPARKLINE function. Select the progress column and use Home > Conditional Formatting > Data Bars.

Who a sinking funds tracker suits

It suits you if your budget breaks every time an annual bill, a holiday or a car repair comes around. It also works well for couples saving toward shared goals and for anyone paid biweekly who wants a per-paycheck amount for each fund.

It is more than you need if you save for a single goal; a savings account and one formula do that. It does not read your bank balance: you log each contribution yourself, and because the tab stands apart from the monthly budget, you record each transfer in both places.

Start with the one irregular cost that surprised you most last year. Once that fund has run smoothly for two or three months, add the next one.