Skip to main content
Skip table of contents

Leave accrual and amount calculations for days/hours setup (New Zealand)

This article deals with how the MYOB Exo Payroll software calculates leave accruals and Days/Hours paid for leave.

This article applies to Leave Calculations in Days or Hours ONLY. For information on managing Holiday Pay in Weeks and further Exo Leave Management information, refer to White Papers. Additional information regarding leave can be found on the MBIE website.

The Holidays Act 2003 provides information on the entitlements for the different types of leave along with the calculations for the amounts to be paid. Below is a guide to how the MYOB Exo Payroll calculates the leave accruals and the Leave amounts to be paid when set in Days or Hours for Holiday Pay. The information required for the calculations can be gathered from the different leave screens in the employee's record in the software.

Please note that from version 2020.06, Exo Payroll provided functionality to manage Annual Holiday entitlements and payments in Weeks - it is recommended to switch to this method where possible. For more information on the Weeks functionality, refer to White Papers.

Calculate an employee's accrued annual leave

Full Time PermanentPermanent Part-time / Pro-rata

(Calendar days between Entitlement Date and Accrued to date / 365)
Entitlement Days

Entitlement days = 20
Accrued to date = 13/09/2013

  • See picture below.

*Entitlement date= 17/05/2013

  • This is the Anniversary Date for the employee, often based on their Start Date.

Days between = 119

(20/365) x 119 = 6.5

Year To Date Accrued days = 6.5

(Annual Entitlement / 260) x Days Paid
(Annual Entitlement / 2080) x Hours Paid

Entitlement days = 20 (hours 160)
Days Paid = 55 (hours 440)

(20/260) x 55 = 4.23

(160/2080) x 440 = 33.84

Year To Date Accrued days = 4.23
Year To Date Accrued hours = 33.84


How much to pay on Holidays

When the software works out the annual leave amounts to pay, it uses the greater of Ordinary Weekly Pay at the time the holidays are being taken or the employee's Average Weekly Earnings over the 12 month period before the leave is taken.

When the Ordinary Daily Rate is set to Standard Pay, the software determines the rate using the following calculation - gross / days (or hours) paid, e.g. $720 gross / 5 days paid = $144/day.

If the Ordinary Daily Rate field is set to 4 Week Average, the software looks at the pays processed in the preceding 4 week period and performs the above calculation using those 4 weeks of earnings and days (or hours) paid.

From the 2018.01 release onwards, the Ordinary Daily Rate field has a new “Higher Rate” option. This calculates the Standard Pay rate and the 4 Week Average rate for the employee each pay (as described above). Whichever is higher becomes the "Ordinary Daily Rate" and is in turn compared with the Average Weekly Earnings (Last 12 Months) calculation mentioned below.

The Average Weekly Earnings calculation in the software uses the values found in the Gross Pay / Days (or Hours) Paid fields of the Last 12 Months section of the employee's Holiday Pay screen.

What rate to pay for different kinds of leave

The Relevant Daily Rate is what the employee would have been paid had they worked on the day in question when being paid for Family Violence Leave, Bereavement Leave, Alternative Leave, Public Holiday and Sick Leave (commonly known as FBAPS Leave). Look for the method calculation on the Sick & Other leave tab.

If an employee did NOT work on a Public Holiday or are being paid for Sick Leave, Bereavement Leave, Alternative Leave or Family Violence Leave, they are paid the Relevant Daily Rate for that day.

If an employee DID work on a Public Holiday, they are paid time and a half of the Relevant Daily Rate for the hours worked on that day.

Relevant Daily Rate (if Holiday Pay is calculated in Days)

Average Daily Pay: Gross Earnings liable for Holiday Pay in the last 52 weeks / Days Paid in last 52 weeks / Hours per Standard Day

Average Daily Pay can be used where it is not possible or practicable to determine an employee's Relevant Daily Pay.

Standard Pay: (Gross Taxable Earnings / Days Paid) / Hours Per Standard Day

Relevant Hourly Rate (if Holiday Pay is calculated in Hours)

Average Daily Pay: Gross Earnings liable for Holiday Pay in last 52 weeks / Hours Paid for last 52 weeks

Standard Pay: Gross Taxable Earnings / Hours Paid

For further information regarding FBAPS Leave, refer to White Papers.

Need more help? You can open the online help by pressing F1 on your keyboard while in your software.

You can also find more help resources on the MYOB Exo Employer Services Education Centre for Australia or New Zealand.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.