Budget Template NZ: Free Spreadsheet Tools for Kiwi Households and Small Businesses

A budget template is a ready-made spreadsheet that already has the categories, layout and formulas built in, so you can start tracking money straight away instead of designing a sheet from scratch. In New Zealand that matters, because a good template can be adjusted for local realities like GST, KiwiSaver, fortnightly pay and provisional tax rather than the US-style monthly assumptions most generic layouts use.

This guide explains where to find genuinely free budget templates in Aotearoa, which tools are worth using, and how to adapt a template for a household or a small business. It covers the differences between free and paid options, how to keep your financial data private under the Privacy Act 2020, the mistakes that trip people up, and clear answers to the questions readers ask most. Everything here is general information, not financial or tax advice.

Where can you get a free budget template in New Zealand?

You do not need to pay for a budget template. Several well-known, safe tools give away professionally built layouts, and one is made specifically for New Zealanders. Avoid random blogs offering “free downloads” of macro-enabled files, because a spreadsheet that runs code can carry malware; stick to the official sources below.

• Google Sheets template gallery — free with any Google account. Open Sheets, click Template gallery, and under Personal you will find a Monthly budget and an Annual budget template with a Summary sheet and a Transactions sheet already linked by formulas.
• Microsoft’s free Excel templates — Microsoft publishes free personal and household budget spreadsheets you can open in Excel for the web (free with a Microsoft account) or the paid desktop app.
• LibreOffice Calc and Apache OpenOffice Calc — free, open-source desktop spreadsheet programs that need no account and no subscription. They open and save both OpenDocument (.ods) and Excel (.xlsx) files, so a template made elsewhere still works.
• Sorted’s budget planner — a free online tool funded by Te Ara Ahunga Ora Retirement Commission, built for New Zealand conditions. It is a guided planner rather than a spreadsheet you download, which makes it the easiest starting point for first-time budgeters.

If you want to build formulas yourself instead of using a pre-made layout, our guide to Google Sheets formulas walks through the calculations a budget relies on, and the OpenDocument Spreadsheet (.ods) format explainer covers the file type LibreOffice and OpenOffice use by default.

Which free option should you choose?

Choose based on how you work, not on brand loyalty. Pick Sorted if you simply want to see whether you are spending more than you earn, with no setup. Pick Google Sheets if several people need to edit the same budget from their phones. Pick a desktop tool such as LibreOffice Calc if you prefer to keep files on your own computer and work without a login. If you are weighing suites more broadly, our roundup of OpenOffice alternatives compares them feature by feature.

How do you set up a budget spreadsheet for a New Zealand household?

Start by matching the template’s labels to how your money actually arrives and leaves. Most templates assume a single monthly salary, but many New Zealanders are paid weekly or fortnightly and juggle several income lines. Renaming rows and adjusting the pay cycle takes a few minutes and turns a generic sheet into an accurate picture of your finances.

A well-structured household budget usually separates income from two kinds of spending — fixed costs you cannot easily change, and variable costs you can. That split is what lets the sheet show your true savings margin once outgoings are subtracted from income.

• Income rows: main salary or wages, any second job or freelance work, boarder income, and Working for Families payments where they apply.
• Fixed costs: rent or mortgage, council rates, insurance, childcare fees, broadband and any body-corporate levies.
• Variable costs: groceries, petrol, power (which swings seasonally), dining out and clothing.
• Savings goals: a first-home deposit or an emergency fund, tracked as its own line so saving is planned rather than left to chance.

Adjusting income rows for PAYE, KiwiSaver and fortnightly pay

Separate your gross pay from your take-home (net) pay so the budget reflects the money that actually lands in your account. For employees, take-home pay is what remains after PAYE income tax, any student loan repayments, the ACC earners’ levy and your KiwiSaver contribution. On the KiwiSaver line, use the current rates: the default employee contribution rose from 3% to 3.5% on 1 April 2026, with a further rise to 4% deferred to 1 April 2028. You can also choose 4%, 6%, 8% or 10%, or apply to Inland Revenue for a temporary reduction back to 3%. Set your row to whichever rate you have selected so the forecast is accurate.

Free templates versus paid budgeting apps: what is the trade-off?

The main difference is automation, not accuracy. A free template is every bit as accurate as a paid app — the paid apps mostly save you data-entry time by importing transactions automatically. Paid budgeting and accounting tools connect to your bank and pull transactions in for you, then categorise them; free templates ask you to enter or paste transactions yourself.

For a household or a hobby club, entering a week of transactions by hand takes roughly ten minutes and costs nothing. For a growing business with hundreds of transactions a month, automatic bank feeds can be worth the subscription. If your needs are drifting toward full accounting, a subscription suite such as Office 365 for business in New Zealand or a dedicated accounting package may fit better than a spreadsheet.

The real cost of manual data entry

Manual entry has one hidden benefit: it keeps you close to your spending. People who type in their own transactions tend to notice patterns — the daily coffee, the forgotten subscription — that an automated feed quietly absorbs. The trade-off is discipline: a template only works if you update it. If you know you will not keep it current, a guided tool like Sorted or an app with automatic feeds may suit you better than a blank spreadsheet you abandon after a fortnight.

Tracking small-business cash flow, GST and invoices

For sole traders and contractors, a spreadsheet doubles as a low-cost cash-flow and invoicing tracker. Logging each invoice with its date, client, NZD amount and a paid/unpaid status lets you see at a glance which accounts are overdue and how much cash is genuinely available versus owed to Inland Revenue.

