The Client Profitability Report provides a wealth of information that provides real insight into KPIs (Key Performance Indicators) for your firm. You can see how your firm is performing on work billing and collections. You can glean performance on staff, clients, and practice areas.
The report summarizes the work performed, what has been billed, and what has been collected. These totals are calculated to provide both a billing and collection realization rate.
|NOTE: This report can NOT be run on a fee earner or timekeeper basis. Please submit a product feature request by raising a support ticket if you think this would be beneficial.|
You can find this report by going to Reports > Billing Reports.
There are Basic options to quickly display report information. There are also Advanced options for more granular filters and layout options.
|WIP and Invoice Date range||Provides options for a range of dates. This will control which items are used in the report figures. The only invoices and time/fee entries that will be considered on the report are items that fall between the first and second selected dates.|
|Responsible lawyer||Allows the selection of one or more responsible lawyers. This will filter the report to only items attributed to matters where the selections are the responsible lawyers. Leaving this field blank will allow the report to display information from matters, regardless of the user with the responsible lawyer designation.|
|Show matters with no AR|
By default, the report will not display information for matters with no AR and WIP. Selecting this option will allow the report to display information from matters that have been billed in the past but currently have no AR.
|Show matter detail||Toggles the display of matter tables. When this is on, a table will be displayed for each matter. This toggle can be useful to expose matter details or hide them to only reference summaries.|
|Show firm summary||Toggles display of Firm summary table. When this is on, a table will display, totaling all items that are filtered for the report to take into account. Turning this off will hide the firm summary table.|
|NOTE: See Understanding the Output of the Client Profitability Report section further down this article for description of the information displayed in the tables listed above.|
|Matter type||Filters the report to display only information from the selected matter type(s).|
|Matter||Filters the report to display only information from the selected matter(s)|
|Client||Filters the report to display only information from the selected client(s)|
|Bill type||Filters the report to display only information from the selected bill type(s)|
Filters the report to display information based upon whether the matter utilizes eBilling.
All will display any matter regardless of whether it uses eBilling. Enabled filters for only matters with eBilling. Disabled filters to matters not using eBilling.
|Exclude unbilled items||If this toggle is On, the report will not display unbilled values, and those values will not be factored into any figures. By default, this option is Off, which allows the report to display values of unbilled entries.|
|Show matters with no data||This option works in conjunction with the Basic option Show matters with no AR. When Show matters with no AR and Show matters with no data are On, even matters that have no bills or associated hours/fees will be shown on the report. This can be useful to see specifically which matters have no associated work.|
|Show client summary||Toggles the display of client summary tables. A table is displayed per client that includes only information for matters with that client.|
|Show matter type summary||Toggles the display of tables that display information per matter type. Each matter type's information will be displayed in its own table.|
|Show bill type summary||Displays tables by the billing arrangement set in the matter billing options. There can be separate tables for Hourly matters and Fixed fee matters.|
|Sort detail by|
Controls the order which matter detail tables display on the report.
|Note:See Understanding the Output of the Client Profitability Report section further down this article for description of the information displayed in the tables listed above.|
On screen (HTML)
|This option displays the report results on your current screen|
|This option launches a print dialog from a PDF version of the report. To download as PDF, select Save as PDF in the Print > Destination dropdown on the print dialog screen.|
|This option downloads an xlsx, MS Excel, file to your computer. This is a great option to perform further calculations in a spreadsheet format.|
Save XLSX file to a matter
After you have selected to run the report in MS Excel you can choose to save the XLSX file directly to a matter using this button.
Save PDF file to a matter
After you have selected to run the report in PDF you can choose to save the PDF directly to a matter using this button.
|Note: Using the three output options will generate the same information in the selected format. For the purposes of this explanation, we will use images from the On Screen (HTML) output.|
|Reload||This button will re-generate the report. This can be useful if changes are being made while viewing the report to see difference between before and after the changes.|
|This will launch your browser's print dialog. The behavior and display of the dialog is dependent upon your browser and workstation settings.|
|Excel||Downloads the report in xlsx format|
|Downloads the report in PDF format|
|Show settings button||Displays the configuration options for the report. Once displayed, the configuration options can be hidden by selecting the Hide settings button|
|WIP and Invoice Date range||Displays the date range, selected in the configuration options, for information displayed on the report.|
|Sort detail by||Displays the Sort detail by option selected in the configuration options.|
|Layout options||Displays which layout options have been selected in the configuration options.|
|Generated stamp||Displays the name of the user who generated the report, as well as the date and time the report was generated.|
Each table has the same columns. The values are determined by the type of table. The table types are defined in the next section.
The Items column contains the row designations for the table. Each item is the category for all subsequent information in that row.
|Work Unbilled - Hours||The number of hours that have yet to be billed|
|Work Unbilled - Value||The monetary value of the unbilled hours|
|Work Billed - Hours||The number of hours that have been billed|
|Work Billed - Value||The monetary value of the billed hours|
|Work Total - Value||The summed values of unbilled and billed hours|
|Billing - Billed||The total fee value that has been billed|
|Billing - Adj. Amt||The total fee adjustments on bills|
|Billing - Discount||The total discounts applied to bills|
|Billing - Total||The total value of billed fees +/- adjustments - discounts|
|Billing - Write-Off||Any write-offs that have been applied to the billed items regardless of the date of the write-off|
|Effective - Unbilled Hr $|
The average rate of unbilled hours.
Calculated as Unbilled value/unbilled hours
|Effective - Billed Hr $|
The average rate of billed hours, after taking into account adjustments, discounts and write-offs.
Calculated as (Billed value +/- adjustments - |discount|)
|Billing - Realization|
The percent of fees/expenses billed against unbilled fees/expenses minus any negative adjustments, discounts, and write-offs.
(Unbilled items +/- |fee adjustments| - |discount| - |write-offs|) / (Billed items + unbilled items)
|Collection - Paid|
The amount of billed items for which payments have been received
|Collection - Realization|
The percentage of billed items that have been collected.
Paid amount divided by (paid + AR)
|Collection - % Collected|
Percentage of Paid amount against paid amount plus AR.
Paid amount / (paid amount + AR bal)
|Collection - AR Bal|
The amount that has been billed but not yet collected
|Matter Detail (Basic)|
The Matter Detail table displays the profitability information for a specific matter. The header above the table provides the following information:
|Firm Summary (Basic)|
The Firm summary table provides profitability information for all items for which the report is currently filtered. The header above the table provides the following information:
|Client Summary (Advanced)|
The Client Summary table displays profitability information across all bills and matters associated with that client. The header above the table provides the following information:
|Matter Type Summary (Advanced)|
The matter type summary table provides profitability information for all matters of a specific matter type.
The header above the table provides the following information:
|Bill Type Summary (Advanced)|
The bill type summary table provides profitability information by bill type. If multiple bill types are used in the system, a table will be created for each. The header above the table provides the following information:
Was this article helpful?
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
We appreciate your effort and will try to fix the article