The T4 Summary gross pay doesn't match with employee detail report

How to resolve when the T4 Summary Gross Pay matches with the Employee Summary Report but not the correct values on the Employee Detail Report in Sage 50 Accounting.

Verifying Employee Summary and Detail Reports for T4 Accuracy

Run the Reports

1. Open Sage 50.
2. Run the Employee Summary Report.
3. Run the Employee Detail Report.
4. Compare the gross pay totals in both reports.

---

If the Reports Match

This means the totals align, but some income may still be missing from Box 14 on the T4 due to reporting codes.

What to Check:

• Some T4 boxes are excluded from Box 14 if a specific code is selected.
• Income will only appear in the box selected, not in Box 14.
• Refer to the CRA’s Employers’ Guide – Filing the T4 Slip and Summary for the correct box reporting rules for the year you're filing.
• Income assigned to these excluded boxes will not appear in the T4 Summary gross income.
• Certain T4 employment codes in Sage 50 (found in the employee record under T4 and RL-1 reporting) will prevent income from showing in Box 14 and reduce the gross amount on the T4 Summary.

---

If the Reports Do Not Match

Take corrective action based on whether the Summary Report shows a higher or lower gross pay than the Detail Report.

1. Save Your Company File

• Save a copy of your company file.
• Name it “T4 printing” — this version will be used to produce your T4s.

2. Adjust Gross Pay

Scenario A: Summary Gross Pay is Higher

1. Create a negative paycheque for the employee.
2. The amount should equal the difference between the Summary and Detail gross pay.
3. Manually calculate taxes on this paycheque.
4. This will reduce the Summary Report total to match the Detail Report.

Scenario B: Summary Gross Pay is Lower

1. Confirm that the Detail Report is correct.
2. Create a positive paycheque for the employee.
3. The amount should equal the difference between the Detail and Summary gross pay.
4. Manually calculate taxes on this paycheque.
5. This will increase the Summary Report total to match the Detail Report.

---

Final Check

• If the reports still don’t match, verify which report is correct.
• Adjust accordingly before printing T4s.