Reports: Scheduled vs Actual Hours Worked

NimbleSchedule features many useful reports that help you stay on top of your labor productivity as well as your staffing costs. In case you use both the scheduling and the time clock component of our system, then there is one particularly useful report in our “Miscellaneous” section called “Scheduled vs Actual Hours Worked”.

As its name suggests, this report allows you to have a clear comparison of the time scheduled for your employees versus the time they were clocked-in using our Time Clock functionality. As with every report in our system, there’s a filter on top of this report. Using the filter on top of the page, you can refine your search and restrict the report to a specific date range, or simply cover the current week or the current month.

Labor Productivity, Reports: Scheduled vs Actual Hours Worked

Once you have selected a proper date range, simply click on the “Generate” button and your employee names along with the data appear in the table below. You’ll notice that the first thing you see in the table on the left are actually employee names, followed by the date of their shift. From left to right, you’ll see Total Scheduled Hours, Total Hours (from time clock), Difference (scheduled vs actual hours worked), Labor Cost scheduled and, finally, Labor cost (actual).

Total Scheduled Hours – this column will show the number of hours for which your employee was scheduled for a particular date. So, in case your employee was scheduled to work from 9AM to 5PM, this column will show 8 hours.

Total Hours (from time clock) – as opposed to the above-mentioned column, this column refers to the time clock entry and will display the exact number of hours for a selected date when your employee was clocked-in. So, if your employee was clocked in from 10AM to 5PM, then the number in this column should simply show 7 hours.

Difference (scheduled vs actual hours worked) – as the name suggests, this column will simply show the difference between the first two columns. Providing your employee was scheduled for 8 hours, but clocked in for only 7 hours, then this column will show 1 hour.

Labor Cost (Scheduled) – displays the cost of all scheduled hours for a shift created for your employee on a specific date. This number gets generated according to the hourly pay rate configured on your employee’s profile multiplied by the number of scheduled hours.

Labor Cost (Actual) – displays the cost of all clocked-in hours for your employee on a specific day. The difference from the Scheduled cost is that this multiples your employee’s pay rate with the number of hours from the time clock instead of those hours for which your employee was scheduled.

On the bottom of this table you’ll see the totals for each column. Using these data to cross-reference what was scheduled and what actually happened may help you stay on top of all your staffing costs, business productivity and you will see where exactly your money goes. Is someone clocking in for more than she/he was scheduled? Is someone consistently clocking in for less than she/he was scheduled? Detect all such cases easily by using our “Scheduled vs Actual Hours Worked” report.

Karin Jakovljevic

About the author

Karin Jakovljevic

Karin Jakovljevic is the head of marketing at Ximble, a powerful, cloud-based workforce management system, simplifying employee scheduling and time tracking for retailers, restaurants and small businesses.

Success Stories

Menchie’s

It was hard to keep Menchie’s young and mostly part-time staff informed about shift changes, until Menchie’s discovered Ximble’s easy-to-use smartphone app.

Fast Fix

Ximble’s easy-to-use scheduling tool allows Fast Fix employees to remotely access shift information, and integrates with their Point of Sale and Payroll systems.

Spry Health

When spreadsheets became too complicated, Spry Health sought simple, cost-effective timekeeping software so they could concentrate on growing their business.

Spirited Gifts

Since switching to Ximble, Spirited Gift no longer struggle with employees turning up at the wrong time, for the wrong shifts.

Re-bath of South Florida

Re-bath required timekeeping software that was simple, flexible, and that could grow with their business.

Vastrm

When they outgrew their own internal system, Vastrm chose Ximble to track their part-time and contracted employees, both in and out of the office.

Excellence Martial Arts

All that Excellence Martial Arts were looking for was basic employee timetracking, with payroll reporting. Ximble’s cost-effective software was the ideal solution.

Collab Inc

Manual timesheets were a poor fit for Collab, and with no easy to feed the data into Gusto they began looking for a viable solution to their scheduling and time tracking headaches.

Carolina Moves

Follow Carolina Moves’ journey as they transitioned from using an archaic time tracking and data entry methods to using something that could optimize their processes and integrate with Gusto.

Bearings Bike Shop

Read how inaccurate time keeping methods forced Bearing Bike Shop to approximate working hours leading to significant losses over the year, until implementing Ximble.

Mermaid Life Chameleon

Needing a simplistic solution to their scheduling and time tracking needs, Mermaid Life didn’t want a solution that would over deliver and overcharge for what they required.

Krein Knives

Outgrowing spreadsheets, Krein Knives now needed a time tracking solution that could accurately track irregular working hours and automate as much of the administrative process as possible.

Garmentory

Looking for automation and simplicity, Garmentory turned towards Ximble in hopes of resolving their time tracking woes.

Novvia

With their eyes set on rapid growth, Novvia needed to implement a scheduling solution that could effectively scale as the business grew while integrating with the existing payroll system.

Story2

Discover how Story2 resolved their time tracking and payroll problems by implementing Ximble into their arsenal of tools and integrating it with their payroll platform, Gusto.

CareCentric Pty Ltd

Spreadsheets lacked the scalability and flexibility that CareCentric Pty Ltd needed as they grew and needed something that would be responsive to their changing needs.

Bou Cou Dancewear

Struggling with varying availability of staff, scheduling for multiple store fronts and managing payroll, Bou Cou Danceware needed a solution to their scheduling and time tracking needs.

Best Pets Veterinary Hospital

Constantly fighting wasted time from data entry errors, outdated methods of scheduling and time tracking were taking their toll. Discover how Ximble helps them overcome their challenges.

Hook SEO

Read how Ximble helped Hook SEO with their time tracking and scheduling problem when they noticed too much time was being wasted on data entry.

National Strategic

After a rapid increase of employees, National Strategic’s dependence on spreadsheets for time tracking was no longer viable. Find out how Ximble solved their problems.

miR Diagnostics

Find out how miR Diagnostics implemented Ximble’s time tracking features for their employees and how it improved their payroll operations through the Gusto integration.

Followell Fotography

Effective time tracking in and out of the office and Gusto integration was important for this photography company. Find out how Ximble stepped up to meet the challenge.

CARP

Ximble provided an inexpensive and user friendly solution to CARP’s time tracking and Gusto integration needs. Find what won them over and how it bettered their operations.

iLoveKickboxing

Discover how the time tracking and extensive feature of Ximble helped improve ILKB’s operations with the Gusto integrations and ximbleChat platform without breaking the bank.

Techpoint1

A tech savvy company that integrates technology into your offices and homes. With their skill and knowledge, they turn your ideas into reality.

Wise Owl Animal Hospital

An animal hospital that combines traditional and modern medicine to provide superior animal care. They raise awareness and provide advice on excellent pet care.

Armstrong Property Management

A property management consulting that specializes in home real-estate. They offer an abundance of services to property owners.

Parsaco

A restaurant consulting company that helps you take your business to the next level. With the best advisors, they can help you expand your business.

Liquid Consulting

A consulting company that strives to become your food processing partner. Comprised of skilled technicians and employees to improve your business.

Alta Animal Hospital

Find out how Alta Animal Hospital do away with printed shift calendars and move to a 100% mobile platform.

Montefiore

Read how Ximble helps Montefiore eliminate the need for multiple spreadsheets and calendars.

Rudy’s Pub & Grill

By utilizing Ximble, Rudy’s Pub & Grill has seen a 60% decrease in missed shift from schedule confusion.

TouchSupport

Learn how TouchSupport was able to manage employees at multiple locations with ease and save 8 hours a week by using Ximble.

Try Ximble for 14 days free

No credit card required. Cancel any time.