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
Sign into bizimply.com
Select Reports from navigation bar > Attendance Reports > Cost Analysis Report
Choose Export Type: Once or Recurring. Click here to learn how to set up recurring.
Select the relevant date range: Last Week, Last 2 weeks, Last 4 weeks or custom date range
Select relevant locations from the dropdown menu
Select relevant employees from the dropdown menu
Click the blue export button at the top right of the screen
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.
Select the column header arrow for the column you want to filter
Uncheck (Select All) and select the boxes you want to show. For example, you could select to only show a specific employee or location
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.
Select the column header arrow for the column you want to sort
Click Sort A to Z to perform an ascending sort (A to Z or smallest number to largest)
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