Public Holiday Not Worked - Upload

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 easy and quick to add entries using this method and it allows you to review the timesheet entry as it's very important to check any hours based on an employee’s specific situation and work pattern.
If you have a large number of employees, you can add Public Holiday not 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.
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.

Adding PH - Public Holiday (not Worked) - Upload

  1. After you have Opened a Payroll
  2. To Download the template -  Payroll > Enter > Enter Timesheets 
  3. Select > Upload from the menu 
  4. Select > Download Timesheet Spreadsheet - the file should appear at the bottom of your screen
  5. Select the file > timesheet ... xlsx to open the spreadsheet (you may need to Enable Editing)
  6. 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 Not Worked complete these fields:
  7. other > PH
  8. quantity > number of hours you are paying for the Public Holiday
  9. leave days > number of days taken
  10. notes > i.e. Boxing Day 2022 as you want it to appear on the payslip
  11. Empty fields can be deleted if you want
  12. Save the file  - in excel File > Save as to an appropriate place
  13. To upload the file -  Payroll > Enter > Upload
  14. Select > Choose File > select the file from where you have saved it
  15. Select > Upload File
  16. 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.
  17. Review > Timesheet Entries for each employee









    • Related Articles

    • 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 ...

    • 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 ...

    • 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 ...

    • 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 ...