Payroll (NZ & UK)
New Zealand Payslip File Format
Requirements for uploading payslip data (earnings, reimbursements, deductions, leave accruals) to Xero from CSV files in New Zealand. NZ only – not available in UK.
Documentation Index
Fetch the complete documentation index at: /docs/llms.txt
Use this file to discover all available pages before exploring further.
Requirements for uploading payslip data (earnings, reimbursements, deductions, leave accruals) to Xero from CSV files in New Zealand. NZ only – not available in UK.
| Heading | Description | Format | Notes |
|---|---|---|---|
| first_name | The first name of the employee. | Text | Required |
| last_name | The last name of the employee. | Text | Required |
| type | The Pay Item type. Must match the text of an active Pay Item defined in Xero. | Text | Required |
| rate | The amount or rate of the transaction. The calculation type determines how this is used. | Number (max 2DP) | Required – see below |
| hours | The number of hours to be adjusted. | Number (max 2DP) | Required – see below. You may optionally provide a Start Time and End Time column instead |
| description | A description of the reimbursement that will appear on the payslip. Used for reimbursements and Kiwisaver superannuation pay item lines only | Text | Optional. For Kiwisaver Superannuation set description to SUPER and complete fields as per a STAT_DEDUCTION |
| Pay Item Type | Rate | Hours |
|---|---|---|
| DEDUCTION | The total amount to be deducted in dollars. Value must be greater than 0 OR leave blank to use the amount defined on the pay item in Xero | Leave blank |
| REIMBURSEMENT | The total amount to be reimbursed in dollars | Leave blank |
| OR the rate per unit. Note – Xero only allows the upload of Reimbursements defined as Fixed Amount. If both Rate and Hours are provided, UpSheets will calculate the total and upload it as a fixed amount and add the Rate and Units as the description. You may need to define a new pay item as Fixed Amount in Xero to allow this. | The number of units | |
| EARNINGS | If the pay item in Xero is set as FIXED_AMOUNT: The total amount in dollars | Leave blank |
| If the pay item in Xero is NOT set as FIXED_AMOUNT: The rate per unit earnings. OR leave blank if a Rate Per Unit value is set in Xero. | The number of units worked | |
| LEAVE ACCRUAL | Leave blank | The number of hours to be accrued |
| STAT_DEDUCTION | The total amount in dollars | Leave blank |
| SUPER | The total amount in dollars | Leave blank. Set Description field to SUPER |
full_name column instead of first_name and last_name.