Skip to main content

​
How payslips work in UpSheets

United Kingdom (UK) organisations: If you cannot see an option to import payslips, this is expected. Xero’s UK payroll API does not allow third-party apps to create, upload, or edit payslips. UpSheets cannot offer UK payslip imports, and no other app can offer them either. Skip the workflow below for payslip files and see NZ and UK Payroll File Formats for what is supported in your region.
Payslip CSV import is available for Australia and New Zealand Xero Payroll organisations only. Where your region supports it, UpSheets helps you import and upload payslip data to Xero Payroll. This includes earnings, deductions, reimbursements, superannuation (where applicable), and leave accruals, depending on your country and Xero setup. UpSheets uploads payslip data to the relevant draft pay run in Xero. In Xero’s payroll workflow, payslips are tied to pay runs, and employees can view payslips online in supported payroll regions. UpSheets fits into that process by validating your payslip data before it is uploaded to Xero.
For Xero’s broader payroll workflow and payslip features, see Xero Payroll features and Xero payroll software overview.

​
What you can control

  • Pay run targeting: Upload to the available draft pay run, or create an unscheduled pay run in Xero first. Payslip rows do not use a date to choose the week — if UpSheets shows the wrong period, the draft pay run in Xero is for the wrong week. See Wrong Pay Period.
  • Duplicate handling: Upload duplicate payslip rows as separate lines or sum duplicate totals.
  • Overwrite behaviour: Overwrite all existing payslip entries in a category, or only overwrite the specific types you upload.
  • Allowances and rates: Upload allowances and choose when rates come from the file or from Xero.

​
Typical workflow

1

Prepare the payslip data

Use the correct country-specific file format and make sure any relevant pay run already exists in Xero.
2

Import and validate

Import the file, map the required fields, and validate the data against employees, pay items, and available pay runs in Xero.
3

Review warnings or errors

Resolve duplicate, rate, pay run, and overwrite-related issues before upload.
4

Upload to Xero

Upload the validated payslip data to the matching draft pay run in Xero.

​
Common tasks

​
Country-specific file formats

Payslip CSV guides are organised under File formats in the help site. Use the section for your payroll region—do not use another country’s payslip format.
  • Australia: Payroll Australia → Payslips.
  • New Zealand: Payroll NZ and UK → Payslips (New Zealand only).
  • United Kingdom: Payslip file upload is not available because Xero does not allow any app to upload or edit UK payslips. For supported UK payroll imports, see NZ and UK Payroll File Formats.

Duplicates

Choose how duplicate payslip lines are handled.

Overwriting Existing Payslips

Control whether UpSheets overwrites all existing entries or only the types you upload.

Uploading Allowances

Upload allowance lines to payslips in Xero.

Unscheduled Pay Runs

Create and use an unscheduled pay run in Xero before validating your file.

Wrong Pay Period

Why UpSheets shows a different week, and how to point payslips at the correct draft pay run.