Import timesheets into Xero

Overview

In Xero you can use timesheets to track hours worked by employees that can be used to determine payroll. With Zed Axis you can import timesheets in batch into Xero.

Items to consider before import timesheets into Xero

You can only add time to timesheets in Xero that are not already Processed ie Status must be Draft, if you try to add time to timesheets that have already been Processed you will get an error message
You can import timesheets into the Xero Payroll version for Australia, New Zealand or United Kingdom.

More help?

Sample Timesheet Data

Steps to import timesheets into Xero

Follow these steps

Download and install Zed Axis on your computer
Open Zed Axis and then connect to Xero company file
Click on the Import tab and browse to the file that contains the time entries.
Set up a mapping between the columns in your file and the corresponding fields in Xero
Click Import and the timesheet data will be directly added to Xero

Where the fields appear in Xero

Detailed description of the fields

Xero	Format	Description
Employee Name	Str	MANDATORY FIELD - Employee name as it appears Xero
Date	Date	MANDATORY FIELD - The date of the time entry.
Status	Enum	Status code for the timesheet either DRAFT, PROCESSED or APPROVED
Total Hours	Time	The number of hours in the format hh:mm or decimal hours ie 3:45 would be three hours and fourty five minutes, as 3.75 is the decimal equivalent of 3 hours and fourty five
Employee Rate	Str	The Earnings rate for the employee, for example, Regular Pay or Overtime Pay
Tracking Item	Str	The tracking category to be allocated to the timesheet line

Article ID: 344, Created: 2/4/2021 at 6:18 AM, Modified: 5/30/2024 at 5:16 AM