Free Budget Template NZ: Where to Get One and How to Set It Up

A budget template is a ready-made spreadsheet or online planner that lays out your income and expenses so you can see where your money goes each week, fortnight or month. Instead of building rows, formulas and charts from scratch, you simply type your numbers into a layout that already does the maths for you. This guide explains where people in New Zealand can find genuinely free budget templates, and how to adapt one for local realities such as fortnightly pay, KiwiSaver, PAYE and GST.

The approach here is practical and neutral. You will find what a budget template actually does, the trustworthy places to get one at no cost, how to structure it for a household or a sole trader, how the main tools compare, and the privacy and accuracy pitfalls worth avoiding. Every New Zealand figure below was checked against official sources current in 2026.

What is a budget template, and why use one?

A budget template is a pre-formatted document that separates your income from your spending and totals the difference automatically. Most templates group costs into categories (housing, food, transport, savings), apply built-in formulas so totals update as you type, and often add a chart or progress bar so you can see your position at a glance. The point is to remove guesswork: you enter real numbers, and the template shows whether you are living within your means.

The main benefit is speed and consistency. A good template means you are not rewriting formulas or reformatting cells every month, and the categories stay the same so you can compare one period against another. The main trade-off is that a free template usually relies on manual data entry — you type transactions in yourself, or paste a CSV export from your internet banking — rather than pulling a live bank feed the way some paid apps do. For most households, a few minutes of entry a week is a reasonable price for keeping full control of the file and spending nothing.

Where to get a genuine free budget template in New Zealand

You do not need to pay for a quality budget template, and you should not have to hand over a credit card or download an unknown macro-enabled file to get one. There are three safe, free routes: the template galleries built into mainstream spreadsheet apps, guided online tools published by reputable New Zealand organisations, and sample templates from government business sites. The comparison below sets out the most reliable options side by side.

Spreadsheet templates in Google Sheets and Excel

Both Google Sheets and Microsoft Excel ship with free budget templates in their template galleries, and these are the most flexible starting point because you can edit every cell. In Google Sheets, open the template gallery from the start screen and pick “Monthly budget” or “Annual budget”; the file is free with any Google account and saves to your Google Drive. In Excel, the equivalent layouts are available through Microsoft’s online template gallery and inside the desktop app. If you want to understand the calculations behind them, our guide to Google Sheets formulas walks through the SUM, IF and conditional-formatting functions these templates rely on, and our overview of using Microsoft Excel in New Zealand covers the Excel side.

If you would rather not use Google or Microsoft at all, a free open-source suite such as LibreOffice Calc opens and edits the same spreadsheet files and can save in the open ODS spreadsheet format or export to Excel’s .xlsx. Our rundown of free office suites like LibreOffice compares the main options if you want a desktop tool with no subscription.

Guided online budget tools from NZ organisations

If a blank spreadsheet feels daunting, a guided tool walks you through the categories instead. The free Sorted budget planner, run by Te Ara Ahunga Ora Retirement Commission, lets you enter income and expenses on a weekly, fortnightly, monthly or annual basis and flags your fixed versus discretionary spending. It is independent, contains no advertising, and does not sell your data. Several New Zealand banks, including ANZ and Westpac, also publish free budget and cash-flow templates you can download without being a customer. These guided tools are a good first step; many people graduate to a spreadsheet once they want to customise categories or keep a longer history.

How to set up a budget template for New Zealand pay and taxes

The single most important setup step is to budget from your net (take-home) pay, not your gross salary. A generic overseas template often assumes you enter a gross figure, but your employer deducts PAYE income tax, your KiwiSaver contribution, any student-loan repayment and ACC earners’ levy before the money reaches your account. Entering gross pay will overstate what you actually have to spend. Adjust the income rows so the top line is what lands in your bank account.

Income: gross, net, KiwiSaver and student loan

