Current New Zealand Employee Tax Codes

Activate User's Guide

Version
2025.2
Current New Zealand Employee Tax Codes

Use the Current New Zealand Employee Tax Codes wizard to use Activate to import employee tax information for New Zealand. With this wizard, you can use a simpler template than the standard HR Import template.

Note: This wizard shows in the Load Your Data section only if there’s at least one New Zealand pay group.

Note: Activate uses HR Version 2.0 (NextGen) when loading data during configuration. To streamline the import, First Name and Last Name are excluded when not required.

Prerequisites

None.

Using this wizard

You’ll do the following in the Current New Zealand Employee Tax Codes wizard:

Complete and upload the Tax Info Data NZL template

Use the Tax Info Data NZL template to upload employee tax information for New Zealand.

Review the data

Use the NZL Tax Review page to review the data and make that it’s correct. If any errors show on this page, you must correct them to continue. You can correct the data in the grid or update the template file and upload it again.

Data on the page

Data on this page includes:

  • Employee Identifier
  • First Name
  • Last Name
  • Effective Start Date
  • Tax Code
  • STC/WT Tax Rate
  • URT Special Deduction Rate
  • Commissioner Deduction Balance
  • Commissioner Deduction Rate
  • Voluntary SL Amount
  • Voluntary SL Percent
  • SDR Special Rate
  • Include Threshold for SDR Special Rate

Install the information in Dayforce

When the New Zealand employee tax code information is complete in Activate, you must install it in Dayforce.

Messages: Error, Warning, and Information

Activate sorts each generated message by severity:

Error codes

Actively incompatible with the data in Dayforce. If you have a data error, you must resolve the error before you can complete the installation.

Warning codes

Indicate nonstandard setup that could potentially cause an error in Dayforce. For example, if an earning code is defined as Hours x Rate and the data is amount only, the system creates a warning. However, you can still import the data into the system.

Informational codes

A notable occurrence of data in the system. For example, an informational note shows if codes are dropped from the YTD import.

Tasks

To complete and upload the Tax Info Data NZL template:

  1. In Activate Central, click Load Your Data. The Load Your Data wizards show.
  2. Click Current New Zealand Employee Tax Codes.
  3. On the NZL Tax Data page, click Download.

    Note: You can also download an empty Current New Zealand Employee Tax Codes template from the Download Template Files page.

  4. Select the location where you want to save the template document.
  5. Open the TaxInfoDataTemplateNZL.xlsx template on your computer.

    Note: The Activate release version shows in cell B3 on the Instructions tab of the template. With this information, you can determine the version of Activate that you were using when you downloaded the template.

  6. On the TaxInfoDataNZL tab, complete all columns with the data for all employees in the organization.

    Note: Instructions for populating the fields are in the Tax Info Data Template Fields section (below) and on the Instructions tab of the template.

  7. Click Save and close the template.

    You can use any file name for the template you upload. The file must be an Excel or CSV (Comma-Separated Value) document and contain the data in the required format.

    Important: The uploaded template must be the current Excel template file downloaded from Activate. Old templates aren’t accepted.

    Important: Don’t change the name of the tab in the template. Activate uses the tab name to validate that the correct template is being uploaded. Also, don’t change the column headings.

  8. On the NZL Tax Data page, click Upload.

    Activate validates that the data is in the list of accepted values for New Zealand.

  9. Go to the completed template in the location where you saved it.
  10. Click Open. The Current New Zealand Employee Tax Codes wizard validates the uploaded file.

    Note: When you upload an Excel file, Activate includes the name of the uploaded file into the name of the XML file it generates and loads to the Dayforce File Server. The format of the generated XML file name is <NamespaceName>_<Import Type>_<file name provided>_YYY-MM-DD_HHMM. This information makes it easier to audit files later.

    Note: If the uploaded file has errors, a Validation Failed message shows in red at the bottom of the page. You must correct the errors in the file on your computer and upload the file again.

  11. Click Next.

