Skip to main content

​
Payslips

(Download Sample)
You may use a single full_name column instead of first_name and last_name.
Payslip rows do not need a date. They upload to the draft pay run in Xero. If UpSheets shows the wrong week, see Wrong Pay Period.
You may optionally provide a Start Time and End Time column instead of a single Hours column where hours are required.
If your file has one column per pay item instead of a single Type column, use Multiple Columns. For Australian organisations, this also supports saved defaults for deductions and leave accruals.

​
Calculation type, rate and hours for payslip types

The field values required in an upload file depend on the type of pay item being uploaded as described in the table below. All pay item types use the same file format and ALL fields must be included in the file, even if left blank. This enables you to upload multiple pay item types in a single file and process them at once. For example, the Hours column is required even when uploading a deduction or reimbursement but the value should be left blank as per the table below. Likewise, Earnings still require the Calculation Type column, even though the value would be left blank.

​
Super contributions

  • The employee must have a super fund membership configured in Xero.
  • The file must have the contribution type code in the type column as shown in the table below.
  • Include an optional date column in your file for super lines only, as the expected payment date (PaymentDateForThisPeriod).
  • For voluntary superannuation, the contribution amount can be a fixed rate or a percentage of earnings. For SGC contributions it must be a percentage.