What version of Sage are you using? If you aren't on 2016 or 2017 you won't have the current payroll tables and Sage will try to calculate EI incorrectly. Otherwise the amount automatically calculated by Sage for EI should be correct based on earnings, where did you get the alternate amount you are trying to enter? For 2017 EI is a standard 1.63% of all earnings across Canada.

Outdated tables or not is not the issue.

It is, as expected, not calculating if I store a checque that has CPP, Tax, and EI. It will correctly recall what I saved (even the EI amount which does not match the automatic calculation).

However, it is acting improperly if I store a checque that has $0 CPP and $0 tax and an amount for EI. It will not recall the saved EI in this case and it will give me the calculated amount instead. Since it's a recurring trx, it should be pulling up what was stored for EI, same as above.

There's a flaw in the logic here that it's seeing those $0 and wrongly concluding that it needs to fetch the info for me.

I wish to know if current version does the same.
Store a pay with amounts for for CPP and Tax, and use 2% EI, for example - recall it - did you get 2% still ?
Store a pay with $0 CPP and $0 Tax, and 2% EI - recall it - did you get 2% or did it ignore what you saved and recalculate 1.63% ?

The calculation of EI has nothing to do with the CPP or tax rates or amounts. The calculation is based on a percentage of the gross earnings.

Why are you entering EI at 2% when the national rate is 1.63%?? You are overcharging your employee and overpaying the government by .27%. If the gross earnings are less than $145 on a semi-monthly cheque it makes sense that there would be no CPP or tax deducted.

If the dollar amount is the same each cheque then using a recurring paycheque makes sense but I don't understand why you are manually adjusting the EI to a higher amount than the required amount...

My manual deductions are correct per CRA, I am deducting 1.63%. I never said I was deducting 2% - I gave that as an example for someone to test with.

You said: "The calculation of EI has nothing to do with the CPP or tax rates or amounts" - I agree, it should not be related, but it does appear to be a flaw in the logic in this case. If there are amounts in CPP and Tax, the EI amount will be recalled as saved. If CPP and Tax are $0, EI will not be recalled.

SIGH, I seem to be unable to get my point across. but thanks for trying.

JJD,

I don't have 2017 on the computer I am working on today but 2016 will do as you have found if you recall the recurring transaction while in Automatic transaction mode. If you recall the transaction after changing modes to Manual, you should get the originally stored amount for all deductions.

I agree the logic is flawed in that it should automatically switch to manual mode and I believe it used to but I don't know any way around it right now.