New Zealand · Free chart of accounts template

NZ Chart of Accounts for Xero with GST Codes (Free)

A free New Zealand chart of accounts for Xero: every account carries its default GST code, as a readable CSV plus a ready-to-import CSV.

By ExpenseFlow team
· 25 June 2026

Free download · no email required

CSV with the default and other valid Xero GST codes per account. Import file and rate list below.

Download chart of accounts (CSV)

This is a New Zealand chart of accounts built for Xero, with the correct GST treatment set on every account using Xero’s own New Zealand rate names. You get a readable reference CSV and a ready-to-import CSV that carries the GST code on each account, so a fresh Xero organisation arrives correctly coded rather than defaulting every line to No GST.

Two files, both shaped for Xero

  • The reference CSV lists each account with its class, its default GST code, any other valid codes that legitimately apply, and a short note on the treatment.
  • The Xero import CSV follows Xero’s chart-of-accounts import layout and puts the real New Zealand rate name in the Tax Code column, so the accounts land already coded.

The account GST code is a starting point, not a rule

Worth understanding before you rely on it: in Xero the rate applied to a transaction line follows a priority order. The contact’s default comes first, then the inventory item’s, then the account’s default, and you can override any line yourself. So the code stored on an account is the lowest-priority fallback that prefills the line. That is exactly the behaviour you want, a sensible default that is right most of the time and quick to change for the odd transaction that differs. It is also why the reference CSV pairs a default with the other codes that account legitimately sees.

The New Zealand treatments that catch people out

GST here is a flat 15% with no reduced rate and no GST-free category for food, which removes a lot of the complexity other countries carry. The traps are elsewhere, and the chart encodes them:

  • 15% GST on Income on sales, 15% GST on Expenses on most purchases.
  • Insurance is standard-rated, not exempt. General business cover carries 15% GST that you claim back.
  • Domestic travel is standard-rated; only international travel is zero-rated. Flights within New Zealand, taxis and domestic accommodation all carry 15%.
  • Entertainment is coded to 15% GST on Expenses, with a note that it is only 50% deductible and the GST claim is limited to the deductible half through an annual adjustment.
  • No GST on wages, bank fees, residential rent and interest, which are either outside the scope of GST or exempt financial supplies.
  • Zero Rated flagged as the alternative on sales and on overseas software where no New Zealand GST is charged.

Why there is no Exempt rate

A standard New Zealand Xero file ships exactly five GST rates: 15% GST on Income, 15% GST on Expenses, Zero Rated, GST on Imports and No GST. There is no separate Exempt rate. Exempt supplies such as financial services and residential rent are therefore coded No GST, which keeps them off the return. The reference CSV uses that convention throughout.

What the import leaves out

The import excludes the system control accounts (accounts receivable, accounts payable, the GST account and retained earnings) because Xero creates them automatically. The readable CSV still lists them and marks them as system accounts so nothing looks missing.

Putting it to work

  1. Open the CSV and adapt account names to the business, keeping the GST defaults.
  2. In Xero go to Accounting, then Chart of accounts, then Import, and upload the file into a demo organisation first.
  3. Confirm the five default rates exist in your organisation before importing for real.
  4. Use the other-codes column to brief whoever codes transactions on the legitimate alternatives per account.

Keeping every transaction coded correctly afterwards is the recurring work, and where most GST-return errors start:

  • Hubdoc remembers the coding for recurring suppliers.
  • ExpenseFlow reads each receipt and bill, applies the right New Zealand GST code for the supply including the imports and exempt cases, and posts it into Xero against the correct account, so the chart you imported stays clean as volume grows.
  • Dext applies supplier rules so repeat costs land in the same place each time.

The chart uses range-based numbering, assets in the 1000s, liabilities 2000s, equity 3000s, revenue 4000s, cost of sales 5000s and overheads 6000s, with gaps so a new account always has a free number in the right band.

On QuickBooks instead? See the NZ chart of accounts for QuickBooks. For the rates themselves, see the NZ GST codes in Xero reference.

Questions, answered

Common questions

Does the Xero import set the GST code on each account?

Yes. The import CSV uses Xero's Tax Code column with the real New Zealand rate names (15% GST on Expenses, 15% GST on Income, Zero Rated and No GST), so each account arrives with its default rate already set. You confirm the rates exist in your organisation as you import.

Why is insurance coded with GST when in some countries it is exempt?

In New Zealand general business insurance is a taxable supply at 15%, and the GST is claimable. That is different from the UK, where insurance is exempt and carries insurance premium tax instead. Only life insurance is treated as an exempt financial service here, so the chart codes ordinary business insurance to 15% GST on Expenses.

There is no Exempt rate in the file. Is that a mistake?

No. A standard New Zealand Xero organisation ships five GST rates and none of them is called Exempt. Exempt supplies such as bank fees and residential rent are coded No GST, which keeps them out of the GST return. If you prefer a dedicated Exempt rate you can add one, but it is not a Xero default here.

Which accounts are left out of the import?

The system control accounts: accounts receivable, accounts payable, the GST account, and retained earnings. Xero creates these automatically, so importing your own would duplicate them. The readable CSV still lists them, marked as system accounts.

Keep exploring

Stop filling in spreadsheets by hand

A template is a starting point. ExpenseFlow captures receipts, reads the tax automatically, and posts the cleaned record to Xero or QuickBooks Online, so the log keeps itself.

Start free trial