Fixed version of the Summarize Payroll Data In Excel workbook template
The QuickBooks Summarize Payroll Data in Excel feature’s template workbook shipped with QuickBooks is corrupted.
When opening it with modern versions of Excel, an error is generated indicating corruption in two of the Pivot Reports included in the file. After updating with payroll data, the State Wage Listing and Quarterly Employee Summary reports do not update and instead continue to show sample data because of this corruption.
As of Jan 2022, customers have waited more than three years for Intuit to fix this issue.
So, we fixed it by repairing the State Wage Listing and Quarterly Employee Summary reports within the template and have posted the fixed version here for download. The reports a little different than the originals in their formatting, but appear to display the same results.
New! Because QuickBooks 2022 is 64-bit, the connection to QuickBooks had to be updated. As a result, there are now two versions of the repaired template.
This fixed templates are free to download and use. There is no need to purchase or register.
However, please consider sending a small $10 thank-you. This will help motivate us to keep the templates up to date and to improve them for modern versions of Excel.
32-bit version – for QuickBooks version-years up to 2021 and Enterprise 21.0
64-bit version – for QuickBooks 2022 and Enterprise 22.0
- Download and open the ZIP file to access the updated template.
- Read the included Readme First! file for simple instructions to use the template instead of Intuit’s broken workbook.