Skip to main content
G
GDMNJ
August 10, 2022
Question

Problem Creating Tax Forms Worksheets in Excel

  • August 10, 2022
  • 2 replies
  • 0 views

I am having trouble creating Tax Form Worksheets in Excel.  This feature used to work and now I keep getting this error : 

Quickbooks error -2147221000: Mehtod 'get module of object IRunningInstanceInfo failed

 

There is no information on this specific issue so I did go to extreme of uninstalling and reinstalling both Quickbooks and Microsoft office. I have also allowed ALL macros to run in Excel even though the suggested mode is to run macros from apps with active certificates - apparently the Quickbooks certificate is expired.

 

Any help would be much appreciated.  Thanks!

 

 

 

2 replies

BigRedConsulting
BigRedConsulting
August 10, 2022

Yes, if you don't have a payroll subscription or if you do and yet you have not validated and received the latest payroll updates for QB 2022, then this will happen.

 

See my answer here for a solution.

S
sammy126
January 16, 2023

I am having the same problem. I just updated to QB 2023 and my payroll dosen't renew until Feb.

S
SirielJeaB
January 16, 2023

Welcome to the Community, @sammy126. Thanks for reaching out to the Community.

 

It's possible that your payroll service isn't activated because you recently upgraded QuickBooks Desktop. Let's activate it by entering your payroll service key.  The steps to activate depend on whether you purchased your QuickBooks Desktop subscription online, over the phone, or from a retail store. Please follow the steps below:

 

To enter the payroll service key (purchase online):

 

  1. Open your QuickBooks Desktop company file, then select Employees.
  2. Click Payroll, then select Enter Payroll Service Key (or Manage Payroll Service key if you have a different payroll subscription).
  3. Select Add or Edit. Enter your service key.
  4. Click Next, and then Finish.
  5. Select OK when the Payroll Update message appears.
  6. Check that your payroll service status is Active, then click OK.

 

To activate a subscription purchased from a retail store:

 

  1. Launch QuickBooks Desktop and navigate to your company file.
  2. Choose Employees, then Payroll. Select Install Payroll from Box.
  3. Fill out the Payroll License and Product Information form. Your license number can be found on a brightly colored sticker in the folder inside the box.
  4. The product number is listed in the folder's instructions.
  5. Get the 16-digit service key to enter, then select Continue.
  6. To complete your payroll activation, follow the on-screen instructions, including entering your service key.

 

You can also refer to this article in the future if you want to manage your QuickBooks Desktop account and services through the Customer Account Maintenance Portal (CAMPs): Manage your QuickBooks Desktop subscriptions and services.

 

Please get back to us if you need further assistance in activating your payroll in QuickBooks Desktop. We're always looking forward to helping you. Have a nice day!

M
mgcpa
April 25, 2023

I am not 100% certain, but I just started to receive this message on Excel 2010 (on my desktop) but I do not get the message on Excel 2019 (on my laptop)

    R
    Rasa-LilaM
    April 26, 2023

    Thank you for bringing this to our attention, mgcpa.

     

     I've come up with a solution to help you create the Tax Form Worksheet in Excel. Let me help ensure the process will only take a few clicks.

     

    Before we continue, may I know what QuickBooks version you're using? This is to determine the source of the unexpected behavior.

     

    While I wait for your response,  allow me to provide some of the factors which contribute to the error.

     

    • Your system doesn't meet the system requirements to run QuickBooks Desktop (QBDT).
    • The Office version you use doesn't work with 64-bit (QuickBooks).

     

    For additional resources, these links discuss in detail what your computer needs to get the best QBDT experience:

     

     

    To move past the error, you'll have to make sure that you're using a newer QuickBooks version (2021, 2022, or 2023). Then, download the latest maintenance release to apply critical fixes and update the tax table version. 

     

     

    To update your QuickBooks:

     

    1. In your company file, tap the Help menu at the top bar and choose Update QuickBooks Desktop.
    2. Head to the Update Now tab and tick the Reset Update box to remove previously downloaded releases.
    3. Click the Get Updates button and then press OK to continue.
    4. Close and reopen the desktop program to kick off the installation.

     

    Next, get the latest payroll update. This way, you have the most current and accurate rates and calculations for supported state and federal tax tables, payroll tax forms, and e-file and payment options.

     

    Once done, let's go ahead and run the Tax Form Worksheets in Excel. Here's how:

     

    1. Click Reports at the top menu bar and choose Employees & Payroll.
    2. Tap More Payroll Reports in Excel.
    3. Select Tax Form Worksheets.
    4. Choose the report you wish to open from the list.

     

    Here's a link to an article that lists the following: Excel-based payroll reports. From there, you'll learn the purpose of each tax form worksheet. 

     

    You can also save the link to our Payroll Hub for future use. It covers topics such as how to manage tax notices, troubleshoot payroll issues, process payroll forms, and run payroll reports, to name a few. 

     

    Keep me posted if you have other payroll-related concerns or questions. I'll get back to help you the best that I can. 

    M
    mgcpa
    April 26, 2023

    I appreciate your answer however, my system far exceeds all of the requirements of Quickbooks Desktop.  But, looking past your initial response.  I have been using QB 2023 to produce all of the reports in Excel 2010 up until the last QB update.  Then it no longer worked with Excel 2010.  I installed Excel 2019 and now everything is honky dory.  

    Terms & ConditionsAccessibility statement