Sinking Funds Tracker

A sinking fund is money you set aside in small amounts for an expense you know is coming, like car insurance, holiday gifts, or a vacation. This tracker shows each fund’s target, due date, and progress, and works out how much to save each month.

Download Excel / Google Sheets Download Printable PDF

What it’s for

Irregular expenses feel like emergencies when they arrive all at once. Splitting them into monthly amounts turns a $600 surprise into $50 a month, so the money is already there when the bill is due. Common sinking funds include car maintenance, annual insurance premiums, holiday gifts, home repairs, and vacations.

What’s included

• Funds tab: your fund list with progress bars, months left, the monthly amount needed, and a status for each fund.
• Contributions tab: a log of deposits and withdrawals, so your saved totals stay current.
• Summary tab: totals by category.
• Printable PDF: a two-page planner and contribution log to fill in by hand.

How to use it

1. List your funds. On the Funds tab, replace the three sample rows. Look through the past year for costs that don’t happen every month, and add each one.
2. Set a target and a due date. Use last year’s bill and round up, since prices tend to rise. Every fund needs a date, or the monthly amount can’t be calculated.
3. Enter any starting balance. If you’ve already saved something toward a fund, add it in the Starting balance column.
4. Choose a planned monthly amount. Compare it to the “Needed per month” column. If your plan covers it, the status shows On track. If not, it shows Behind.
5. Log every deposit. Each time you move money into a fund, add a row on the Contributions tab. If you spend from a fund, log it as a Withdrawal.
6. Check your progress. The tiles at the top show your total saved and what you still need to save each month.

Using the PDF? Fill in the planner on page 1 once, then use page 2 to record each deposit and the running balance.

Tips

• Keep the money separate from everyday spending, such as a different savings account or a labeled bucket.
• Move the money on payday so you can’t spend it first.
• If your list feels overwhelming, start with three to five funds. Add the biggest or most stressful ones first.
• Add a small buffer when you can. Repairs and trips often cost more than the first estimate.
• Months left rounds up, and the monthly amount is based on today’s date. The figures are planning estimates, not bank balances.

Note: This tracker runs entirely in the file you download. It doesn’t connect to your accounts, and it doesn’t move money for you. It’s for personal organization only and isn’t financial advice.