Exporting FlexiTime timesheets into your PayHero account

Follow

The FlexiTime to PayHero upgrade will copy all unpaid time entries across to your new PayHero account, ready for inclusion in your first PayHero pay.

There are some situations where you might need more of your FlexiTime timesheet history, particularly if your employees don't have a regular work pattern and you need their timesheet history to determine their Otherwise Working Days. 

In this situation you can either simply reduce your Work Pattern Review Period on Manage > Settings to make sure that you're only reviewing weeks with time entries in PayHero, or you might need to export your recent time entries from your FlexiTime account and import them into PayHero. 

Export time entries from FlexiTime

You can do that using FlexiTime's Report Centre

  1. Log on to your FlexiTime account 
  2. Select Tools > Report Centre
  3. If you're prompted to load a dashboard, click Cancel
  4. Maximize a blank pod, then click Settings
  5. Select Pod Type = Grid
  6. Enter Grid Title = Timesheet Export
  7. Select Table = Time
  8. Add Column > Employee Name
  9. Add Column > Work
  10. Add Column > Date
  11. Add Column > Start Time
  12. Add Column > End Time
  13. Add Column > Measure > Break Duration.  Set Decimal Places to 2
  14. Add Column > Units (optional,  only relevant if you're recording piecemeal work) 
  15. Use the Date&Time tab to select the date range that you need to export
  16. Click Refresh and check you're happy with the information
  17. Close the Settings pane and click Export to create a .xls file if you're using the web browser, or a .csv file if you're using the desktop app

Adjust the file format

Open your exported file in a spreadsheet and make the following changes so it matches PayHero's import file requirements. 

Change the "Employee Name" column heading to "Employee"

Change the "Work" column heading to "Work Name"

Click on the Date column and change the format to to DD/MM/YYYY

Then save the file as a .csv file 

Import into PayHero

Import your timesheet file into your PayHero account. This article explains how to do that: PayHero Timesheet Imports

 

Have more questions? Submit a request

Comments