Leave Earnings History
The Leave Earnings tab on the Employees History screen allows you to inspect and maintain data that is used in calculating the Average and Ordinary Leave Rates.
To see this page, press
on the toolbar ,click on the 'History' tab. and select 'Leave Earnings'.
Overview
Period Ending Date The Pay Period End Date.
Average Gross Earnings This sum of payments in the pay period that accumulate into 'Average Gross'.
Ordinary Gross Earnings This sum of payments in the pay period that accumulate into 'Ordinary Gross'.
Hours/Week The number of hours worked in a normal week, based on the employee’s employment agreement or verbal agreement. Only applies when Annual Leave is calculated in weeks.
Days/Week The number of days worked in a normal week, based on the employee’s employment agreement or verbal agreement. Only applies when Annual Leave is calculated in weeks.
H/Rate Hours (Holiday Rate Hours) The total number of ordinary hours worked by an employee in the Pay Period. This value excludes any Overtime or Penal Time hours and is used in the calculation of 'Holiday Rates'.
ADP Hrs (Average Daily Pay related Hours) The total number of hours worked by an employee in the Pay Period. This value includes any Overtime or Penal Time hours and is used in the calculation of an employees 'Average Daily Pay'.
H/Rate Days (Holiday Rate Days) The number of Standard Days Worked by an employee in the Pay Period. This value excludes any additional days worked and is used in the calculation of 'Holiday Rates'.
ADP Days (Average Daily Pay related Days) The number of Total Whole and Part Days Worked by an employee in the Pay Period. This value includes any additional days worked and is used in the calculation of 'Average Daily Pay'.
Hours Per Day The employees standard hours per day as per the employees Payment screen.
LWOP Weeks The number of whole or partial Leave Without Pay (LWOP) weeks taken by the employee beyond the first, e.g. if the employee took 3 weeks of LWOP, the LWOP Weeks would be 2; if they took 1.5 weeks of LWOP, the LWOP weeks would be 1. Only applies when Annual Leave is calculated in weeks.
The Leave Earnings History data is updated automatically when a pay period is closed. During this process the applicable pay rates are calculated using the following formulas:
|
Average Rate |
= |
Employee's Gross Earnings over the last 52 weeks |
|---|---|---|
|
Days OR Hours worked in the last 52 weeks |
|
Ordinary Rate |
= |
Employee's Ordinary Earnings over the last 4 weeks |
|---|---|---|
|
Days OR Hours worked in the last 4 weeks |
|
Average Daily Pay (Days) |
= |
All Gross Earnings over the last 52 weeks |
|---|---|---|
|
Number of Whole or Part Days Worked or on Paid Leave during the last 52 weeks |
|
Average Daily Pay (Hours) |
= |
All Gross Earnings over the last 52 weeks |
|---|---|---|
|
Total number of Hours worked in the last 52 weeks |
|
Average Weekly Earnings |
= |
All Gross Earnings for the last 12 months |
|---|---|---|
|
52 - any LWOP weeks |
|
Ordinary Weekly Pay |
= |
All Gross Earnings for the last 4 weeks |
|---|---|---|
|
4 |
Average Weekly Earnings and Ordinary Weekly Pay are only calculated for employees who have the Calculate Annual Leave in Weeks option ticked.
Include Periods Prior To Start Date This checkbox is only available if the employee has been reinstated and Leave Earnings history records exist for periods prior to the current Start Date. Tick this box if you wish the prior periods to be included in the calculation of Average, Ordinary and Average Daily Pay.
Loading Leave Earnings Data
This is an import feature available from the tools menu of MYOB IMS Payroll. For more information on how to use this feature please refer to the document entitled 'Leave Earning History'. To view this document click Start > Programs > IMS Payroll Partner > Documentation > Leave Earnings History.
Maintenance Options
Add A pop-up window will appear where you can enter data for a pay period. You can not add a record if one already exists with the same Period Ending Date.
Modify A pop up window will appear where you can modify the selected record.
Delete Deletes the selected record.
Add Range Allows you to add multiple records over a selected date range. When adding a range all fields must contain valid information. There are options available which allow you to control how a record is added if there is already a record with the same Period Ending Date in the current date range. This option is intended for use where an employees Earnings, H/Rate Hours, R/Rate Hours, H/Rate Days, R/Rate Days and Hours Per Day are the same for every pay period during the selected date range.
Modify Range Allows you to modify multiple records over a selected date range.
Delete Range Allows you to delete a multiple records over a specific date range.
The pay you are currently processing will not appear on this history until you have Closed the pay period.
The history will be archived from time to time, refer to the Open Period screen for details.
Leave Rates Report
There is a Leave Rates report available on the Sundry Reports screen.
