Skip to main content
Timecard Analysis Report

What information can I export from the Timecard Analysis Report?

Sean McTiernan avatar
Written by Sean McTiernan
Updated over 2 years ago

In this article you will learn about:

  • The Timecard Analysis Report

  • What information it will give you

  • Our Timecard Analysis Template

The Timecards Analysis Report will allow you to compare scheduled times, clock in records and paid times across multiple locations, employees, schedules and positions.

  1. Login to Bizimply online

  2. Select Reports > Attendance Reports > Timecards Analysis Report

  3. Choose Export Type: Once or Recurring. Click here to learn how to set up recurring.

  4. Choose Date Range, Locations and Employees

  5. Press 'Export'

What information will I receive with this export?

Your export will look similar to the below screenshot:

In this report you can view:

  • First name

  • Last Name

  • Employee Number

  • Date

  • Location

  • Scheduled in time (pulled from schedule)

  • Scheduled out time (pulled from schedule)

  • Scheduled break (pulled from schedule)

  • Schedule Total (Total scheduled hours)

  • Actual in (Pulled from Review Punch Times section)

  • Actual out (Pulled from Review Punch Times section)

  • Actual break (Pulled from Review Punch Times section)

  • Actual Total (Total of actual hours worked)

  • Paid in (Pulled from selected paid time on Timecard)

  • Paid out (Pulled from selected paid time on Timecard)

  • Paid break (Pulled from selected paid break on Timecard)

  • Paid total (Total of paid hours selected on Timecard)

  • Position (What position was selected on timecard/schedule for this shift)

  • Schedule (What schedule was selected on Timecard/schedule for this shift)

Why should I use this report?

This report gives you an overall view of your account within the specific date range selected. Unlike the Timecards report - the Timecards Analysis Report will show scheduled times, actual times and selected paid times across multiple locations/employees/schedules/positions.

Timecard Analysis Template

We also have a template if you would like to further analysis your data (use filters, sort columns, count hours scheduled versus hours worked etc). Click on the excel icon below to download the template.

How to use Template:

Once you have exported your Timecard Analysis Report - Copy and Paste the information into the template.

  1. Select the column header arrow for the column you want to filter

  2. Uncheck (Select All) and select the boxes you want to show. For example, you could select to only show a specific employee or location

  3. Click OK. The column header arrow changes to a Filter icon. Select this icon to change or clear the filter

You can also sort any columns, for example, you may want to sort by date.

  1. Select the column header arrow for the column you want to sort

  2. Click Sort A to Z to perform an ascending sort (A to Z or smallest number to largest)

  3. Click Sort Z to A to perform a descending sort (Z to A or largest number to smallest)

Related Articles:

Did this answer your question?