re insurable earnings discrepancy

SOLVED

The amount in question is just from the regular Sage 50 Pro (Canadian version).  We do not have a special payroll package.  If I need to go to  the forum for product communities can you tell me how to get there?

  • 0

    Hi mhbc,

    I will move your post to the Sage 50 CA Support Community.

    You can get there by clicking on Support Communities in the green navigation bar at the top of this page and then choosing Sage 50 CA from the products available.

    Please note that in order to post questions or reply to threads you will first need to join any group you are interested in.

    Thanks,

    Derek

  • 0 in reply to Derek Vink

    Hi mhbc - what is your question?

  • 0
    verified answer

    Hi MHBC,

    The KB article below will give you some explanation about insurable earning discrepancy.

    Why is my EI insurable earning not matching the gross earned (Employment Income on T4)? - KB27268

    If you are unable to find the paycheque that crate the discrepancy, you can always go to the T4 and RL-1 reporting tab of the employee record and put in the correct insurable earning for printing T4 and summary.

    Hope this helps.

  • 0
    verified answer

    Thanks so much. Your information showed me why I had the discrepancy.

  • 0 in reply to mhbc

    Hi Mhbc,

    If any suggestions provided in this thread is able to help you resolving your issue, would you please click the 'Yes' button to the question - 'Did this answer the question?'  The thread will be marked as answered, which will benefit other users who have the same issue.  Thanks a lot.

  • 0 in reply to Keith L

    "The Sage 50 payroll update wasn't installed prior to the first set of paycheques for the year"

    In other words, it is still the case that the program back-calculates the EI insurable amount based on the deduction taken? So if your payroll is out of date (you are doing manual checks) and the EI rate has changed since the year you last paid for payroll - 2010, for example, the "EI insurable amount" is calculated using the tables for 2010.

    This year, (made up example) a salary of 1000.00 warrants a deduction of $45

    Simply looks up the $45 in the 2010 table which was a deduction for 1085.00

    VOILA -  your EI insurable amount is out of whack.

    This will happen whether you

    - have stopped paying for payroll altogether (the amounts are calculating from your last installed tables)

    - or you are simply late installing your PUP for the new year - whatever checks you cut in the interim will cause the amounts to be off (unless there has been no rate change since last year).

    The logic behind them calculating it this way (instead of EI insur = income) has to do with employees hitting maximum. If you enter a final smaller deduction on the pay where they hit max, or a $0 deduction on pays afterwards, the 'EI insurable amount' for those pays is indeed no longer equal to the gross income.  

    If they don't make 'EI insurable' a field that can be entered/adjusted at the time of each paycheck issuance, then the only thing you can do is adjust it manually on the employee's record 'T4 and RL-1 Reporting' tab.