Cost Analysis Report

What information can I export from the Cost Analysis Report?

Sean McTiernan avatar
Written by Sean McTiernan
Updated over a week ago

In this article, you will learn:

  • How to export the Cost Analysis Report

  • What information is contained in the report

  • Our Cost Analysis Template

  • Permission to Access Report

The Cost Analysis Report will give you a detailed view of your weekly costings on a shift by shift basis and show you how the costs were calculated.

Please note: Overtime is currently not included in the report.

How to export the Cost Analysis Report

  1. Sign into bizimply.com

  2. Select Reports from navigation bar > Attendance Reports > Cost Analysis Report

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

  4. Select the relevant date range: Last Week, Last 2 weeks, Last 4 weeks or custom date range

  5. Select relevant locations from the dropdown menu

  6. Select relevant employees from the dropdown menu

  7. Click the blue export button at the top right of the screen

  8. The report will be emailed to you via the email address you are signed into Bizimply with

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

  • Emp No (Employee Number)

  • Company Code

  • Main Location (the Main Location the employee works in)

  • Date (of shift)

  • Day (of shift)

  • Hourly Rate (for the shift that was worked)

  • Day Rate (If they are a salary employee)

  • Location (location employee worked in for that shift)

  • Position (position selected on timecard)

  • Schedule (scheduled assigned on timecard)

  • Payroll Department

  • Hourly/Salary

  • In (Clock in time, paid time off logged e.g. holiday, sick or salary shift)

  • Out (Clock out time)

  • Break

  • Hours (Total hours worked for shift)

  • Cash Extra (if included in timecard)

Please note: Salary employees will have two lines recorded in the report - one with the times they clocked in and out and another which displays salary with the cost associated. This is because the salary employees are paid regardless of the number of hours worked.

Why should I use this report?

This report gives you a detailed shift by shift view of your costs. This shows you how your costs are calculated and allows you to filter through the data as needed.

Cost Analysis Template

We also have a template if you would like to further analyse your data (use filters, sort columns, check costs per position etc). Click on the excel icon below to download the template.

How to use Template:

Once you have exported your Cost 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

Please note: When comparing the costs (using the template) to the labour costs on the dashboard, you must exclude Sick & Holiday time off from the report using steps 1-3 above to ensure these costs match up. This is because the labour costs on the dashboard do not include paid time off costs.

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)

Permission to Access Report

Managers and other roles can access this report if they have been given the permission to view 'Attendance Reports' in Account Access > Permissions > Reports as highlighted below.

Related Articles:
โ€‹Timecard Analysis Report

Did this answer your question?