Skip to main content

​
Start here

UpSheets helps you move payroll and project data to Xero from files or connected systems. It’s fast, error free and easy to use.

Quickstart

Upload your first file or integration data and get to a successful import quickly.

Connect UpSheets to Xero

Connect your Xero organisation so UpSheets can validate and upload data.

Import files

Use CSV, Excel or Google Sheets files as your data source.

Import from integrations

Bring in timesheet and project data directly from supported apps.

​
What UpSheets helps you do

UpSheets sits between your source data and Xero.
  • Import data from CSV, Excel, Google Sheets or supported integrations.
  • Validate before upload using employees, earnings rates, tracking options and other data already in Xero.
  • Upload payroll data such as timesheets, leave and payslips.
  • Upload project data such as project tasks and project time.
  • Reduce manual work by reusing mappings, file formats and Smart Formulas.

​
What you can upload

​
Payroll

UpSheets supports:
  • Timesheets
  • Leave
  • Payslips including earnings, reimbursements, deductions, super and leave accruals
See transaction types for the country-specific list.

​
Projects

UpSheets also supports:
  • Project tasks
  • Project time
See project file formats for the supported layout.

​
Typical workflow

1

Connect to Xero

Connect your organisation so UpSheets can read the data it needs for validation.See Connecting to Xero.
2

Choose a data source

Import from a file or use a direct integration, depending on where your timesheet or project data starts.See File Types or Integrations overview.
3

Check your file format and options

Make sure your columns and transaction type match the kind of upload you want to do.See the file format guides and transaction types.
4

Map and validate your data

Review employee mappings, pay item mappings and any validation messages before upload.See Mappings and Timesheet Validation.
5

Upload to Xero

Once the import is valid, upload the data to Xero and then complete any follow-up steps there if needed.

​
Choose your next guide

Quickstart

Follow the shortest path to your first successful upload.

How UpSheets works with Xero

See the process flow and data flow between UpSheets and Xero.

File formats

Pick the right template and structure for your country and upload type.

Smart Formulas

Automate earnings rate calculations from dates, times and rules.
If you are new to UpSheets, start with the Quickstart page, then use the linked guides for the exact import type you need.