Solved

Employee's Hours Are Different in "Time by Job Detail" report vs "Item Actual Cost Detail" report

Forum|Forum|4 years ago
October 18, 2021
2 replies
0 views

I am using QuickBooks 2019 Desktop Contractor Edition.

I’m trying to get a total for the number of hours one employee spent on a particular item for a customer job.

When I run a “Time by Job Detail” report, the hours show as 16.5 in the first week and 9 in the second week for a total of 25.5.

However when I run a “Job Profitability” report and click on the particular item, the numbers aren’t quite the same. Specifically, the “Item Actual Cost Detail” report has one extra hour added to each week. As I’ve been investigating this, I’ve noticed that all of the “Item Actual Cost Detail” reports for this employee have an extra hour added each week.

When I click on the numbers, the paychecks show 16.5 and 9 hours.

The employee is on salary and had no vacation or sick time during this period.

Also, I noticed that for another employee who is paid on an hourly basis, those extra one hours don’t show on the report.

Where are those 2 extra hours on the report coming from? I’m attaching a couple screenshots in case I’m not explain this clearly.

QuickBooks Desktop

Best answer by Archie_B

Thank you for providing details, csoffice.

Let's run the Verify and Rebuild Utility Tool to check the integrity of your data on your company file. This way, we can fix minor issues with your reports in QuickBooks Desktop.

Like this:

Go to the File menu.
Choose Utilities.
Select Rebuild Data and then OK.
Wait until the tool repairs your file. Click on OK once finished.
Go to the File menu, then select Utilities and choose Verify Data.
Let the tool check your file for data issues.

That should get you back on track. You can check out this article to learn how you can personalize your own customer, job, and sales reports: Customize customer, job, and sales reports in QuickBooks Desktop.

Here's a link to know more about the reports in QuickBooks Desktop: Understand report.

Click the Reply button below and let me know how it goes. I'll be around if you need help. Have a nice week!

A

Archie_BAnswer

Thank you for providing details, csoffice.

Let's run the Verify and Rebuild Utility Tool to check the integrity of your data on your company file. This way, we can fix minor issues with your reports in QuickBooks Desktop.

Like this:

Go to the File menu.
Choose Utilities.
Select Rebuild Data and then OK.
Wait until the tool repairs your file. Click on OK once finished.
Go to the File menu, then select Utilities and choose Verify Data.
Let the tool check your file for data issues.

That should get you back on track. You can check out this article to learn how you can personalize your own customer, job, and sales reports: Customize customer, job, and sales reports in QuickBooks Desktop.

Here's a link to know more about the reports in QuickBooks Desktop: Understand report.

Click the Reply button below and let me know how it goes. I'll be around if you need help. Have a nice week!

C

csoffice 11Author

Unfortunately rebuilding the data didn't change anything. Thank you for the idea - never hurts to try.

One other thing I noticed about the "Actual Item Cost Detail" report is that the dollar amount listed under the 1 hour entry is 4.75% of the amount listed above it for the "real" hours worked. So in the screenshot below, the $19.56 amount is 4.75% of $411.71. Same with the numbers near the bottom: $10.67 is 4.75% of $224.57. This is true on all the "Actual Item Cost Detail" reports. Every amount next to the 1 hour is exactly 4.75% of the amount above it.

I'm wondering if that 1 hour cost amount has something to do with taxes or some other type of deduction?

I opened the paycheck details and didn't see any deductions in those amounts though. One of our employees gets reimbursed for mileage but the others don't. This mystery 1 hour appears for all of them.

That's as far as I've gotten.