Import data from Square
UpSheets can import data directly from Square into Xero Payroll.Enable the Square integration
Before importing your Square data and uploading it to Xero, enable the Square integration.Importing
Once the integration is enabled, the Import screen shows a Square data source. When you select it, your Location and From / To dates are shown.
Square date selection
1
Select date range
Select the From and To dates from which you wish to import data. All time data in Square will be imported for this range (including all data on the From and To dates).
2
Select transaction types
Select the transaction types and any other import options (or accept the defaults). Click Import Data to proceed.
You can import the data as Timesheets, Leave or Payslips. If you use start/end times in Square, these can be used with Smart Formulas.
3
Map columns
Imported columns follow the Square definition – select the columns that map to name, type, hours, date, description, and so on. See Validate options for field details. Click Validate to continue.
4
Validate
UpSheets validates your data.
5
Upload
Click Upload to send your data to Xero Payroll.