Prepare to export into XERO

Prepare to export into XERO


Overview

If you are using Xero for your payroll, timesheets can be transferred from ClickTime to Xero via API to process payroll.

Why does this integration exist?

Well although Xero does have basic timesheet functionality - what it lacks is two things:
1. You can only enter hours durations into Xero Payroll
2. You have to perform the calculations manually (e.g. breakdown of regular hours versus overtime hours).

The ClickTime Xero integration allows you to record start and end times that employees clock in/out with and then calculate how much regular/overtime to send across to Xero


Note: The Xero integration is only available for Australian customers. It is not available for New Zealand, UK, or US customers at this stage.
Before, you go any further, please ensure that you have access to your Xero Payroll module and have your credentials ready because they will be required in the steps below

Ensuring Accurate Employee Details for Seamless Timesheet Exports to Xero
Before proceeding with your timesheet export to Xero, please verify that the first name, last name, and email address of your employees in ClickTime exactly match the corresponding details in Xero. This alignment is crucial to ensure successful timesheet transmission. Any discrepancies may result in an 'Employee Not Found' error.


1. Setup and configure XERO

If this is the  first time you're using Xero for payroll  and you haven't already used Xero to run
payroll, you should first check the following settings in Xero: Configuring XERO

2. Make sure employee names and email match exactly in Xero and ClickTime. 

3. For users without Advanced Payroll subscription

     Go the this help article exact details on how to setup timesheet sync with Xero
     Users with Advanced Payroll subscription can continue with the steps below
  
4. Create Pay Cycle(s) in ClickTime
    Note:
    Depending on your subscription with Clicktime, your organization might not have access to
    pay cycles. Creating pay cycles are not mandatory and you still can export your timesheet to
    XERO without having a pay cycle. 
    
     To create a pay cycle, go to Setting > Payroll setting > Pay Cycle
  1.  Add and create your company  Pay Cycles 
  2.  Make sure the Pay Cycles period created & defined in ClickTime, match the Pay Calender period in XERO
  3. Click Here for more details about the pay cycles in ClickTime

5. Assign each employee in ClickTime to a pay cycle

    If you have created a pay cycle in the previous step, you will need to assign your employees
    to the proper pay cycle, otherwise, if your organization subscription does not have access to
    pay cycles, then you can skip this step. 

6. Create Pay Categories / Export Code in ClickTime

      Go to Setting > Payroll Setting > Pay Categories/ Export Codes
      Create and add your Pay Categories and try to make the pay categories as descriptive as much
      as possible. 
      Remember that the pay categories that you create should exactly match the pay  items and
      earning rate item in XERO
       An example of pay categories might look like this 
  • Ordinary Hours
  • Day Rates
  • Night Rates
  • Saturday Rate
  • Sunday Rate
  • Public Holiday Rate
  • Overtime 1.5

7. Pay Template

      Create a pay template that can be applied to your employees

8. Ensure the leave codes in ClickTime match Xero leave 

  1.     Ensure all leave codes in ClickTime match those in Xero.
  2. Verify that each employee in Xero has the correct leave categories assigned.
  3. Double-check the alignment of leave codes between both systems before exporting.
  4. Proceed with exporting the timesheets from ClickTime to Xero.
9. Approve timesheet and export to XERO


If you have any errors while exporting please:

      

    • Related Articles

    • Troubleshooting Xero Export

      Validation Exception Error Possible Reasons Leave names do not match between ClickTime and Xero Hire date is after the start of the pay period Solutions Check leave items in the timesheets, and use this to match the leave name in Xero - they must ...

    • Setting Up Xero Timesheet Sync for Non-Premium Plans

      Before You Begin: Timesheet must be approved. To export timesheets from ClickTime, they must be approved. ClickTime will only export timesheet records that have been approved. On the list of employees to be exported, only those with approved ...

    • Configuring XERO

      For comprehensive instructions on the configuration in Xero to run payroll please see the details provided by Xero Support central.xero.com Xero payroll settings In Xero, go and select your company name in the main menu > Select the settings option. ...

    • Pay Categories & Export Codes Explained

      Pay Categories & Export Codes Pay categories & export codes are labels used to identify pay rate multipliers – they allow you to apply pay rate multipliers to users' time. They are used in overtime rules and pay rules and payroll calculations, and ...

    • Manage blocked pop-ups on your browser

      Depending on your current browser, some customers will face the issue that ClickTime Web application is not able to download and save their timesheet export file and some other customers might not be able to connect to XERO for the first time because ...