To review and confirm the data:

  1. Review the information shown in the grid.

    Important: If the Error/Warning/Message panel shows any errors, you must resolve them to continue.

    Activate validates that the data provided in the optional fields aligns with what Dayforce accepts based on the Tax Code value.

  2. On the TaxInfoDataNZL tab, complete all columns with the data for all employees in the organization.

    Note: Instructions for populating the fields are in the Tax Info Data Template Fields section (below) and on the Instructions tab of the template.

  3. To make updates to data on the page:
    • To insert a new row in the grid, click the row where you want to insert it and click New.

    • To delete a row, click the row and click Delete.

    • To download the error message list and save it to your computer, click Download Errors File.
    • To correct errors in the grid, click in the field containing the error. Click Tab to move to the right and Shift+Tab to move to the left in the row. Use the scrollbars on the right side and bottom of the grid to go to other areas of the grid.
    • To save information in the grid to your computer, click Download File and save it to the location you want.

    • To upload the file from your computer, locate the file and click Upload File. The data in the file shows in the grid.

    • To remove changes that you don’t want to save, click Refresh.

  4. When the data is complete, click Done & Install. When you leave the page, the selected values stay in the grid.

To install the information in Dayforce:

When the data is correct in Activate, you must install it in Dayforce.

  1. Click Done & Install. A message shows stating that you’re going to install the new data.
  2. Click one of the following:
    • Cancel to return to the previous page.
    • OK to continue.

    Important: If someone is signed directly in to Dayforce and potentially applying manual configuration, Activate shows a warning at Done & Install. Don’t continue with the Activate installation if users are actively applying configuration changes. Users’ changes might be lost if a failure occurs during the Activate installation. Download the User Report and follow up with the team members before you continue with the Activate wizard.

    The Load page opens with a list of the steps to be completed and an estimate of how long the installation should take to complete. The list indicates the scenario being executed–whether Activate is doing a reconfigure only, a reconfigure that includes new levels, or it’s adding new groups. The estimated installation time reflects the respective scenario being installed.

    During the installation, the current step in the process shows in bold text so you can monitor the progress.

  3. Click one of the following:
    • Add Email and enter your email address to be notified when the installation process ends instead of waiting for it to finish.
    • Next when the installation is complete.

    Activate Central opens with the wizard name now in green text and a green checkmark next to it. The day, date, and time of completion show, along with your name as the user who completed the wizard. The environment in which the installation was applied (Stage, Config, or Train) is also shown.

    Note: If you want to add more information, click I want to add more. See Executing a Rollback When Using the “Add More“ Feature in the Payroll Wizards.

Results

Fields populated in Dayforce

The data uploaded from the Tax Info Data NZL template populates the fields on the following pages in Dayforce.

Note: You must select an employee if you haven’t done so already.

Dayforce fields populated by the Tax Info Data NZL template
Field in Template Field in Dayforce Page in Dayforce
Employee Identifier Employee Reference / Number Employee (People icon)

 

 

First Name First Name
Last Name Last Name
Effective Start Date Effective Start

Tax Definitions page for a New Zealand employee
(People icon > Payroll > Tax Definitions)


 

 

 

Tax Code Tax Code
STC/WT Tax Rate STC/WT Tax Rate
URT Special Deduction Rate URT Special Deduction Rate
Commissioner Deduction Balance Commissioner Deduction Balance

Commissioner Deduction Rate

Commissioner Deduction Rate

Voluntary SL Amount

Voluntary SL Amount

Voluntary SL Percent

Voluntary SL Percent

SDR Special Rate

SDR Special Rate

Include Threshold for SDR Special Rate

Include Threshold for SDR Special Rate

ESCT Rate

ESCT Rate

ESCT Effective Start Date

ESCT Effective Start Date

ESCT Effective End Date

ESCT Effective End Date

File generated by the current New Zealand Employee Tax Codes wizard

After completing the Current New Zealand Employee Tax Codes wizard, a single import file is automatically generated and placed on the customer's FTP site.

Benefit Elections Import

  • FTP Subdirectory: EmployeeImport
  • Filename: <Namespace> -EmployeeImport-DepBenElect-<DateTime>.xml

Example illustrating how translates the template data to XML:

