cancel
Showing results for 
Search instead for 
Did you mean: 
lpurcell
Level 1

Certified Payroll Reports

Hello, 

 

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

6 Comments 6
Rubielyn_J
QuickBooks Team

Certified Payroll Reports

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
QuickBooks Team

Certified Payroll Reports

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!

Berenice 1
Level 1

Certified Payroll Reports

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

FritzF
Moderator

Certified Payroll Reports

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.

undefined

 

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
Community Champion

Certified Payroll Reports

@FritzF 

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.

BigRedConsulting
Community Champion

Certified Payroll Reports

@Berenice 1 

This happens every time you upgrade because not all of the payroll reports are initially installed.

After you get payroll updates successfully and then restart QuickBooks the additional reports will appear.

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us