Additional Filter

By default, the Legal Spend Metrics widgets compare the two previous years data. Use the KPI Year filter to change options.

The following table describes the KPI Year options:

Option	Description
Current Year	The KPI widgets compare current year and previous year data.
Previous Year	The KPI widgets compare previous year and the preceding year data.

Amount Billed: The sum of the amount billed minus credits and discounts on the current year (left) and previous year (right). The calculation is a percent change. The sum of the amount billed of the current year is calculated as follows:

$$B_c = (A_1-C_1-D_1) + (A_2-C_2-D_2) + ... + (A_n-C_n-D_n)$$where $$Bc​ is the sum of the amount billed of the current year,
$A$ is the amount billed,
$C$ is the credit,
$D$ is the discount.
The sum of the amount billed of the previous year is calculated as follows:

$$B_p = (A_1\prime-C_1\prime-D_1\prime) + (A_2\prime-C_2\prime-D_2\prime) + ... + (A_k\prime-C_k\prime-D_k\prime)$$where $$Bp is the sum of the amount billed of the previous year, $A\$$prime$ is the amount billed, $C\$$prime$ is the credit and $D\$$prime$ is a discount.
The percent change is calculated as follows: $$P=\frac{100(B_c-B_p)}{}$$

Additional Filter: Select Previous Year in the KPI Filter to compare the previous year with the year before.

Cases Billed: The cases count on the current year (left) and previous year (right). The calculation is a percent change. The percent change is calculated as follows:

$$T=\frac{100(C_t-C_p)}{}$$where $$Ct​ is the case count of current year
and $$Cp​ is the case count of previous year.

Additional Filter: Select Previous Year in the KPI Filter to compare the previous year with the year before.

Avg. Case Cost: The average amount billed per case minus credits and discounts on the current year (left) and previous year (right).

The average amount billed of the current year is calculated as follows: $$\overline{B_c} = \$$where $\overline{B_c}$ is the average amount billed of the current year,
$A$ is the amount billed,
$C$ is the credit,
$D$ is the discount.
The average amount billed of the previous year is calculated as follows: $$\overline{B_p} = \$$where $\overline{B_p}$ is the average amount billed of the previous year, $A\$$prime$ is the amount billed, $C\$$prime$ is the credit and $D\$$prime$ is the discount.
The percent change is calculated as follows: $$P=\frac{100(\overline{B_c}-\stackrel{}{B_p}}{}$$

Additional Filter: Select Previous Year in the KPI Filter to compare the previous year with the year before.

Invoice Count: The number of invoices for the current year (left) and previous year (right). The calculation is a percent change. The percent change is calculated as follows: $$I=\frac{100(I_t-I_p)}{}$$where It is the invoice count of current year
and $$Ip​ is the invoice count of previous year.

Additional Filter: Select Previous Year in the KPI Filter to compare the previous year with the year before.

Avg. Processing Time (Days): This KPI widget counts the number of business days that took each of the invoices to go from status Received to status Finalized reported as an average. Excluded days are weekends, holidays, and days when the invoices were in the law firm or client review queue. The average processing time for the current year shows to the left and the average processing time for the previous year shows to the right. The calculation is a percent change.

The average number of days for the current year is calculated as follows:$$\overline{D_c}=\frac{{\mathrm{(d}}_1+d_2+\mathrm{.}\mathrm{.}\mathrm{.}+dn)\; /\; n}{}$$

​​where dn​ represents the number of days for invoice $n$. Similarly, the average number of days of the previous year is calculated as follows: $$\overline{D_p} = \$$The percent change is: $$T = \$$

Additional Filter: Select Previous Year in the KPI Filter to compare the previous year with the year before.

Additional Filters

Apart from the main filters, use the Invoice Status Start and Invoice Status End filters to select the time frame. Data is limited to the last five years, so even if you choose a period of time that spans more than five years, the data displayed will be limited to five years.

Note: The Invoice Status Start and Invoice Status End filters apply to all widgets under Law Firm Analysis except for the Approved Hourly Rate by Position widget.

Top 10 Law Firms by Amount Billed: The sum of the amount billed minus credits and discounts. Invoices counted are the ones set in the main filter. The KPI widget shows Net Amount Billed, Recommended Adjustments, and Realized Adjustments for the top ten law firms that contributed to the amount billed. The remaining law firms are grouped as Other at the bottom.

Approved Hourly Rate by Position: This KPI widget shows all available positions for a client. Each position belongs to several law firms. Next to the law firm is the average hourly rate for that position. The average hourly rate is based on all received invoices in the last 18 months.

Top 10 Adjustment Categories by Realized Adjustments: This chart shows the top ten categories that had the highest fee adjustments. The rest of the categories are grouped as Other.

Note: If Recommended Adjustments is greater than Realized Adjustments, or Recommended Adjustments is a negative amount, it is due to In-House adjustments. For more information, see Known Issues.

Additional drill down option: Use the down-arrow to drill down the analysis by law firm.

This option shows the top law firms that contribute more to adjustments.

Hover over a law firm to see the exact amounts.

Use the up-arrow to return to the analysis by categories.

Activity Analysis: This KPI widget shows the following data:

• The law firms that contributed to each fee category.

• Hrs. Billed shows the total hours billed by each law firm for the Fee Category.

• % Hrs.Billed shows in which percentage each law firm contributed to all hours billed.

Additional drill down options: Click on the plus sign + to the left of a Fee Category to drill down the analysis by law firm.

The three dots icon  contains the following functions:

• Use Hide +/- buttons to remove the hide/show functionality. Note that this option takes a snapshot of the table as it is and you cannot show or hide the sections.

• Use Show +/- buttons to enable the hide/show functionality again.

Top 10 Expense Categories: This chart lists the top ten expenses. The rest of the categories that contribute to expenses are grouped as Other.

Approved Hourly Rate by Position: This KPI widget shows all available positions for a client. Each position belongs to several law firms. Next to the law firm is the average hourly rate for that position. The average hourly rate is based on all received invoices in the last 18 months.

Additional Filters:

Use the Timekeepers Positions filter to select the timekeeper positions (associate, legal assistant, etc.) that you want to include in the analysis.

Note: Approved Hourly Rate by Position: ignores the Invoice Status Start and Invoice Status End filters.

Flat Fee Analysis: Flat fees are analyzed as a different category and not compared to the rest of the expenses. This chart only shows data if flat fees are relevant.

 

Additional drill buttons: Use the down arrow to drill down the analysis to view matter details by law firm.

The result is the analysis by matters:

Hover over a bar to see to which law firm the matter belongs:

Note that the chart shows the top ten matters that contribute to flat fees. The remaining matters are grouped at the bottom as Other.

Use the up-arrow to return to the analysis by law firm.