Payroll deductions and expenses doubled?

Question

Hi everyone, 
 I have just come up to something that baffled me terribly and I need your help. 
 Since I started using Sage 50 (back in 2015) I've always printed my Deductions and Expenses Summary report and based my monthly payment to CRA on it thinking that the program would do the math without any issues. Well, apparently I was wrong all along! I just noticed that on my Employee Detail report the amount deducted is half the amount of what my Deductions and Expenses Summary is (which is the amount that I remit to CRA). 
 Does anyone know if this is an error or could someone explain to me why? And how can I fix it? I would really appreciate it. Because if that is the case, I've been paying double our deductions to CRA ever since. 
 
 Thank you.

Richard S. Ridings · Accepted Answer

The Deductions and Expenses report includes what the employee pays and what the employer pays. The Employee Detail report shows only what was deducted from the employee. The company owes portions of EI (generally 1.4x what the employee pays) and CPP (the same as what the employee pays). 
 I am surprised the Employee Detail report is showing half of the the other report for each of EI, CPP and Income tax. Only the CPP should be half, EI if applicable should be about 42%, Income tax should be the same, WSIB/WCB should not show on the Employee Detail report because it is not an employee deduction, etc. 
 If the Deductions and Expenses report match the General Ledger account balances for EI, CPP and Income tax for the same period of time, you have likely been doing your remittances correctly.

Sage 50 Canada

Payroll deductions and expenses doubled?

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING