Australia Multi-Type Payroll File Format

Combine multiple payroll transaction types

UpSheets lets you upload multiple transaction types in a single file, so long as all required fields are included. For more information on individual file formats see Payroll. Note: All columns must be included in the file, even if their values are left blank. This keeps formats consistent and lets UpSheets determine the transaction type automatically.

In all of the examples below you may use a single FULL_NAME column instead of FIRST_NAME and LAST_NAME.

You may optionally provide a Start Time and End Time column instead of the Hours column.

Timesheet, Leave and Payslip file format

(Download Sample)

Heading	Description	Format	Notes
first_name	The first name of the employee.	Text	Required
last_name	The last name of the employee.	Text	Required
date	The date the employee worked or leave started.	Date	Required for timesheets and leave. Optional for payslips (required in file for super).
hours	The number of hours the employee worked, took as leave, or on the payslip.	Number (max 2DP)	Required for Timesheets, Leave and some payslips (depending on calculation_type below). You may optionally provide a Start Time and End Time column instead.
type	The Earnings Rate for the hours worked or Pay Item. Must match the text of the Earnings Rate/Pay Item in Xero.	Text	Required for Payslips. Optional for Timesheets, but if not in the file a default or the employee default must be selected at import.
tracking_code	The Tracking Code for the hours worked. Must match the text of the Tracking Code in Xero.	Text	Required on every line when tracking categories are enabled in Xero (Xero validation). If omitted, select a default at import. See Tracking Categories.
end_date	The date the leave ended.	Date	Required for Leave.
description	A description of the reimbursement that will appear on the payslip, or leave that will show on the request.	Text	Required for Reimbursements and Leave.
rate	The amount or rate of the transaction. The calculation type determines how this is used.	Text	Required for Payslips.
calculation_type	The method used to calculate the total amount of the transaction.	Text	Required for Payslips. See Payslips for more details.

Timesheet and Payslip file format

(Download Sample)

Heading	Description	Format	Notes
first_name	The first name of the employee.	Text	Required
last_name	The last name of the employee.	Text	Required
date	The date the employee worked.	Date	Required for timesheets. Optional for payslips (required in file for super).
hours	The number of hours the employee worked or on the payslip.	Number (max 2DP)	Required. You may optionally provide a Start Time and End Time column instead.
type	The Earnings Rate for the hours worked or Pay Item. Must match the text of the Earnings Rate/Pay Item in Xero.	Text	Required for Payslips. Optional for Timesheets, but if not in the file a default or the employee default must be selected at import.
tracking_code	The Tracking Code for the hours worked. Must match the text of the Tracking Code in Xero.	Text	Required on every line when tracking categories are enabled in Xero (Xero validation). If omitted, select a default at import. See Tracking Categories.
description	A description of the reimbursement that will appear on the payslip. Used for reimbursements only.	Text	Required for reimbursements only.
rate	The amount or rate of the transaction. The calculation type determines how this is used.	Text	Required for Payslips.
calculation_type	The method used to calculate the total amount of the transaction.	Text	Required for Payslips. See Payslips for more details.

Timesheet and Leave file format

(Download Sample)

Heading	Description	Format	Notes
first_name	The first name of the employee.	Text	Required
last_name	The last name of the employee.	Text	Required
date	The date the employee worked or leave started.	Date	Required
hours	The number of hours the employee worked or took as leave.	Number (max 2DP)	Required. You may optionally provide a Start Time and End Time column instead.
type	The Earnings Rate for the hours worked, or the type of leave taken. Must match the text of the Earnings Rate/Leave Type in Xero.	Text	Required for Leave. Optional for Timesheets, but if not in the file a default or the employee default must be selected at import.
tracking_code	The Tracking Code for the hours worked. Must match the text of the Tracking Code in Xero.	Text	Required on every line when tracking categories are enabled in Xero (Xero validation). If omitted, select a default at import. See Tracking Categories.
end_date	The date the leave ended.	Date	Required for Leave.
description	A description of the leave taken.	Text	Required for Leave.

Leave and Payslip file format

(Download Sample)

Heading	Description	Format	Notes
first_name	The first name of the employee.	Text	Required
last_name	The last name of the employee.	Text	Required
date	The date the leave started or the expected payment date for super lines.	Date	Required for leave and super payslips. Optional for other payslips.
hours	The number of hours the employee took as leave or on the payslip.	Number (max 2DP)	Required for Leave and some payslips (depending on calculation_type below).
type	The Leave Type or Pay Item. Must match the text of the Leave Type/Pay Item in Xero.	Text	Required
end_date	The date the leave ended.	Date	Required for Leave.
description	A description of the leave that will appear on the request.	Text	Required for Leave.
rate	The amount or rate of the transaction. The calculation type determines how this is used.	Text	Required for Payslips.
calculation_type	The method used to calculate the total amount of the transaction.	Text	Required for Payslips. See Payslips for more details.

Super contributions (payslips)

For super lines, use the Xero contribution type code in the type column. The employee must have a super fund membership configured in Xero. Include a date column in your file for super lines as the expected payment date.

Value	Description
SGC	Mandatory 9% contribution
SALARYSACRIFICE	Pre-tax reportable employer superannuation contribution, which is displayed separately on payment summaries
EMPLOYERADDITIONAL	Additional employer superannuation contribution, which is displayed as RESC on payment summaries
EMPLOYEE	Post-tax employee superannuation contribution

For voluntary superannuation, the contribution amount can be a fixed rate or a percentage of earnings. For SGC contributions it must be a percentage.

Getting Started

Connect

Importing

Integrations

File Formats

Mapping

Timesheets

Leave

Payslips

Smart Formulas

Employees

Account

Pricing

Troubleshooting

Australia Multi-Type Payroll File Format

Combine multiple payroll transaction types

Timesheet, Leave and Payslip file format

Timesheet and Payslip file format

Timesheet and Leave file format

Leave and Payslip file format

Super contributions (payslips)

​Combine multiple payroll transaction types

​Timesheet, Leave and Payslip file format

​Timesheet and Payslip file format

​Timesheet and Leave file format

​Leave and Payslip file format

​Super contributions (payslips)

Combine multiple payroll transaction types

Timesheet, Leave and Payslip file format

Timesheet and Payslip file format

Timesheet and Leave file format

Leave and Payslip file format

Super contributions (payslips)