Forecast for funds

Plan your fund balances a year ahead

Introduction

If your organisation has a lot of restricted and unrestricted funds to track, this tool will help you to manage the income and expenditure throughout the year. It is simple to use, just follow the instructions and fill in the boxes. It has space for four unrestricted funds including a general fund, and twenty restricted funds.

Key features

  • Calculate project income and expenditure across the year

  • Add opening fund balances and reveal an estimated closing balance

  • See budget variance as the year progresses

Download

Click the button below to download our free template.
(Size: 143KB, Format: Microsoft Excel)

Further support

If you need any help with our resources, feel free to contact us. We are happy to explain them and offer training. We can even redesign the tools a bit, perhaps expand them or develop new features, because these resources are fairly basic tools and they're not designed for everyone.

You may need to amend the tools yourself a little bit to suit your individual needs as an organisation, and we would encourage you to adapt them and make the resources work for you.

We hope you enjoy them and find them useful. Providing free advice and resources helps us achieve our own charitable goal, which is to help organisations run themselves more efficiently and effectively.

Helpful reading

If you found this useful, why not try:

Cashflow basics

Business planning

Project-based cashflow