Sinking Funds Tracker Template for Google Sheets (Free, 2026)

Most budgets only plan for the month in front of you. That works right up until a $1,200 car repair, a $600 insurance renewal, or a $900 Christmas lands — and suddenly a normal month feels like an emergency. None of those expenses were actually surprises. They were predictable. They just weren't planned for. That's exactly the gap a sinking funds tracker in Google Sheets closes: it turns each big, irregular expense into a small, scheduled monthly contribution you barely notice.

This guide explains what sinking funds are, how to set them up, and how to keep them on pace with a free template — plus a way to stop the whole system from going stale.

What are sinking funds?

A sinking fund is money you set aside a little at a time for a specific expense you know is coming. The name is old — companies have used "sinking funds" for centuries to set aside cash to repay a debt or replace equipment. The personal-finance version is the same idea, scaled down: instead of paying a large cost in one hit, you spread the saving across the months leading up to it.

The mechanics are simple. You decide:

1. What the expense is — the fund's name (Car Repairs, Holiday, Christmas).
2. How much it will cost — the target amount.
3. When you'll need it — the due date.

Divide the target by the number of months until the due date and you have your monthly contribution. A $1,200 holiday 12 months out is $100 a month. A $600 insurance premium due in 6 months is $100 a month. Save those amounts, and the bill is fully funded before it arrives. No credit card, no scramble, no blown budget.

Sinking fund vs. emergency fund

These two get confused, but they do different jobs:

• An emergency fund is for the genuinely unexpected — a job loss, a broken boiler, a surprise medical bill. You don't know what it'll be or when it'll hit, so you keep a general cushion.
• A sinking fund is for the expected but irregular — your car's annual service, holiday gifts, an insurance renewal. You know it's coming and roughly what it costs, so you plan for it on purpose.

Sinking funds actually protect your emergency fund. When you've saved ahead for Christmas, you don't have to raid your safety net to cover it. Over a year, the two systems working together mean far fewer "where did that come from" moments — the unexpected gets the cushion, the predictable gets a fund, and your checking account stops absorbing shocks it was never meant to carry.

Why sinking funds beat willpower

The reason sinking funds work isn't math, it's psychology. A single $1,200 expense feels like a penalty; twelve $100 contributions feel like a routine. By the time the car needs new tires, the money is already sitting there with that job's name on it, and the decision to spend it is easy because you made it months ago. You've removed the moment of pain and replaced it with a habit. That is also why a tracker matters: seeing each fund inch toward its target is the feedback loop that keeps the habit going.

Common sinking fund categories

You don't need a fund for everything — just for the costs that are big enough to disrupt a month and predictable enough to plan for. The most common:

• Car — repairs, maintenance, tires, registration, and the next set of brakes.
• Travel and holidays — flights, accommodation, and spending money for trips.
• Christmas and gifts — December alone, plus birthdays scattered through the year.
• Insurance premiums — annual or semi-annual policies you pay in a lump sum.
• Annual bills and subscriptions — anything billed once a year instead of monthly.
• Home — repairs, appliances, and furniture you'll eventually need to replace.
• Medical and dental — checkups, glasses, and predictable out-of-pocket costs.
• Taxes — property tax or any bill that arrives once or twice a year.

A good test: if it lands once or twice a year and makes you wince, it deserves a fund.

How much to put in each one

The size of each fund comes from real history, not optimism. Pull up last year's spending — Avery or your bank statements make this fast — and find what each of these categories actually cost in US dollars. People consistently underestimate two of them: car costs (because repairs are sporadic and forgettable) and the holidays (because December spending hides across dozens of small purchases). Set the target a little above last year's figure to leave headroom, then let the months until the due date do the rest of the work. A fund you set too low just becomes another surprise, so err on the generous side and enjoy the leftover.

It also helps to separate fixed-date funds from rolling funds. A fixed-date fund has a hard deadline — an insurance renewal on a known date, a wedding you're attending in September. A rolling fund has no single due date and just needs a healthy balance you top up — a car-repairs fund is the classic example, since you never know exactly when the next repair lands, only that one is coming. The tracker handles both: give fixed-date funds a real deadline, and give rolling funds a target balance with a contribution you keep flowing in.

How to make a sinking funds tracker in Google Sheets (step by step)

You can build one from scratch, but starting from a template means the formulas already work. Here's the full process either way.

Step 1: List your funds

Add one row per irregular expense. Keep it focused — start with three to five funds rather than twenty. The most disruptive costs first: car, travel, gifts, and an annual-bills fund cover most people. You can always add more once the habit sticks.

Step 2: Set a target and a due date

For each fund, enter the total amount you'll need and the date you'll need it. Be realistic on the target — look at what last year's car repairs or holiday actually cost, in US dollars, rather than guessing low. The due date is what drives the math in the next step.

