Cost of Work Report is available with Accounting Extension only

Cost of Work Report

Section Contents

Report Description
Cost of Work Report Parameters
Report Examples

Report Description

Cost of Work report provides you with information on costs calculated for working and leave hours reported by the selected system users. Costs are calculated on the base of hourly user rates.

Example of Cost of Work Report, detailed form

Only the users who have 'Generate Cost & Billing Reports' access right may generate Cost of Work reports. Note that the users who do not have this right will not see the reporting interfaces at all.

Report Sections

The Cost of Work report consists of three sections:

Costs calculated for the selected customers and projects on the base of regular user rates

Cost of Work report, Costs calculated for the selected customers and projects

This section shows costs calculated for the working time reported by the selected system users for the selected customers and projects within the specified date range.
Note that costs shown in this report section are:
1. Always calculated on the base of regular user rates
2. Always calculated for all working time reported by the users for the selected customers and projects
In particular, this means that costs shown in this report section include cost of overtime hours calculated on the base of regular user rates. See also description of the Overtime Addition costs listed below in the description of the General costs report section.
You can configure how to group information shown in this section. The available grouping options are:
- by customers
- by projects
- by projects having the same names (by project names)
- by tasks having the same names (by task names)
  
  Grouping by task names allows to generate reports on "generic" tasks, i.e. typical tasks present in a number of projects.
- by billing types
- by dates
There are 2 levels of data grouping available. For example:
- First group results by customers, then group by projects
- First group results by dates, then group by customers
- First group results by projects, then group by dates
- First group results by billing types, then group by customers
- etc.
The second grouping level is optional.

actiTIME automatically calculates subtotals when grouping report records.
General costs

Cost of Work report, 'General costs' section

This section shows costs that do not depend on the selected customers and projects and depend only on the date range selected for the report.

General costs include:
- Leave Time costs - costs calculated on the base of leave time user rates.
- Overtime Addition costs - additional costs calculated for users' overtime hours reported within the specified date range. Overtime Addition costs are calculated as specified below:
```
    Overtime Addition Cost = (Overtime Hours) * (Overtime Rate - Regular Rate)
```
  Where parameter 'Overtime Hours' means one of the following:
  - Overtime hours reported by the users who are allowed to enter overtime/undertime manually
  - Auto-calculated overtime hours for the users with overtime calculation mode set to 'Automatic calculation'
  Note that Overtime Addition does not depend on selected customers and projects. It shows additional overtime costs for the selected dates independently of the tasks users were working on at that time.
  
  This means that Overtime Addition does not change when you filter report records by customers and projects; thus in some cases report section with per-customer costs might not contain any spent time and costs (as they were filtered out), but the Overtime Addition Costs will be greater than zero.
Grand Total

Cost of Work report, 'Grand Total' section

This section presents sum of costs shown in the other two report sections.

Note that when you filter report records by customers and/or projects, section with general costs does not change, but the section with per-customer costs may depend on your filters.

In this case summation of general costs and per-customer costs may provide you with results that are hard for interpreting, especially when selected users were working on the projects that were filtered out.

When displaying of leave time and overtime costs is turned off in report parameters, corresponding report section is hidden.

Example of Cost of Work report,
displaying of leave time and overtime costs is turned off

Per-User Information Shown in the Report

Cost of Work report presents the following information for the selected users:

Spent time - working or leave time reported by the user.

You can turn off displaying of spent time in the report parameters.
Rate - hourly user rate, one of the following:
- Regular rate
  
  This rate is shown in the section presenting costs calculated for the selected customers and projects.
- Leave Time rates
  
  These rates are shown in the General costs section, in the lines presenting leave time costs.
- Overtime Addition rate
  
  This rate is shown in the General costs section, in the line presenting additional cost of overtime hours. Overtime addition rate is calculated as (Overtime Rate - Regular Rate).
- Average rate
  
  Average rates are shown in the summary rows 'Total for Leave Time' and 'Grand Total'. Average rates are calculated as (Cost / Spent Time).
You can turn off displaying of user rates in the report parameters.
Cost calculated on the base of hourly user rates

If hourly rates were changed for a user within the date range selected in the report parameters, the report will contain several sets of user-specific columns for each set of user rates.

Cost of Work report, columns for different user rates

For example, if rates for Billy Crown were changed on January 07, 2009, and report is generated for the date range January 01, 2009 - January 08, 2009, the report will contain two column sets for Billy Crown:

One for date range January 01, 2008 - January 06, 2009
And another for date range January 07, 2009 - January 08, 2009

Compact and Detailed Report Formats

You can generate Cost of Work report in the compact or detailed form. Level of details to show in the report is configured in the report parameters.

You can show or hide the following information:

Report columns:
- Spent time
- User rates
- Average rates
Report rows:
- Per-task costs

In the most detailed form Cost of Work report shows all available information on the calculated costs:

Example of Cost of Work report, detailed form

In the most compact form Cost of Work report shows only costs without any supplementary details.

Example of Cost of Work report, compact form

You can also hide report rows displaying leave time and overtime addition costs.