● SALE  60% off every template in the Etsy shop, for a limited time Pinterest Instagram Threads Facebook TikTok Tumblr
Shop on Etsy
Home›Savings Investing & Retirement›Sinking Funds Tracker Spreadsheet
Sinking Funds Tracker Spreadsheet hero image showing the savings planner workbook
SAVINGS INVESTING & RETIREMENT

Sinking Funds Tracker Spreadsheet

Car insurance, property tax and the holidays are not emergencies, they are just rare enough to feel like ambushes. This sinking funds tracker spreadsheet spreads each big bill into small monthly amounts, so when the day comes, the money is already waiting.

$3.00$7.5060% OFF

Sale price in our Etsy shop right now. Checkout, payment and instant delivery are handled by Etsy.

Instant DownloadExcel + Google SheetsPDF Guide Included

Big bills stop being surprises

A sinking fund is a simple idea with an outsized effect: instead of meeting a large bill all at once, you set aside a small amount every month toward it. This tracker runs that system for up to 30 funds at once. You set each fund up once with its target and the date the money is due, and the sheet calculates how much to save per month and per week to land exactly on time.

After setup, your only job is logging deposits and withdrawals on the Transactions tab, which holds up to 500 entries chosen by fund from a dropdown. The dashboard then keeps score: total goal, total saved, still to save and funds completed, plus every fund with its progress bar, days left and a pace flag comparing what you have saved with what you should have saved by today. A fund slipping behind shows up months early, while a few bigger deposits can still fix it.

A Due Soon list watches the next 60 days so nothing creeps up on you, and the Monthly Plan sets what you planned to save beside what you actually saved each month. There are printable cash envelope blocks for people who like paper, and a Yearly Summary showing deposits, withdrawals and your growing balance with charts. The EXAMPLE file comes filled with eight sample funds, from Christmas to car insurance, so the whole system makes sense before you start.

Inside the workbook: 8 tabs

What you receive

  • Google Sheets Access PDF with a one-click link that copies the tracker into your own account
  • BLANK Excel workbook, clean and ready, with all formulas live
  • EXAMPLE Excel workbook filled with eight sample funds, including Christmas and car insurance
  • Quick Start Guide PDF with setup in about 5 minutes, step by step
  • Separate files, no ZIP to unpack

Good to know

  • Runs in Microsoft Excel 2021 or Microsoft 365, and in Google Sheets with a free Google account
  • Both formats are the full tracker, not a cut-down copy
  • Set your own currency label in Settings
  • Nothing connects to your bank: you log each deposit yourself in seconds
  • Stuck at any point? Message us on Etsy and we reply within 24 hours

Questions about this template

The things buyers ask us most.

How many funds can I track?

Up to 30 funds, which covers most households with room to spare. Each fund gets its own target, start date and goal date, and the tracker works out the monthly and weekly amounts for every one of them. Typical funds include insurance premiums, property tax, holidays, car repairs, annual subscriptions, school costs and a vacation fund.

What do the pace flags mean?

Each fund on the dashboard carries a flag comparing what you have saved with what you should have saved by today. It reads Goal Met, On Track, Behind or No Due Date. Behind is the useful one: it appears months before a deadline, while topping up with slightly bigger deposits can still get that fund back on pace.

Can I change a target or due date later?

Yes, easily. Edit the fund on the Funds tab and the monthly amount, weekly amount, progress and pace flag all update themselves across the dashboard and plans. Life changes, bills change, and the tracker is built to absorb that without you rebuilding anything or checking formulas by hand afterwards.

Do I need both Excel and Google Sheets?

No, just pick the one you already use. The download includes both: BLANK and EXAMPLE workbooks for Excel, and an access PDF whose link copies the full tracker into your own Google Sheets. Both versions carry all eight tabs and the same calculations, and there is no subscription to keep either one running.

More in Savings Investing & Retirement

All templates in this category →

Three more workbooks from the same shelf.

FIRE Tracker

Your FI number, savings rate and FI date, worked out and tracked month by month.

$7.50 $3.00
View on Etsy
Retirement Planner Spreadsheet

Project savings to age 95 and see plainly whether you are on track.

$7.50 $3.00
View on Etsy
Investment Portfolio Tracker Spreadsheet

Every holding, gain and dividend in one file, with no bank logins ever needed.

$7.50 $3.00
View on Etsy
View on Etsy · $3.00