Spreadsheet
12-Month Cashflow Forecast
Profitable businesses still fail when they run out of cash. A cashflow forecast shows you, month by month, whether you will have enough money in the bank to pay wages, suppliers, GST and tax — before it becomes a problem.
This free Excel template is set up for New Zealand businesses, with lines for GST, PAYE, KiwiSaver, ACC levies and provisional tax. Enter your expected money in and out, and the totals and closing bank balance calculate automatically.
What’s inside
- 12 months of cash in and cash out lines
- NZ-specific lines for GST, PAYE, KiwiSaver, ACC and provisional tax
- Automatic totals, net cashflow and running bank balance
Who it’s for
Any NZ business owner who wants to plan ahead, prepare for a bank meeting or avoid cash surprises.
General guidance only — not legal, tax or financial advice.
