Reserve Fund Planner Spreadsheet Template
Free reserve fund / sinking fund planner for UK blocks. Track planned major works, estimated costs, target balance and annual contribution — opens in Excel or Google Sheets.
No signup required · Free for UK residential blocks
General information only — not legal, financial or professional advice. You are responsible for how you use these templates. Full disclaimer
Work item,Estimated cost (£),Target year,Current reserve (£),Annual contribution (£),Notes Roof replacement,,,,, External redecoration,,,,, Lift refurbishment,,,,,Remove if no lift Communal boiler replacement,,,,, Window replacement programme,,,,, TOTAL,,,,, Current reserve balance:,,,,, Recommended annual contribution:,,,,,
Major works always arrive eventually — roof, lift, windows, external paint. A reserve fund planner stops you scrambling for a special levy when the surveyor's report lands. It also gives leaseholders confidence that the board is thinking ahead.
This free reserve fund spreadsheet lists planned works, estimated costs and target years. Use it at the AGM to agree the annual reserve contribution and update it when you get new surveyor estimates.
How to use it
- 1List every major work item you know is coming in the next 10–15 years.
- 2Get rough cost estimates from your surveyor or last contractor quotes.
- 3Set a target year for each item based on condition surveys.
- 4Calculate the annual contribution needed to reach each target on time.
- 5Review at every AGM and after any major project completes.