Forum Discussion

JaniceM's avatar
JaniceM
Contributing User
8 months ago

Payroll YTD figures are incorrect.

I prepared a spreadsheet of each pay slip to get the correct YTD total and the YTD totals in MYOB do not agree.  The YTD totals, in MYOB, were correct as at Nov 23. The employee was terminated in De...
  • gavin12345's avatar
    gavin12345
    8 months ago

    Hi JaniceM 

     

    I would recommend you first check the Payroll Register Summary YTD report to ensure all employee's totals are correct - this is where MYOB takes the figures from for STP Reporting. If the figures going to the ATO are wrong for this employee, they might well also be wrong for other employees. MYOB may have failed to update all totals for some unknown reason.

     

    If all others are correct and only this employee's is wrong, using suggestion by Earl_HD may well fix the employee's income statement, however your P&L should also be reviewed. I would recommend having this all checked by someone who knows what they are doing, in case one fix creates more problems.

     

    Regards

    Gavin

JaniceM's avatar
JaniceM
Contributing User
8 months ago

Further to above request for help:

The P&L figures and the Payroll activity report both agree with the spreadsheet I did of each pay slip.

However the YTD Pay-run history report and the YTD vertification report do not agree - they are out by the Novemeber payroll.  Hence the ATO Income Statement provided by the ATO has the same discrepancy.

I can provide the spreadsheet detailing all the above.

 

  • Shella_A's avatar
    Shella_A
    MYOB Staff
    8 months ago

    Hi JaniceM,

     

    It's great to have you in our Community Forum!

     

    Thank you for your post. The discrepancy could be due to the total amount of an inactive employee not showing in the activity and register report. If any payments have been altered at any point over the year (amended over/under payments, reversed or deleted a pay), it could cause discrepancies as every report through STP is reflected in the BAS Portal, and those figures do not update as per YTD figures. I suggest checking the payroll reports first to see if they agree with the YTD verification report under EOFY.

     

    However, if the figures are still not matching, given the complexity of these issues, may we have the spreadsheets and those payroll reports showing discrepancies in the figures for reference? Please note to hide any important details shown on the screenshot before posting it here in the forum.

     

    We're looking forward to your response.

     

     

    Kind regards,

    Shella

    • Shella_A's avatar
      Shella_A
      MYOB Staff
      8 months ago

      Hi JaniceM,

       

      Thanks for sending us the screenshot of the report requested. After checking it thoroughly, I suggest checking the ATO payroll categories assigned to those pay items included for the November pay run. If all of these are correct and no changes were made in the November pay runs, I highly recommend submitting an update event to sync all the figures correctly. Then, once it is accepted, rerun all the payroll reports again to compare the figures and see if they're updated.

       

      Should you require additional assistance, don't hesitate to respond. We also encourage you to connect with our virtual assistant, MOCA, through this link: myob.com/support, for prompt support.

       

      Otherwise, if my response has answered your inquiry, please click "Accept as Solution" to help other users find this. 

       

       

      Kind regards,

      Shella

  • JaniceM's avatar
    JaniceM
    Contributing User
    8 months ago

    I cannot delete the company details from the reports, can you advise how to do so and I will then send the reports.

    • Shella_A's avatar
      Shella_A
      MYOB Staff
      8 months ago

      Hi JaniceM, 

       

      Thanks for the update. If you aren't able to remove those important details from the report, kindly send me the report via private message.

       

       

      Thanks,

      Shella

    • Shella_A's avatar
      Shella_A
      MYOB Staff
      8 months ago

      Hi JaniceM, 

       

      Thanks for your response. To attach a screenshot of the payroll reports, you may click this "photo" (see screenshot below). 

       

       

      Then another screen will show an option to upload an image or document. 

       

       

      Click the file and upload the screenshot. Let me know how it goes.

       

       

       

      Kind regards,

      Shella

    • JaniceM's avatar
      JaniceM
      Contributing User
      8 months ago

      Have deleted the company information. Attached please find:

      Scanned copy of YTD verification report

      Copy of Pay run history exported to Excel, it which you will see that the YTD figures for Base salary, personal leave, allowances, tax and super for pay periods 1/10/12-31/10/23 and 1/11/23-30/11/23 have not changed. I have highlighted the YTD figures in question.

      As you will see the payroll for pay period 1/11/23-30/11/23 has not been included in the YTD.

      I trust you will be able to resolve this issue, hope to hear fom you soon

      Regards

      • JaniceM's avatar
        JaniceM
        Contributing User
        8 months ago

        Hi Shella,

         

        I have checked all the ATO payroll categories assigned to those pay items included for the November pay run, all of them are correct and no changes were made in the November pay run.

        I don't think sumbitting an update event to sync all the figures correctly will work, as:

        1) I sent an update event to the ATO on the 29/12/2023 when I advised them of the termination of the employee. Attached please find copy of STP report - (the 29/12/2023 is date sent termination date to ATO)

        2) On 17 January 2024 is the date the Employee's Accounting firm requested the Income Statement from the ATO, which showed the discrepancies between the Employee's Verification YTD and the ATO's Income Statement.

         

        I have attached myob Payroll Activity Report - this report shows the correct figures. Why do some myob reports show correct figuires?

        It is a dilemna but I don't see how sending another update event will sync all the figures correctly with the ATO.

         

        Please advise at your earliest,

        Thanks

        Janice

         

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.

 

Related content