...
- Do not remove, rename, add or re-order any columns in the import file.
- Ensure you do not include any commas in the text of the file (e.g. in the address or salary fields) as this will cause the import to fail.
- For some columns only select values will be accepted. A list of these columns and possible values is below.
- For Cost Structure, Division, Cost Centre and Department must be filled out. Sub-department onwards can be left empty if required (levels 5, 6, 7 and 8).
- ESCT rate must be entered in decimal form (e.g. 0.03 for 3%)
The template can be downloaded from the Bulk Import tool as shown in the below screenshot.
| Import Field | Possible Values |
|---|---|
| Region | Auckland | Canterbury | Canterbury South | Chatham Islands | Hawke's Bay | Marlborough Nelson | Otago | Southland | Taranaki | Wellington | Westland |
| Pay Rate Option | FTE | Annual Salary | Basic Hourly Rate | Daily Rate |
Tenure | Apprentice Fulltime | Apprentice Part Time | Casual | Contractor Invoice | Fixed Term Fulltime | Part Time | Seasonal | Temporary Fulltime | Temporary Part Time | Working Proprietor |
| Pay Setup | Auto Paid | Timesheet |
| KiwiSaver | Existing Member | Exempt |
...
Leave the Source Type as Default, and select your import file to be uploaded.
View file