Two New Zealand tax figures should be built into any business sheet. GST is charged at 15%, and you must register for GST once your turnover passes NZ$60,000 in any 12-month period. Separately, you generally pay provisional tax if your residual income tax was more than $5,000 in the previous year, so many sole traders set aside roughly 25–30% of each invoice in a dedicated tax column to avoid a shock at year-end.

• GST columns that calculate the 15% component on both sales and expenses.
• Invoice tracking sorted by due date so overdue accounts stand out.
• A tax-set-aside row that ring-fences money for provisional tax and GST returns.
• A mileage log for work travel, which supports vehicle expense claims.

Getting your records ready for the IRD and your accountant

A tidy spreadsheet kept up to date all year is far cheaper than a shoebox of receipts handed over at tax time. Inland Revenue accepts electronic records, so a clear, dated ledger you can export satisfies record-keeping requirements and reduces the billable hours an accountant spends untangling your year. Keep backups, and export a copy to Excel (.xlsx) or PDF at year-end so the record is fixed even if you change tools later.

How do you share and collaborate on a budget safely?

Cloud spreadsheets let more than one person edit the same budget at once, which suits couples, flatmates and small teams. Instead of emailing files back and forth, everyone opens one shared copy that updates live. The key is to control who can do what.

• Share to specific people, not “anyone with the link”, when a budget contains personal figures.
• Use view-only access for people who only need to see the numbers, and edit access for those who maintain them.
• Protect formula cells so a collaborator cannot accidentally overwrite a calculation.
• Rely on version history to see who changed what and to roll back mistakes.

Keeping your budget data private under the Privacy Act 2020

A budget spreadsheet holds sensitive information — income, bank details, sometimes an IRD number — so protecting it matters. Organisations that hold personal information in New Zealand must comply with the Privacy Act 2020, which sets rules for how that information is collected, stored and shared. For an individual, the strongest protection is your own account security.

Reputable providers encrypt your data in transit and at rest, but that only helps if your account itself is locked down. The practical steps below make the biggest difference. New Zealand’s regulatory context, from tax to privacy, is summarised on Wikipedia if you want the wider picture.

• Turn on two-factor authentication so a stolen password alone cannot open your account.
• Restrict sharing links to named email addresses rather than public links.
• Turn off download, copy and print for confidential business files in the advanced sharing settings.
• Know how to delete files completely if you ever move to a different tool.

Common budgeting-spreadsheet mistakes to avoid

Most budgets fail for predictable reasons rather than bad maths. Watching for these keeps a template useful past the first month.

• Budgeting on gross instead of net pay, which overstates the money you actually have to spend.
• Ignoring irregular costs such as car registration, insurance excess or Christmas, then treating them as emergencies.
• Forgetting the tax set-aside as a sole trader, so GST and provisional tax bills arrive with no money reserved.
• Never updating the sheet, which turns an accurate plan into fiction within weeks.
• Sharing a public edit link, exposing personal financial details to anyone who receives it.
• Using the wrong KiwiSaver rate, which quietly throws off every take-home figure in the sheet.

Working offline and fixing common spreadsheet glitches

Connectivity is not guaranteed everywhere in New Zealand, from rural Northland to a West Coast bach. Cloud tools such as Google Sheets can be set to work offline: enable offline access in your account settings before you lose signal, and the app keeps a local copy you can edit, syncing automatically when you reconnect. A desktop program like LibreOffice sidesteps the issue entirely, since files live on your computer.

If a browser-based sheet becomes slow or misbehaves, close spare tabs to free memory and clear your browser cache, which forces a fresh copy of the app to load. Formula errors are almost always small typing mistakes — a missing comma, an unclosed bracket, or a calculation pointing at a cell that contains text instead of a number — so read the error tooltip and check the referenced cells first.

Disclaimer

This article is general information about budgeting tools and templates, not financial, tax or legal advice, and it does not recommend any single product. Tax rates, KiwiSaver settings and thresholds change; confirm current figures with Inland Revenue before relying on them. For free, independent budgeting help built for New Zealanders, use Sorted’s budget planner from Te Ara Ahunga Ora Retirement Commission, and speak to a qualified accountant or financial adviser about your own situation.

Frequently asked questions (FAQ)

Are budget templates really free in New Zealand?

Yes. Google Sheets and Microsoft both include free budget templates, LibreOffice Calc and Apache OpenOffice Calc are free open-source programs, and Sorted’s budget planner is a free government-funded tool made for New Zealanders. None of them require payment for a basic budget, though Microsoft’s paid desktop apps and some accounting suites add features on top.

What KiwiSaver rate should I put in my budget?

Use the rate you have actually chosen. The default employee contribution rose to 3.5% on 1 April 2026, and you can select 4%, 6%, 8% or 10%, or apply to Inland Revenue for a temporary reduction to 3%. Enter your chosen rate so the sheet calculates your take-home pay correctly.

Do I need to charge or track GST in my budget spreadsheet?

Only if you are GST-registered. GST is 15%, and registration is required once your turnover passes NZ$60,000 in a 12-month period. If you are registered, add columns that calculate the 15% component on sales and expenses so you can set aside what you owe before each GST return.

Can I open a Google Sheets or Excel budget on my phone?

Yes. Google Sheets and Microsoft Excel both have free mobile apps for iOS and Android, and a budget created on a computer scales to a phone screen. That makes it easy to log a purchase at the checkout, and shared budgets update for everyone at once.

Is a spreadsheet safe enough for private financial data?

It can be, with sensible habits. Turn on two-factor authentication, share files only with named people rather than public links, and protect or lock formula cells. Providers must handle personal information under the Privacy Act 2020, but your own account security is the most important safeguard.