Skip to main content
S
SkyQueen
October 26, 2022
Solved

Re: State Wage Listing in Excel

  • October 26, 2022
  • 2 replies
  • 0 views

Re: State Wage Listing in Excel & it downloaded employee information including SS#s (assume sample data) that are not my employees. It appears the State Wage Listing still DOES NOT function after I purchased Pro Plus 2022. Luckily I am a small employer and do my state unemployment calculations by hand since this error is YEARS old. I get so discouraged with QB when I get error message "We found a problem with some content in "QB_Payroll_link_xlt".  And then PivotTable problems and data integrity issues.  Excel functionality is not a tool I use since I can't trust it.

 

Pardon my whining.

Best answer by BigRedConsulting

Yes, this has been an ongoing problem for for or more years that Intuit has not addressed. Not sure why, as it's an easy fix. I got busy one day a year or so ago and fixed it in a couple of hours and published a free solution on our site.

 

See Summarize Payroll Data In Excel Fix « Big Red Consulting  to download it.

2 replies

MariaSoledadG
MariaSoledadG
October 26, 2022

Let's fix the issue so the State Wage listing will function and calculate without any issues, SkyQueen.

 

I can see the urgency of having this resolved. Sometimes, you'll experience odd behavior and issues in QuickBooks whenever you haven't updated them and gotten the latest payroll tax table. You'll have to make sure to update QuickBooks to the latest release to keep up with the latest available updates and works with the most available fixes. To set up auto-updates, follow the steps outlined below:

 

  1. Go to Help and select Update QuickBooks Desktop.
  2. Select Options.
  3. Select Yes to turn on automatic updates. If you want to share automatic downloads with other computers on your network, you’ll need to do this for each one.
  4. Select Close.

 

QuickBooks will automatically download updates when they're available. Aside from that, ensure to get the latest payroll tax table to ensure you won't encounter issues in any of your payrolls. 

 

Once you already have updated QuickBooks and downloaded the latest tax table, you can use the Verify and Rebuild Data tool to fix any data integrity issues that you'll encounter. Here's how:

 

To verify data: 

 

  1. Choose Window then Close All.
  2. Verify Data. Choose File then Utilities. Select Verify Data. If you see:
    • "QuickBooks detected no problems with your data," no further action is needed.
    • A specific error message, there may already be an article for it. Try searching for it on our QuickBooks Desktop support site for specific instructions.
    • "Your data has lost integrity," indicates there is data damage in the file.  Continue to the steps below to Rebuild Data to correct the problem.

To rebuild data:

 

  • Choose File, Utilities then Rebuild Data.
  • You will receive a warning message to back up your company file, press OK. A rebuild requires a company file backup beforehand because in rare cases the process may need to delete transactions or list entries to fix the file.  A backup of your company file will ensure you have a secured copy of your company file before any changes are made to it.
    1. Select where you want to save your backup, then select OK at the bottom of the QuickBooks Desktop Backup window.
      • If a message asks if you want to replace another backup file, select NO. Enter a new name in the File name field and click Save.
      • If the backup fails, select Cancel at the Rebuild prompt and contact Payroll Support for additional assistance.
    2. The Rebuild Data utility starts as soon as the backup is finished.
    3. Click OK when you get the message "Rebuild has completed".

 

Furthermore, learn how to manage payroll and keep track of employee expenses using different payroll reports in QuickBooks. You can also customize them to make sure you get the information you need most. Go through this article for your guide: Customize Payroll And Employee Reports.

 

Drop a reply below if you have any questions about the State Wage listing or any of your payroll. I'll always be here to help.

S
SkyQueenAuthor
October 28, 2022

Thanks MariaSoledadG,

I went through your directions step by step but they had no change in my results. 

I didn't have any errors in my data.

My Excel problem still exists.

Regards,

 

    R
    RCV
    October 28, 2022

    Thanks for bringing this exporting error to my attention, SkyQueen.

     

    I appreciate you for performing the steps provided by my colleague. Exporting your payroll reports is my priority. With that being said, let's try repairing your QuickBooks Desktop to resolve this so you to export the tax form worksheets seamlessly. Then, let's perform some troubleshooting steps to fix this, which include the following:

     

     

    To begin, we can reset the software update and download the latest QuickBooks release. This can help improve the overall performance of the software and fix known issues. Here’s how:

     

    1. Go to the Help menu at the top to choose Update QuickBooks Desktop.
    2. Tap the Update Now tab to mark the box for Reset Update.
    3. Click on the Get Updates button to remove the previously downloaded releases.
    4. Hit OK to continue.
    5. Once completed, close and reopen your QuickBooks to kick off the installation.


    Next, try opening the tax form worksheet and exporting it. If you continue to get the same result, make sure your computer meets the program’s system requirements. This will ensure the application is compatible with your setup and will help avoid unexpected behavior when using it. 

    However, if your version is compatible, repair Excel to fix the issue. The Repair an Office application link contains detailed instructions about the process. If none of these suggestions work, perform Steps 4-5 in the Repair an Office application article.

     

    You can bookmark the Excel-based payroll reports article for future reference. It contains instructions on how to build the reports as well as information about each one. For additional insights, you may check out these articles: 

     

    If the issue persists, I'd recommend reaching out to our Technical Support Team. A specialist will be able to further assist you and help you resolve this one. Here's how to reach them: 

     

    1. Click the Help menu.
    2. Select QuickBooks Desktop Help.
    3. On the pop-up screen select Contact us.
    4. Click the Search for Something else button then type your concern in the Ask us anything box.
    5. Press Search then scroll down to get your contact options.

     

    I wish you continued success with your business. Feel free to click the Reply button if you have other questions about exporting your payroll report.

    BigRedConsulting
    BigRedConsultingAnswer
    November 5, 2022

    Yes, this has been an ongoing problem for for or more years that Intuit has not addressed. Not sure why, as it's an easy fix. I got busy one day a year or so ago and fixed it in a couple of hours and published a free solution on our site.

     

    See Summarize Payroll Data In Excel Fix « Big Red Consulting  to download it.

    Terms & ConditionsAccessibility statement