A financial forecasting template should match the decision in front of you. For simple NZ cash planning, start with Business.govt.nz's Cash Flow Forecaster, then move to linked statements or richer scenario models as the business grows.
What question are you really trying to answer? Is it, “Will we have enough cash to pay next month's bills?” Or is it, “Can we defend this growth plan to a lender or investor?” Those questions need different tools, even when both are called a financial forecasting template.
Subscriptions are changing, invoices are landing at odd times, and cash is moving through the business faster than your spreadsheet can explain. A useful model should make the next few months clearer, not create another admin job. The ten resources below cover distinct founder tasks, from basic cash flow and a written financial plan to budgeting, bank discussions, linked three-statement modelling and scenario analysis.
Local context matters. Global templates may use unfamiliar tax timing, payroll rules or reporting terms, so check GST, PAYE, provisional tax and other compliance costs before relying on their outputs. NZ-built tools can also make conversations with local banks, advisers and stakeholders easier. For a wider explanation of cash planning, see this cash flow forecasting guide from Everglow Prosperity.
The comparison focuses on format, audience, depth, strengths, limitations, localisation work and the practical layout you'll encounter. Screenshot previews are included where supplied. Let's get to the tools.
The Business.govt.nz Cash Flow Forecaster is the cleanest starting point for a founder who needs to see whether cash will hold up. It's an interactive NZ government tool for entering expected income and expenses, viewing month-by-month cash movement and sharing the result with an adviser or bank.
Business.govt.nz's guidance sets out the basic sequence clearly. Choose the forecasting period, date expected cash income, date outgoing costs, add the starting balance, then tally the movements to see forecast cash on hand. It also recommends using three income scenarios, which gives founders a best-case, base-case and worst-case view without turning a small business forecast into a finance department project. The official cash flow guidance explains that process in plain language.
The main strength is low friction. You don't need to understand linked statements to enter revenue, expenses and opening cash. Automatic opening and closing balances make the output useful for a quick runway conversation, while the NZ terminology reduces translation work.
Practical rule: Use this tool when the decision is about timing, not accounting presentation.
The limit is just as important. It focuses on cash flow rather than building a full income statement, balance sheet and supporting schedule. Scenario control is also lighter than in a driver-based model. Still, for a young SaaS or services business with uneven receipts, it can be the right first move. Once the cash picture is stable, teams can improve cash flow forecasting by adding better assumptions and regular actual-versus-forecast reviews.
Some founders don't need another spreadsheet. They need a clear document that explains what the business expects to earn, spend and raise. The Business.govt.nz Financial Plan Template is a DOCX resource for that job, with sections for forecast costs, revenue, profit and loss, cash flow and funding needs.
Word is the point here. You can edit the narrative quickly, explain the assumptions behind the numbers and prepare a plan for a lender, grant application or internal review. It keeps funding requirements visible instead of burying them across multiple spreadsheet tabs. For founders still working through setting up a business in NZ, that structure can also prompt useful questions about operating costs, sales plans and capital needs.
The template works well beside the Cash Flow Forecaster. One explains the business and its funding case. The other shows when cash should arrive and leave. Keeping those roles separate is sensible, because a polished plan can still hide a weak cash position.
The trade-off is that a DOCX file won't create linked financial statements or calculate a changing forecast for you. You'll need a separate spreadsheet or accounting model for the numeric engine. That isn't a flaw. It means you should not treat written assumptions as a substitute for tested formulas.
Use this resource when the immediate task is communication. If a bank asks why funding is needed, or an adviser wants the business story in one place, a concise written plan is often easier to review than a spreadsheet with a dozen tabs.
A budget answers a slightly different question from a forecast. It sets out what you expect to spend and earn, then gives you a reference point for comparing actual results. Xero's Free Budget Template is useful when that comparison matters more than building a detailed projection from scratch.
The editable template is available for Excel, Google Sheets and PDF. That makes it easy to start in a familiar format, adjust revenue and cost lines, and share a working version with a bookkeeper or adviser. Businesses using Xero can also import budgets into Budget Manager for reporting inside the product, which creates a practical hand-off from spreadsheet planning to accounting review.
The Xero connection is the attraction for many NZ and Australian SMEs. Accountants in both markets commonly work with Xero, so the format feels familiar and the budget can sit closer to monthly reporting. If you're comparing tools for small businesses in New Zealand, this kind of hand-off is worth considering.
But a budget isn't automatically a forecast. The template is primarily budget-oriented, and its depth depends on how much you add. You may need separate assumptions for customer receipts, payment timing, payroll, GST and funding movements. A budget can tell you that marketing spend is above plan. It may not tell you whether a delayed customer payment will create a cash crunch next week.
Use Xero's template when the team needs a simple target and review rhythm. It works less well as the sole model for an investor pack or a business with complex working-capital movements.
Founders often underestimate the value of a bank-shaped forecast. The ASB Business Hub cashflow forecasting template presents monthly inflows and outflows in a format that suits practical cash management and funding discussions.
It's aimed at small businesses, with guidance on spotting timing gaps rather than adding annual totals. That distinction matters. Revenue can look healthy on paper while cash arrives after wages, suppliers or tax payments fall due. A month-by-month layout makes those pressure points visible.
ASB's main advantage is context. The template comes from a NZ bank and uses a friendly format for owners who aren't accountants. That can help when you're preparing to discuss an overdraft, loan or working-capital gap, because the cash question stays front and centre.
Cash planning should explain not only how much money you need, but when you need it and what changes the requirement.
The model is not a linked profit and loss or balance sheet system. You won't get a complete view of retained earnings, receivables or liabilities without building those pieces elsewhere. It also won't replace a detailed tax schedule. Add GST, PAYE, provisional tax and other compliance payments as dated cash outflows, rather than treating tax as an afterthought.
ASB suits a founder who needs a clear cash conversation soon. It's less suitable when you want to test many drivers, connect operational metrics or maintain a full three-statement model.
Automation can save time, but it can also create a support headache. Westpac NZ's business tools and templates include a macro-enabled Excel cash flow forecasting template with a companion guide. It's aimed at teams that want a bank-style monthly structure with more spreadsheet automation than a plain input sheet.
The macro version can make repetitive calculations faster. It also gives the model a familiar structure for monthly projections and funding conversations. For a founder preparing an overdraft or loan discussion, a bank-recognised format may feel more comfortable than a heavily customised personal workbook.
Some organisations block macros under IT and security policies. Cross-platform use can also be awkward, especially when people need to review the file outside Windows Excel. Westpac NZ also distributes cash flow and profit and loss templates with and without macros, so the wider set supports both automated and non-macro workflows, as documented in the local template resource.
Before using the file in a team, test it on the computers and spreadsheet applications people use. Keep a clean fallback copy. A model that only one person can open isn't a reliable forecasting process.
This tool fits an established small business that wants more convenience than a basic sheet provides. It won't solve weak assumptions. Macros can move numbers quickly, but they can't tell you whether your sales plan is credible or whether a customer will pay on time.
What should a founder bring to a lender meeting when the discussion turns to cash timing? ANZ New Zealand's cash flow forecast calculator and Biz Hub guide supports a clear, month-by-month review that people can discuss around a table.
The resource provides a pre-structured layout for expected inflows and outflows, alongside instructions for preparing and interpreting the forecast. Users record opening cash, expected revenue, other revenue such as bank lending, and expected outgoings. The sheet calculates opening and closing balances for each month, keeping attention on liquidity rather than an unsupported annual estimate.
The PDF suits a lender meeting, board discussion or founder review. It is easy to print, explain and complete, while the companion guide gives non-finance users a practical path through the inputs. That matters when the immediate need is a shared view of upcoming cash movements.
Its trade-off is limited customisation. A PDF cannot function like a live Excel or Google Sheets model, so scenario testing and formula changes may require rebuilding the structure elsewhere. ANZ's guidance reinforces the month-by-month method, which is useful for cash planning but does not replace a full financial plan with linked statements.
Use this resource when meeting clarity matters more than model depth. A SaaS founder managing deferred collections or a services firm with uneven invoices should recreate the layout in a spreadsheet, add dated receipt assumptions, and localise tax, lending and payment timing before relying on the forecast. The result becomes more useful for NZ or Australian operations, without pretending that a printable template is a scenario-ready model.
Reckon NZ's cashflow forecast template takes the middle road. It offers an editable spreadsheet for a 12-month cash flow projection, with clear line items and basic formulas that early-stage operators can adjust without wrestling with a large corporate model.
That balance is useful. A blank workbook invites inconsistency, while a complex model can discourage regular updates. Reckon's layout gives the business a starting frame, then leaves room to add its own revenue streams, supplier payments, payroll and financing lines.
The template suits a small NZ business that needs a clean forecast without building a fully linked model. Excel and Google Sheets support make sharing easier, and the simple formulas are easier to inspect than an opaque automated workbook.
Its limits appear when the business needs driver logic. You won't get advanced scenario controls, detailed supporting schedules or automatic links between the cash flow, income statement and balance sheet. A founder may need to add separate tabs for customer payment timing, tax obligations and funding movements.
Use it as a working cash model, not as a promise of precision. Business.govt.nz says its Cash Flow Forecaster needs monthly figures for cash in, cash out, cash reserves and borrowing, with bank statements available. That cash-based discipline is more important than which simple spreadsheet you select, and the official Cash Flow Forecaster resource makes the mechanics explicit.
Smartsheet is useful when the founder knows the business has outgrown a basic cash sheet but isn't ready to build a model from an empty workbook. Its cash flow forecast and financial projection templates include simpler cash flow files, startup projections and more detailed multi-statement structures.
The range is the feature. You can start with a straightforward monthly sheet, then move to a richer projection as reporting needs grow. Excel and Google Sheets formats make the files accessible, while instructions and example layouts help a team understand how the workbook is meant to work.
These are global templates, so NZ and Australian founders need to inspect the assumptions before using them. Check GST treatment, payroll timing, tax lines, payment terms, currency settings and the way financing is presented. A global model may be mathematically sound while still being wrong for a NZ tax-heavy startup.
NZ guidance specifically reminds businesses to include GST, PAYE and provisional tax in cash-flow forecasts. Local resources also recommend comparing actuals against forecasts every month and keeping a detailed 12-month forecast with longer-range summaries, as outlined in Prospa's NZ cash flow guidance.
Smartsheet works best for a founder who wants a menu of complexity. It doesn't give you local compliance by default, so write down every adjustment. Otherwise, the model may look polished while its cash timing misses the point.
A cash forecast tells you when money moves. A three-statement model explains how the income statement, balance sheet and cash flow statement connect. The CFI 3-Statement Financial Model Template is designed for founders and finance teams who need that deeper structure.
The model links the Income Statement, Balance Sheet and Cash Flow statement, with supporting schedules and a compact starter model. It can serve as a learning base for FP&A work, investor reporting, discounted cash flow analysis and scenario analysis. That makes it a serious step up from a cash-only spreadsheet.
The value comes from the links. Change revenue, costs, working capital or financing assumptions and the effect can flow through the statements. That helps answer questions a basic cash sheet can't, such as whether growth is consuming working capital or whether a funding plan changes the balance sheet as expected.
The cost is learning time. You need enough modelling knowledge to customise formulas safely, understand circularity risks and check that the statements balance. The template also needs NZ or Australian localisation for GST, payroll, tax and reporting treatment. Don't paste local figures into a global model and assume the result is ready for an adviser.
A linked model earns its place when the business needs to explain not only the cash outcome, but the accounting story behind it.
CFI suits investor-grade planning and deeper internal analysis. It's too much for a founder who only needs a clear view of next month's bills, but it becomes valuable when capital providers ask harder questions.
SCORE's Startup Financial Projections Template is the broadest all-in-one file in this list. It includes tabs for startup costs, sales forecasts, payroll, cash flow, profit and loss, balance sheet, break-even and financial ratios, with input areas and automatic calculations.
That breadth can help when a lender or investor expects a complete projection pack. The documentation is written for non-experts, and the single-file approach keeps assumptions, statements and supporting outputs together. For founders learning how the parts relate, it provides more scaffolding than a plain cash flow worksheet.
SCORE is a US small-business resource, so NZ and Australian users must change the defaults. Review tax assumptions, payroll treatment, GST handling, payment terms, currency and regulatory lines. If you're still working through how to start a small business in NZ, get an accountant to check the local treatment before sending the file to a lender.
The template is also more demanding than a cash-only tool. More tabs mean more ways to create an inconsistent assumption. If revenue grows in one sheet but staffing capacity stays unchanged elsewhere, the output may be tidy but unconvincing.
Use SCORE when you need a broad projection pack and are willing to localise it carefully. For a young business with irregular receipts, start by validating the cash timing first. A complete model with the wrong tax dates is still the wrong model.
| Tool | Core features (✨) | Quality (★) | Best for (👥) | Price/value (💰) | Standout (🏆) |
|---|---|---|---|---|---|
| Business.govt.nz – Cash Flow Forecaster | Guided inputs, monthly opening/closing balances, exportable | ★★★★☆ | 👥 NZ SMEs, non‑financial founders | 💰 Free | 🏆 NZ‑centric, very low learning curve |
| Business.govt.nz – Financial Plan Template (DOCX) | Word format, sections for forecasts, funding & assumptions | ★★★★ | 👥 Founders preparing decks, bank packs | 💰 Free | 🏆 Familiar DOCX for lenders & grants |
| Xero – Free Budget Template | Editable Excel/Sheets, import to Xero, time‑period budgets | ★★★★ | 👥 Xero users, accountants & SMEs | 💰 Free | 🏆 Smooth hand‑off into Xero reporting |
| ASB Business Hub – Cashflow Forecasting Template | Month‑by‑month inflows/outflows, practical guidance | ★★★★ | 👥 Bank‑facing founders, small biz owners | 💰 Free | 🏆 Bank‑aligned format for lender conversations |
| Westpac NZ – Cashflow Forecasting Excel (with Macros) | Macro automation, bank structure, companion guide | ★★★★☆ | 👥 Teams using Excel on Windows | 💰 Free | 🏆 Macro automation speeds calculations |
| ANZ NZ – Cash Flow Forecast (PDF) + Biz Hub Guide | Pre‑structured monthly template, walkthrough guide | ★★★★ | 👥 Founders needing printable bank‑ready docs | 💰 Free | 🏆 Simple, meeting‑friendly printable format |
| Reckon NZ – Cashflow Forecast Template | 12‑month editable sheet, clear line items, formulas | ★★★★ | 👥 NZ SMEs wanting customisable spreadsheet | 💰 Free | 🏆 Easy to adapt for local businesses |
| Smartsheet – Cash Flow & Projection Templates | Multiple templates (simple to detailed), docs & examples | ★★★★ | 👥 Teams needing choice of complexity | 💰 Free | 🏆 Wide template variety and good docs |
| CFI – 3‑Statement Financial Model Template | Linked IS/BS/CF, schedules, DCF/base for FP&A | ★★★★★ | 👥 Investors, FP&A, growth startups | 💰 Free | 🏆 Investor‑grade, fully linked model |
| SCORE – Startup Financial Projections Template | All‑in‑one: P&L, BS, CF, ratios, break‑even | ★★★★ | 👥 Startups seeking comprehensive single file | 💰 Free | 🏆 Very comprehensive lender/investor pack |
| Westpac NZ – Cashflow Forecasting Excel Template (with Macros) | Macro‑enabled calculator, monthly projections, guide | ★★★★☆ | 👥 Excel‑centric finance teams | 💰 Free | 🏆 Automated features; bank style layout |
The best financial forecasting template isn't the one with the most tabs. It's the one that helps you make the next decision with less guesswork.
Start with a cash flow tool when runway and payment timing are the concern. Business.govt.nz's Cash Flow Forecaster is the natural first stop for simple NZ cash planning. Bank templates from ASB, Westpac NZ and ANZ make sense when you're preparing a funding conversation or want a familiar monthly structure. Reckon offers a practical editable middle ground, while Xero's budget template fits businesses that need to compare actual results with planned spending.
Add the Business.govt.nz written financial plan when the numbers need a story. A lender, grant provider or investor will want to understand what drives revenue, why costs rise and how much funding the business needs. A document can hold that explanation more clearly than a workbook alone.
Use a budget when tracking actuals matters. A budget gives the team a reference point, but don't confuse it with a cash forecast. The budget says what you plan to spend. The cash forecast shows when money arrives and leaves. Those are related, not interchangeable.
Choose a linked three-statement model when investors, advisers or deeper scenario work require it. CFI and SCORE provide more structure, but both demand careful customisation. Global templates need NZ or Australian checks for GST, PAYE, provisional tax, payroll timing, currency and reporting treatment. Those lines can materially change runway, especially for SaaS, app and services businesses with irregular receipts or deferred collections.
Write down the assumptions beside the model. Record the expected receipt date, not only the invoice date. Separate base, downside and upside cases, then identify which changes create the sharpest cash pressure. Business.govt.nz explicitly supports three income scenarios, and local guidance recommends regular comparison of actuals against forecasts. For variable-income businesses, weekly forecasting may be more useful than a neat monthly file, while the monthly view still helps with bank and management reporting.
The wider NZ macro picture also supports a multi-year view. Treasury's 2025 Budget Economic and Fiscal Update projected real GDP growth of 2.9% in 2025/26, 3.0% in 2026/27, 2.9% in 2027/28 and 2.6% in 2028/29, with CPI inflation forecast at 2.2%, 2.1%, 2.0% and 2.0% across those years, as reported through the Reserve Bank's business expectations resource. Those aren't your company's forecast, but they offer a sensible backdrop for testing pricing, wages and costs.
Review the model regularly, compare it with bank data and change assumptions when reality changes. A forecast that sits untouched in a shared drive isn't planning. It's a diary entry.
NZ Apps serves founders, operators and technical decision-makers across New Zealand and Australia, making this a practical companion to its wider regional app and tech coverage.
If you're building or assessing an NZ or Australian app business, visit NZ Apps for regional company coverage, software roundups and practical resources for founders and operators. Use the directory and editorial guides to find relevant local tools, partners and market context before your next planning or funding conversation.
Add your NZ or Australian app or tech company to the NZ Apps directory and get discovered by founders and operators across the region.
Get ListedReach tech decision-makers across New Zealand and Australia. Sponsored and dofollow editorial links, permanent featured listings, and sponsored articles on a DA30+ .co.nz domain.
See Options