How to Set Up Sinking Funds in Google Sheets (Step by Step)

By Cedar & Ledger · Updated October 31, 2026

A sinking fund is money you set aside a little at a time for a cost you already know is coming: the car insurance bill that renews every six months, holiday gifts, the yearly vet visit, new tires. Instead of one painful month, you pay a small, planned amount every month and the bill is already covered when it lands.

This guide walks through building a working sinking funds tracker in Google Sheets from a blank file. You'll end up with three things: a list of funds that tells you how much to save each month (and each paycheck), a log of every deposit and withdrawal, and a check that your spreadsheet matches the real balance in your savings account. It takes about 30 to 45 minutes the first time. All the numbers below are made-up examples.

Step 1: List the costs you know are coming

Before you open Sheets, make a rough list. Go through the last 12 months of bank and card statements and write down anything that wasn't a normal monthly bill. Common ones:

• Car insurance, registration, inspections, tires and repairs
• Holidays and birthdays (gifts, travel, food)
• Annual subscriptions and memberships
• Pet costs: checkups, vaccines, grooming
• Home or renter costs: repairs, appliance replacement, renter's insurance if paid yearly
• Medical and dental costs that aren't covered, glasses and contacts
• Back-to-school costs, kids' activities and camps

For each one, write a target amount and a due date. If you don't know the exact amount, use last year's cost and round up a little. If the cost has no fixed date (car repairs, for example), give it a yearly target and treat it as due 12 months from now. Need ideas? The 2027 sinking funds list has a longer list of categories.

Don't try to fund twenty categories at once. Five to eight is a sensible start. You can add more later.

Step 2: Create the Funds tab

Open a new Google Sheet and rename the first tab Funds. In row 1, type these headers:

Fill in columns A to D for each fund, one per row, starting in row 2. Format B, D, E, F, H and I as currency (Format > Number > Currency) and C as a date.

Step 3: Add the formulas that tell you what to save

Put these in row 2 and copy them down to the last fund. (Column E comes in Step 4, after the log exists.)

Still needed (F2):

=MAX(0, B2 - E2)

MAX stops the number from going negative once a fund is full.

Months left (G2):

=IF(C2 <= TODAY(), 1, MAX(1, DATEDIF(TODAY(), C2, "M")))

DATEDIF counts whole months between today and the due date. It returns an error when the date is already past, so the IF catches that, and MAX makes sure you never divide by zero in the next column. If a bill is due in less than a month, the sheet treats it as one month left, which means "save the rest now".

Per month (H2):

=F2 / G2

Per paycheck (I2): if you're paid every two weeks, there are 26 paychecks in a year, so

=H2 * 12 / 26

Paid weekly? Use 52 instead of 26. Paid twice a month? Use 24. Paid monthly? Per paycheck is the same as per month.

Below the last fund, add a total row: =SUM(H2:H20) for the monthly total and =SUM(I2:I20) per paycheck. That total is the number your budget has to make room for.

Step 4: Build the Log tab

Add a second tab named Log with these headers in row 1: Date, Fund, Note, Amount. Every time you move money into savings for a fund, add a row with a positive amount. Every time you spend from a fund, add a row with a negative amount.

Make the Fund column a dropdown so the names always match: select column B on the Log tab, choose Data > Data validation, add a rule, pick "Dropdown (from a range)" and enter Funds!A2:A20. Now a typo can't quietly break your totals.

Now go back to the Funds tab and fill in Balance now (E2):

=D2 + SUMIFS(Log!D:D, Log!B:B, A2)

That adds your starting balance to every deposit and withdrawal logged for that fund. Copy it down.

Step 5: A worked example

Here's how three funds might look, assuming today is the start of a month (example numbers only):

Car insurance: $720 still needed over 6 months is $120 a month. Holidays: $900 minus the $150 already saved leaves $750 over 10 months, or $75 a month. The per-paycheck column is per month × 12 ÷ 26. So this household needs to move about $102 into savings each payday to stay on track. You can check any single fund with the free sinking fund calculator.

Step 6: Check the sheet against your bank

Most people keep all their sinking funds in one savings account. That's fine, as long as the spreadsheet tracks which dollars belong to which fund. Once a month, compare the two:

1. On the Funds tab, below the totals, type "Sheet total" and =SUM(E2:E20) next to it.
2. Type "Bank balance" and enter the real balance of your savings account.
3. Type "Difference" and =bank cell - sheet total cell.

If the difference isn't zero, you forgot to log something: a transfer you made, a purchase you paid from savings, or interest the bank added. Interest is easy to handle: log it as a deposit to whichever fund you like, or to a fund called "Unassigned" that you spread out later.

Step 7: Make it easy to read

A couple of formatting touches help you see where you stand at a glance:

• Full funds turn green. Select A2:I20, choose Format > Conditional formatting, pick "Custom formula is" and enter =$E2>=$B2 with a green fill.
• Urgent funds turn yellow. Add a second rule, =AND($G2<=2, $F2>0), with a yellow fill. Those are funds due within about two months that aren't full yet.
• Freeze the header row (View > Freeze > 1 row) so the labels stay visible as the list grows.

Step 8: When the bill arrives, and what happens after

When you pay a sinking-fund expense, pay it from checking as usual, then move the same amount from savings to checking and log it as a negative amount for that fund. The fund drops to (about) zero, which is exactly the point: the money did its job.

Then reset the fund for next time. Change the due date to the next renewal and update the target if the price went up. The per-month figure recalculates on its own.

If a bill comes in higher than the fund, you have three honest options: cover the gap from your regular budget this month, borrow from a fund that isn't due for a while (and log both moves so you can pay it back), or raise the target for next time. What you shouldn't do is quietly stop logging, because then the bank check in Step 6 stops meaning anything.

What if the total is more than you can afford?

It often is the first time. Seeing the real monthly cost of your irregular bills is useful, even when it's uncomfortable. Some ways to handle it:

• Prioritize. Fund the costs that would hurt most if they hit unplanned (insurance, car repairs, medical) before the nice-to-haves.
• Stretch the dates you control. A holiday budget can be smaller this year, or a planned purchase can wait a few months.
• Fund partially. Saving half of the monthly amount still means half the bill is covered.
• Look at the monthly budget. The budget-by-paycheck guide shows how to fit savings into each check instead of the whole month.

Sinking funds aren't the same as an emergency fund. Sinking funds are for costs you can predict; an emergency fund is for the ones you can't. Sinking funds vs an emergency fund covers how to do both.

Prefer a ready-made version?

Everything above works in a sheet you build yourself. If you'd rather start with the formulas, dropdowns and per-paycheck math already set up, the Sinking Funds & Savings Goals Tracker ($5, Excel and Google Sheets) does the same job for up to 20 funds, with a log and automatic balances. It's optional; the steps in this guide are all you really need.

This is general information with example numbers, not financial advice.

Try the free sinking fund calculator →

Related template: read about the Sinking Funds & Savings Goals Tracker

See all Cedar & Ledger templates