cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
SusanHWA
Level 1

Custom Report Comparing Scheduled Hours to Actual Time Clocked In & Clocked Out

Looking for a report that compares scheduled time in & time out with actual time clocked in and out, not just scheduled hours vs hours logged in QB Time. Even the option to customize a report would be great thanks!

1 Comment 1
GebelAlainaM
QuickBooks Team

Custom Report Comparing Scheduled Hours to Actual Time Clocked In & Clocked Out

A report that compares scheduled hours to actual time clocked In & clocked out in QuickBooks Time (QB Time) is unavailable, @SusanHWA. However, I have a workaround you could use to still achieve your goal.

You can pull up the Scheduled vs. Worked and Timesheet Log reports. Then, export them to Excel so you can manually compare them from there. I'll show you how.
 

  1. Go to the Reports menu.
  2. Select Schedule Reports and choose Scheduled vs. Worked.
  3. Customize the report period and click Run Report.
  4. Then, hit Download .csv button to export.
     

To pull up timesheet report, click again the Reports menu, click Logging and Auditing and select Timesheet Log. Then, choose report dates and Download CSV.

Untitled.png

In addition, you can check out this article for more details in managing reports: Learn about QuickBooks Time reports.

Furthermore, in case you want to run reports for employees in QuickBooks, you can visit this link for future reference: Run and use the payroll report for QuickBooks Time.

Tag me in the comment below if you have clarifications in managing reports in QuickBooks. I'm always here to help you.

Log in today
Get expert help and peer support to tackle all your QuickBooks questions effortlessly.

Need to get in touch?

Contact us