Copy
<?xml version="1.0" encoding="UTF-8"?>
-<EmployeeImport>
    -<Employee>
        <XRefCode>0002</XRefCode>
        <EmployeeNumber>0002</EmployeeNumber>
        <FirstName>Raffarty</FirstName>
        <LastName>Coenraets</LastName>
        -<NZLTax>
        <EffectiveStart>2020-04-01</EffectiveStart>
        <EmployeeTaxCode>M</EmployeeTaxCode>
        </NZLTax>
    </Employee>
    -<Employee>
        <XRefCode>0003</XRefCode>
        <EmployeeNumber>0003</EmployeeNumber>
        <FirstName>Rhea</FirstName>
        <LastName>Tarbin</LastName>
        -<NZLTax>
            <EffectiveStart>2021-04-01</EffectiveStart>
            <EmployeeTaxCode>SB SL</EmployeeTaxCode>
            <URTSpecialDeductionRate>10</URTSpecialDeductionRate>
            <CommissionerDeductionBalance>300</CommissionerDeductionBalance>
            <CommissionerDeductionRate>3</CommissionerDeductionRate>
            <VoluntaryDeductionAmount>1.33</VoluntaryDeductionAmount>
            <VoluntaryDeductionAmountType>Percent</VoluntaryDeductionAmountType>
            <SpecialTaxStudentLoanRate>10</SpecialTaxStudentLoanRate>
            <SpecialTaxRateIncludeThreshold>0</SpecialTaxRateIncludeThreshold>
        </NZLTax>
    </Employee>
    -<Employee>
        <XRefCode>0011</XRefCode>
        <EmployeeNumber>0011</EmployeeNumber>
        <FirstName>Freddie</FirstName>
        <LastName>Grellis</LastName>
        -<NZLTax>
            <EffectiveStart>2021-04-01</EffectiveStart>
            <EmployeeTaxCode>S</EmployeeTaxCode>
            </NZLTax>
    </Employee>
    -<Employee>
        <XRefCode>0013</XRefCode>
        <EmployeeNumber>0013</EmployeeNumber>
        <FirstName>Dolores</FirstName>
        <LastName>Creech</LastName>
        -<NZLTax>
            <EffectiveStart>2018-11-23</EffectiveStart>
            <EmployeeTaxCode>STC</EmployeeTaxCode>
            <SpecialTaxStudentLoanRate>5</SpecialTaxStudentLoanRate>
            <SpecialTaxRateIncludeThreshold>1</SpecialTaxRateIncludeThreshold>
            <SpecialSchedularTaxCodeRate>7.5</SpecialSchedularTaxCodeRate>
        </NZLTax>
    </Employee>
</EmployeeImport>

Tax Info Data template fields

All templates have the same basic structure:

  • Instructions tab: Helps you understand the purpose of the data and complete the fields in the template.
  • Data tab: Contains headers for the data to be included in the template. The headers remain the same, but you can change the column order. If you add more columns, Activate ignores them.

All number ranges in the templates include the numbers at both ends of the range.

Employee Identifier (Required)

Field information for the Employee Identifier field
Order Data Type Description Examples Why This Is Needed
1 Alphanumeric. Unique value between 1-40 characters.

For Canadian pay groups, a unique value between 1-9 characters.

It allows our system to identify employees uniquely. Use the same number assigned to the employee in the Getting Started HR data loads. 3241245
000000006
abc123499

In the context of this import, the Employee Identifier, First Name, and Last Name help users identify employees when completing the template.

This required field validates that the data being loaded is assigned to the correct employee record. The values provided must match exactly to an existing employee record in Dayforce.

First Name (Required)

Field information for the First Name field
  Data Type Description Examples Why This Is Needed
2 String1 between 1-64 characters.

Legal first name of the employee.

Note: Activate‘ compares the First Name and the Last Name with the Employee Identifier in Dayforce. If they don’t match, Activate shows an error message that states that the data is being loaded incorrectly and to check the source data.

Joe

In the context of this import, the Employee Identifier, First Name, and Last Name help users identify employees when completing the template.

This required field validates that the data being loaded is assigned to the correct employee record. The values provided must match exactly to an existing employee record in Dayforce.

1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &

Last Name (Required)

Field information for the Last Name field
Order Data Type Description Examples Why This Is Needed
3 String1 between 1-64 characters.

Legal last name of the employee.

Note: Activate‘ compares the First Name and the Last Name with the Employee Identifier in Dayforce. If they don’t match, Activate shows an error message that states that the data is being loaded incorrectly and to check the source data.

Smith

In the context of this import, the Employee Identifier, First Name, and Last Namehelp users identify employees when completing the template.

This required field validates that the data being loaded is assigned to the correct employee record. The values provided must match exactly to an existing employee record in Dayforce.

1 Special characters accepted within the string include: alphanumeric, space, period, apostrophe, dash, number symbol #, comma, underscore, forward slash /, parentheses (), &

Effective Start Date (Required)

Field information for the Effective Start Date field
Order Data Type Description Examples Why This Is Needed
4 Date. Excel right-justified date format or Excel text format yyyy-mm-dd. Start date for the tax record.

Date formatted cells:
09/24/2015
24/09/2015

Text formatted cells:
2015-09-24

This date identifies when this tax declaration begins.

Tax Code (Required)

