Search

Generic NZ employee Payroll Importer

 

During your account set up process you may have either manually added each employee record to your account or imported all your employee records at once using our 'Employee Record Importer' which includes the employee’s personal and employment information. As an additional layer to your current employee data, Account Admins can opt in to display the employee payroll tab via user access role Payroll Tab to capture and display Payroll details, Bank, Tax and Kiwisaver details.  

This article provides you with step-by-step instructions on where to go and how to complete our Payroll Importer by using an excel template. 

Account Admins can access this new template under the 'Actions' dropdown and in 'Integrations & Importer' section.

 

Import-1.png

 

Click on the option for 'Import Information from an Excel spreadsheet in enableHR's standard format:'

 

Import-2.png

Click on the 'Import Employee Payroll data' option to navigate to the page for downloading the excel template.

 

Import-3.png

You can find a copy of the example spreadsheet intended to be used with the importer on this import page:

 

 

For this option, you need to ensure your spreadsheet has the appropriate named columns in the correct order and that employees are assigned an Internal ID number. To assist you with this, there is a sample spreadsheet available for download.

 

IMPORT RULES

  1. Columns must be in the correct order (Same as the example template)
  2. Do not delete columns. Columns can be left blank unless they are mandatory
  3. The system requires Row 1 & 2 to be a header row . 
  4. Column A is mandatory and must contain a unique Internal ID. This field cannot be blank. If you do not know how to get unique Internal ID, please run the Record export CSV for employee records.
  5. First name and Last names in Column B&C are for reference only and their data is not uploaded into the system.
  6. Payroll Details - Pay Rate (Column E) should have a corresponding Pay Rate (Column F) with a value as either HOURLY or ANNUAL.
  7. Payroll Details - Pay Schedule can have allowed Values: WEEKLY, FORTNIGHTLY, MONTHLY, TWICE_MONTHLY
  8. Bank Details - Only one bank account is allowed through import for an employee and all fields are mandatory if included.   
      • The format of the bank account details includes the BSB and the Suffix - xx-xxxx-xxxxxxx-xxx
  9. Kiwisaver details for an employee.
    • Status - ACTIVE , OPT_OUT, SAVINGS_SUSPENSION, NOT A MEMBER
    • 'Employer Contribution %', 'Employee Contribution %' and 'ESCT %' when Kiwisaver status is 'ACTIVE'.   The value entered should be without % sign.
      • ESCT% - the following are valid % - 10.5, 17.5, 30, 33.   Enter these in the spreadsheet without %
    • 'Opt Out Date' , 'Bank Account Number' and 'Bank Account Name' when Kiwisaver status is 'OPT_OUT'.
    • 'Suspension End Date' when Kiwisaver status is 'SAVINGS_SUSPENSION'
  10. Tax Details - You can add the below for employee tax details.

    • IRD Number

    • Valid tax codes - CAE, M, M SL, ME, ME SL,ND, NSW, S, S SL, SA, SA SL, SB, SB SL, SH, SH SL, ST, ST SL,STC, WT

    • Student Loan %
  11. The Import file must contain only one worksheet (Tab)

Import-5.png

 

It is important that the payroll person or your implementation team member follows these instructions exactly otherwise you will have issues when trying to import.