Cashflow forecast

Financial planning for the year ahead

Introduction

Many organisations need to predict and monitor the cash (bank) balances in the months ahead. It’s one thing to do a budget for the year ahead, but you might need to look at the actual timing of the inflows and outflows from the bank. This tool is a simple template to help you. Just follow the instructions and fill in the boxes.

Key features

  • Understand how much you’ll have incoming and outgoing each month.

  • Calculate your total expenses for the year ahead.

  • Includes an example tab to show you how it works.

Download

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

Demo video

In the video below, we walk you through how to use our template.

Download transcript (Size: 16KB, Format: Microsoft Word)

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

Reserves basics