Set your income rows to reflect how New Zealand pay works. KiwiSaver is the voluntary work-based savings scheme: from 1 April 2026 the default (minimum) employee and employer contribution rate rose from 3% to 3.5% of gross pay, and it is scheduled to rise again to 4% on 1 April 2028. You can still choose to contribute 3%, or opt up to 4%, 6%, 8% or 10%. If you contribute at least $1,042.86 over the KiwiSaver year, the government adds a contribution worth up to $260.72 (this was halved from the previous $521.43). Student-loan repayments are a separate deduction — 12% of earnings above the pay-period threshold — and should not be lumped in with the ACC levy or KiwiSaver. Giving each of these its own row keeps your take-home figure accurate.

Fixed and variable expenses

Split your spending into fixed costs and variable costs so the template can show which parts you can actually influence. Fixed costs are the predictable commitments — rent or mortgage, council rates, insurance, broadband, power and any body-corporate levies. Variable costs change week to week, such as groceries, petrol, eating out and clothing. A common and useful feature is conditional formatting that turns a cell red when actual spending exceeds the amount you budgeted, giving you an early warning. Remember to include irregular annual bills (car registration and warrant of fitness, insurance excesses, back-to-school costs) as a monthly set-aside so they never catch you out.

Using a budget template for a small business or sole trader

For a sole trader or contractor, a budget template doubles as a simple cash-flow and invoice tracker. By logging each invoice date, client, amount and a paid/unpaid status, you can see at a glance which accounts are overdue and whether you have enough coming in to cover upcoming costs. This matters most for separating money you can spend from money you are only holding on behalf of the tax system.

GST and provisional tax columns

Build dedicated columns for GST and tax so you never spend money that is not yours. GST (Goods and Services Tax) is charged at 15% in New Zealand, and you must register once your taxable turnover passes $60,000 in any rolling 12-month period — a threshold that has been unchanged since 2009. If you are registered, add a column that calculates the 15% GST portion of each sale so you can set it aside for your return. Provisional tax applies if your residual income tax for the previous year was more than $5,000; under IRD’s standard method you pay 105% of last year’s tax in three instalments. A practical habit is to move roughly 25–30% of each payment you receive into a separate account for income tax. If you also raise invoices, our GST-compliant invoice template for New Zealand shows the exact fields IRD requires.

Google Sheets vs Excel vs a dedicated budgeting app

The right tool depends on how you work rather than which is objectively “best”. Google Sheets is free, works in any browser, syncs across devices and is strong for sharing a single file with a partner or flatmates in real time. Microsoft Excel offers deeper formulas and offline power; it comes free in the browser-based version with a Microsoft account, while the full desktop app needs a one-off Office purchase or a Microsoft 365 subscription. A dedicated budgeting app can connect to your bank for automatic imports, but usually charges a monthly fee and gives you less control over the underlying numbers. For most households a free spreadsheet is enough; a business tracking GST and many transactions may prefer Excel or accounting software.

Three practical questions usually decide it. First, do you need to work offline? A desktop spreadsheet such as Excel or LibreOffice Calc always works without a connection, whereas cloud tools need offline mode enabled in advance and are less reliable in areas with patchy coverage. Second, who else needs access? If a partner, flatmate or accountant has to see the same file, a cloud spreadsheet with proper sharing settings is simpler than emailing versions back and forth. Third, how much data will you track? A simple household budget runs fine in any tool, but hundreds of monthly transactions and GST are easier in a structured spreadsheet or purpose-built software. Match the tool to those answers rather than to marketing claims.

Keeping your financial data private and secure

A budget file holds sensitive information — income, bank balances, sometimes your IRD number — so treat its security seriously. Organisations that handle personal information in New Zealand (Wikipedia defines the country’s framework under the Wikipedia entry on its privacy law) must comply with the Privacy Act 2020, which sets rules for how personal data is collected, stored and shared. For your own files, the practical steps matter most: turn on two-factor authentication (2FA) on your Google or Microsoft account, and never use an “anyone with the link” share setting for a budget. Instead, share to specific email addresses, and switch off download, copy and print permissions for anything confidential. Avoid emailing a budget spreadsheet as an attachment where you cannot control who forwards it.

