I'm not sure why Intuit hasn't fixed this in over a year.

I noticed it was still broken a couple of months ago.  So I investigated the issue and found several issues with the template.   I fixed them and tested the fix in about two hours.  It was easy enough.

I posted the fix on our site here: Summarize Payroll Data In Excel « Big Red Consulting