Has anyone else run across this? After I printed my T4's for the two companies I do books for, while ensuring all info was complete and accurate I noticed that on several T4's there was a difference between the Gross payroll & the EI insurable and CPP pensionable earnings. I went back into the detailed report for each employee, but cannot figure out why the difference. Any ideas? Thanks for any input.
Please read THIS article on possible reasons why this may be happening. The article will also go over how to match the gross income to the pensionable and insurable earnings in the program.
I hope this helps.
Hi Andrew, thanks for getting back to me, but this did not answer the question at all. The discrepancy in EI insurable and CPP pensionable earnings is greater than what would be caused by rounding. Also, the employees affected have not reached their maximum contributions. AND the difference is significant in all cases, i.e. $86.57 in employee TK but only $6.62 in employee RM and it is reporting their EI insurable is higher than their Gross earnings. How can that be possible? Out of 9 T4's SA is not reporting any insurable earnings in 7 of them, and 2 are over stated, CPP pensionable earnings are showing in 2 only [2 different employees] and it too is incorrect. I took over these books mid year and have not been able to completely reconcile and confirm everything previous, but I have no idea why this would be so out of whack. Any ideas what to look for? Thanks for any help you can be.
Were any manual adjustments done to the gross and amounts? As per the article I attached in my earlier post this can cause mild fluctuations especially if the amounts were maxed. Also was the calculate taxes manually button ever checked off in Paycheques? This can also cause fluctuations as well. Also check the following:
i. Birth Date (if CPP not calculating)
i. Tax Table
ii. Federal and Provincial Claim Amounts
iii. Deduct EI/Deduct CPP checkboxes checked
iv. No amount in Additional Fed. Tax box
i. Pay Periods per year
I also suggest you go through your Employee Detail Reports found in Reports/Payroll/Employee and click detail before displaying the report. If you took over these books in mid year and you're not sure what was done for payroll by the previous bookkeeper, I suggest you go through these reports as manual adjustments, taxes being calculated manually, etc may most likely be causing your discrepancy. If in doubt test in a sample company to see if its calculating correctly. If it is, then it is most likely a setting in your payroll and/or manual adjustments, taxes being calculated manually, etc that is causing your issue.
I hope that clears it up.
Sorry, hit the enter key too quickly. My last post shows the paycheque for Dec 12th for TK. As you can see, the EI insurable and CPP pensionable are not the same as the gross earnings. I didn't prepare this paycheque. Do you have any idea what would have caused this to happen? Thanks Andrew
© 2016 The Sage Group plc, its licensors or its affiliated companies. Sage, Sage logos, and Sage product and service names mentioned herein are the trademarks of The Sage Group plc, its licensors, or its affiliated companies. All other trademarks are the property of their respective owners. For more information, visit www.sage.com.
Community Terms of Service | Community Guidelines | Blog List | Community Help