Field information for the Tax Code field
Order Data Type Description Examples Why This Is Needed
5 Accepted Values:
Any of the tax codes listed on the IR330 form ND.
Specify the Employee Tax Code. Use ND if no IRD number or tax code was applied. Refer to the IRD website for the official list of tax codes: https://www.ird.govt.nz/income-tax/income-tax-for-individuals/tax-codes-and-tax-rates-for-individuals/tax-codes-for-individuals M
ME SL
CAE
STC
ND
Required to determine the correct tax amounts.

STC/WT Tax Rate

Field information for the STC/WT Tax Rate field
Order Data Type Description Examples Why This Is Needed
6 Numeric 0 to 100. Provide the special tax rate if the Employee Tax Code is STC or WT. 13.4
25
Required to determine the correct tax amounts.

URT Special Deduction Rate

Field information for the URT Special Deduction Rate field
Order Data Type Description Examples Why This Is Needed
7 Numeric 0 to 11. Employees who earn less than the Student Loan repayment threshold from their main job can apply to IR to allocate the unused repayment threshold (URT) towards a secondary job and pay a reduced rate. In this case, provide the special deduction rate. 7.5
9
Required to determine the correct Student Loan repayment.

Commissioner Deduction Balance

Field information for the Commissioner Deduction Balance field
Order Data Type Description Examples Why This Is Needed
8 Numeric 0 to 99999999.99. IR might require additional student loan deductions to be made using SLCIR or “Commissioner Deduction.“ Enter the total amount to recover, as specified in the IR notice. 500
650
Required to determine the correct Student Loan repayment

Commissioner Deduction Rate

Field information for the Commission Deduction Rate field
Order Data Type Description Examples Why This Is Needed
9 Numeric 0 to 5. Enter the percentage rate to use for the SLCIR Commissioner deduction, as specified in the IR notice. 3 Required to determine the correct Student Loan repayment.

Voluntary SL Amount

Field information for the Voluntary SL Amount field
Order Data Type Description Examples Why This Is Needed
10 Numeric 0 to 99999999.99. Specify the fixed amount selected by employees who want to pay more towards their student loan as an SLBOR deduction. Employees can’t select both Voluntary Amount and Voluntary Percent at the same time. 100
45
Required to determine the correct Student Loan repayment.

Voluntary SL Percent

Field information for the Voluntary SL Percent field
Order Data Type Description Examples Why This Is Needed
11 Numeric 0 to 100. Specify the percentage rate selected by employees who want to pay more towards their student loan as an SLBOR deduction. Employees can’t select both Voluntary Amount and Voluntary Percent at the same time. 6 Required to determine the correct Student Loan repayment.

SFR Special Rate

Field information for the SFR Special Rate field
Order Data Type Description Examples Why This Is Needed
12 Numeric 0 to 12. For employees with a special deduction rate (SDR) certificate from IR, provide the student loan percentage rate from the certificate. 6 Required to determine the correct Student Loan repayment.

Include Threshold for SDR Special Rate

Field information for the Include Threshold for SFR Special Rate field
Order Data Type Description Examples Why This Is Needed
13 Accepted Values:
YES
NO
Indicate whether the special tax rate from the SDR certificate includes a threshold limit. YES
NO
Required to determine the correct Student Loan repayment.

ESCT Rate (Not Required)

Field information for the ESCT Rate field
Order Data Type Description Examples Why This Is Needed
14 Accepted Values:
10.5
17.5
30.0
33.0
39.0
System Calculated.
Required to determine the Employer Superannuation Contribution Tax rate. 10.5
17.5
30.0
33.0
39.0
System Calculated

Required to determine the Employer Superannuation Contribution Tax rate. Where not provided, this field defaults to System Calculated.

ESCT Effective Start Date (Not Required)

Field information for the ESCT Effective Start Date field
Order Data Type Description Examples Why This Is Needed
15 Date. Excel right-justified date format or Excel text format yyyy-mm-dd. The start of the financial year that the ESCT rate applies to.

Date formatted cells: 09/24/2015
24/09/2015

Text formatted cells:
2015-09-24

This date identifies when this ESCT declaration start.

ESCT Effective End Date (Not Required)

Field information for the ESCTEffective End Date field
Order Data Type Description Examples Why This Is Needed
14 Date. Excel right-justified date format or Excel text format yyyy-mm-dd. The end of the financial year that the ESCT rate applies to.

Date formatted cells:
09/24/2015
24/09/2015

Text formatted cells:
2015-09-24

This date is used to identify when this ESCT declaration end.