DEV Community

Financely Templates
Financely Templates

Posted on

Sinking Funds in a Spreadsheet: Stop Surprise Bills From Wrecking Your Budget (Free Template)

#spreadsheets #productivity #tutorial #beginners

Disclosure: I make the Financely Templates spreadsheets linked at the end. The starter is free ($0 works), and everything below works in a blank Google Sheet or Excel file too.

Most budgets don't fail because of rent or groceries. They fail because of the $480 car insurance renewal, the holiday gifts, or the annual subscription you forgot about. Those aren't surprises. They're expenses you knew were coming but didn't save for. A sinking fund fixes that.

What a sinking fund is

A sinking fund is a small amount you set aside every month for one known future cost. Instead of finding $600 in March, you save $50 a month starting now.

Step 1: List every irregular expense

Go through the last 12 months of bank statements and write down anything that doesn't happen monthly:

  • Car registration, insurance, tires, oil changes
  • Holidays and birthdays
  • Annual subscriptions (Amazon Prime, software, memberships)
  • Medical and dental copays
  • Back-to-school or work clothes

Step 2: Build the table

A: Fund B: Target C: Due date D: Saved so far E: Monthly amount

In E2, drag down:

=IF(C2<=TODAY(), B2-D2, ROUNDUP((B2-D2) / MAX(1, DATEDIF(TODAY(), C2, "M")), 0))
Enter fullscreen mode Exit fullscreen mode

That divides what you still need by the months left, rounds up, and never divides by zero. Example: $600 target, $100 saved, due in 10 months gives $50 a month.

Step 3: Add a progress bar

In F2:

=SPARKLINE(D2/B2, {"charttype","bar";"max",1})
Enter fullscreen mode Exit fullscreen mode

(Google Sheets only. In Excel, use Conditional Formatting, then Data Bars on column D.) Watching the bar fill is surprisingly motivating.

Step 4: Put the total into your monthly budget 

=SUM(E2:E20)
Enter fullscreen mode Exit fullscreen mode

That one number becomes a single "Sinking funds" line in your monthly budget. If you use a zero-based budget, it's just another job for your dollars.

Step 5: Where to keep the money

A separate high-yield savings account works well. Some banks let you create multiple named "buckets" inside one account, which matches this table perfectly.

Common mistakes

  • Starting too late: a fund due next month needs the full amount now, so start with the far-off ones.
  • Raiding one fund for another without updating the sheet.
  • Forgetting to reset the target after the expense is paid.

Free templates

Top comments (0)