How to start using your budget template in five steps

Getting a budget template working takes about half an hour the first time, then a few minutes a week after that. A simple, repeatable process keeps it accurate:

1. Pick one template and make a copy. Choose a single layout from a trusted source above and save your own copy so you never overwrite the original. Resist the urge to combine three templates into one.
2. Gather a month of real numbers. Open your internet banking and list your actual income and every recurring payment. Real figures from the last statement beat estimates every time.
3. Set up income as net pay. Enter your take-home amount per pay cycle, and match the template’s period (weekly, fortnightly or monthly) to how you are actually paid.
4. Categorise your spending. Rename the template’s categories to match your life — for example splitting “transport” into petrol, public transport and vehicle costs — and add a line for savings or debt repayment.
5. Review on a set day. Book a recurring ten-minute slot, update actual spending against your plan, and adjust next month’s figures based on what you learned.

For shared households, the same steps work with one addition: keep the file in the cloud and give each flatmate edit access so grocery, power and internet costs are logged as they happen rather than reconstructed at the end of the month. A single shared sheet removes the awkward “who paid for what” conversations and keeps everyone looking at the same totals.

Common budgeting-template mistakes to avoid

Most budgets fail for a handful of avoidable reasons rather than bad maths. Watch for these:

• Budgeting from gross pay: always use your take-home figure after PAYE, KiwiSaver and any student-loan deduction, or you will plan to spend money you never receive.
• Ignoring irregular costs: rates, insurance, vehicle registration and annual subscriptions wreck a budget that only lists monthly bills — set aside a monthly amount for them.
• Not ring-fencing tax: sole traders who spend their GST or provisional tax get a nasty surprise at return time; move it to a separate account as it comes in.
• Downloading risky files: avoid macro-enabled spreadsheets from unknown blogs; stick to the built-in galleries or the reputable sources listed above.
• Setting and forgetting: a budget only works if you update it — book a regular ten-minute slot each week rather than leaving it for months.

Disclaimer

This article is general information about budgeting tools and New Zealand tax settings as at 2026; it is not personalised financial advice. Tax rates, thresholds and KiwiSaver rules can change — confirm current figures with Inland Revenue (ird.govt.nz) before relying on them. For free, independent budgeting help, the Sorted website and the MoneyTalks helpline are good starting points, and a registered financial adviser can help with decisions specific to your situation.

Frequently Asked Questions (FAQ)

Is a budget template really free in New Zealand?

Yes. The template galleries in Google Sheets and Microsoft’s free browser-based Excel both include budget layouts at no cost, and the Sorted budget planner is free and ad-free. You should never need to pay or enter card details to get a basic budget template; be cautious of sites that lock a simple spreadsheet behind a paywall or an email capture.

Should I enter my gross or net pay in a budget template?

Enter your net, take-home pay — the amount that actually reaches your bank account after PAYE, KiwiSaver, ACC and any student-loan repayment. Many overseas templates assume a gross figure, which overstates what you have available. Adjust the income row so the total matches your payslip’s net amount.

What KiwiSaver rate should my budget assume in 2026?

From 1 April 2026 the default employee and employer contribution rate is 3.5% of gross pay, rising to 4% on 1 April 2028. You can choose 3%, 4%, 6%, 8% or 10% instead. If you contribute at least $1,042.86 in a KiwiSaver year, the government adds up to $260.72, so it is worth reflecting your real rate in the template.

Can my partner and I edit the same budget at once?

Yes, if you use a cloud spreadsheet such as Google Sheets or Excel for the web. Share the file to each other’s specific email addresses with edit access, and you can both update rows at the same time from different devices. For privacy, avoid the open “anyone with the link” setting and turn on two-factor authentication.

Do I need a special template to handle GST as a sole trader?

Not necessarily — any spreadsheet can handle GST if you add a column that works out 15% of each sale and set that money aside. You must register for GST once turnover passes $60,000 in a rolling 12-month period. A business-focused template that also tracks invoice dates and provisional tax set-asides will make your end-of-year return much easier.