Sinking funds tracker spreadsheet

A sinking fund is money you set aside a little at a time for a cost you know is coming: car repairs, insurance premiums, holidays, property tax. It turns big surprise bills into small monthly ones.

The Sinking Funds Tracker handles up to 15 funds. Give each a target and a due date, log money in and out, and it works out how much to save each month and marks each fund Funded, On track, Behind or Past due. The dashboard shows total saved, total goal, percent funded and your total to save per month.

Works in Excel and Google Sheets.

What you get

You get two files, a blank template and a filled-in example, plus a Start Here guide. Open them in Microsoft Excel, or upload them to Google Drive and open them with Google Sheets (free). You type in the input cells; the formulas, totals and charts update themselves.

Tips

• List every yearly or irregular bill from last year.
• Divide each by the months until it's due.
• Log withdrawals too, so balances stay true.