Wrong Hourly Rate

[Naomi26]

I'm so confused what is happening. I was wondering if anyone has encountered errors where the Hourly Rate shown on payslip is different to the actual hourly rate set on myob (essential) resulting in an employee severely underpaid. I have also found an unpaid study leave, unpaid basic hourly wage (although public holidays have been paid), and unpaid public holiday pay for some employees. I have experienced 4 times the past 5 months already, and this time experienced 4 errors in one payroll, but I do not know how I can fix this if it wasn't a system error. 

It would be great if anyone can help me.

[Tracey_H]

HI @Naomi26 

Thanks for your post. Based on the information provided it looks like your issues are due to the employee and pay item set ups. A general example of how the Calc rate can change is:

Employee is on $25.00 per hour and 38 hours per week:

A normal week with 38 hours Base hourly, Calc rate is $25 and Gross pay is $950:

Public holiday pay item is set up as Regular rate multiplied by 1.5 and Automatically adjust base hourly or base salary details is ticked. When this option is ticked the base hourly/salary hours and amounts are adjusted to meet the employee's standard pay.

A pay including a Public holiday. The Calc rate for Base hourly has been automatically adjusted so the Gross pay is still $950:

The Calc rate is calculated as follows:

Public holiday 15.2 hours x $37.50 = $570

Standard gross $950 minus Public Holiday $570 = $380

$380 divided by 22.8 base hours = $16.67

If I untick Automatically adjust base hourly or base salary details in the Public Holiday pay item and process the same pay as above, the Base hourly amount isn't adjusted so the Calc rate is $25 as per the employee card:

If you need further help please provide screenshots of the pay items and employee set up. Make sure sensitive information is removed from screenshots prior to posting on the public Forum.

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

[Naomi26]

Hi @Tracey_H 

Thank you very much for your reply and explanation.

I understand your explanation on rate adjustments according to their stadard pay.

However, this expalantion does not correlate with the issue that I am facing.

Firstly, public holiday rate and base rate is same in our company.

We have over 50 employees in our company, and more than half of them are permanent staffs, who are entitled to public holiday pay, but these issues are only faced by these staffs.

This one here, set hourly cycle is 64 hours.

Why is base hourly rate blank while public holiday is calculated ?

A normal week with 64 hours Base hourly, Calc rate is $26.38 and Gross pay is $1688 --> It does not exceed in this payment.

This one here, set hourly cycle is 80 hours.

Why is study leave blank while base hourly is calculated ?

A normal week with 80 hours Base hourly, Calc rate is $50.94 and Gross pay is $4075--> It does not exceed in this payment.

This one here, set hourly cycle is 64 hours.

Why is base hourly rate half the amount of usual when it does not exceed the hours in a pay cycle ?

A normal week with 64 hours Base hourly, Calc rate is $32.93 and Gross pay is $2107 --> It does not exceed in this payment.

This one here, set hourly cycle is 48 hours.

Why is public holiday pay blank?

A normal week with 48 hours Base hourly, Calc rate is $27.34 and Gross pay is $1312--> It does not exceed in this payment.

There must be other issue than exceeding the hourly rate in a pay cycle for such issue to occur. 

It would be great if you can advice me on this issue.

Thank you so much.

kind regards,

@Naomi26 

[Tracey_H · Accepted solution]

Hi @Naomi26 

So that I can look into this further please send me the following screenshots by private message:

• full payslips showing the gross pay
• those pay items set up
• the employee pay Salary and wages tab
• the employee Standard pay tab

*Update: resolved in private messages