Cash Flow Forecasting for NZ Small Businesses (with a Free Template)

A cash flow forecast is one of the most useful tools a small business can keep, and one of the most overlooked. It tells you, week by week, whether you will have enough cash to cover what is coming. This guide shows you how to build a simple, practical forecast for your New Zealand business.

What is a cash flow forecast?

A cash flow forecast is a projection of the money coming into and going out of your business over a set period, usually the next 13 weeks or 12 months. Unlike a profit and loss statement, it is about timing: when cash actually lands and when it leaves, not just whether you are profitable on paper.

Why it matters

Plenty of profitable businesses run into trouble because of timing. A big invoice is due in 60 days, but wages, GST, and suppliers are due next week. A forecast shows those squeezes before they happen, so you can act early rather than scramble.

How to build a simple forecast

You only need a spreadsheet. Set up a column for each week or month, and these rows:

1. Opening balance: the cash you start the period with.
2. Cash in: expected customer payments, based on when you realistically expect them to clear, not the invoice date.
3. Cash out: wages, rent, suppliers, GST, provisional tax, loan repayments, and other costs.
4. Net movement: cash in minus cash out.
5. Closing balance: opening balance plus net movement. This carries forward as next period's opening balance.

The key discipline is being honest about timing. If a client usually pays two weeks late, forecast the late date, not the due date.

A simple template you can copy

Build a table in any spreadsheet with one row per item and one column per week:

• Row 1: Opening balance
• Rows 2 to 5: Cash in (one row per major client or income type)
• Rows 6 to 12: Cash out (wages, rent, suppliers, GST, tax, repayments, other)
• Row 13: Net movement
• Row 14: Closing balance

Update it weekly. Within a month you will have a rolling view that makes cash surprises far less likely.

Common mistakes to avoid

• Forecasting the invoice date, not the payment date. This is the single most common error.
• Forgetting lumpy costs such as GST, provisional tax, insurance renewals, and annual subscriptions.
• Never updating it. A forecast is only useful if it reflects reality, so review it weekly.

Where invoice finance fits

If your forecast keeps showing gaps caused by slow-paying clients, that is exactly the problem invoice finance solves. Getting paid the full value of an invoice upfront turns an unpredictable inflow into a known one, which makes the whole forecast more reliable. For more ideas, read our cash flow management tips, or see how getting paid upfront works on our invoice financing page.