We reviewed the template intuit included with QB 2020 and see that it has the same issues. 

So, we figured out what is wrong and fixed it. It took about two hours to fix and test.

If you'd like to get a fixed version of the template (free) start here:

Summarize Payroll Data In Excel « Big Red Consulting