Forum Discussion
Update : the whole timesheet is out of whack. The hours worked don't equal the amount column, using either the incorrect or correct hourly rate, and the accrued annual leave amount doesn't look right either.
Hi @sg9,
Thank you so much for your post and welcome to the Community Forum! I'm sorry to hear about the outage that happen. I understand the inconvenience caused by the recent outage. Your patience and understanding regarding this issue are greatly appreciated, and I apologize for the delayed response.
If the amount in timesheets is correct, based on the base hourly rate, you can follow these steps to rectify the issue:
- Open the "Employee card file".
- Navigate to "Payroll Details" and select "Standard Pay."
- In this section, ensure that all the amounts are set to $0.
Regarding the calculation basis for annual leave, it's crucial to clarify the specific parameters and rules applied within your organization. For Annual Leave accrual, if the Calculation basis is a percentage of wages/gross hours, it calculates the hours based on all pay items with an hourly basis. If the accrual is less than the expected hours, please check the leave accrual category to see if any of the pay items used in a pay run are added to the exemptions. Including pay items in exemptions can prevent the hours entered for those pay items from being included in the calculation of leave accrual.
For more detailed information on setting up leave and understanding the calculation basis, you can refer to this help article: Set up leave.
If you have any further questions or need additional assistance, please don't hesitate to ask. We're here to help you resolve any issues and provide guidance as needed.
Regards,
Earl
- sg92 years agoContributing User
Hi Earl_HD, many thanks for your reply. I've had a little look through the forum and it may be that my issue wasn't triggered by the outage, and may actually be an existing MYOB issue. I found this post, which seems to be what I am experiencing:
"I want to bring to your attention that the payroll sofware we are using has been exeperiencing errors in its calculation. Although i have informed the support team about these issues, but we are still encountering random errors. Specifically , the progdram is incorrectly calculating the gross pay by using incorrect salary rates. Our salary rates are supposed to be permanent, but the program randomly changes them . It is also impossilbe to conroll or check from my side as a user to avoid the wrong calculations. "
This is exactly what happened in my last pay run - i.e. the hourly rate radomnly changed and charged the hours worked at $3.96 more per hour than what it should have. Also, the hours worked for that pay cycle were down by two days due to employee sickness, but the gross amount column has remained at the figure that would have applied had a full week been worked. So the employee was paid a full week's pay PLUS two days sick pay. I can send you a copy of the timesheet if that helps?
On the annual & personal leave side, I've followed the advice given in the instructions in the help section, and as the employee is on an hourly rate, I've set the leave accrual option to "Equals a percentage of gross hours". The employee's base hours are 45 hours per week. Can you please confirm whether this is the correct option, or whether I should in fact be using the other option of 2.92 hours per week? I was under the impression that using the percentage of gross hours option, the calculation would be capped at 38 hours per week, but now looking through past time sheets, this doesn't appear to be the case, as there's different amounts of accrual listed on every pay cycle. If I am to change the accrual method, how do I go about reporting this change please? Could you also please advise the best method for changing and reporting the incorrections on this last time sheet. We don't use the built in timesheets provided by MYOB, we use our own.
Many thanks, and I look forward to hearing from you.
- Earl_HD2 years agoMYOB Moderator
Hi sg9,
Thanks for the detailed information and my apologies for the late response.
Thank you for bringing these issues to our attention, and I apologize for the difficulties you've been facing with our payroll software. I understand the importance of accurate payroll calculations for your business.
To address the problems you've described, here are the steps you can take:
1. Incorrect Base Hourly Calculations: It's crucial to ensure that only the leave pay items have the "automatically adjust base hourly" option selected in their settings. If this option is enabled for overtime pay items and you enter overtime hours, the base hourly rate may inadvertently change in the system. Please be aware that our development team is actively investigating this matter to resolve it.2. Leave Accrual Calculation: If you've chosen the "percentage (7.6923%) of gross hours" calculation method, it will calculate leave accrual based on the total gross hours worked, which may result in varying accruals each pay period. This method is not capped at 38 hours per week. If you want your employees to consistently accrue 2.923 hours every pay period, you should opt for the "equals hours per pay period" calculation basis.
3. Adjusting Leave Balances: To determine the necessary adjustment, you'll need to manually calculate the variance between the accrued YTD leave balance on the employee's card file and the correct accrual based on 2.923 hours per pay period in a weekly pay cycle. To make the required leave balance correction, you should proceed by processing a void pay run that includes negative hours. This will ensure that the employee's card file reflects the accurate leave accrual.
If you're using your own timesheets and not the built-in MYOB timesheets, you can manually enter the correct hours and amounts in your payroll software based on your own records.Please remember to keep thorough records of any corrections or changes you make in your payroll system for auditing and reporting purposes.
If you encounter further difficulties or have any specific questions regarding the software, don't hesitate to reach out to our for assistance. We are here to help ensure your payroll processes run smoothly and accurately.
Thank you for your understanding, and we appreciate your patience as we work to address these issues.
Kind regards,
Earl
Looking for something else?
Search the Community Forum for answers or find your topic and get the conversation started!
Find technical support and help for all MYOB products in our online help centre
Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.