Time entries are able to be imported into PayHero via the Timesheet Import process and if you're using Deputy as your scheduling system you'll be able to export time in a format that's ready to import directly into PayHero.
(Please Note: The Format Modifier on the 'Timesheet MealBreak Duration' applied by default in Deputy doesn't have a Format Modifier option for 'Hours' shown initially. You'll need to first remove the column during the 'Edit' stage and then re-add 'Timesheet MealBreak Duration' to see the updated options)
Exporting Timesheets
To begin exporting time from Deputy navigate to the Timesheets > Export Timesheets area of the system. Select the employees or individual time entries you're looking to export and click 'Export Selected Items'.
From the export selected items pop-up window select the 'Custom Payroll Exporter (BETA)' option and the file can be renamed here as you require.
Under the 'Preview' section, click the 'Edit' button to set the export formatting to match the PayHero import requirements.
Formatting Exported File
After clicking the 'Edit' option you'll have the ability to select the different columns and data sources that will be exported in the .csv file. The table below has a list of the columns that are available to import into PayHero and which Deputy Data Source they align with.
Please note: The 'Column Header' and 'Format Modifiers' will need to be adjusted to match the PayHero requirements for each data source.
PayHero Column Header | Deputy Data Source |
Ensure the 'Column Header' for the Deputy data sources are renamed to reflect the below. | These are the deputy Data Sources that align with the PayHero import columns. |
Employee | Display Name - The employee's 'Display Name' in Deputy must be an exact match to their 'Display Name' in PayHero. |
Work Name | Timesheet Area Name - The name(s) of the 'Timesheet Area' must be an exact match to your Work names in PayHero. |
Notes (optional) | Employee Comment or Supervisor Comment
Choose which comments you'd like to be saved on the imported timesheets in PayHero. |
Date (DD/MM/YYYY) | Timesheet Date
Format Modifier - dd/mm/yyyy |
Start Time (HH:MM) | Timesheet Start Time
Format Modifier - HH:mm |
End Time (HH:MM) or Duration (HH.HH) | Timesheet End Time
Format Modifier - HH:mm
or
Timesheet Total Hours
Format Modifier - Round (2 Decimal) |
Break Duration (HH.HH) | Timesheet Mealbreak Duration
Format Modifier - Hours |
Completing the Export
Once the columns are renamed and formatted as required, click the 'Export' button.
(The first time this is done the button will be 'Export & Save', this will export the file and save your specific settings for the next time an export is run).
After clicking 'Export' there will be a second screen to confirm and download the .CSV file.
With the newly downloaded .CSV file you can import those hours into PayHero ready for your next pay run and our support article: Timesheet Imports outlines the import process with the steps to take.