1. Arcoro
  2. ExakTime, Advanced Time & Attendance
  3. ExakTime Connect
  4. Reports
  5. Guides to Available Reports

Module Navigation

Using the "By" Reports for ExakTime

Avatar
Kevin F

ExakTime Connect features twelve "By" reports that sort information based on two different parameters. For example, the Cost Code by Employee report will display the time accrued to each Cost Code sorted by the employees who accrued that time for the given date range. You can choose from the following:

Cost Code Reports

  • Cost Code By Employee - Displays the total hours accrued to each Cost Code broken down into each employee who worked those hours
  • Cost code By Location - Displays total hours per Cost Code, separated into each location where the time was accrued.

Employee Reports

  • Employee By Cost Code - Displays employees and their hours worked for a specified date range, broken out by cost code.
  • Employee By Location - Lists each employee's hours separated into each location where the time was recorded

Equipment Reports

  • Equipment By Employee - Displays total amount of hours accrued to each piece of equipment separated by the employee who recorded those hours.
  • Equipment By Location - Shows hours for each equipment item was used, broken out by location

Expenses Reports

  • Expenses By Employee - Lists the expenses recorded by each Employee within the specified date range.
  • Expenses By Location - Lists the expenses recorded at each location, within the specified date range.

Location Reports

  • Location by Cost Code - Lists each location and total time for cost codes performed at the location. Useful for job costing or comparing actual hours worked to estimates. Also helpful for billing labor costs when different cost codes have different rates.
  • Location by Employee - Displays a list of locations and the regular, overtime, and total hours of each employee who worked there.

Scheduled Shifts

  • Scheduled Shifts by Employee - Displays the scheduled shifts for each employee.
  • Scheduled Shifts by Location - Displays the scheduled shifts by location
Navigating to "By" Reports
  • Click Reports from the top-menu bar.

    Reports_-_02.png

  • Expand the appropriate section on the left and select the "By" report you want to view.

    ETC_-_Reports_-_By_-_Navigation_-_00.png

 

Cost Code Reports

Cost Code by Employee

Report Specific Options

ETC_-_Reports_-_Co_by_Emp_-_00.png

  • Show Cost Code ID - If enabled, will show the cost code ID in addition to the cost code name.
  • Show Employee ID - If enabled, will show the employee ID in addition to the employee name.
  • Sort By - Select if the list of cost codes should be sorted by the cost code name or ID. This option will not be available if the "Show Cost Code ID" is not enabled.
  • Separate Names and IDs with - Choose to separate the names and IDs by one of four available options
  • Show Overtime Hours - If enabled, this will show the regular, OT1, and OT2 hours alongside the Total Hours.
  • Show each Cost Code on a separate page - If enabled, each cost code will be shown on its own pages.

Example of Report

ETC_-_Reports_-_Example_-_Co_by_Emp_-_00.png

The report will list your cost codes, the total hours of the cost code used by employees, and columns for:

  • Cost Code
  • Employee Name
  • Regular/OT1/OT2/Total - Cost code hours are broken down and the total hours.
Cost Code by Location

Report Specific Options

ETC_-_Reports_-_Co_by_Loc_-_00.png

  • Show Cost Code ID - If enabled, will show the cost code ID in addition to the cost code name.
  • Show Location ID - If enabled, will show the location ID in addition to the location name.
  • Sort By - Select if the list of cost codes should be sorted by the cost code name or ID. This option will not be available if the "Show Cost Code ID" is not enabled.
  • Separate Names and IDs with - Choose to separate the names and IDs by one of four available options
  • Show Overtime Hours - If enabled, this will show the regular, OT1, and OT2 hours alongside the Total Hours.
  • Show each Cost Code on a separate page - If enabled, each cost code will be shown on its own pages.

Example of Report

ETC_-_Reports_-_Example_-_Co_by_Loc_-_00.png

The report will list your cost codes, the total hours of the cost code used with a location, and columns for:

  • Cost Code
  • Location Name
  • Regular/OT1/OT2/Total - Cost code hours broken down and the total hours.

Employee Reports

Employee by Cost Code

Report Specific Options

