Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
February 22, 2023
Question

Enterprise Contractor 2023 Edition Payroll Reporting Issues with Excel

  • February 22, 2023
  • 1 reply
  • 6 views

Our company and IT were advised last week that there is an Error with the rollout of the 2023 Edition when attempting to get payroll information on a certified payroll report.  At first they told us to install the 2013 edition of excel to see if that would fix it.  It has not.  Then QB Support said they are aware of this and are working on fixing this.  

Is anyone else out there experiencing the same Error?  This is very frustrating as 38 employees on Certified payroll reports on several jobs is a pain to manually do the WH347 form.

1 reply

Moderator
February 22, 2023

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.

F-SmithAuthor
February 23, 2023

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!

 

 

July 6, 2023

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.