Step 3: Let the sheet calculate the monthly contribution

This is where a template earns its keep. The core formula divides the amount still needed by the months remaining:

• Monthly contribution — (target − current balance) ÷ months until due date.
• Progress — current balance ÷ target, shown as a percentage.
• On pace? — compares your balance to where it should be by now and flags any fund that's behind.

Lay a "required this month" column next to each fund and sum it, and you get the single most useful number in the whole sheet: your total monthly sinking-fund commitment. That's the figure to fold into your budget.

Step 4: Fund them every month

You have three options, in increasing order of "set it and forget it":

1. Manual logging — record each contribution as you transfer the money. Most hands-on.
2. Monthly catch-up — sit down once a month and log every fund's deposit at once.
3. Automatic sync — connect Avery and your contributions show up and update each fund for you.

One account or many?

A common question: should each fund live in its own bank account? Both approaches work.

• One account, many funds on paper. Keep a single savings account and use the tracker to divide the balance into named funds. Cheaper and simpler — the spreadsheet is the source of truth for what belongs to each goal. The risk is accidentally spending earmarked money, which the tracker prevents by always showing what's allocated.
• Separate accounts per fund. Some banks let you open multiple sub-accounts or "pots." This makes the boundaries physical, but it's more to manage. The tracker still gives you the dashboard and the on-pace math across all of them.

Most people start with one account and the tracker, then split out only the funds they keep dipping into by mistake.

One detail worth getting right either way: keep your sinking funds out of your everyday checking account. Money that sits next to your spending balance tends to get spent. A separate savings account — even a single one holding all your funds — adds just enough friction that the balance survives the month, while the tracker keeps the accounting honest.

A worked example

Say you're setting up three funds in June 2026, all amounts in US dollars:

• Car maintenance — a rolling fund. You target a $900 balance and contribute $75 a month until you reach it, then hold it there and top up after any repair.
• Holiday — a fixed-date fund. The trip is next June, the budget is $1,800, so that's $150 a month over 12 months.
• Christmas — a fixed-date fund. You spent about $720 last December, due in 6 months, so $120 a month gets you there in time.

Add those up and your total monthly sinking-fund commitment is $345. That's the number you fold into your monthly budget as a single line. It feels like a real expense because it is one — you're just paying it ahead of time, in installments, instead of all at once when the bill arrives. Six months in, the Christmas fund is full, the holiday fund is halfway there, and the car fund has already absorbed one unexpected repair without touching anything else.

How to calculate the monthly contribution for any fund

Every contribution figure in the tracker comes from one core sum, and it's worth understanding it even when the sheet does it for you. The formula is:

monthly contribution = (target − current balance) ÷ months until due date

The "current balance" term is the part people forget, and it's what makes the math self-correcting. If you already have $300 in a $1,800 holiday fund due in 12 months, you don't owe $150 a month — you owe (1,800 − 300) ÷ 12, or $125. As the balance climbs, the required contribution falls, so a fund that's ahead of schedule quietly asks for less and a fund that's behind asks for more. You never have to recalculate by hand.

A worked walkthrough in US dollars makes it concrete. Suppose it's the 1st of the month and you're funding three goals:

• Annual car insurance — $960 due in 8 months, $0 saved so far. (960 − 0) ÷ 8 = $120/month.
• New laptop — $1,500 target, due in 10 months, with $450 already set aside. (1,500 − 450) ÷ 10 = $105/month.
• Summer trip — $2,000 due in 5 months, $800 saved. (2,000 − 800) ÷ 5 = $240/month.

That's $465 total this month. Run the same sum next month with the new balances and due dates one month closer, and the figure updates itself. Two edge cases are worth knowing. If a fund's due date has passed and it's still short, the months-remaining term hits zero — the tracker should treat that as "fund it now or move the date" rather than dividing by zero. And for a rolling fund with no fixed deadline, you swap the due-date math for a flat monthly amount and a target balance, so the contribution simply stops once the balance is full.

Rounding helps in practice. Bumping a $105 contribution to $110, or $120 to $125, builds a small buffer in every fund and means you reach each target slightly early — which is exactly the side of the line you want to be on.

A full list of common sinking fund categories

The earlier list covers the big eight, but the right set is personal, and seeing a wider menu makes it easier to spot the costs that quietly ambush your year. Group them by how often they land.

Once or twice a year (clear due dates):

• Auto, home, or life insurance premiums paid as a lump sum
• Property tax or any annual tax bill
• Annual software, membership, or warehouse-club renewals
• Vehicle registration and inspection
• Back-to-school clothes and supplies
• Annual checkups, dental work, or new glasses and contacts

Seasonal or event-driven:

