Sinking Funds Tracker Excel - Free Template

1. Open the Sinking Funds sheet and list each future cost on a separate line. Enter the fund name, target amount, current saved amount, monthly contribution and due date.
2. Use the current saved figure as your opening balance. For example, if you already have £240 set aside for a £600 car service, the shortfall is £360.
3. Set the monthly contribution by dividing the shortfall by the number of months left. If a £1,200 boiler fund is due in 10 months and you have £200 saved, you need £100 a month.
4. Review the Summary Dashboard after each update. Check the total target, total saved and total gap before you move money into each pot.
5. Follow the Instructions sheet if you want to keep the workbook tidy. Keep one row per fund and update the saved amounts on a fixed date each month.
6. When a fund is fully built, leave it in place rather than deleting it. That gives you a record of what was funded, when it was completed and what may need renewing next year.

This template suits anyone who has regular but non-monthly costs to plan for. A sole trader might use it for software renewals, van servicing and accountant fees, while a family may use it for school uniform, Christmas or holidays.

The Sinking Funds sheet is the working list, and image 1 shows the kind of simple line-by-line layout that suits this job: one fund, one target, one saved amount and one deadline. That is the right structure when you are juggling 8 to 15 separate pots and want to see which ones are falling behind.

Useful at predictable points in the year

You usually reach for this workbook when a known bill is coming but not yet due. For example, if you need £900 for a car repair in 6 months, you can set aside £150 a month instead of taking a hit in one week.

Good for households, clubs and small firms

A club treasurer might track a £2,400 roof reserve, a trades business might ring-fence £1,800 for tools, and a household might build a £1,200 emergency fund. In each case, the spreadsheet helps you decide whether the pot is on track or whether you need to increase the monthly transfer.

A sinking fund is not the same as day-to-day spending money. It is a planned reserve for a specific cost, so the amount and the deadline matter more than the daily bank balance.

For businesses, keep the records with the same discipline as any other financial working paper. Companies should retain bookkeeping records for 6 years, and sole traders should keep records for 5 years after the 31 January Self Assessment deadline for the relevant tax year.

Link the fund to the real deadline

If a set of accountancy software fees falls due on 01/09/2026 and the bill is £360, the monthly set-aside is £30 if you start 12 months earlier, or £60 if you only have 6 months. That simple timing check is often the difference between a tidy reserve and a cash squeeze.

Use the right amount, not a rough guess

For a known annual cost of £1,440, the clean monthly figure is £120. If you round it down to £100, you will be £240 short after a year, which is enough to leave one fund underfilled and force you to raid another pot.

The most common mistake is treating every pot as if it can wait. A van fund, a tax reserve and a holiday pot are not interchangeable, and mixing them creates gaps that only show up when the bill arrives.

Another problem is entering the target but not reviewing the saved amount. If you promised yourself £80 a month towards a £960 boiler fund and miss three months, you are already £240 behind before the engineer has even quoted.

Shortfalls build faster than people expect

At £50 a month, a £300 missed contribution leaves a 6-month hole. If you discover it late, you may have to pull the money from a credit card or overdraft, which turns a planned cost into avoidable interest.

Too many pots can hide the real position

A spreadsheet with 25 funds is still fine, but only if you update it properly. If 5 lines are stale, the dashboard can show a healthy total saved while three urgent items are actually underfunded by £400, £700 and £1,100.

Those stale lines are easiest to catch when each pot has a clear target and progress bar, so a goal tracking sheet keeps the underfunded items visible before the shortfall turns into borrowing.

Build the update into a fixed routine, not an occasional tidy-up. The easiest habit is to review the workbook on the same day as the bank transfer, payroll run or month-end money sweep.

The Summary Dashboard is the quickest way to do that, and image 2 should be the first place you look when you open the file. If the total gap is still too high, increase the transfer before you spend anything elsewhere.

Simple habits that keep it alive

• Review it on the same day each month, for example the first Monday after wages go out.
• Copy the saved amounts into the next month instead of rebuilding the list from scratch.
• Use one fixed transfer per fund so the figures do not drift by £5, £10 or £20 each month.

When a spreadsheet is no longer enough

Move on when you are tracking dozens of funds, multiple people are editing the file, or you need bank feeds and live reconciliations. At that point, a proper budgeting system or accounting package will handle the workload better than a manual workbook.

When the workbook starts to strain under all those moving parts, a monthly budget planner becomes the next place to map every payment, transfer, and savings target in one place.