Forum Discussion

ann75's avatar
ann75
Experienced User
2 years ago

salary deduction not showing in payroll deductions in balance sheet

Hi,

Appreciate if someone could help with this issue which I think is a glitch in MYOB.

 

Whenever we give an employee a salary advance in any month, we recover that from one of the following months salaries through a payitem ' advance deduction' which is in turn linked to the Balance Sheet account ' Payroll deductions' in Liabilities. So basically , whenever salary is deducted, that amount sits in Payroll Deduction. We then pass a journal entry between 'Advance to employee' (Asset)and 'Payroll deductions'(Liability) to cancel out and close the amounts. This is what we have doing for many years.

 

Howver we found in the months Feb to May of 2023, payroll deductions we had done for 2 employees was not reflecting in the B/S liabilities side in 'Payroll deductions' .It was specifically for 2 employees only. All relevant accounts were correctly reflecting the deduction, eg  cash, wages. Its just that the deduction was not there in Payroll Deductions. After a few days of digging around, we found out that the salary deductions for both these employees strangely were sitting in  PAYG Withholding Payable account. The linked account is payroll deductions and for all others employee salary deductions goes to payroll deductions. So I cannot understand why in just these 2 employees instances , each months deduction went to PAYG withholding acccount.

 

When I look at payroll register report for those months, I can see the amounts correctly in Deductions column and not in PAYG withholding, but  when we look at the Balance Sheet view for that period, you can see it in  PAYG withholding.

 

This clearly seems to be a glitch in the system. Can this be fixed to reflect correctly as we are due to file taxes for 22-23 soon?

7 Replies

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    2 years ago

    Hi ann75,

     

    Thank you for your post, and I regret the delay in responding back to your query.

     

    It does seem unusual that the payroll deductions for these two employees are appearing in the PAYG Withholding Payable account instead of the Payroll Deductions account. It's possible that there may have been a change in the linked accounts for these specific employees during the period in question. To resolve this issue, I would recommend checking the linked accounts for these employees to ensure they are set up correctly. Ensure to check the employee payroll details and compare them to the other employee details, specifically the salary advanced pay item. This can be a complex issue, and it requires us to gather information. If possible, please provide a screenshot of the employee's setup for us to investigate further. 

     

    Please remove any sensitive information before posting it to the community forum. 

     

    Feel free to reach out if you require further assistance.

     

    Cheers,

    Princess

     

  • ann75's avatar
    ann75
    Experienced User
    2 years ago

    Thank you for your reply. I have attached some screenshots for 1 employee just as a reference, for one month, Feb 2022, though the issue happned over 4 months. . 

    1)There is screenshot of the payroll deduction linked account in MYOB 

    2) The payroll set up and the deduction set up for the same employee

    3) The Break up of Feb 2022 salary for the employee which shows PAYG as $770 and Payroll Deduction as $1000

    4) The payroll withholding payable ledger for Feb shows both the above amounts combined as $1770 and sitting in PAYG withholding

     

    This has happened for both emploees over 4 months as their advance was recovered over 4 months. In none of the 4 months was either of their deduction  reflected in 'Payroll Deductions'.

    Funny thing is when i tried a trial payrun for the same employee this month with the same deduction, it is reflecting correctly in relevant accounts. The issue was for only Feb-May2022. It seems like a glitch in the code happened when the employee deduction was set up then. We did ntot make any changes since initial set up of employees. 

     

    Please let me know if you need any more evidence.

     

    Thank you

     

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    2 years ago

    Hi ann75,

     

    Thank you for providing screenshots, as they greatly aid in understanding the issue at hand. It's possible that a system glitch occurred at the time, or perhaps there were alterations to the account linked to the employee card file. Given that it's quite some time ago, especially if you've already closed the financial year, making changes to this payment, and reallocating it to the correct account could potentially create significant complications. It would be advisable to consult with your accountant before proceeding. Additionally, it's possible that during the pay period, the linked payroll payable account was not correctly linked to what was in the employee's card file.

     

    Please let me know if you require further assistance.

     

    Cheers,

    Princess

  • ann75's avatar
    ann75
    Experienced User
    2 years ago

    HI Princess, thanks for your reply.

    I am certain that the settings for linked accounts for employees iin the screenshots I sent were definitely not changed. It was set up this way in Feb 2022 for the first payrun for these employees and payroll deductions made over the next 4 months payroll. Its only now in Feb 2023 when we were preparing the books for tax filing( we havent closed the year yet) that we found the issue. Which is why I think it was a system glitch during set up time for both these employees.

     

    I do understand the complexitites around fixing this, at this point, so our accountant will look at working around through journal entries to take the amounts to the correct account. thanks for you responses though. Appreciate it.

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    2 years ago

    Hi ann75,

     

    Thank you for your response.

     

    Your accountant is currently taking the correct approach by utilizing journal entries to transfer the figures to the appropriate account. It's true that managing these types of concerns, which involve linked accounts for employees and payroll deductions, can be complex and requires the expertise of an accountant to make the necessary adjustments. However, if there's anything else I can assist you with, please don't hesitate to reach out. I'm here to help in any way I can.

     

    Cheers,

    Princess

  • ann75's avatar
    ann75
    Experienced User
    10 months ago

    Hi Princess,

     

    I was about to post this issue I have on the community forum and then I realised the matter seems to be linked to the problem I had 5 months ago and for which I connected with you above.

    So, I was about to send the payroll YTD finalisation report from the system, and when i did a cross check of the Gross and PAYG numbers as per finalisation report vis a vis the payroll register, I saw there was mismatch. When I checked i saw the 2 employees I mentioned in the previous case above(if you could refer to the messages above) have a random payrun each amount sitting in the finalisation report which is causing the mismatch.

    What is strange is that we did NOT process a payrun for these 2 employees in 23-24. They were not employees of the entity in 2023-24. Their last payrun was in June 2023. ALso we do not know where the 2 payruns amounts for these 2 employees come from as we have not done a payrun of  like that even in 22-23. Its almost like ghost payrun. There is some issue/glitch which affected multiple areas and only for these 2 employees.

    Now before I submit the finalisation report, I can untick these 2 pay runs and then we have the correct Gross and Payg total. But my question is where did these 2 payruns come from in the finalisation report when there was no pay run processed at all. When I look at the figures closely I see the payrun is done for 100 hours x their hourly rate. Both cases are the same. i have attached one of those cases. This shows only in the finalisation report and does not show anywhere else in past payrun, balance sheets, payroll register, payroll summary etc. Can you please help with this? I need to send the finalisation report asap but cause of this mismatch I havent. 

     

    Regards,

    Ann

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    10 months ago

    Hi ann75,

     

    I totally understand your concern with the unexpected pay runs appearing in your payroll YTD finalisation report for two employees who weren't active during 2023/24. To sort this out, we need to check if these employees are really ghost employees. Here's how you can do it: First, you need to find the employee ID in the Summary of Payments from EOFY Finalisation. You can do this by clicking on the 3 dots next to the employee. Then, search the card file for the employee and make sure to tick Show Inactive Cards. This will help you see if the employee ID from EOFY pops up in the file. If those employees are nowhere to be found within the file, then we can go ahead and process a file repair. To do this, please get in touch with our live chat. To get through to a live chat agent, you will need to get in touch first with our virtual assistant, MOCA, through myob.com/support. Don't worry, if MOCA can't provide the help you need, our live chat team is just around the corner to pick up where MOCA left off. If you encounter issues in the future, don't hesitate to create a post again.

     

    Cheers,

    Princess

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.