Skip to main content
L
lpurcell
February 25, 2021
Question

Certified Payroll Reports

  • February 25, 2021
  • 4 replies
  • 0 views

Hello, 

 

The certified payroll report is not pulling the data into the excel file. Help!

4 replies

Rubielyn_J
Rubielyn_J
February 25, 2021

I'm here to make sure you're able to pull up the data into Excel, @lpurcell.

 

It is possible that you already exceed the limit. Due to Microsoft Excel 2003, 2007, 2010, and 2013 limits, this Excel report export feature has a limit of 65,536 detail lines.

 

If you exceed this limit you would have to upgrade to Excel 2015 or 2016 and try the following workaround

  1. Ensure to have Excel 2015 or 2016 for this to work because they support more than 65,536 detail lines.
  2. In your QuickBooks Desktop file, run a report such as the Create State SUI EFile.
  3. Before getting the QuickBooks Desktop data in Excel, change the settings using the Create State SUI (State, Filing year, Quarter) EFile.
  4. Go to the generated excel and Save As. Choose the type as Excel Macro-enabled Workbook (xlsm).
  5. Open the saved xlsm file and enable the macro contents by clicking on the Enable Content.
  6. Go to ADD-IN menu, then select QuickBooks Payroll State SUI E-File drop-down or the Excel Report you are trying to run.
  7. Choose Refresh State Data.
  8. We will again get the option of getting the QB data. Choose the following settings:
    1. State = State filing for
    2. Filing Year = Correct Date
    3. Quarter = Correct Quarter
  9. This time it should fetch all the data.

 

For more information, feel free to check this article: Excel based payroll reports.

 

Moreover, I've added this link to learn more about Certified payroll: Certified Payroll Overview..

 

Feel at ease to let me know if you have other concerns. I'll make sure to help you out. Keep safe. 

Rubielyn_J
Rubielyn_J
February 26, 2021

Hi, @lpurcell.

 

Hope you’re doing great. I wanted to see how everything is going about the certified payroll report issue you had the other day. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

 

Looking forward to your reply. Have a pleasant day ahead!

B
Berenice 1
October 27, 2021

I am having the same problem. After updating to QB 22.0 the certified payroll report is gone. Please help!

AlcaeusF
AlcaeusF
October 27, 2021

Good day, @Berenice 1.

 

Thanks for joining this conversation. Allow me to chime in and help make sure you're able to pull up the Certified Payroll report in QuickBooks Desktop (QBDT).

 

If you already followed the steps shared by my colleague above and the issue persists, let's run the QuickBooks built-in diagnostic and repair tools called rebuild and verify data utilities. These tools will repair and notify you of any possible data damage within the file.

 

Here's how:

 

  1. Go to File, then select Utilities and Rebuild Data.
  2. Choose OK. Follow the prompts to save a backup.
  3. Click OK once completed.
  4. Now, go back to File, then Utilities, and select Verify Data this time.

21.PNG

 

If QB detected no problem with your data, hit OK. However, if it finds an issue, you will be prompted to Rebuild Now or View Errors. Choose Close, then perform the steps below.

 

Here's how:

 

  1. Locate and check the QBWin.log or QuickBooks.log files.
  2. Scroll to the bottom for the most recent Verify information.
  3. Find the line that contains the LVL_ERROR, then check Top data damage errors in QuickBooks Desktop.

 

For additional information about the process, consider checking out this article: Fix data damage on your QuickBooks Desktop company file.

 

I'm also including this article to learn more about the Certified payroll in QBDT: Certified Payroll Overview.

 

Please know that the QuickBooks Community is always here to help if you have other questions or concerns. Don't hesitate to reach out anytime.

BigRedConsulting
BigRedConsulting
October 27, 2021

@AlcaeusF 

Rebuilding the company file will not change the reports that appear on the QuickBooks menu.

Problems with a company file do not change the contents of the QuickBooks menu.

