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

Hours is not importing into Certified Payroll

When creating a Certified Payroll Repors the Hours (from timesheet database) are missing. Only payroll information appears.

9 Comments 9
Rea_M
Moderator

Hours is not importing into Certified Payroll

I'll make sure your Certified Payroll report in QuickBooks Desktop (QBDT) displays all the data you need, @MishaFyodorov

 

The Certified Payroll report should include the hours worked by each of your employees (from the timesheet database) along with your payroll information. With this, I would encourage you to keep your software updated to have the latest features and fixes. Then, you'll have to get the newest payroll tax table to stay compliant with paycheck calculations.

 

Once you're done, go ahead and pull up the Certified Payroll report again.

 

In case the issue persists, you may have a minor data issue with your company file. With this, I'd recommend utilizing the Rebuild Data tool. It's a built-in tool that can help automatically fix data issues with your company file. To do this, here's how:

 

  1. Go to the File menu.
  2. Select Utilities, then choose Rebuild Data.
  3. On the QuickBooks Information window, select OK. Follow the onscreen steps to save a backup.
  4. Let the tool repair your file. It may take some time. 
  5. When the tool finishes, select OK.
  6. Go to the File menu.
  7. Select Utilities, then choose Verify Data.
  8. Let the tool check your file for data issues.

 

Then, you may continue performing the recommended solutions in this article starting with Solution 2 if you’re still having data issues: Fix data damage on your QuickBooks Desktop company file.

 

Also, to learn more about several Excel reports available in QuickBooks and how you can generate them, I'd recommend checking out this article: Excel-based payroll reports.

 

Let me know in the comments if you have other concerns about the Certified Payroll report and managing payroll data in QBDT. I'll gladly help. Take care, and I wish you continued success, @MishaFyodorov.

MishaFyodorov
Level 1

Hours is not importing into Certified Payroll

Hello, 

I tried all step outline in your reply. No fix.

The problem started when I updade Excel to 365.

Certified payroll report is not connectin to Time Sheet dadabase, and therefore not importing hours info, but only imports Payroll Data.

AileneA
QuickBooks Team

Hours is not importing into Certified Payroll

Hello, MishaFyodorov.

 

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. 

 

In addition, you can read these articles to learn more about the different reports in QuickBooks Desktop and how you can customize them:

 

 

If issue persists, I highly recommend reaching out to our Technical Team. They can run some diagnostics on the company file to identify underlying issues with the report path.

 

Here's how to contact support:

 

  1. Go to your QuickBooks Home page, then click the Help menu at the top.
  2. Choose QuickBooks Desktop Help from the drop-down.
  3. Hit the Contact us icon.

 

Feel comfortable to leave a reply below if you have any other concerns or questions. I'll be around to help. Take care always!

MishaFyodorov
Level 1

Hours is not importing into Certified Payroll

Hello, 

 

I tried QB technical support phone line for 4 days. I spend around 24 hours talking to different assistant, but no avail. I have several open cases on this matter.

 

[removed by moderator]

 

No answer for two months.

 

The is a glitch in programm that does not connect to Time Sheet dadabase when it generate Certiified Payroll Report. 

I made tryed every correction method QB sudgested. Nothing work.

 

What id phone number to a real tech support for QB reports in Payroll?

 

BigRedConsulting
Community Champion

Hours is not importing into Certified Payroll

When time doesn't appear in the columns, it's usually because there is no matching time in QuickBooks.

 

I know it seems like a basic question, but have you verified that you have time records in QuickBooks for the dates of the report (11/29/2021 - 12/5/2021) that use the customer:job selected for the report and the payroll earnings items used to pay your employees for the period?

 

 

MishaFyodorov
Level 1

Hours is not importing into Certified Payroll

Yes. The hours and Custmer job all intered corrctly in the timesheet. 

 

Problem, that CPR is not connecting to Timesheet Database? 

BigRedConsulting
Community Champion

Hours is not importing into Certified Payroll


@MishaFyodorov wrote:

Yes. The hours and Custmer job all intered corrctly in the timesheet. 

Problem, that CPR is not connecting to Timesheet Database? 


 

If you don't get an error message while the report pulls data from QuickBooks, then there isn't an issue with the connection to your QuickBooks file. Is that what you're asking?

 

If you review the time records pulled from QuickBooks, are the ones you're expecting to see on the report pulled from QuickBooks?

 

To review them, create the report and then unhide the worksheet where the time records are stored. It's called "Detail Time".  With newer versions of Excel, right-click on a worksheet tab and choose Unhide... and then pick the worksheet to unhide.

 

pr confused
Level 1

Hours is not importing into Certified Payroll

I am having the exact same problem.  I run a time detail report for the same time range and job and the hours show up on the report, but not on the certified payroll report.  Very frustrating considering the time requirements to report payroll......

LieraMarie_A
QuickBooks Team

Hours is not importing into Certified Payroll

Hi there, @pr confused.

 

Thanks for joining this thread. I'm here to ensure you'll get all the data you need in the Certified Payroll report. 

 

Did you follow the troubleshooting steps above? You'll want to run the Verify/Rebuild tool. Verify will detect any damaged data. Rebuild will attempt to fix the damaged data detected. It also allows your QuickBooks software to refresh the data inside the company file. Make sure to create a backup copy of your company file before doing the process. If there are changes that occur, having a backup copy allows you to restore it to undo the changes.

 

Follow the steps below on how to verify data:

  1. On the top menu, click File.
  2. Choose Utilities.
  3. Select Verify Data.
    1.JPG
  4. Click OK when you see the message, QuickBooks detected no problem with your data.
  5. If Verify finds an issue with your data, you'll be prompted to Rebuild Now or View Errors.
  6. Click Close or View Errors and take note of the specific error message.

 

Next, here's how to rebuild data:

  1. On the top menu, click File.
  2. Choose Utilities.
  3. Select Rebuild Data.
    2.JPG
  4. Click OK if you receive a prompt to back up your company file.
  5. Click OK when you get the message, Rebuild has completed and proceed to the next step.
  6. Run Rebuild Data again to make sure there's no error.

 

Additionally, make sure your QuickBooks Desktop is up-to-date. This way, you always have the latest features and fixes. Once done, run the Certified Payroll report again.

 

Visit me here again in the Community and keep me posted on your progress with getting the hours worked displayed in the said report. 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us