Public Holiday Worked - Upload
PHW - Public Holiday (Worked) - Upload to Timesheet
iPayroll has a public holiday calendar in the system and each time you open a pay, if a holiday falls within the pay period; you will see a notification on each timesheet. If you have a large number of employees that worked on the Public Holiday, you can add Public Holiday Worked to the timesheet by creating an upload file. You upload to an open pay and the employees must have a timesheet in the pay.
If they worked more than one Public Holiday enter it as two separate transaction entries as the dates are shown in the Leave History.
The credit for the Alternative Holiday will show on their payslip. If you want to show it as a balance on future payslips and in their kiosk, check Setup > Organisation > Defaults > Payslip > Display on Payslips > tick Alternative Holiday > Save
Remember to delete the sample information. Check any entries you have copied. Remove any formulas before you upload. Test your data before uploading it. Uploading the file twice will ADD data not REPLACE it.
PHW - Public Holiday (Worked) - Upload for Multiple employees
- If you only have a small number of entries, you can enter them into the Timesheet OR
- After you have Opened a Payroll
- To Download the template - Payroll > Enter > Enter Timesheets
- Select > Upload from the menu
- Select > Download Timesheet Spreadsheet - the file should appear at the bottom of your screen
- Select the file > timesheet ... xlsx to open the spreadsheet (you may need to Enable Editing)
- This is a list of all employees and their IDs, the first employee has example data which you will delete. To populate the Public Holiday Worked complete these fields:
- You may need 2 rows per employee, one for PHW and one to credit the Alternative Holiday (if this is an otherwise working day for them)
- First row other > PHW
- quantity > number of hours they worked
- Second row other > ALT-CR
- quantity > number of hours they worked
- leave days > number of days you are crediting them
- from > date of the holiday
- to > date of the holiday
- reason > i.e. Waitangi Day or as you want it to appear on the payslip
- Empty fields can be deleted if you want
- Save the file - in excel File > Save as to an appropriate place
- To upload the file - Payroll > Enter > Upload
- Select > Choose File > select the file from where you have saved it
- Select > Upload File
- Correct any errors. If you upload the file again it will ADD entries not REPLACE. Ordinary Time will be reduced if standard timesheet template hours are in the pay.
- Review > Timesheet Entries for each employee
Download the Timesheet Spreadsheet
Check for errors
Related Articles
Public Holiday Not Worked - Upload
PH - Public Holiday (not Worked) - Upload to Timesheet Entry iPayroll has a public holiday calendar in the system and each time you open a pay, if a holiday falls within the pay period; you will see a notification on each timesheet. It is relatively ...
Public Holiday Worked
PHW - Public Holiday (Worked) It is a legislative requirement that employees get a paid day off on public holidays, but if your employee works on this day and if it’s an otherwise working day for them (a day that they would have normally been at ...
Public Holiday Not Worked
PH - Public Holiday (not Worked) It is a legislative requirement that employees get a paid day off on public holidays, if it’s an otherwise working day for them (a day that they would have normally been at work). iPayroll has a public holiday ...
Regional Holiday or Anniversary Day
Regional or Anniversary Day It is a legislative requirement that employees get a paid day off on public holidays, if it’s an otherwise working day for them (a day that they would have normally been at work). This also includes the Regional or ...
Upload Pay Rates Tool
Upload Pay Rates This upload file will allow you to change pay rates for several people at once. The pay rate for anyone on the upload file will be applied to the next pay period when you open the pay. If your pay is already open, it will update the ...