Cash Flow Template for Excel (Free Excel)
A free 12-month cash flow forecast for Excel. Enter cash in and cash out and see the closing balance each month.
Download the free Excel template (.xlsx)
Free. No email or sign-up needed. One Excel file, 2 sheets.
What is inside the cash flow template
| Sheet | What it does |
|---|---|
| Cash flow | 12 months of cash in and cash out lines, net cash flow, opening and closing balance, a chart and red warnings if cash goes negative. |
| Read me | Short instructions. |
Yellow cells are for your own numbers and text. Green cells calculate by themselves, so do not type over them. Sample data is included so you can see how it works, then replace it with your own.
How to use it
- Download the file and open it in Excel 2010 or later. It also opens in Google Sheets and LibreOffice.
- Replace the sample data in the yellow cells with your own.
- Read the totals and results that update automatically.
- Save a copy for each month, project or client, or print it from File > Print.
The template is free to use and edit. If you want a version built around your own process, with your branding, extra sheets or automation, tell us what you need.
Free pricing tips for your business
Get short, practical tips on pricing jobs and using our free calculators. No spam, unsubscribe any time.
Frequently asked questions
What is a cash flow forecast?
A month-by-month estimate of cash coming in and going out, showing whether you will have enough cash.
Cash flow vs profit?
Profit counts sales and costs when they happen. Cash flow counts when money actually moves.
How do I use the template?
Enter opening cash and expected cash in and out per month. The closing balance carries forward.
How far ahead should I forecast?
12 months is common, reviewed monthly.
Need a custom spreadsheet built for your business?
Talk to usMore free tools: All free Excel templates · Profit and loss template · Small business budget template · Balance sheet template