Sinking Funds Tracker (Free Spreadsheet Template)

A sinking fund is the budgeting trick that kills “surprise” expenses: you save a little every month toward a cost you know is coming — car repairs, Christmas, annual insurance — so that when the bill lands, the money is already sitting there. The expense stops being an emergency and becomes a withdrawal.

The concept needs almost no math, but it does need a place to live. This tracker is that place: one row per fund, and three computed columns that answer the questions that actually matter — how funded am I, how much is left, and how many months until I’m done?

As always on this site, every formula was verified against the worked example in the download’s second tab before publishing.

How the tracker works

Each fund gets four inputs: a name, a goal, what you’ve saved so far, and your monthly contribution. The sheet computes the rest:

% funded = saved ÷ goal (capped at 100%). In the example, Christmas & gifts is at 80% in August — which is exactly the point of a Christmas fund.

Remaining = goal − saved, floored at zero.

Months to goal = remaining ÷ monthly contribution, rounded up — because a partial month of saving doesn’t pay a bill. The example’s car repair fund ($750 remaining at $100/month) shows 8 months, not 7.5.

The totals row adds up your combined goals ($6,240 in the example), total saved ($1,600), and — most useful — the total monthly contribution ($520). That last number is what plugs into your budget as a single “sinking funds” line, like the one in our biweekly budget template.

Which funds should you have?

The template ships with eight starter funds, but the right list comes from a simple exercise: look back through the last 12 months of statements and write down every expense that was over $100 and not monthly. Those are your sinking funds. For most households the list looks like:

Certain and scheduled — annual insurance premiums, car registration, subscriptions billed yearly. You know the amount and the date; divide by the months remaining and you have your contribution.

Certain but unscheduled — car repairs, home maintenance, vet bills. You don’t know when, but the annual average is surprisingly stable. $1,000–1,500/year for an older car is a common planning number; adjust from your own history.

Chosen — vacation, Christmas, a new laptop. These are the pleasant ones, and funding them in advance is what makes them guilt-free.

Sinking fund vs. emergency fund

They’re different tools and shouldn’t share a row. An emergency fund is for genuine surprises — job loss, medical events. A sinking fund is for predictable irregular expenses. The practical reason to separate them: if Christmas raids your emergency fund every December, you don’t actually have an emergency fund; you have a Christmas fund with anxiety attached.

Where to keep the money

The spreadsheet tracks the plan; the cash itself can live anywhere that’s boring and slightly annoying to spend from — a separate high-yield savings account is the common choice. Some banks let you split one savings account into named buckets, which maps one-to-one onto this template’s rows. You don’t need ten separate accounts; you need one account and this sheet telling you who owns what inside it.

Using it in Google Sheets

1. Google Sheets → blank sheet → File → Import → Upload → choose the file → Replace spreadsheet.
2. Update the “Saved so far” column each time you contribute (or once a month — it’s four numbers).

Frequently asked questions

What if I can’t fund everything at once? Fund the certain and scheduled group first — those have real deadlines. The example’s $520/month total is a mature setup; starting with $50 toward one fund is a real start.

What happens after a fund hits 100%? Either stop contributing (annual bills), or keep going (car repairs — the fund refills after each use). The % funded column caps at 100% so a topped-up fund doesn’t distort the view.

Is it free? Yes — free for personal and commercial use, no signup. Spot an error? Tell us and we’ll re-verify against the example and fix it.