A sinking funds spreadsheet turns big, predictable costs (car repairs, holidays, a new laptop) into small monthly savings, so they never become emergencies. For each goal it shows how much is still needed, how many months are left, and how much to save per month.
By Abdallah Elsied, creator of the Irregular Income Budget Bundle · Last updated October 2026 · Screenshots are from the real spreadsheets · How we write
Money you save a little at a time for an expense you know is coming. Unlike an emergency fund, you know roughly what it will cost and when.
Still needed = target amount minus saved so far
Months left = months from today to the target date
Save per month = still needed divided by months left
Total save per month = the sum for all goals: put that into the "Sinking Funds" line of your budget
Car repairs and tires: $1,200 by June 2027, $450 saved
Holiday gifts: $600 by December 2026, $380 saved
Summer vacation: $2,500 by July 2027, $650 saved
New laptop: $1,800 by March 2027, $1,100 saved
Annual software renewals: $400 by January 2027, $160 saved
The sheet works out the monthly amount for each goal, and the total becomes one budget line.
Car maintenance, registration, tires
Holidays and birthdays
Travel
Annual subscriptions and software
Home repairs
Medical and dental
Pet care
Electronics
If a big annual bill lands in a slow month, it eats your buffer. Sinking funds spread it out so your salary and buffer stay steady. See Irregular Income Budget Template.
The Sinking Funds tab is part of the full bundle: the Irregular Income Budget Bundle adds the "pay yourself a salary" system on top of the monthly budget:
Steady salary: pick "lowest month" (safest), "average month" or a custom amount. It is based on finished months only, so a half-finished month never lowers it.
Buffer and runway: your buffer balance, a buffer goal in months of essential bills, and how many months you could cover with no new income.
Tax set-aside tracker: park a share of every payment (25% by default) and log your estimated tax payments.
Pending invoices: unpaid invoices show on the Dashboard but do not count as income until they arrive.
Bills & subscriptions: monthly, quarterly and yearly bills turned into their true monthly cost, with the next due date.
Sinking funds: how much to save per month to hit each goal on time.
Debt payoff: Snowball or Avalanche, extra payments, your debt-free date and total interest.
13 tabs, blank + demo files, Google Sheets and Excel, one payment of $9.
Get the Irregular Income Budget Bundle for $9 →
The free template has a Sinking Funds category in the budget; the goal tracker is in the full version. Get the free template.
Free template: a complete monthly budget. Best if your paycheck is the same every month. Get it free.
Irregular Income Budget Bundle ($9): everything in the free template plus steady salary, buffer, taxes, pending invoices, bills, sinking funds and debt payoff. Best for freelancers and anyone with changing income. See the full bundle.
Your rows copy straight across, so you can start free and upgrade later without retyping anything.
Divide the amount still needed by the months left until the target date.
As many as you have predictable big costs. Five to ten is common.
Many people use a separate savings account, sometimes with sub-accounts per goal.
Yes. The Irregular Income Budget Bundle includes one and works in Google Sheets and Excel.
Get the Irregular Income Budget Bundle ($9) →
Download the free budget template (Google Sheets + Excel) →
About this page: written by Abdallah Elsied, who makes the Free Monthly Budget Template (free) and the Irregular Income Budget Bundle ($9), both linked on this page. Last updated October 2026. This is general budgeting information, not financial, tax or legal advice.