Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
S
shuaib95
January 15, 2023
Question

Excel Payroll Reports broken

  • January 15, 2023
  • 3 replies
  • 7 views

I'm getting the following error when trying to run Client Ready Payroll reports in QB 2023 and 2022.  

 

 

Compile error in hidden module:  UpdateReports

This error commonly occurs when code is incompatible with the version, platform, or architecture of this application.

 

I have a 2nd computer and I tested on there and it was working fine.  What I discovered though on the 2nd computer that Office 365 was not updated like the 1st computer was.

 

Once I updated the 2nd computer to latest 365 update, I started to get this same error.

 

Office 365 Version 2212 Build 15928.20216 on 1/10/23 is the update where this error starts to occur.

 

Now I'm not sure if this requires QB to update the VBA to this latest Office update...or the other way around.

 

 

3 replies

JaeAnnC
JaeAnnC
Level 6
January 15, 2023

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!

S
shuaib95Author
January 15, 2023

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.

K
Kurt_MQuickBooks Team
QuickBooks Team
January 15, 2023

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!

J
jl888
January 17, 2023
No text available
R
RCVQuickBooks Team
QuickBooks Team
January 18, 2023

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.

M
MTA Oregon
January 19, 2023

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?

    J
    jl888
    January 17, 2023

    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-Version

    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!!

    M
    MTA Oregon
    January 18, 2023

    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;

     

     

     

      D
      dso0216
      January 20, 2023

      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?

      Need QuickBooks guidance?
      Log in to access expert advice and community support instantly.
      Terms & ConditionsAccessibility statement