Fee Recovery Report

This report calculates the percentage of all fee recovered during a given date range. It shows you:

  • Fees billed in a given date range
  • Discounts and write-offs on the billed amounts
  • Collections on those bills through a specified date
  • Month-by-month comparison 

Using the filters provided you can choose to view the report by different criteria such as Matter Owner, Timekeeper, Client, Matter, Area of Law and more.

To access the report, go to Reports > Financial Productivity > Fee Recovery Report

Report Filters

  • Matter Owner: Choose all matter owners or a specific matter owner.
  • Party Role: You can run the report for the Originating Attorney, Responsible Attorney, Work Attorney or Other.
  • Party Name: All in this role or a specific party.
  • Timekeeper: Choose all timekeepers or a specific timekeeper.
  • Client: Choose all clients or a specific client. 
    • All clients: By default all active clients are included. To choose a specific client, uncheck this box and type in the client name. 
    • Active Clients Only: By default, only active clients are included. To include inactive clients, uncheck this box.
  • Client-Matter: Choose all matters or a specific matter.
    • All Client Matters: By default all active matters are included (unless filtered by client above). To choose a specific matter, uncheck all client matters and type in the matter name. 
    • Active Matters Only: By default, active and inactive matters are included. To only include active matters, check this box.
  • Area of Law: Choose all areas of law or a specific area of law.
  • Date Range: The date range options you have are Last Month, Last Quarter, Last Year, This Month, This Quarter, and This Year. You can also customize the date range to be covered in the report.
  • Group By: You can choose to group by Matter Owner, Timekeeper, Client, Matter, or Area of Law.
  • Show: Choose between summary or detail. The detail report allows you to choose to break out the data month by month or quarter by quarter.
  • Options
    • Include Hourly Matter Only: When checked, the report includes only hourly matters. Uncheck the box to include all matters, including Fixed/Contingent fee matters.
    • Include Discounts: Checked by default, uncheck to exclude discounts.
    • Include Change/Write-Offs: Checked by default, uncheck to exclude Change/Write-Offs amount.
    • Include Effective Rate: Checked by default, uncheck to exclude total paid by clients/total worked hours by timekeepers.
    • Include Hours Worked Categorization: When checked, you can choose from All, Billable, Non-Billable and No Charge total time spent on timecards. Time will be displayed depending on the firm configuration (Time Display Format) on firm settings. 
  • Print Options
    • Apply page break between items: Checked by default, uncheck if you do not wish to apply page break between items.

View/Download

You can click View to preview the report if you uncheck all the include options.  However, you can include the options when you download the report.

Note

The Fee Recovery Report can ONLY be downloaded in Excel format.

Learn more about generating reports.

Report Columns and Their Descriptions

Column 

Description 

Hours Worked 

Displays the total time spent on timecards, and can be categorized as Billable, non-billable and No charge if selected. Time will be displayed depending on the firm configuration (Time Display Format) on firm settings. 

Hours Billed 

Displays the total time invoiced. Time will be displayed depending on the firm configuration (Time Display Format) on firm settings. 

Billing Realization % 

Calculated as Hours Billed / Hours Worked. It is displayed as a Percentage. Can be more than 100% because the time billed on timecards can be more than time spent. 

Amount Billed 

It is calculated as Total Legal Fees (time entries fees) plus Write-off amount, if Any. 

Total Billed 

It is calculated as Total Legal Fees (time entries fees) minus discounts applied if any. 

Discounts 

Displays the Discount amount. Only if the User selects Show Discounts on the report options. 

Change/Write-Offs 

Displays the Change/Write-Offs amount. Only if User selects Show Change/Write-Offs on the report options. 

Amount Paid during Date Range 

Displays the amount paid from clients on the date range selected by the User

Fee Recovery % for Date Range 

Calculated as Total Billed / Amount paid during date range. It is displayed as a percentage. 

Total Amount Paid to Date 

Displays the total of the amount paid from clients in all dates 

Fee Recovery % 

Calculated as Total Billed / total amount paid. It is displayed as a percentage. 

Effective Rate 

Total Paid by clients / total worked hours by timekeepers. Only available if the User selects Show Effective Rate option 

Updated on May 1, 2023

Was this article helpful?

Related Articles

Need Support?
Can't find the answer you're looking for?
Contact Support