Connecting UpSheets and Xero

How to connect UpSheets to a Xero organisation so you can validate and upload data.

Create a Mapping for Employee, Type or Tracking Code

How to create, edit, exclude, and delete mappings for payroll and projects, and download all mappings.

How do Earnings Rates / Types / Pay Items work in UpSheets?

How UpSheets uses Xero Pay Items and the Type field when uploading, and options for specifying earnings rates.

Smart Formulas

How to use Smart Formulas to calculate earnings rates from dates and times worked (overtime, penalties, public holidays, breaks).

Adding or Removing Users from Your Xero Organisation

Manage user access to your connected Xero organisation in UpSheets.

Uploading Allowances to Payslips

How to upload allowance pay items to Xero payslips in UpSheets, including fixed amount, rate per unit, and multiple allowances.