Home › Templates › Free cash flow forecast template
Free template
Free cash flow forecast template
A 12-month cash flow forecast that does the maths for you. Free to download, no sign-up.
Free, no sign-up. Works in Excel, Google Sheets and Numbers.
What is in the template
A 12-month cash flow forecast that does the maths for you. Enter your opening bank balance, your expected income and your expenses by category, and the template works out your net cash flow each month and rolls your closing balance forward automatically. It is the simplest way to see a cash squeeze coming before it arrives.
How to use it
- Download and open it in Excel, Google Sheets or Numbers.
- Enter your opening bank balance in month one.
- Fill in your expected income and expenses for each month. Use your best estimates, you can refine as you go.
- Read the closing balance row. Any month that dips low or negative is a warning to act early.
Why forecast cash flow
Plenty of profitable businesses run out of cash because money comes in later than it goes out. A simple forecast turns that from a nasty surprise into a plan. Our guides on improving cash flow and managing seasonal ups and downs pair well with this template.
Live instead of static: a spreadsheet forecast is only as current as the last time you updated it. Countova builds your cash position from real transactions, so your numbers are always live.
Skip the spreadsheet entirely
Countova creates invoices, tracks cash flow and prepares your GST or BAS automatically. Start free for 14 days, no card needed.
Start free →