ETC_-_Reports_-_Emp_by_Co_-_00.png

  • Show Employee ID - If enabled, will show the employee ID in addition to the employee name.
  • Show Cost Code ID - If enabled, will show the cost code ID in addition to the cost code name.
  • Sort By - Select if the list of employees should be sorted by the employee name or ID. This option will not be available if the "Show Employee ID" is not enabled.
  • Separate Names and IDs with - Choose to separate the names and IDs by one of four available options
  • Show Overtime Hours - If enabled, this will show the regular, OT1, and OT2 hours alongside the Total Hours.
  • Show each Employee on a separate page - If enabled, each employee will be shown on its own pages.

Example of Reports

ETC_-_Reports_-_Example_-_Emp_by_Co_-_00.png

The report will list your employees, the total hours that the employee was working for a cost code and columns for:

  • Employee
  • Cost Code Name
  • Regular/OT1/OT2/Total - Employees' hours broken down and the total hours.
Employee by Location

Report Specific Options

ETC_-_Reports_-_Emp_by_Loc_-_00.png

  • Show Employee ID - If enabled, will show the employee ID in addition to the employee name.
  • Show Location ID - If enabled, will show the location ID in addition to the location name.
  • Sort By - Select if the list of cost codes should be sorted by the employee name or ID. This option will not be available if the "Show Employee ID" is not enabled.
  • Separate Names and IDs with - Choose to separate the names and IDs by one of four available options
  • Show Overtime Hours - If enabled, this will show the regular, OT1, and OT2 hours alongside the Total Hours.
  • Show each Employee on a separate page - If enabled, each employee will be shown on its own pages.

Example of Reports

ETC_-_Reports_-_Example_-_Emp_by_Loc_-_00.png

The report will list your employee with the total hours that the employee was working for a location and columns for:

  • Employee
  • Location Name
  • Regular/OT1/OT2/Total - Employees' hours broken down and the total hours.

Equipment Reports

Equipment By Employee

Report Specific Options

ETC_-_Reports_-_Eq_by_Emp_-_00.png

  • Show Equipment ID - If enabled, will show the equipment ID in addition to the equipment name.
  • Show Employee ID - If enabled, will show the employee ID in addition to the employee name.
  • Sort By - Select if the list of equipment should be sorted by the equipment name or ID. This option will not be available if the "Show equipment ID" is not enabled.
  • Separate Names and IDs with - Choose to separate the names and IDs by one of four available options.
  • Show each Equipment on a separate page - If enabled, each piece of equipment will be shown on its own pages.

Example of Report

ETC_-_Reports_-_Example_-_Eq_by_Emp_-_00.png

The report will list your equipment with the total hours that the equipment was used for a location and columns for:

  • Equipment
  • Employee Name
  • Total - The total hours that the equipment was used with a location.
Equipment by Location

Report Specific Options

ETC_-_Reports_-_Eq_by_Loc_-_00.png

  • Show Equipment ID - If enabled, will show the equipment ID in addition to the equipment name.
  • Show Location ID - If enabled, will show the location ID in addition to the location name.
  • Show Cost Code - If enabled, will show the cost code used with a time record with a piece of equipment.
  • Show Cost Code ID - If enabled, will show the cost code ID in addition to the cost code name.
  • Sort By - Select if the list of equipment should be sorted by the equipment name or ID. This option will not be available if the "Show equipment ID" is not enabled.
  • Separate Names and IDs with - Choose to separate the names and IDs by one of four available options.
  • Show each Location on a separate page - If enabled, each piece of Location will be shown on its own pages.

Example of Report

ETC_-_Reports_-_Example_-_Eq_by_Loc_-_00.png

The report will list your equipment with the total hours that the equipment was used for a location and columns for:

  • Location
  • Equipment Name
  • Total - The total hours that the equipment was used with a location.

Expense Reports

Expense by Employee

Report Specific Options

ETC_-_Reports_-_Exp_by_Emp_-_00.png

  • Show Employee ID - If enabled, will show the employee ID in addition to the employee name.
  • Show Location ID - If enabled, will show the Location ID in addition to the Location name.
  • Sort By - Select if the list of employees should be sorted by the employee name or ID. This option will not be available if the "Show Employee ID" is not enabled.
  • Separate Names and IDs with - Choose to separate the names and IDs by one of four available options
  • Show each Employee on a separate page - If enabled, each employee will be shown on its own pages.

Example of Report

