As at 30 November 2020, Xero will no longer accept payroll data sent from FlexiTime via their API. While we strongly recommend migrating to PayHero (see Upgrade from FlexiTime Payroll to PayHero) for those unable to complete this migration we have provided a process that allows payroll details to be transferred to Xero using a file export/import.
To export the relevant data from FlexiTime, open the Report Centre (from under Tools) and load the report Xero Export from the Pay Reports folder.
By default this report will pick up any pays run in the last three days. If the pay you want is outside this time period, or if there are other pays in this period that you don't want to transfer you can change the date range by going to Settings and changing the date range on the Date & Time tab.
When you Export this report (you need to close the Settings panel to see the Export option) you will have a .csv file downloaded that you can import into Xero.
To import the file into Xero:
- In the Business menu, select Purchases overview.
- Click Import.
- Click Browse and select your saved CSV file.
- Click Import
If you're having trouble importing the file, try opening it in a spreadsheet and check the formatting of the InvoiceDate and DueDate columns, Xero requires these dates to be DD/MM/YYYY or DD MMM YYYY e.g. 10/12/2020 or 10 Dec 2020.