4. Leave Rates - 52 weeks Holiday Pay Gross Liable Pay History

4. Leave Rates - 52 weeks Holiday Pay Gross Liable Pay History

Leave Rates History 

If a persons hours worked fluctuates each period, or receives regular extra pay on top of their normal pay, then to enable iPayroll to correctly calculate the leave rates over the next 12 months, it requires the last 12 months of pay history to complete this task.

Opening Leave Rates Spreadsheet

On the spreadsheet each person requires 1 of:

  • 52 rows = 52 weekly pays prior to iPayroll pay information
  • 26 rows = 26 fortnightly pays prior to iPayroll pay information
  • 24 rows = 24 bi-monthly pays prior to iPayroll pay information
  • 12 rows = 12 monthly pays prior to iPayroll pay information

Information required:

1.    Id

2.    Name

3.    Period End Date

4.    Liable Pay (Holiday Pay liable gross earnings)

5.    Liable Hrs (worked for each period)

6.    Days (worked for each period)

Note: iPayroll can provide an additional service working with you to help you compile this information at an additional one off fee of $10 per person.

Download File:


    • Related Articles

    • Leave Taken Pay Elements

      Leave Pay Elements iPayroll has Standard Leave Taken Pay Elements, these are maintained by iPayroll and are created using standard legislative requirements and processing rules. You can set up your own Special Leave Taken Pay Elements. This allows ...

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

    • Pay Rates - Edit An Existing Employee

      Increase an Employee's Pay Rate You may need to edit an employee's pay rate due to a change to their employment conditions, employment agreement or due to a legislative change i.e. The Minimum Wage has increased. By changing the information on their ...

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

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