A simple month-by-month projection of cash in and cash out, so a client can see when the bank balance is tightest across the year.
Starting position
$20,000 opening balance
Opening bank balance at the start of the forecast
$
Apply the same amount to every month, then fine-tune individually in the table
Forecast result
End of year balance
Send this forecast through for a full cash flow review.
Lowest month balance
$0
End of year balance
$0
Total inflows
$0
Total outflows
$0
Monthly forecast
Edit each month's expected cash in and cash out
Month
Cash in
Cash out
Net movement
Closing balance
Forecast Your Business Cashflow with Confidence?
Project monthly cash in and out to identify shortfalls early. Our accountants build realistic forecasts and help you plan for seasonal variation, growth, and working capital needs.
Monthly projections Seasonal analysis Planning support
This is a simple planning tool, not a substitute for detailed budgeting or management accounts. It doesn't account for GST timing, loan drawdowns, seasonal variation beyond what's entered manually, or contingency buffers. Refer to a registered tax or business adviser for a full cash flow analysis.
📩
Get advice
Leave your details and an adviser will follow up — usually within one business day.
✅
Thanks — we've got it!
Someone will be in touch within 1 business day.
In the meantime, feel free to keep adjusting the forecast above.
