Share
Report
22,647Problem
Client generated H01152018 Canadian Payroll batch – sent the batch to the GL and posted the GL.
Client then in completing the Payroll, realized an error in the pay for some staff. So she restarted the Payroll process and recreated H01152018 and corrected her first errors – sent the batch to the GL and posted the GL.
Client once again, before completing the Payroll process realizes an error in something with someone’s pay amount, so once again, restarts the Payroll H01152018 and corrects additional errors – sends the batch to the GL – reviews the payroll and is satisfied and Updates masters in payroll. Client then walks away from the job, as she is done.
Fast forward to 6 months later when the client asks (internally) why there is an unposted payroll batch for January? Answer – oh, must be a duplicate as we have that posting Journal printed here. So, client deletes the unposted CPY batch.
Fast forward to February 2019. The year end process and the tax updates are done. 2 full payrolls cycles have been completed in January and the client is in the middle of the first payroll of February.
External Account send request to client to see ‘why there are two JE posted for H01152018 in Jan 2018?’ You have to correct this as it effects the payroll numbers for the staff.’
Client now comes to me for help – first time I hear about this matter is 13 months after the fact.
Panic call – ‘we have to fix the payroll for the staff – we have recorded two payrolls for January 2018 and we have to get the T4s out asap.’
Research on the system shows in fact that the payroll was only updated once for H01152018 and there is only one record of this payroll batch in the Payroll. However, we can confirm that there are two JEs created in the GL. Requested of the client to confirm which of the two was the ‘correct’ JE and which one we had to remove. Client confirmed what went through the bank – and we provided direction on how to reverse the batch posted in error.
After that was done, client determined on her own that the other JE created was also wrong and took it upon herself to correct this by ‘reversing out’ that JE as well. No problem, it was the wrong amount.
Challenge now – there is a CM transaction for a different dollar amount than either of the two amounts of the two JEs that were reversed. So where is the JE that should have been there?
ANSWER – that is the one that was deleted in July 2018 based on the note the client found in the note book of the now departed accounting clerk. The batch that was deleted was not printed, it was not recorded in any fashion as “it was a duplicate of the one that was posted”
Almost right – it was different by about 250 dollars – 117650 vs 117350 – but who was paying attention to that minor detail.
So, getting to the reason for this post –
Is there any chance that in Canadian Payroll there is somewhere that the batch detail for the H01152018 batch that was last generated and sent to the GL and then deleted can be recreated? I have reviewed the reports in Canadian Payroll LY Reports and I can not find anything that shows that detail. Any suggestions?
*This post is locked for comments
All responses (
Answers (
