Enterprise Contractor 2023 Edition Payroll Reporting Issues with Excel

I can see the inconvenience this issue has caused to your business and its impact on your QuickBooks experience, @F-Smith. I’ve got some updates and resolutions for you.

Recently, we’ve confirmed that this payroll report issue with Excel was caused by a Microsoft Office update released last January 4, 2023. Thus, our team conducted an investigation with Microsoft. They released a fix you can perform to get around this.

One of the solutions is to revert the Office version back to build 15831.20208 or an earlier version. Since you’ve already done this workaround, you can refer to the following steps below to resolve this.

1. Close all Microsoft Office applications.
2. Reboot the computer.
3. Open and close the Excel a couple times. 
4. Once done, try to export the Certified Payroll Report in QuickBooks.

If the same thing happens, you can try installing other earlier Office versions except for the update from January 4 or utilize non-Excel-based reports in the Reports menu to obtain the information you need. You can contact the Microsoft Office Support team for assistance if need be.

In addition, here's an illuminating guide that provides more fixes and information about system requirements to ensure the Microsoft Office version works smoothly in the program: Fix export to Excel issues in QuickBooks Desktop.

If any other questions arise, please feel free to add a message at any time on this page. I’m always here to help.

Unfortunately, installing Office 365 did not work.  Under the Employee & Payroll Reports in Excel the ONLY spreadsheet not working is the WH347 Certified Payroll.   This is not acceptable as we are paying for this service with Payroll. 

Payroll department has told us this is a Microsoft Office products issue.  I am sick and tired of getting the run around.  Quickbooks has come out with an upgrade and failed to check the compatibility with the office products.

Fed UP!

I am doing Quarterlies, run reports and on the State Wage listing and the Quarterly Employee summary it is only listing unknown employees with Social Security Numbers 

What is going on.....dangerous for these people listing their wage info and security numbers. 

Thanks for chiming in on this thread, @JACR. I'll provide some troubleshooting steps to fix the issue with the employee summary report in QuickBooks Desktop (QBDT).

Let's run the Verify and Rebuild Data tools to get this resolved. This way, we can verify and resolve your company file's most commonly known data issues. Beforehand, please ensure your QBDT program is on the latest release so you'll always have the latest features and fixes.

Here's how to verify data:

1. Navigate to the File menu.
2. Choose Utilities, then select Verify Data.
3. Click OK when you see the message. QuickBooks detected no problem with your data.
4. If Verify finds an issue with your data, you'll be prompted to Rebuild Now or View Errors.
5. Click Close or View Errors and take note of the specific error message.

Next, here's how to rebuild the data:

1. Go to the File menu.
2. Choose Utilities, then select Rebuild Data.
3. Click OK if you receive a prompt to back up your company file.
4. Click OK when you get the message, Rebuild has completed, and proceed to the next step.
5. Rerun Rebuild Data to make sure there are no errors.

However, I suggest contacting our Technical Support Team if the issue persists. They have the necessary tools to pull up your account securely and perform a screen-sharing session to investigate this behavior further and pinpoint its root cause.

Furthermore, check out this article to help you track your payroll and employee expenses in QBDT. This will help you focus on the most essential information to your business: Customize payroll and employee reports.

Please get in touch with us if you need further assistance. I'll always be right here to help you anytime.