Xero Export
EXPORT REPORTS REQUIRES COLUMN FORMAT CHANGE IN EXCEL
Hours column needs to be formatted to Custom [H]:MM (remove the seconds part) this is due to Excel not accepting the formatting of Crystal in terms of decimal separator.
https://upsheets.com/ - direct Info link important bits pasted below
Upload Payroll and Projects Spreadsheets
to Xero in Seconds
UpSheets walks you through the process - One step at a time
Connect
Initiate a secure connection with Xero
Import File
Import your file and select the data to upload
Validate Data
Validate your data with Xero and correct any issues
Upload to Xero
Upload Validated data to Xero
Features
File Upload
Use spreadsheets or CSV output from to create and update Timesheets, Leave and Payslip Adjustments, Tasks and Time in Xero
Earnings Rates / Tracking Codes
Upload Timesheets with Earnings Rates and Tracking Codes (including multiple entries per employee/day).
Payslip Adjustments
Upload Earnings, Reimbursements, Deductions and Leave Accruals directly to Employee Payslips
Projects
Tasks / Time
Upload Tasks and Time transactions straight onto to Xero Projects
Leave & Accruals
Upload Leave Requests/Leave Accruals to Xero and update Payslips automatically
Approvals / Pay Runs
Approve your Timesheets & create Pay Runs without leaving Upsheets
UpSheets + Xero Integration
Connecting UpSheets to Xero enables you to upload spreadsheets containing:
- Timesheets
- Timesheets Approvals
- Approved Leave
- Pay Runs
- Payslip Adjustments
- Earnings
- Reimbursements
- Deductions
- Leave Accruals
Pricing
UpSheets is FREE for 30 Days - No credit card required
Basic
Best for under 250 lines
£3 /month
+ £0.05 /line
- All Transaction Types
- Email Support
- Support Center
Standard
Best for 250-1000 lines
£6 /month
+ £0.04 /line
- All Transaction Types
- Email Support
- Support Center
Premium
Best for 1000-2000 lines
£20 /month
+ £0.02 /line
- All Transaction Types
- Priority Email Support
- Support Center
Enterprise
Best for over 2000 lines
£35 /month
+ £0.01 /line
- All Transaction Types
- Priority Email Support
- Support Center