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

csoffice · ‎October 18, 2021

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.

Archie_B · ‎October 18, 2021

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!

View solution in original post

Archie_B · ‎October 18, 2021

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!

csoffice · ‎October 20, 2021

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.

Candice C · ‎October 20, 2021

Good morning, @csoffice.

I appreciate you coming back here with some more information about this issue.

To clarify, are you customizing the report that is showing the problem? If so, this may be way the information is way.

If not, I recommend contacting our Customer Support Team. They'll be able to assist you further with this issue. Here's how:

Go to the Help menu.
Choose QuickBooks Desktop Help.
Click the Contact Us hyperlink.
Give a brief description of the problem and hit Let's talk.
Scroll down and select to Get a callback.

It's that easy!

Let us know how the phone call goes. I want to ensure that you're taken care of today. Have a great day!

csoffice · ‎October 20, 2021

Hi Candice,

Thank you for the response.

I am customizing the report by customer job. I will try running it without customization and see what happens.

I'll keep you posted.

Thanks again!

Topics

Training

Community

Resources

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