ETC_-_Reports_-_Example_-_Exp_by_Emp_-_00.png

The report will list the employees and the total expenses of those employees with columns for:

  • Date - The date entered for the expense.
  • Type - The type of expense.
  • Amount - The dollar value of the expense.
  • Location - The location associated with the expense.
Expenses by Location

Report Specific Options

ETC_-_Reports_-_Exp_by_Loc_-_00.png

  • Show Location ID - If enabled, will show the Location ID in addition to the Location name.
  • Show Employee ID - If enabled, will show the employee ID in addition to the employee name.
  • Sort By - Select if the list of locations should be sorted by the location name or ID. This option will not be available if the "Show Location ID" is not enabled.
  • Separate Names and IDs with - Choose to separate the names and IDs by one of four available options
  • Show each Employee on a separate page - If enabled, each location will be shown on its own pages.

Example of Report

ETC_-_Reports_-_Example_-_Exp_by_Loc_-_00.png

The report will list the locations and the total expenses of those locations with columns for:

  • Date - The date entered for the expense.
  • Type - The type of expense.
  • Amount - The dollar value of the expense.
  • Employee - The employee associated with the expense.

Location Reports

Location by Cost Code

Report Specific Options

ETC_-_Reports_-_Loc_by_Co_-_00.png

  • Show Location ID - If enabled, will show the Location ID in addition to the Location name.
  • Show Cost Code ID - If enabled, will show the Cost Code ID in addition to the Cost Code name.
  • Sort By - Select if the list of locations should be sorted by the location name or ID. This option will not be available if the "Show Location ID" is not enabled.
  • Separate Names and IDs with - Choose to separate the names and IDs by one of four available options.
  • Show Overtime Hours - If enabled, this will show the regular, OT1, and OT2 hours alongside the Total Hours.
  • Show each Location on a separate page - If enabled, each location will be shown on its own pages.

Example of Report

ETC_-_Reports_-_Example_-_Loc_by_Co_-_00.png

The report will list your locations with columns for:

  • Location
  • Cost Code Name
  • Regular/OT1/OT2/Total - The hours broken down and the total hours.
Location by Employee

Report Specific Options

ETC_-_Reports_-_Exp_by_Loc_-_00.png

  • Show Location ID - If enabled, will show the Location ID in addition to the Location name.
  • Show Employee ID - If enabled, will show the employee ID in addition to the employee name.
  • Sort By - Select if the list of locations should be sorted by the location name or ID. This option will not be available if the "Show Location ID" is not enabled.
  • Separate Names and IDs with - Choose to separate the names and IDs by one of four available options.
  • Show each Location on a separate page - If enabled, each location will be shown on its own pages.

Example of Report

ETC_-_Reports_-_Example_-_Loc_by_Emp_-_00.png

The report will list your locations with columns for:

  • Location
  • Employee Name
  • Regular/OT1/OT2/Total - The hours broken down and the total hours.

Scheduled Shift Reports

Scheduled Shifts by Employee

Report Specific Options

ETC_-_Reports_-_Sch_by_Emp_-_00.png

  • Show Actual Hours With Variance - If enabled, will include a table that shows scheduled hours compared to how many actual hours worked with variance amount.
  • Sort By - Sort the employees by their name or their ID.

Example of Report

ETC_-_Reports_-_Example_-_Sch_by_Emp_-_00.png

The report will show a list of employees with a total of shifts, daily scheduled hours, daily actual hours, and variance between scheduled and actual hours with columns for:

  • Location
  • Cost Code
  • Shift Start
  • Shift End
  • Total - Total worked hours scheduled.
Scheduled Shifts by Location

Report Specific Options

ETC_-_Reports_-_Sch_by_Loc_-_00.png

  • Show Actual Hours With Variance - If enabled, will include a table that shows scheduled hours compared to how many actual hours worked with variance amount.
  • Sort By - Sort the locations by their name or their ID.

Example of Report

ETC_-_Reports_-_Example_-_Sch_by_Loc_-_00.png

The report will show a list of locations with a total of shifts, daily scheduled hours, daily actual hours, and variance between scheduled and actual hours with columns for:

  • Employee
  • Cost Code
  • Shift Start
  • Shift End
  • Total - Total worked hours scheduled.
Was this article helpful?
0 out of 0 found this helpful

Articles in this section

See more