T4's difference in EI & Pensionable earnings

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.    

  • Hi Jacke,

    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. 

  • Hi Jacke,

    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:

    1. Confirm Settings for Payroll (Setup, Settings, Payroll, Incomes)
      1. Confirm Calc Tax, Calc EI, Calc CPP/QPP selected for all income types
      2. Confirm all accounts are linked (Incomes and taxes)
    2. Confirm the Following information in the Employee record
      1. Personal Tab

                                                                   i.      Birth Date (if CPP not calculating)

    1. Taxes Tab

                                                                   i.      Tax Table

                                                                 ii.      Federal and Provincial Claim Amounts

                                                                iii.      Deduct EI/Deduct CPP checkboxes checked

                                                                iv.      No amount in Additional Fed. Tax box

    1. Income Tab

                                                                   i.      Pay Periods per year

    1. Confirm Release and Version (Help – About Simply Accounting)

    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.

  •  

    Dec 12, 08 978.75 978.75 1,065.32

  •  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

More Content