Forum Discussion

LisaGSA's avatar
LisaGSA
Trusted Cover User
5 years ago
Solved

Year-to-date Verification Report not balancing to payroll totals

Each month once i have finalsied payroll I check that the totals on the Year to Date Verification report match the totals on the Payroll Activity Statement.   LAst month (Jan) it was fine, I have n...
  • Tracey_H's avatar
    Tracey_H
    5 years ago

    Hi LisaGSA 

     

    Thanks so much for working with me, I'm glad we were able to resolve your issue. 

     

    For the benefit of other users who may see this post:

     

    If you delete and reprocess a termination pay with ETP, you also need to delete that ETP payment from the Payroll Reporting Centre by following the steps below:

    1. Click Payroll in the command centre
    2. Click Payroll Reporting 
    3. Click Payroll Reporting Centre 
    4. Click Employee Terminations tab 
    5. Find the employee and click the 3 dots next to their name 
    6. Select "Remove ETP" 
    7. Select the duplicate payments 
    8. Once it is removed then process a $0.00 payrun for the employee to update the ATO of the new YTD totals

     

    Please don't hesitate to post again if you need further help.

     

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

Tracey_H's avatar
Tracey_H
Former Staff
5 years ago

Hi LisaGSA 

 

Thanks for your post. When reconciling payroll the first reports I used to check were the Payroll Activity Summary and Payroll Register Summary.  This is because the Activity report gets it's data from pays recorded through Process Payroll. The Register report gets it's data from the Pay History tab in the employee card. STP reports also get their figures from the Pay History tab in the employee card. 

 

When the Activity and Register reports don't match it generally means that a manual adjustment has been made in the Pay History tab of the employee card. 

 

If the Activity and Register reports do match, then it's time to look at the ATO reporting categories. Check for any payroll categories that you've paid for the first time in that month, eg, annual leave, leave loading, personal leave. You can run the Activity Detail report to get a break up of the payroll categories. Check the different categories to see if one of them is the amount you are out of balance by.

 

Please let me know if you need further help.

 

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

  • LisaGSA's avatar
    LisaGSA
    Trusted Cover User
    5 years ago

    Hi Tracey,

     

    Thanks for the reply. I have run the Payroll Register and Payroll Activity Summary reports and checked these against each other. Both match.
    I have now run the payroll summary and checked these totals against the Year to Date Verification report and all of the ATO reporting categories match the totals on the payroll summary (i have grouped everything into the applicable category) except for the "ETP - Tax Free Component"

     

    The issue here is, this is not a new item, it has been used previoulsy and up until this month, it was always balanced. IT was used for 1 emplouee this pay, and the difference i have is not related to that particular employees payment.

     

    I have now run the Payroll Category Transactions report and cross checked these against the employee totals in the YTD Verficiation report and have found the employee record that is causing this issue

     

    I will need to run a zero pay for the employee to send through updated YTD's to correct this. 

    Im not sure why this has happened though, so if you have any insights that would be good to know. 

     

    Thanks

    Lisa 

     

    • LisaGSA's avatar
      LisaGSA
      Trusted Cover User
      5 years ago

      Hi Tracy, I should have checked this before I hit reply, but running a zero pay has not worked.

       

      For some reason the YTD Verification Report is overstated for this employee and is causing this issue.

       

      But after looking at her YTD income and comparing this to the Payroll Register/Activity Summary and the YTD Veriifcaiton Reports there are discrepancies.

       

      Who would be the best person to talk to to get this sorted?

       

      Thanks,

      Lisa 

       

    • Tracey_H's avatar
      Tracey_H
      Former Staff
      5 years ago

      Hi LisaGSA 

       

      Sorry to hear you haven't been able to resolve this. You can send me screenshots of those reports by private message and I'll have a look into it for you. 

      • LisaGSA's avatar
        LisaGSA
        Trusted Cover User
        5 years ago

        Hi Tracey,

         

        Just checking to make sure my private message came through and if you have had a moment to look into my query.

         

        Ta.
        Lisa

Related content