How to Create a 12-Month Cashflow Forecast for Your Small Business
By FundTap Team ·14 Apr 2026
A cash-flow forecast is a month-by-month projection of money in and money out. It helps you spot gaps before they become crises. You don't need special software, a simple spreadsheet works; the discipline is updating it regularly.
Last reviewed 21 August 2026
What is a cash-flow forecast?
A month-by-month projection of all money coming in (inflows) and going out (outflows). The difference shows whether you'll have enough to cover obligations each month. It's not a profit and loss statement, you can be profitable on paper and still run out of cash if payments don't arrive when you need them.
"Profit and cash are not the same thing, and the gap between them is where good businesses get caught out. A forecast is just the habit of looking at the cash version of the future before it arrives."
Matt Peacey, Founder & CEO, FundTap
Step 1, List your cash inflows
For each month, estimate cash you'll actually receive: customer payments (timed to when they pay, not when you invoice), recurring revenue, GST/BAS refunds, other income. Use realistic timing, if customers take 45 days on average, record the cash in the month it lands.
Step 2, List your cash outflows
Rent and utilities, wages and super, supplier payments, loan repayments, insurance, tax (PAYG, GST, company tax), equipment and vehicles, marketing and professional services, owner drawings.
Step 3, Calculate the monthly balance
Opening balance + Inflows − Outflows = Closing balance. Each month's closing balance becomes the next month's opening balance. A negative closing balance is a gap to address before it arrives.
Step 4, Identify and address gaps
- Accelerate inflows, invoice sooner, offer early-payment incentives, use invoice finance
- Delay outflows, negotiate longer supplier terms
- Reduce costs, cut or defer non-essentials
- Arrange funding, overdraft, loan, or invoice finance as a bridge
Step 5, Update monthly
A forecast is only useful if it reflects reality. Update at least monthly with actuals and re-forecast the remaining months. Predictions sharpen as you learn your patterns.
Common mistakes
- Being too optimistic on timing, use actual DSO, not terms
- Forgetting irregular costs, quarterly BAS, annual insurance, tax instalments
- Not updating, a three-month-old forecast is fiction
- Confusing profit with cash, invoiced revenue isn't cash until it arrives
When the gap is structural
If your forecast consistently shows a gap between invoicing and being paid, it won't fix itself. Invoice finance closes it by releasing the value of outstanding invoices immediately, with FundTap, an advance the same day (median first fund: 3 days from sign-up; FundTap data, 2026), settled automatically when your customer pays.
Frequently asked questions
What is a cash-flow forecast?
A month-by-month projection of money coming in and going out, showing whether you'll have enough cash to cover obligations each month.
What's the difference between a cash-flow forecast and a profit and loss statement?
A P&L shows profitability; a forecast shows cash timing. You can be profitable yet run out of cash if payments arrive late.
How do I create a 12-month cash-flow forecast?
List monthly inflows (timed to when cash actually arrives) and outflows, then calculate opening + inflows − outflows = closing balance for each month, and update with actuals monthly.
What software do I need?
None specifically, a simple spreadsheet works. The discipline that matters is updating it monthly with real figures.
What are the most common forecasting mistakes?
Optimistic payment timing, forgetting irregular costs like BAS and insurance, never updating the forecast, and confusing invoiced revenue with cash received.
What if my forecast keeps showing a cash gap?
A persistent gap between invoicing and payment is structural. Invoice finance closes it by releasing the value of outstanding invoices the same day.
Related
Keep reading
Small Business Tips
Cashflow Forecasting: A Step-by-Step Guide for Small Business Owners
TL;DR: Cashflow management is one of the biggest challenges for small businesses. This guide covers
FundTap Team · 24 Mar 2026
Read the articleAdd Invoice Factoring To Your Services, A Step by Step Guide
TL;DR: Invoice factoring is one way to fund unpaid invoices, but it's not the only option. This guide
Shane Laurence · 01 Apr 2025
Read the articleHow to Create a 12-Month Cashflow Forecast in Under an Hour
TL;DR: Cashflow management is one of the biggest challenges for small businesses. This guide covers
FundTap Team · 26 Sep 2025
Read the articleCustomer Guides
How do I submit and Invoice for Funding?
TL;DR: This guide covers key insights to help Australian and New Zealand small businesses make better
FundTap Team · 04 Nov 2025
Read the articleThe work's done. The money shouldn't be the wait.