Importing Connecteam Data to Xero

Overview

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

Enable the Connecteam Integration

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

Importing

Once enabled, the Import screen will have a new Data Source for Connecteam. When selected, your active Time Clock 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 Connecteam will be imported for this range (including all data on the From and To dates).
connecteam_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 Connecteam 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 Connecteam 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.
connecteam_imported
  1. Your data will be imported and validated by UpSheets.
connecteam_validated
  1. Click Upload to upload your data to Xero Payroll.
connecteam_uploaded