cancel
Showing results for 
Search instead for 
Did you mean: 
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.

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

Need to get in touch?

Contact us