Run Employee Charge Statistics report

The Employee Charge Statistics report is designed to show employees' chargeable hours. It can also be used as customisable cost reporting tool, see Employee Charge Statistics.

To run the report select View > Reports from the main menu or click the reports toolbar button and then click Employee Charge Statistics.

The report works with the entire Case Manager database and its cost records

Each cost record has a date and is linked to a case, to employee(s), usually to one or more companies, and so on. It has a type, a billable status and an invoice status: billed or unbilled. It also has a base rate, which is the number of employee hours involved multiplied by their base rate at the time the cost was created.

The first step is to specify the filter conditions, i.e. exactly which of these cost records you want to display and add up. You first narrow them down by date, company and case. The you further narrow them down by characteristics of the cost.

Lastly you specify options that you want to see in the report.

There are three tabs where you set your requirements:

Filters tab

Click the Filters tab. In this tab you specify filters for date, company and case.

  1. Select a date range option for the cost records from the Range dropdown list.
  2. Select whether this date range should be applied to the date of the cost or the date of its invoice (if one exists).

    3. This is an important choice and is further explained below at Cost date and invoice date.

  3. For company filtering you can choose between
    • All companies

      • Don't filter by company

    • Filter by company on invoice

      • Filters by the company name on the invoice.

      Type the company name in the box at the bottom of this section or select from the dropdown list. Note that choosing this option will exclude all unbilled costs because they have not been invoiced.

    • Company in role

      • This allows you to apply a company filter based on the contacts associated with a case. Type the company name in the box at the bottom of this section or select from the dropdown list. You can optionally specify one or more roles to further restrict the filter:

      For example, to display costs associated with cases referred by the Acme company, select this option, click Referrer and type Acme in the company filter.

  1. Choose between costs for all cases, open cases or closed cases.
  2. Click the Category dropdown list and select one or more case categories.
  3. Click the Assigned to dropdown list and select cases assigned to one or more employees.
  4. Click the Team dropdown list and select cases assigned to one or more teams.
  5. Click the Office dropdown list and select cases assigned to one or more offices.

Cost filters tab

Click the Cost filters tab. In this tab you specify filters for the cost records themselves.

  1. Click one or more checkboxes to specify which type(s) of costs should be included.
  2. Click one option to filter the value of the cost: non zero, zero or any.
  3. Click one option to filter the billable status of the cost.
  4. Click one option to filter based on the cost's invoice status. Choose between:
    • all costs,
    • unbilled costs,
    • billed costs regardless of whether the invoice has draft or finalised status,
    • billed costs with a draft invoice, or
    • billed costs with a finalised invoice.

  1. Click the Employee dropdown list and select costs added by one or more employees.
  2. Click the Team dropdown list and select one or more cost teams.
  3. Click the Office dropdown list and select one or more cost offices.

Other options tab

Click the Other options tab. In this tab you specify what should be displayed in the report. Most of these only relate to preview or print outputs, see below, except for the important option at T which also applies to grid outputs.

  1. Click the checkbox to show columns with time as a decimal value in the preview or print outputs.
  2. Click the checkbox to show columns with time as hours and minutes in the preview or print outputs.
  3. Click the checkbox to show columns with the amount charged in the preview or print outputs
  4. Click the checkbox to show columns with the base cost (employee base rate, which is set at the Employee List, multiplied by time worked) in the preview or print outputs.
  5. Select an option from the dropdown list to specify on what basis the report data should be subtotalled.

    6. Report data is first divided at the employee level. The value that you specify here is the secondary level of information and organisation in the report. If organisation of the data per employee is not desired at all, the report can be output to a grid or pivot grid or exported to a spreadsheet and then re-ordered as required.

    Examples of this option are shown at the top of this page.

  1. Click the checkbox to exclude tax from the cost amount displayed in the pivot grid, preview or print outputs.
  2. Click the checkbox to include a cost adjustments column in the preview or print outputs.

Report output options

Report data can be output to a number of formats. You can choose:

  • Preview

    • This uses a template to display the report data on your screen. The information you selected at the checkboxes in the Other options tab is displayed.

    A standard template is applied and there are several style sheets you can select at the Print Options tab. The template can be modified by clicking Edit Layout at this tab and editing it with the Report Designer.

  • Print

    • This prints the report seen in the Preview option above.

  • Grid

    • This displays all the data as a grid, with powerful grid functionality allowing you to order, display, filter, search, sort, print and export the report data.

  • Pivot Grid

    • This displays all the report data as a pivot grid. Here column headings (fields) can be dragged into different positions in order to sort and total the data as desired. This kind of grid is more powerful than an ordinary grid because the report data fields can provide customisable rows as well as columns. This grid can also be filtered, printed or exported to an Excel file. See Pivot grids for full details.

General notes

When reporting employee statistics:

  • At Filters select cases where the Assigned to is All Employees because there may be costs that an employee has billed to cases where s/he is not the Assigned to employee for the case.
  • Similarly be aware that a cost can be billed by a different office or team, for example when someone is doing work on a case for a different office or team.
  • Display both billable and non billable costs.
  • To produce the same data as the Time sheet, you need to select cases at the Filter tab where the Assigned to is All Employees and ensure that only billable costs are selected at the Cost filters tab.

Cost date and invoice date

It is important to be clear about the difference between selecting between the cost date and the invoice date when filtering costs by date. This is best explained with simple examples.

For the first invoice, the invoiced costs report results for June 2018 would be $150, regardless of which date (cost or invoice) was selected. That's because both the invoice and the cost were created in June 2018.

However, for the invoice below, the invoiced costs report results for June 2018 would be different for each option.

If invoice date was selected the result is 120 + 200 = $320.

If cost date was selected the result is only $200. The $120 Accommodation cost was added in May and would not be included.

This difference means that if you want to compare the results of the Sales Summary report with the Employee Charge Statistics report you should select the invoice date.

Note also that counter intuitive invoices like the example below may account for comparison discrepancies when the cost date is used. Here the invoice date had been set to earlier than the cost date.