Excel Payroll Reports broken

Glad to see you here in the QuickBooks Community, @shuaib95. Let me help you get across this challenge so we can export payroll reports from QuickBooks Desktop (QBDT) to Excel. 

The error Compile error in hidden module: UpdateReports frequently occurs when code is incompatible with the application's version or architecture (for example, code in a document targets 32-bit Microsoft Office applications, but it's attempting to run on 64-bit Office).

To get around the issue, we'll have to keep our QBDT updated to the latest release. Here's how:

1. Press F2 or Ctrl + 1 when logged in to QBDT to check your current version and release. Please note the current release numbers for each version of QBDT: QuickBooks 2023 R3_172, QuickBooks 2022 R7_20, QuickBooks 2021 R12_7, and QuickBooks 2020 R16_25.
2. Next, let's update QBDT manually. Go to Help and click Update QuickBooks Desktop.
3. Select Update Now, then click Get Updates.
4. Once done, close and reopen QBDT.
5. Click Yes when asked to install the update.
6. Restart your computer once the installation finishes.

In addition, download the latest payroll tax table if you have an active payroll subscription so we can process payroll in QBDT. 

For a more detailed guide, please refer to this article: Update QuickBooks Desktop to the latest release.

I'd also recommend checking with your IT for further assistance to see if your operating system is compatible with the system requirements for Office 365.

I'll include this article as your future guide if you'll be interested in importing and exporting information with QBDT: Import and export data in QuickBooks Desktop. This way, we can transfer data to and from QBDT without starting from scratch. This makes it easier to convert, upgrade, or create a new company file.

If you have any follow-up concerns about exporting reports, please don't hesitate to leave a reply. We're always around to help. Stay safe!

Payroll tables are updated.

Quickbooks version is updated to the latest release.

Same problem persists.

I've been running 64bit Office 365 for some time now without issue...until today.

Hello there, @shuaib95. I'll point you in the right direction to get this sorted out so you can export your payroll reports from QuickBooks Desktop (QBDT) to excel.

Before anything else, I'd like to take this opportunity to thank you for the time and effort that you've put into performing my colleague's recommendation. Since the issue persists, I'd recommend contacting our QuickBooks Customer Care Team. This way, they can assign someone to check on your end and determine why you're unable to export payroll reports to excel. I'll input the steps below so you can proceed. To begin, here's how:

1. Open QuickBooks.
2. Go to Help, then select QuickBooks Desktop Help/Contact Us.
3. Select Contact Us.
4. Give a brief description of your issue, then select Continue.
5. Sign in to your Intuit account and select Continue and then Continue with my account.

• If you don't already have an account, make sure to Create a new account.

      6. We'll email you a single use code. Enter your code and select Continue.

• If you have more than one account, select the account you want to use and then Continue.

     7. Select to chat with us or Have us call you.

For more information, feel free to visit this article: Contact QuickBooks Desktop support.

In addition, here's an article about adding more details to a report in QBDT: Customize reports in QuickBooks Desktop.

You can also check this page in case you'd like to set scheduled reports: Set up and modify Scheduled Reports.

@shuaib95, if you need further assistance exporting your payroll reports out of QuickBooks, feel free to leave a comment below. I'll make sure to get back to you as soon as possible. Stay safe, and have a nice day!

Hello!

I had the same issue.

Here's what I followed to fix my issue: https://myinnerpc.zendesk.com/hc/en-us/articles/360042173231-How-to-Revert-Office-365-to-a-Previous-...

When you write your "config.xml", make sure to type 15831.20208 instead of the numbers the article has. I attached a screenshot here so you can see how I typed mine.

You only have to update it once. You don't need to update it again after rebooting your computer.

I hope this helps!!

I have the same issue when trying to create a client ready report.  It is happening to all my workstations. All have QuickBooks R7 20 update for 2022 and we are running Office 365 in 64 bit.  The resolution above does not resolve my issue.  I have called Customer Service 4 times and Microsoft 1 time.  Microsoft says it is a QuickBooks issue and QuickBooks says it is a Microsoft issue.  I've had my IT tech working on this and he assures me it is a QuickBooks issue due to the VBA code within the QuickBooks program which no one has or will give access to.  Has anyone else had this issue?  Another accountant friend is having the same issue as well.  Here is a screenshot of the error;

This is not the impression we want you to experience when exporting payroll reports from QuickBooks Desktop to Excel, MTA Oregon.

We appreciate the effort you put in to adhere to my colleague's above-mentioned recommendations and contact our support agent. I've checked our record and there's no reported case of this error message. We can check the system requirements for your version of QuickBooks since each version works with specific versions of Microsoft Office. If your version of Microsoft Office isn't compatible, we'll need to upgrade.

