Hi Janice, I understand how overwhelming this must be, especially when you've been relying on these reports to be accurate without any issues in the past. When you see multiple boxes, such as Box 14, 16, 18, 19, and 22, and the T4s themselves add up correctly, it could point to an issue in the underlying data file rather than in the report.
The first thing I’d do is make a full backup of your file, then run a Verify Data to scan for any damage, and if QuickBooks reports issues, follow that with a Rebuild Data to repair what it can.
Once the rebuild finishes, close and reopen QuickBooks, regenerate the T4 Summary, and compare those boxes again to the totals you calculated from the individual T4s.
If everything is still out, but your T4s and other payroll reports continue to tie to your spreadsheet, then this is likely a deeper file problem that will require a closer look. In that case, I recommend contacting QuickBooks Desktop Support so they can review your company file and help identify what’s driving those incorrect summary figures.
I’ll ensure this conversation remains open for any future updates and discussions.
