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

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.

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 

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 

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. 

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

Hi LisaGSA 

I do apologise for the delay in replying. I have looked at your reports and responded to your private message.

After the debarcle with YTD figures not reconciling to the Summary of Reports I am now down to just two employees to sort out.

1. Last pay advice has a YTD figure for unused RDO of $157.28 and ETP -Tax withheld of -$50, however Summary of Payments has taken these two figures and multiplied them x4?

2. Last pay advice has a YTD figure for unused RDO of $416.46 and ETP-Tax withheld of -$133.00, however Summary of Payments has taken these two figures and multiplied them x2?

Any suggestions on how to fix please.

Tracey,

Thank you so much for the instructions on removing ETP payments through the Payroll Reporting Centre.  This has explained how two of my employess had their ETP double and quadrupled because he person who termianted them obviously took several attempts.

I just with the person I spent 1.75 hours on a chat with last Tuesday could have told me this, would have saved me hours of reading.