K
kimbuc
December 8, 2021

I am having issues with the certified payroll reports not pulling all the data from the timesheet entry screen into the excel file.  The error seems to consistently be with just a handful of employees, but is a very frustrating and time consuming process to manually correct.  I have called QB support for assistance, done a file rebuild, reloaded my excel but nothing corrects this problem.  This issue began when we updated the software to QB Enterprise Contractor 22.0

J
JonpriL
December 8, 2021

Let me make it up to you, @kimbuc. I want to ensure you're able to correctly generate your report.

 

We haven't received quires from other customers, like you, whose having issues with Certified Payroll reports in QuickBooks Desktop. Let's repair QuickBooks to and generate the correct data of your reports so you can get back to business in no time. I'll show you how.

 

First set:

  1. Download the QuickBooks Tool hub.
  2. Open and install the downloaded file.
  3. On the QuickBooks Tool app, select Program Problems.
  4. Click Quick Fix my Program.

 

Second set:

  1. Go to Start.
  2. Select Control Panel.
  3. Under Program and Features, select Uninstall a Program.
  4. From the list of applications, select QuickBooks.
  5. Select Uninstall/Change.
  6. Click Repair.

 

Once done, restart your desktop first before working again with QuickBooks. Then, right-click on the QuickBooks icon on your Desktop, select Run as Administrator, and pull up and generate the data of your report accordingly.

 

Additionally, I've included this reference for a compilation of articles you can use to get an in-depth understanding of your business's financial activity: Know where you stand financially.

 

If there's anything else that I can help you with aside from generating your reports, please let me know in the comments. I'll be here to lend a helping hand. Take care always!

K
kimbuc
December 8, 2021

Thanks - I followed these procedures also and the report still does not pull the timesheet data into the excel spreadsheet (or pulls some days but not all).  Not sure how to get this fixed, but it needs to be fixed as the certified payroll reports are vital to us receiving payment from our customers.

E
ECSVA
February 23, 2023

I get this error now every time I try to do a certified payroll report "Security warning: Macros have been disabled"  But no matter what option I choose it still won't work

C
Carneil_C
February 23, 2023

Hi, @ECSVA.

 

This isn't the experience we want you to have when trying to do a certified payroll report in QuickBooks Desktop. Let's work together to ensure you can get past this error and utilize QuickBooks seamlessly.

 

Here are some troubleshooting steps for you to perform to fix this issue. These are:

 

 

To start, we can download the latest release to improve the overall performance of your system and fix commonly known issues. I'll show you how to do it:

 

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

 

Then, ensure the application is appropriate for your system and will prevent unusual behavior. Details about the system requirements for each QuickBooks version can be found in this link: System requirements for QuickBooks Desktop 2022.

 

From there, repair an office application to fix the issue if your version is compatible. If the problem persists, follow Steps 4-5 in this article: Fix export to Excel issues in QuickBooks Desktop.

 

Suppose you still encounter the same error after trying out those steps above. In that case, I recommend reaching out to our QuickBooks Desktop Payroll Support Team to look further into your account in a safe environment to investigate this matter and provide a possible fix.

 

Moreover, visit this article for more information about several Excel reports available in QuickBooks and how to generate them: Excel-based payroll reports.

 

Please keep me posted on how things turn out. I'll get back here as soon as possible to assist you again. I appreciate you dropping by and wish you well.

S
skcstx
July 10, 2023

We are having issues with certified payroll that have made us scratch our heads.  The jobs that we are trying to run suddenly drop off the job list drop down menu while running the certified program.  This causes an issue for us as we need to run the report even if we didn't have any work on that job that week.  We don't understand why we can run the report just fine and then the next week the job doesn't show up on the job list.

Is anyone else having this issue or had this issue before and if so how did you fix it?  If we can't get it fixed we will be forced to purchasing a certified payroll program to run our report.

Terms & ConditionsAccessibility statement