Skip to content
Sinking Funds Tracker cover: a sample sheet with funds tracked, cost of all funds and set aside each month and a bar chart, beside the Dashboard and Funds tabs

Sinking Funds Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

Households with yearly insurance, car service, holiday gifts and school costs can use this sheet to spread those bills across the year. The Funds tab lists each expense with its cost, how many months apart it falls, its next due date, the money already saved and its category. The sheet works out the monthly set-aside, the gap, the months left and the extra needed each month to catch up. The Dashboard totals the funds and charts the monthly amount by category.

Move the set-aside amounts into one savings account on payday, so the money is ready when a bill arrives. Update the Saved now column each month from the account balance rather than from memory. A fund turns red when it is short and its due date is near, which is the signal to check whether its monthly figure needs to rise. Review the list each January, since premiums and fees change.

Useful for

  • Plan for an annual insurance premium without a shock
  • Save for holiday gifts over twelve months
  • Cover car service and new tires before they come due

What's included

  • 3 tabs: Dashboard, Funds, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Funds: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Funds tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What is a sinking fund?

A sinking fund is money set aside regularly for a known cost that arrives later. Dividing the cost by the number of months between payments gives the monthly amount. The fund grows steadily, so the bill is paid from savings rather than from the month it falls due.

What do I do if a fund is behind?

Look at the Extra each month column. It shows the amount needed each month to reach the cost before the due date. Add that amount for a while, move the due date later if you can, or cut spending on the item if it is flexible.

When should the balances be updated?

Update the Saved now column once a month, after you move the set-aside amounts. Monthly updates keep the gap figures honest and make a quick check easy. Use the account statement as the source rather than estimates.

  • #savings-tracker
  • #sinking-funds-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More savings tracker templates

See all 10

Also in Finance

All finance templates
Get this template

Preparing your template…