If you'd like to import pay history into PayHero for your employees, you can fill out the spreadsheet attached to the bottom of this article and send it to firstname.lastname@example.org.
The pay history is used for calculating the Ordinary and Average Weekly Earnings that are used in calculations of the rate at which annual leave is paid out, and the Average Daily Pay for other leave. Since the Average Weekly Earnings and Average Daily Pay are calculated on a rolling twelve month period, a pay history broken down by pay period may be required for accurate assessment.
Alternatively, if you're only needing to add a few lines of history to your employees you can do so directly from their Pay History tab.
Creating the Import File
Download the template attached to this article, open it in Excel, and then detail twelve months of employee pay history.
The file should be completed with one line per employee, per pay period for the previous 12 months. If you have processed multiple pays with the same pay end date for any of your employees, you should combine them onto a single line.
Display Name - The employee's PayHero display name. Must be an exact match.
Pay End Date - The end date of the pay period, must be formatted as DD/MM/YYYY
Hours Worked - The total amount of hours for the period. The earnings are divided by these hours to determine the average and ordinary pay rates.
If the employee has a set Work Pattern their leave is based on then you should use those fixed hours instead of the actual hours worked. For example, an employee who accrues leave based on 40 hours per week and is paid fortnightly should have 80 hours per pay in their pay history.
Days Worked - The number of work days in the period that this pay covers, including days taken as leave. This is used for calculating the average daily pay if an employee works irregular hours. This should be in whole days - for example if an employee works a full shift on Monday, a half shift on Tuesday, and a half shift on Thursday the total days worked is 3.
Earnings - The employee's gross earnings for the pay that attract holiday pay. Discretionary payments and reimbursed expenses should be excluded. Do not include dollar signs.