Skip to main content
All CollectionsReportsStatistics reports
Billed Fees - Average Rate & Efficiency
Billed Fees - Average Rate & Efficiency

Statistics reports

Collaboratrice Virtuelle avatar
Written by Collaboratrice Virtuelle
Updated over 2 years ago

Before you begin: Note that additional permissions to your access profile may be required to perform the following steps. We invite you to validate your access with your software administrator.


This report displays the value of transactions invoiced for a given period in different variations.

Very relevant for performance analysis and to know the fee variations between the values entered in the activities and the actual post-billing result.

6 versions are available

  • Detailed statistics (Detailed by transaction grouping by employee)

  • Monthly statistics by employee (Summary by month)

  • Statistics by employee (Summary)

  • Statistics by client (Summary)

  • Statistics by responsible for the matter (ERD) (Summary)

  • Statistics by responsible for the client (ERC) (Summary)

Time, fees and adjustments are shown separately for hourly and fixed fee matters.

The last columns of the report show the values of the credit notes and write-offs followed by the efficiency calculations for the net fee in $ and the value in %. The average billing rate is also calculated.

Thus, this report can be visually divided into 4 sections;

1. Calculations related to matters billed at an hourly rate (including Legal Aid)

2. Calculations related to matters billed at fixed fee

3. Calculations for Credit Notes and Write-offs

4. Fee, efficiency and average rate results


Calculations related to matters billed at an hourly rate

(including Legal Aid)


Time column

All hours recorded in billable fee activities billed in the requested reporting period.

Fees Column

All fees $ recorded in billable fee activities invoiced in the requested reporting period.

Adjustment column

Adjustments made by the user to change the value of the fee.

There are several types of adjustments that can influence this report.

Elements that may constitute the value of the fee adjustment for these matters:

  • Billing adjustments

  • Cancellation of work in progress **

  • Manual adjustment of the value of an activity

% colomn

Represents the percentage increase or decrease in the hourly rate

Example of an increased rate

  • Fee value(B) of $1,050.00 ÷ per 7 hours(A) = hourly rate $150.00

  • Adjustment Value(C) of $230.00 + Fee(B) of $1,050.00 ÷ per 7 hours(A) = Adjusted Hourly Rate of $182.86

The hourly rate* of $182.86(E) represents an increase of 121.90%(D) over the hourly rate of $150.00

*Rate column

This is the adjusted hourly rate established by the value of the fee(B) +/- the adjustment(C) ÷ the number of hours in the Time(A) column.


Calculations related to matters billed at fixed fee


The behaviour is identical for the calculations at the level of fixed fee matters.

The only difference is in the adjustments.

Adjustment column

  • Difference between the actual value of the fees included in the invoice and the value invoiced as a fixed price.

If the value of the adjustment is negative, this may demonstrate that the fixed fee matter is being charged at a loss.

Example of a loss

$3,982.50(B) +/- $3,632.50(C) = $350.00 is the invoiced fixed value on a fee of $3,982.50


Calculations for Credit Notes and Write-offs


Credit note column

Represents the value of credit notes affecting the employee on a pro-rata basis of fees credited based on invoices subject to distributions.

Write-off column

Represents the value of bad debt wrtite-offs affecting the employee on a pro-rata basis of fees written off based on invoices subject to distributions.


Fee, efficiency and average rate results


Net Fees column

The value of net fees is the sum (section 1 and 2) of fees billed(B) and adjustments(C) .

From this sum, Credit Notes(F) and Bad Debt Write-offs(G) are subtracted.

This is the total fee generated by the employee for the period analysed.

Effenciency% column

This is an assessment of the realisation of the fee.

A value of more than 100% indicates a higher billing than the recorded fees billed.

Efficiency = Net fees(H) ÷ by Billed fees(B) (section 1 and 2)

Everage rate column

In the same idea as efficiency, the average rate allows to know the increase or decrease in the value of the rates used for the fees charged.

It would also be relevant to identify it as Net Billing Rate.

Average billing rate = Net fee(H) ÷ Time(A) (section 1 and 2)


**

Cancellation of work in progress only affects the Time, Fee, Adjustment and Average Rate columns.

It has no impact on Net Fees and Efficiency because in practice, when WIPs are cancelled, the adjustment is always equal to the cancelled fees.

The time of the cancelled WIPs is considered. The average rate is therefore influenced by the cancellation of Work in Progress.


Depending on the version of the report used, the information may be presented differently visually and some columns may be hidden.

Did this answer your question?