• Christmas and holiday gifts
• Birthdays and anniversaries across the year
• Travel and vacations
• Weddings you're attending — gifts, travel, and outfits add up fast

Rolling funds (no single due date, just a healthy balance):

• Car repairs and maintenance
• Home repairs and appliance replacement
• Pet care and the occasional vet bill
• A tech-replacement fund for phones and laptops that die on their own schedule
• A "next car" or major-purchase fund you build over several years

You won't run all of these at once, and you shouldn't try. Pick the handful that would do the most damage if they hit unplanned, fund those first, and let the tracker show you the combined monthly cost before you commit. A fund you can't actually afford to feed isn't planning — it's a second to-do list. It's better to run four funds you reliably top up than a dozen you fall behind on.

Sinking funds on an irregular income

Fixed monthly contributions assume a steady paycheck. Freelancers, commission earners, and anyone with a seasonal income need a slightly different rhythm, and sinking funds actually shine here because they convert lumpy income into smooth, pre-funded expenses.

The cleanest approach is percentage-based funding. Instead of committing to $465 every month, decide what share of each payment goes to sinking funds — say 15% off the top of whatever lands — and split it across your funds in proportion to their monthly targets. In a big month you overfund and get ahead; in a lean month you contribute less, and because the tracker's contribution math is based on the remaining balance, the next strong month automatically asks for more to catch up. Nothing breaks; the funds just fill unevenly.

It also helps to rank your funds so a thin month is easy to triage. Fixed-date funds with a hard deadline — an insurance renewal, a trip with non-refundable bookings — get fed first. Rolling funds like car repairs can coast for a month on the balance they've already built. The tracker's on-pace flag makes this obvious: fund whatever's flagged red, let the green ones wait, and resume normal contributions when income recovers. Pairing this with a monthly budget built on your lowest recent month of income keeps the whole system honest — you fund the essentials and your highest-priority sinking funds first, then treat anything above that baseline as extra runway for the funds that are behind.

Keeping funds on pace

Sinking funds only fail in two ways: you stop contributing, or you spend a fund on the wrong thing. The tracker is built to catch both.

When a fund falls behind

Life happens and a month gets skipped. The tracker compares each balance to where it should be and flags the shortfall. You then have two levers: raise the monthly contribution to catch up, or push the due date if the goal is flexible. A $300 gap noticed in March is an easy fix; the same gap discovered the week the bill is due is a crisis. The point of the tracker is to surface it early.

When you spend a fund

That's the fund doing its job. Log the withdrawal against that fund and watch the balance drop. For recurring expenses — an annual premium, next year's Christmas — just reset the target and due date and start the cycle again. The contribution recalculates automatically.

Why Google Sheets is the right home for it

You could track sinking funds in an app or a notebook. Google Sheets hits the sweet spot:

• Free and cloud-based. No license, and it auto-saves so you never lose a balance.
• Works everywhere. Update it on your laptop, check a fund on your phone with the Sheets app.
• Easy to share. A partner can see and edit the same funds in real time.
• Automatable. It connects to Avery, which syncs your transactions so contributions and balances stay current without manual logging.

That last point is the difference between a tracker you use for a month and one that's still working for you a year from now.

Keeping the tracker current (the part that matters)

Here's the uncomfortable truth about every savings tracker: it dies the moment you stop updating it. You start strong, fund everything for two months, then miss a logging session, then another — and soon the balances on screen don't match reality. A tracker you don't trust is a tracker you ignore.

That's the problem Avery solves. Connect your bank with a read-only link and Avery:

• Imports your transactions automatically.
• Recognizes contributions and transfers tied to each fund with AI, learning from your corrections.
• Keeps balances live, so every fund's progress and on-pace status are always accurate.

You go from "log every transfer by hand" to "spend a few minutes a month confirming." The tracker stays honest, which is the only way sinking funds actually keep their promise.

If you want the automation to extend to your whole budget, the same connection powers the budget spreadsheet and monthly budget, so your everyday spending and your sinking funds stay current together. For comparisons with other tools, see Avery vs Tiller and Avery vs Mint.

Related templates and guides

• Sinking Funds Tracker template — the free Google Sheet this guide is built around.
• Sinking funds Q&A — quick answers to the most common setup and pacing questions.
• Budget Spreadsheet template — the flexible budget to fund your sinking funds from.
• Monthly Budget template — a month-by-month layout that pairs cleanly with sinking funds.
• Free monthly budget template guide — the companion walkthrough for monthly budgeting.
• How to use a monthly budget template — turning a budget into a habit you keep.
• Browse all free templates — the full Avery library.

Sinking funds turn the year's biggest expenses into small, boring monthly contributions — which is exactly what you want them to be. Start with the free template, set up your first three funds, and let Avery keep the balances current so future-you is never blindsided by a bill you always knew was coming.