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 paid for the period (optional - not currently required for leave calculations)
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. Do not include dollar signs. This should only include gross earnings that attract holiday pay - discretionary payments and expense reimbursements should be excluded, and a full list of inclusions/exclusions can be found in this article from MBIE.