Once done, follow the steps from Microsoft to repair Microsoft Office. Then go back into QuickBooks and export the payroll report again. If the same thing happens, toggle your Windows UAC settings on and off. This should reset anything blocking the export feature and these steps work for Windows 7, 8, and 10. Here's how:

1. Open the Windows Start menu. Type User Account Control Settings into the search and open User Account Control Settings.
2. Select and move the slider to Never Notify. Then select OK.
3. Restart your computer.

Go back into QuickBooks and export a report again. If the issue persists, I'd suggest contacting our Technical Support Team. I know you already contacted us, however, this is the best option we can have for them to further investigate what's causing this issue. Here's how:

1. Go to Help, then select QuickBooks Desktop Help/Contact Us.
2. Tap Contact Us.
3. Give a brief description of your issue, then hit Continue.
4. Sign in to your Intuit account and select Continue and then Continue with my account.
5. If you don't already have an account, make sure to Create a new account. We'll email you a single-use code. Enter your code and select Continue.
6. If you have more than one account, select the account you want to use and then Continue.
7. Click to chat with us or Have us call you.

Feel free to visit our Tax forms page for more insight s about adding and managing your tax forms.

Please touch base with us here if there's anything else you need, I'm determined to ensure your success. Wishing you and your business continued success in all that you do.

Pretty ballsy to post for other to see but you are absolutely wrong.  I have proof that I called customer service 4 times.  But that is not the issue.  The issue is QuickBooks has a problem with the VBA code and needs to fix it.  Several offices in my area are stuck in the water at the worst time of year.  There has to be something figured out.  The last customer service person I spoke with, Sarah, said that she was taking so many calls all with this same issue.  She did say that QuickBooks (Intuit) was working on a fix.  Is this happening?

Exact same error as MTA Oregon.  ProAdvisor with several clients on payroll.  Happening with all.

Trying to get payroll reports to reconcile to quarterly and year-end submissions to various agencies.  How can we resolve this issue?

Hi there, @dso0216. I'm here to share additional information to help get rid of the error so you can export your report in QuickBooks Desktop (QBDT).

Currently, there's an ongoing investigation (INV-82323) about getting a Compile Excel error when attempting to export payroll reports in QBDT. Rest assured that our Engineering Team is dedicated to working to implement a solution that will fix this issue. Please know that this is a top priority for us, and it will continue to be so until it's fully resolved.

A workaround to fix this is to uninstall all Add-Ins and restart Excel. Once the error is fixed, activate one Add-In at a time to see which of them is the problem. For reference, please read this article: Fix Compile error in hidden module in Excel or Word. 

On the other hand, you can also install the 32-bit version of Excel or click the X icon in the message (not the close) and wait until the report will come up. 

While we're unable to tell when this issue will be resolved, I encourage you to contact our Phone support team. They can add you to our notification list, and you'll receive an email notification once an update is available. Here’s how:

1. Open your QBDt account and select the Help icon and click QuickBooks Desktop Help.
2. Then, select Contact Us.
3. Enter the investigation number and give a brief description of your issue. Then, select Continue.
4. Log in to your Intuit account and select Continue and then Continue with my account.
5. We'll email you a single-use code. Enter your code and select Continue.
6. Next, choose either Chat with us or Have us call you.

Please don't hesitate to post again here if you have any other concerns about running reports in QBDT. I'm just around the corner ready to lend a hand. Have a good one and keep safe. 

This solution is not correct. I completely uninstalled the 64 bit version of office and replaced it with 32 bit version. It fixed the issue for one day. 

If a quickbooks function is no longer working because of a microsoft update then it's quickbooks' job to coordinate with Microsoft on the problem, you don't send your customers to micrsoft tech support. 

Has there been any solution from QuickBooks/Intuit?  We are facing a deadline in just over a week to submit reports to the State in excel.

Hello there, MTA Oregon. I understand how important it is to submit this reports on time.

Upon checking on my end, the status of this issue is still open, and our engineers are currently working with Microsoft to find a permanent solution. Rest assured that our team will do our best to fix this issue so you can export those payroll reports.

As a workaround, we can revert Excel version back to Build 15831.20208 and disable automatic updates for MS office so that you won't get the updates. You can turn automatic updates back on after Microsoft releases a fix for this issue. You can check out this article for the detailed steps on how to revert to an earlier version: https://support.microsoft.com/en-us/topic/how-to-revert-to-an-earlier-version-of-office-2bd5c457-a91...

You can also utilize non-Excel based reports in the Reports Menu so you can obtain the needed data.

I also recommend reaching out to our Payroll Team to ensure your company is included among the affected users. This way, we can make sure that you'll receive an update as soon as the problem is fixed.

Let me know if you have other concerns or questions about reports and payroll. I'll be checking your response in this thread. Keep safe and have a wonderful day!