New Zealand · Free chart of accounts template

NZ Construction Chart of Accounts for QuickBooks: Schedular Payments + Retentions

A free New Zealand construction chart of accounts for QuickBooks Online: schedular payment and retention accounts, with GST mapped to labour and materials.

By ExpenseFlow team
· 25 June 2026

Free download · no email required

CSV with schedular payment and retention accounts mapped to QuickBooks GST codes. Import and code list below.

Download chart of accounts (CSV)

Construction in New Zealand needs accounts a generic QuickBooks chart does not provide, and the reason is local: there is no construction reverse charge here. The tax that moves before profit is worked out is schedular payment withholding on labour-only contractors, plus retentions held back until completion. This is a New Zealand construction chart of accounts for QuickBooks Online, with those accounts built in and the GST mapping ready to apply. It comes as a readable reference CSV and a QuickBooks import CSV.

Two steps in QuickBooks, with one New Zealand catch

QuickBooks Online does not create New Zealand GST codes for you, and its chart-of-accounts import has no tax column, so the work is: turn on GST and create the rates, import the structure with the CSV, then assign the GST codes from the CSV mapping. For construction the mapping matters most on the cost accounts, where labour, materials and plant all sit at 15% GST on Expenses.

Schedular payments on both sides

Schedular withholding sends tax to Inland Revenue before anyone records a profit, so QuickBooks needs accounts for it in both directions:

  • Schedular payments deducted (an asset): tax that contractors withhold from your labour-only invoices, recoverable against income tax.
  • Schedular payments withheld (a liability): tax you withhold from subcontractors you pay, owed to Inland Revenue.

A labour-only contractor completes an IR330C and selects a withholding rate; the standard 20% applies if they do not. The accounts are where each side lands cleanly, separate from ordinary income and expenses.

Labour, materials and plant kept apart

The chart splits the generic subcontractor line into subcontractor labour, materials and plant and equipment hire. Schedular withholding applies to the labour element only, so labour must be separable from materials on every job. All three carry GST on Expenses at 15%, with materials showing Zero Rated as the alternative for exported goods.

Retentions and site costs

Two retention accounts, retentions receivable and retentions payable, track amounts held back pending sign-off so debtors and creditors are not overstated. The chart also adds small tools (items under NZ$1,000 can be written off immediately as low-value assets) and protective clothing and PPE, standard-rated and deductible. Progress claims and deposits taken before the work is finished are still taxable supplies, so account for the GST when each claim is invoiced rather than waiting for the job to complete.

How to use it

  1. Open the CSV: each account is mapped to its QuickBooks GST code, with alternatives and a note. The schedular and retention accounts are the construction additions.
  2. In QuickBooks Online go to Settings, then Import data, then Chart of Accounts, and upload the CSV for the structure.
  3. Turn on GST, create the New Zealand rates, then bulk-assign the codes from the CSV, applying GST on Expenses to labour, materials and plant.
  4. Keep labour and materials on separate lines on every subcontractor invoice so the withholding calculates against labour alone.

The recurring work is keeping each cost coded and split correctly:

  • Dext extracts the GST and supplier from photographed bills.
  • ExpenseFlow reads each receipt and bill, codes it to the right construction account at 15% GST, and posts it into QuickBooks Online, so labour, materials and plant land where job costing expects.
  • Hubdoc pulls recurring plant-hire and merchant bills into the file.

One point the chart supports but cannot enforce: hold each labour-only contractor’s IR330C and chosen rate before you pay, since that drives the withholding. The accounts give you the structure; the checks are a process step.

On Xero instead? See the NZ construction chart of accounts for Xero, where the import sets the GST codes directly. For the full picture of schedular payments, see the New Zealand construction expenses guide.

Questions, answered

Common questions

Does QuickBooks New Zealand preload construction GST codes?

No, and it does not preload any New Zealand GST codes. QuickBooks Online only auto-creates a default GST set for a fixed list of regions that does not include New Zealand, so you turn on GST and create GST on Expenses, GST on Income, Zero Rated and No GST yourself, then assign them to the construction accounts from the CSV.

How does construction tax work in New Zealand?

Through schedular payments, not a reverse charge. The payer of a labour-only contractor withholds tax at source; the contractor gives an IR330C and chooses a rate, with 20% applying if none is chosen. The chart adds asset and liability accounts to track tax withheld from you and tax you withhold from others.

Why does the import not set the GST codes?

QuickBooks Online's chart-of-accounts import has no tax column, so the CSV builds the structure and you set the GST codes afterwards. The mapping gives the code for each account, including GST on Expenses on labour, materials and plant.

Can I override a code on a transaction?

Yes. The account code is only a default that prefills the line. Override it where a job differs, such as Zero Rated on exported materials.

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