The bank balance looks fine on Friday. By Tuesday, a supplier payment, payroll, GST, and a delayed customer receipt have all landed on different dates than your team expected. The business may still be profitable, but profit won't tell you whether there's enough money available when each obligation falls due.
That's the practical problem cash flow forecasting solves. It gives you a dated view of cash entering and leaving the business, then turns that view into decisions about collections, supplier terms, hiring, stock, tax, and investment. For New Zealand operators, the forecast needs to reflect how the business runs, not just what the spreadsheet said at the start of the quarter.
The Moment a Cash Flow Forecast Actually Matters
It's Tuesday morning at a Wellington services firm. The P&L shows a healthy profit, the debtor book looks strong, and the director expects the month to close well. Then the operations manager asks whether payroll is safe.
The director opens the bank app. There's enough cash for the immediate bills, but not enough to cover the next payroll run and a group of supplier payments landing shortly afterwards. The problem started weeks earlier, when a $180,000 retention was billed late. The revenue still belongs in the commercial conversation, but the cash won't arrive when the business needs it.
The director calls the project lead, the accounts team, and the client contact. Everyone agrees the money should be paid. Nobody can say exactly when it will arrive. The P&L showed a profitable contract. It told the director almost nothing about Thursday.
Practical rule: If your forecast can't show the date of a cash pinch, it can't support a decision.
This is why cash flow forecasting isn't an academic finance exercise. It's the discipline of looking 30, 60, and 90 days ahead and asking what money will move, on which date, and with what level of confidence. That view gives the founder time to accelerate a collection, negotiate a supplier payment, defer a purchase, or pause a hiring decision before the problem becomes urgent.
New Zealand's official guidance treats forecasting as a practical planning tool. Business.govt.nz's cash flow forecasting guidance defines it as an estimate of money coming in and going out over a future period and points businesses towards Stats NZ's Annual Enterprise Survey when building sales assumptions. Its Cash Flow Forecaster projects cash in hand and cash flow for the next 12 months, using monthly inputs for cash in, cash out, reserves, and borrowing.
The promise of a useful forecast is simple: it should update when reality changes. It shouldn't be a spreadsheet someone opens once a quarter, adjusts until the result looks comfortable, and then files away. Explore Wisely's business case studies for examples of how connected business processes can support better operational visibility.
What Cash Flow Forecasting Really Means
Cash flow forecasting is a dated projection of money expected to enter and leave your bank accounts. It answers a practical question: what will the closing cash balance be after each planned receipt and payment has cleared?
Treat the forecast as a live operating workflow, not a spreadsheet prepared in isolation. Sales commitments, customer invoices, supplier bills, payroll, tax obligations, financing, and planned purchases all affect the result. The finance owner should connect these inputs to the same work management system used by the wider business, so a delayed project, approved purchase, or changed collection date updates the forecast when reality changes.
The distinction from budgeting and accounting matters. A budget sets the intended spending plan. Accounting records what has already happened. Forecasting updates the expected cash position using current information, including timing that may not appear in reported profit.
A sale can improve revenue without putting money in the bank. A supplier bill can reduce cash before the related cost changes the month's reported result. The forecast follows movement and timing.
Cash flow management is the action taken because of the forecast. You decide which customer to call, whether to request a deposit, how to sequence supplier payments, and whether a proposed hire can proceed. Cash flow analysis works backwards, showing why collections missed expectations or why spending ran ahead of plan. The forecast works forwards.
The four lines every forecast needs
A practical model starts with four building blocks:
- Opening balance: Cash available at the start of the period, based on reconciled bank information.
- Expected inflows by date: Customer receipts, financing, grants, refunds, asset sales, and other cash entering the business.
- Expected outflows by date: Payroll, suppliers, rent, tax, debt payments, operating expenses, and capital expenditure.
- Closing balance: Opening cash plus inflows minus outflows. That figure becomes the next period's opening balance.
New Zealand's official Cash Flow Forecaster uses monthly figures for cash in, cash out, cash reserves, and borrowing. Use that structure as a starting point, then connect it to the commitments your team is creating and changing each week.
Timing beats headline profit
GST cycles, fortnightly payroll, customer payment terms, and seasonal trading can make cash timing more important than the P&L profit figure. A retail business may buy stock before demand arrives. A services firm may complete work long before its client pays. A growing company may be profitable while funding receivables and hiring costs at the same time.
For a broader explanation of the mechanics, use this guide to cash flow forecasting as a reference. Build your own model around actual bank dates, approved work, and operating commitments, not generic monthly percentages.
Choosing the Right Forecasting Method and Horizon
A direct-method forecast can show that a supplier payment is due next week. A driver-based forecast can explain why that payment changes when stock orders, sales volume, or project timing changes. Choose the method around the decision, the quality of your data, and how quickly leaders need an answer. Do not choose a model because a software package advertises it.
The direct method lists receipts and payments by date. It gives the clearest near-term view of liquidity because it shows when specific customers, suppliers, employees, and tax authorities are expected to move cash. The indirect method starts with projected profit, then adjusts for working capital and non-cash items. It fits longer-range planning and sits effectively beside P&L and balance sheet forecasts.
Driver-based forecasting models the operating causes behind cash movement. Revenue volume, debtor days, payment terms, stock purchases, payroll growth, and committed capital expenditure become connected inputs. That structure works better than hard-coding a revenue line when the business has several products, regions, customer groups, or seasonal patterns. Link those assumptions to the same work management system where sales, projects, purchasing, and hiring change. The forecast should update when the underlying work changes.
Match the model to the business
| Business Profile | Recommended Method | Horizon | Upgrade Trigger |
|---|---|---|---|
| Small operator with stable debtors and straightforward expenses | Direct method | Rolling 13 weeks | Collections or payment timing becomes difficult to track manually |
| Growing business with stock, supplier terms, or several revenue channels | Driver-based method | Rolling 13 weeks plus 12 months | Inventory cycles, hiring, or expansion decisions materially affect cash |
| Finance team with an established accounting layer | Direct method for liquidity, indirect method for planning | 13 weeks plus 12 months | Leadership needs integrated P&L, cash flow, and balance sheet scenarios |
| Seasonal retailer or hospitality operator | Direct and driver-based methods | Weekly near-term view, monthly long-term view | Demand, stock, and supplier commitments move sharply across trading periods |
A rolling forecast extends forward as each period closes. A 13-week rolling view supports payroll, supplier payments, and GST planning because it preserves weekly visibility and gives leaders time to respond. A static quarterly forecast loses value after a customer pays late, a project slips, or an approved purchase changes.
Keep a 12-month horizon for capex, tax planning, debt relief discussions, and strategic capacity decisions. New Zealand guidance makes this horizon explicit. Inland Revenue can require a 12-month cash flow forecast when a business applies for debt relief, covering income, expenses, bill payment timing, and repayment capacity. New Zealand's business guidance for tradies also frames forecasting as a forward view built on realistic assumptions.
If your team is comparing modelling approaches, use this resource to choose the right forecasting model and assess the trade-offs. The operating rule remains simple: method choice follows data quality and decision speed, not software features.
Building a Forecast With Drivers and Scenarios
A driver-based forecast starts with the events that cause cash to move. Instead of entering a hopeful collections number, you connect receipts to invoices, debtor ageing, agreed terms, and the probability of payment. Instead of adding a broad expense allowance, you separate payroll, supplier commitments, GST, rent, stock, debt, and capex.
Begin with the current bank balance and a clean debtor list. For each material customer, record the invoice amount, due date, ageing status, and expected payment date. If your customers usually pay later than their stated terms, that behaviour belongs in the forecast. A 35-day debtor assumption that reflects actual collections is more useful than a 30-day assumption that only reflects the contract.
Then model the outflows that are easy to overlook. Put GST due dates, payroll cycles, rent, insurance, supplier terms, loan repayments, and approved purchases on dated lines. Add seasonal commitments, such as stock buys before Christmas or harvest-related purchasing, rather than smoothing them across the year. Committed capex belongs in the model even when the equipment hasn't arrived.
| Driver | Typical NZ Starting Assumption | Source / Trigger |
|---|---|---|
| Customer collections | Use invoice due dates, then adjust for actual debtor behaviour | Debtor ageing and collection history |
| GST | Enter the actual filing and payment dates | GST return calendar and accounting records |
| Payroll | Enter each scheduled pay cycle | Employment agreements and payroll calendar |
| Supplier payments | Use agreed terms, then adjust for negotiated timing | Supplier contracts and accounts payable ageing |
| Seasonal stock | Place purchases before the relevant trading period | Inventory plan and supplier lead times |
| Capex | Include approved commitments on their expected payment dates | Purchase approvals and project plans |
The Business Loan Warrior forecast guide is useful for thinking about how a forecast can support lending conversations. Your own model should go further by tying each assumption to an owner and an operational event.
Use scenarios to expose the decision
Build at least a base case and a downside case. A stretch case can help with planning growth, but it shouldn't be the case used to approve permanent costs.
Suppose the base forecast assumes customers pay after 35 days, but collections extend to 50 days. Don't reduce the monthly revenue line. Push the affected receipts into later periods and let the closing cash balance recalculate. The change may create a cash trough before the revenue decline becomes visible, especially if payroll, GST, and supplier payments remain fixed.
Each scenario should answer three questions:
- What changed? For example, debtor timing, demand, supplier costs, or stock requirements.
- When does cash feel the impact? Identify the week or month where the balance changes.
- What action is available? Assign collection work, renegotiate terms, defer capex, or adjust hiring.
A scenario is valuable only when it leads to a decision. If the model shows a shortfall but nobody owns the response, you've created information without control.
KPIs, Common Pitfalls, and the NZ Operating Reality
A useful forecast turns liquidity into weekly decisions. Review the indicators with the people who can change the outcome, assign an owner to each exception, and set the threshold that requires action. The dashboard should show whether the business can absorb delay, not just report yesterday's bank balance.
Review indicators as operating controls
Use the KPI definitions established earlier. The weekly review should focus on movement, ownership, and response:
- Cash runway: The finance lead reviews the updated closing balance against planned operating needs. Escalate when the forecast crosses the runway limit agreed by leadership. The owner must present a specific response, such as delaying discretionary spend or revising hiring timing.
- Minimum cash buffer: Compare the projected low point with the buffer approved by the directors. If the low point falls below that threshold, the owner of the relevant outflow must confirm whether the payment can be rescheduled, reduced, or funded.
- Forecast accuracy: Review rolling 13-week MAPE against actual cash movement. Finance owns the calculation, while operating owners explain the largest variances. Repeated misses should lead to revised driver assumptions, not a manual adjustment that hides the error.
- Days cash on hand: Use this as the plain-language liquidity signal for directors and managers. A deterioration should trigger the same response as a weakening runway, with finance confirming which receipts or payments caused the change.
- Negative cash months: Treat any newly forecast negative period as an escalation. The responsible executive must identify the timing gap, the decision required, and the date by which cash returns above zero.
New Zealand SME evidence shows why this weekly discipline matters. A 2021 small-business survey reported that 95% of surveyed firms experienced at least one month of negative cash flow, the average small business experienced four months of negative cash flow, and about 17% experienced more than six months. It also reported that only 27.8% of SMEs planned to focus on cash flow forecasts, with larger SMEs more likely to use forecasting than small SMEs, 48.6% versus 9.1%. These figures come from the available New Zealand SME research source.
Correct the causes of variance
Optimistic collections remain a common failure. Founders enter invoice due dates as receipt dates, then discover that a strong debtor book does not equal available cash. Finance should review ageing buckets weekly, while the account owner confirms the next collection action and revised receipt date.
Tax timing creates another blind spot. GST and provisional tax are known outflows, yet teams often omit them from the weekly view. Record the payment dates, assign an owner to verify them, and escalate any funding gap before the due date.
Static forecasts fail after reality changes. A delayed project, changed supplier term, or approved hire must update the relevant task, assumption, and cash impact. Auckland Chamber reported that 35% of businesses cited cash flow as a concern in early 2025, as recorded in its February 2025 confidence survey. Retail and hospitality operators should therefore test demand and stock assumptions against current operating signals rather than preserve a smooth growth line.
Set the review agenda, owners, and escalation thresholds in one place. Then connect these indicators to our management reporting framework, so leadership sees the forecast beside the decisions that affect it.
Connecting the Forecast to Your Operating Workflow
A spreadsheet forecast dies when reality changes outside the spreadsheet. The sales team updates a deal stage, the accounts team chases a debtor, an executive approves a hire, and a project manager commits to equipment. If those events don't feed the forecast, finance is working from yesterday's assumptions.
The fix is to connect the model to the workflow where decisions already happen. A work management system can hold the collection task, the responsible person, the expected receipt date, and the latest customer update. The same structure can track hiring approvals, supplier negotiations, project milestones, and capex requests.
Put ownership beside every assumption
A connected workflow should make responsibility visible. A debtor collection line needs an owner and next action, not just a number in a cell. A proposed hire should show approval status, start date, and expected payroll impact. A capex request should show whether the spend is planned, approved, ordered, or paid.
monday.com can act as the workflow layer for these decisions. Boards can track debtor follow-up, hiring approvals, supplier commitments, and capex requests. Actuals and committed spend can then feed the cash forecast through connected accounting and workflow data, reducing the delay between an operational change and its financial impact.
Wisely's finance layer can build the 13-week cash forecast, connect it to accounting data, and publish the live result into monday.com dashboards. Its monday.com and Xero integration service provides a practical route for connecting work management and accounting workflows.
The leadership team shouldn't need to ask finance for a special report every time a customer delays payment. They should see the impact, the owner, and the available response in the same weekly operating rhythm.
Review the forecast after the actuals refresh, then discuss the exceptions. Which receipts moved? Which costs were committed? Which assumption is no longer credible? The forecast becomes useful when those questions sit inside the normal management meeting, rather than waiting for a quarterly finance pack.
A connected system won't make uncertainty disappear. It will make changes visible earlier and give someone a clear task to resolve them. That's the difference between a forecast as a finance artefact and a forecast as an operating control.
Turning This Into Action This Week
You don't need a perfect model to improve control. You need a trusted opening balance, dated cash movements, explicit assumptions, scenario discipline, and a named owner who reviews the result on a fixed cadence.
A seven-day build sequence
Day 1, lock opening balances. Reconcile each bank account and confirm the current debtor and creditor balances. If the opening cash number isn't trusted, every projected closing balance is suspect.
Day 2, list the next 13 weeks. Enter dated inflows and outflows, including customer receipts, payroll, GST, rent, supplier payments, debt, and approved capex.
Day 3, classify confidence. Mark every line as confirmed, probable, or an assumption. A signed contract and a hopeful sales opportunity shouldn't sit in the same category.
Day 4, calculate liquidity indicators. Review weeks of cash, debtor days, the minimum cash buffer, and the lowest projected closing balance. Highlight the first point where management action may be needed.
Day 5, add two scenarios. Change the assumptions that could hurt cash fastest, such as slower collections, softer demand, higher stock purchases, or delayed project billing.
Day 6, choose the tool and owner. A spreadsheet may work as a starting point. As operational inputs multiply, connect accounting data and workflow tasks so updates don't rely on one person's memory.
Day 7, book the weekly review. Hold a short meeting with the founder, finance owner, and relevant operational leads. Review actuals against forecast, explain variances, and assign actions.
Prioritise effort where it matters
| Priority | Check | Decision it supports |
|---|---|---|
| High | Opening cash, payroll, GST, and major receipts | Whether immediate obligations are safe |
| High | Debtor ageing and collection ownership | Which customers need contact now |
| Medium | Supplier terms and committed spend | What can be sequenced or renegotiated |
| Medium | Hiring and capex approvals | Whether growth costs fit the cash path |
| Lower | Long-range refinement of minor expense lines | Better planning after near-term risks are controlled |
A living forecast isn't judged by how polished it looks. It's judged by whether the leadership team sees a cash problem early enough to act. Start with the next 13 weeks, keep the assumptions visible, and update the model when a customer, supplier, project, or hiring decision changes.
Wisely can help you build a connected cash flow forecasting process, combining Virtual CFO support, accounting data, scenario modelling, and monday.com workflows into a decision-ready operating view. Visit Wisely to discuss the forecast, reporting cadence, and workflow integration your NZ business needs.
