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

This thread is now closed to new comments.
Some of the links and information provided in this thread may no longer be available or relevant.
If you have a question please start a new post.
LisaGSA
Trusted Cover User
51 Posts
Trusted Cover User
Australia
Trusted Cover User

51Posts

13Kudos

2Solutions

Solved: Go to Solution

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 now run a report again today to check and i can't get the GRoss payments to match. All other categories matcs

 

I have not set up any new payroll codes this month, it was a normal payroll. So I am unsure as to why things balanced last month, but not this month.


Any ideas on where or what I should look at to find the problem?

Thanks,

PS - I finish work shortly for the week, so will hopefully be sorting this out first thing Monday morning Smiley Happy

9 REPLIES 9
Tracey_H
12,172 Posts
Former Staff
Former Staff

12,172Posts

0Kudos

1,836Solutions

Re: 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.

Cheers,
Tracey
Previously @bungy15

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

LisaGSA
Trusted Cover User
51 Posts
Trusted Cover User
Australia
Trusted Cover User

51Posts

13Kudos

2Solutions

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

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
Trusted Cover User
51 Posts
Trusted Cover User
Australia
Trusted Cover User

51Posts

13Kudos

2Solutions

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

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
12,172 Posts
Former Staff
Former Staff

12,172Posts

0Kudos

1,836Solutions

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

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. 

Cheers,
Tracey
Previously @bungy15

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

LisaGSA
Trusted Cover User
51 Posts
Trusted Cover User
Australia
Trusted Cover User

51Posts

13Kudos

2Solutions

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

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

Tracey_H
12,172 Posts
Former Staff
Former Staff

12,172Posts

0Kudos

1,836Solutions

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

Hi @LisaGSA 

 

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

Cheers,
Tracey
Previously @bungy15

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

Tracey_H
12,172 Posts
Former Staff
Former Staff

12,172Posts

0Kudos

1,836Solutions

Accepted Solution Solved

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

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.

Cheers,
Tracey
Previously @bungy15

MYOB Community Support

Online Help| Forum Search| my.MYOB| Download Page

Did my answer help?

Mark it as a SolutionHelpful? Leave a to tell others

traceyb1
Experienced User
18 Posts
Experienced User
Experienced User

18Posts

20Kudos

0Solutions

End of Year Balances

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.

traceyb1
Experienced User
18 Posts
Experienced User
Experienced User

18Posts

20Kudos

0Solutions

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

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.

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post