Importing Clockify Data to Xero

Overview

UpSheets allows you to import data directly from Clockify to Xero Payroll.

Enable the Clockify Integration

Before importing your Clockify data and uploading it to Xero, you must first enable the Clockify Integration.

Importing

Once enabled, the Import screen will have a new Data Source for Clockify. When selected, your active Workspace and From/To dates will be displayed.

To import Data:
  1. Select the From and To dates from which you wish to import data. All time data in Clockify will be imported for this range (including all data on the From and To dates).
clockify_select
  1. Select the type of transactions you wish to import and any other options (or accept the defaults). Click Import Data to proceed.
import_data

You can import the data as Timesheets, Leave or Payslip adjustments. If you have used start/end times in Clockify these can also be used in conjunction with Smart Formulas.

  1. Your data will be imported and displayed on the following screen. The columns are labelled according to the Clockify definition - depending on how you have set this up, you will need to select the appropriate columns to map the name, type, hours, date, description etc. Then click Validate to proceed.
clockify_imported
  1. Your data will be imported and validated by UpSheets.
clockify_validated
  1. Click Upload to upload your data to Xero Payroll.
clockify_xero