Excel template · Instant download

Big bills, already paid for.

Save a little every payday for car insurance, Christmas, repairs and every other bill you know is coming. See what’s in each fund, what to set aside, and which ones are behind. No macros.

Get the tracker $7.99

✓ One-off payment   ✓ Instant download   ✓ Excel for Windows & Mac

Lee from Sheet Leveller
Made by Lee at Sheet Leveller, whose tutorials have been watched 6.3 million times on YouTube.
Sinking-Funds-Tracker.xlsx
Total saved$5,100Each payday$361Behind2Due in 90 days3
FundSavedTarget% savedPer paydayStatus
Car insurance$700$1,20058%$50.00On track
Christmas gifts$495$80062%$61.00Behind
Vacation$800$2,50032%$100.00On track
Car repairs and tires$830$1,50055%Ongoing
Doctor and dentist$520$75069%$32.86On track
Start HereDashboardFundsTransactionsSettings
Sound familiar?

The bills that aren’t surprises, but still hurt

🚗

The yearly insurance bill

You knew it was coming. It still lands on the credit card.

🎄

Christmas on credit

December arrives, the money doesn’t, and January is spent paying it off.

🔧

The “emergency” repair

Tires, the dentist, the water heater. Not really emergencies, just unplanned.

How it works

Set it up once. Save a little every payday.

  1. List your funds

    Each thing you’re saving for, the target, when it’s due and whether it repeats every year.

  2. Move the money

    On payday, add a deposit for each fund. The tracker tells you how much.

  3. Pay the bill from the fund

    When it’s due, the money’s already there. Repeating funds start again by themselves.

Every fund

Exactly what to set aside each payday

Every fund shows what’s saved, what’s left, how many paydays you have, and the amount per payday to be ready on time. Paid weekly, every two weeks, twice a month or monthly.

  • Repeating funds roll on by themselves
  • Ongoing funds with no due date
  • Per payday total across all funds
Funds
Repeating funds roll on to next year by themselves.
FundTargetRepeatsNext dueLeft to savePer payday
Car insurance$1,200Every yearFeb 28, 2027$500.00$50.00
Christmas gifts$800Every yearDec 20, 2026$305.00$61.00
Annual subscriptions$300Every yearNov 30, 2026$50.00$12.50
New laptop$1,200NoApr 19, 2027$1,050.00$75.00
Car registration$180Every yearOct 21, 2026$15.00$15.00
Coming up

See every big bill coming

The Dashboard lists what’s due next, how many days away it is and how much you’re still short, plus how much you’ve put in and paid out this year.

  • Due in 90 days count
  • Behind and Past due warnings
  • Chart of your total growing
Dashboard
Put in this year$4,375Paid from funds$770
FundDueDaysStill short
Car registrationOct 2120$15
Annual subscriptionsNov 3060$50
Christmas giftsDec 2080$305
Doctor and dentistJan 15106$230
Car insuranceFeb 28150$500
Transactions

Every dollar in and out

Add a Deposit when you move money in, and Spent when you pay the bill. Each fund’s balance is worked out for you, even when it’s all in one savings account.

  • One account, many funds
  • Room for 20 funds and 1,000 transactions
  • Pick funds from a drop-down
Transactions
Add a Deposit on payday. Add Spent when the bill comes.
DateFundTypeAmount
Sep 1VacationDeposit$200.00
Sep 1Christmas giftsDeposit$60.00
Sep 1Car insuranceDeposit$100.00
Sep 11Home repairsSpent$135.00
Sep 19Christmas giftsSpent$45.00
Who it’s for

For anyone tired of big bills wrecking the budget

Budgeters

Envelope and zero-based budgeters who want their sinking funds in Excel.

Families

Christmas, back to school, birthdays and the yearly insurance bills.

Car and home owners

Repairs, tires, registration and the things that always need fixing.

Everything you get

  • Up to 20 sinking funds
  • Target, due date and repeating funds
  • Amount to set aside each payday
  • Weekly, every 2 weeks, twice a month or monthly
  • On track, Behind and Past due warnings
  • Coming up list with what’s still short
  • Transactions log for deposits and spending
  • Dashboard with progress bars and a savings chart
  • One-off payment, no subscription
Sinking Funds Tracker
$7.99

One-off payment. Yours to keep.

Get instant access $7.99

Secure checkout by Payhip · Card or PayPal
Download link emailed straight away

Lee from Sheet Leveller

Hi, I’m Lee

I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials.

This tracker uses the SUMIFS, DATEDIF and EDATE formulas from my tutorials, so every fund works itself out.

6.3Mtutorial views
11,900+YouTube subscribers
500tutorials

Questions

Do I need a separate bank account for each fund?

No. Most people keep all their sinking funds in one savings account. The tracker shows how that one balance is split between funds.

What happens after a yearly bill is paid?

Add it as Spent. When the due date passes, the fund rolls on to next year’s date and starts again.

I’m paid twice a month. Does that work?

Yes. Choose Twice a month on the Settings tab and every per-payday amount updates.

Does it link to my bank?

No. You add deposits and spending yourself, which takes a minute each payday.

Does it use macros?

No. It’s a normal .xlsx file, so there are no security warnings and nothing to enable.

Which versions of Excel does it work with?

Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac. It’s built for Microsoft Excel.

Is this a subscription?

No. You pay once and the file is yours to keep.

Next time the big bill comes, you’ll be ready.

A little every payday, for every bill you know is coming.

Get the tracker $7.99

Want to see it first? Watch how it works on YouTube.

Sinking Funds TrackerInstant Excel download
Buy · $7.99
Scroll to Top