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