Free Sinking Funds Tracker for Google Sheets

Some expenses show up like a surprise party you did not ask for. Christmas in December (every single year, and somehow still a shock). The car needing brakes. The insurance premium that lands as one fat annual bill. None of these are actually surprises. You know they are coming. You just have not set money aside for them, so they hit the credit card and undo three months of good behavior.

That is the exact problem sinking funds solve, and once you set them up, a whole category of money stress simply stops happening. A sinking fund is money you set aside a little at a time for a specific expense you know is coming, so that when it arrives, the cash is already there waiting.

I built a free sinking funds tracker in Google Sheets that keeps all your funds in one place, works out how much to set aside each month for each one, and shows your progress. Copy it, list your own upcoming expenses, and let it turn a pile of someday-bills into one calm monthly number.

Jump to a section

• What a sinking fund actually is
• The expenses that deserve a sinking fund
• How the tracker does the math for you
• Where to actually keep the money
• A two-minute monthly habit

What a sinking fund actually is

The name sounds like accounting jargon, and technically it is borrowed from the world of corporate bonds. The idea underneath, though, is simple and old. Instead of saving into one giant pool and hoping there is enough when a big bill lands, you fund each known expense on purpose, ahead of time.

Think of it as reverse budgeting for the lumpy stuff. Your rent and groceries are predictable, so they live in your normal monthly budget. Your car registration, your annual dentist visit, the wedding you are invited to next summer, those are occasional and irregular, so they get their own small monthly deposits until the money is ready. When December or the repair bill shows up, you are not scrambling or reaching for a card. You are just spending money you already decided to spend.

The expenses that deserve a sinking fund

Almost anything predictable that does not happen every month is a candidate. A few that catch people year after year:

• Holidays and gifts: the classic, because it arrives on the same date annually and still feels like an ambush.
• Car costs: registration, new tires, the repair you can already feel coming.
• Annual or semi-annual bills: insurance premiums, property taxes, that once-a-year subscription.
• Travel: flights home for the holidays, a summer trip, weddings you are actually in.
• Medical and dental: the checkups and deductibles insurance does not fully cover.
• Home stuff: the appliance that will not last forever, seasonal maintenance.

You do not need a fund for everything at once. Start with the two or three that have burned you before, and add more as you find your footing. If you have never mapped out these irregular costs, a slow pass through a full monthly expenses list will surface the ones you always forget until they are due.

How the tracker does the math for you

Here is what makes a spreadsheet beat a jar of cash envelopes. For each fund, you type four things into the yellow cells: the name, the total goal, the date you need it by, and whatever you have already saved. That is the entire input.

From there the sheet handles the part that actually trips people up. It works out how much is still left to save, then divides that by the number of months until your deadline, so you get a real monthly number for each fund. Down in the summary, it rolls every fund’s monthly number into one figure: the total you need to set aside this month to keep every goal on track. That single number is the whole game. If it fits your budget, you are set. If it does not, you get to decide what to trim or push out calmly, in advance, instead of in a panic at the register. Building this into a plan you will actually stick with pairs well with a budget you won’t quit in a week.

Where to actually keep the money

The tracker organizes the plan, but the cash needs a home too. For money you will spend within a year or so, the goal is safety and easy access, not growth. A high-yield savings account is the standard pick, because it earns real interest while keeping the money one transfer away. Many banks now let you open several named sub-accounts, so you can have a Christmas bucket and a Car bucket sitting right next to each other. If you want the mechanics, here is how a high-yield savings account works.

One gentle warning: do not sink this money into investments. Sinking funds are for known, near-term expenses, and the market has a talent for being down exactly when your bill comes due. Keep it boring and liquid. The whole promise of this system is that the money is there when you need it, no drama, no timing luck required.

A two-minute monthly habit

The setup takes fifteen minutes. The upkeep takes two. Once a month, on a date you pick, open the sheet, move your set-aside amounts into the right savings buckets, and update the “saved so far” cells so your progress bars climb. When a fund gets fully funded and the expense is paid, you either retire that fund or reset it for next year (Christmas comes back around, after all).

That is the rhythm. A little bit, on purpose, every month, so the big bills stop feeling big. Copy the tracker, list the three expenses most likely to blindside you this year, and give each one a date and a goal. Which surprise expense keeps getting you? Drop it in the comments and I will tell you how I would fund it.

---

Who wrote this

Robby Naka writes The Millennial Budget, a no-shame take on money for people who want a great life now and later. He’s not a financial advisor, just a guy a little obsessed with spending on purpose and figuring out his own kind of rich. More about Robby. This article is general education, not financial or tax advice for your situation.