Firm Performance Dashboard

The Firm Performance Dashboard provides a visual reference of your Firm’s performance in areas such as billable hours/dollars, billed dollars and AR Relieved. Aged AR and Aged WIP information is also available and a Firm Summary providing some firm wide performance indicators is available.

Firm Performance Dashboard Button

20.png

21.png

When you first access the Firm Performance Dashboard, the data represents your Firm as a whole. To view data for an individual Responsible Attorney, choose their ID from the Responsible Drop Down. The Firm Summary Chart will not change but all other Charts will change to reflect performance on that ID only. The option to Show Summary Tables toggles the Summary Tables located under the Billable and Billed Chart and the Accounts Receivable Relieved Chart on and off. The Show Labels option toggles on and off the values represented by each month and/or series. The As Of Date is the date and time the data was captured by the summary compiler that runs on your server. The time of day and frequency at which compiler is run is determined by your accounting department.  NOTE: Compiler will normally be run at night so your Dashboard may not reflect data entered in the system during the current day.

Firm Summary Chart                                                             

Following is an explanation of each section of the Firm Performance Dashboard:

23.png

The Firm Summary section provides an “at a glance” view of the Firm’s performance for the current month, current year and last 12 month period.

Field Description
Cash Balance

Cash balance for operating accounts. Accounts to be included in this are determined in Accounts Payable Bank Setup.

Open Vouchers Posted but unpaid vouchers on operating accounts. Accounts to be included in this are determined in Accounts Payable Bank Setup.
Billable Dollars Total Billable Dollars entered in the system.
Average Rate The average rate at which billable time has been entered in the system. This number is calculated by taking total billable dollars and dividing by total billable hours.
Billed Dollars Total Dollars Billed on Billable Matters.
Average Billed Rate

The average rate at which time was billed. This number is calculated by dividing billed dollars by the original hours billed.

Fee Payments Total payments applied to fees (payments, retainers applied as payment and trust applied as payments). This number does not factor in reversals.

Average Collected Rate

This number is calculated by dividing total fee payments by total billable hours worked during the same time frame.
Fee CR/WO

Total write offs and credits applied to fees.

Average CR/WO

This number is calculated by dividing total Fee Credits/Write Offs during the last 12 months by 12.

Total Fee WIP Total unpaid fees.
Average Unbilled Days This number is calculated by dividing Total Fee AR by the average daily billings for the last 12 months. Average Daily Billing is calculated by taking Billed Dollars for the Last 12 Months and dividing by 365.
Total Fee AR Total unpaid fees.

Average Uncollected Days

This number is calculated by dividing Total Fee AR by the average daily billings for the last 12 months. Average Daily Billing is calculated by taking Billed Dollars for the Last 12 Months and dividing by 365.
Matters Opened Number of Matters opened during the specified period.
Total Open Matters Total open Matters.

Billable and Billed Chart                                                             

24.png

The Billable and Billed Chart allows you to view and compare Billable Dollars for this year and last year or Billed Dollars for this year and last year. The Billable Dollars values are based on Fee Transaction Date. The Billed Values are pulled based on Invoice Date - in other words, hours/dollars billed during the month regardless of when the time was actually worked. You can switch between Billable and Billed by choosing the option from the drop down in the chart. The Table below the chart lists Responsible Attorney Totals in order of highest to lowest based on year to date totals. If you have chosen to view the Dashboard for one Responsible Attorney rather than the entire Firm, that attorney will be the only attorney listed in the Summary Table. To view the Client‐Matter Detail for a Responsible Attorney, double click on their name and the list of their Client‐Matters will be displayed in order of highest to lowest based on year to date amounts. You may sort this list by clicking on any column header.

Accounts Receivable Relieved Chart                                                             

25.png

The Accounts Receivable Relieved Chart is a Stacked Bar Chart that shows Fee Payments and Credits/Write Offs separately for this year and last year. Credits/Write Offs appear at the top of each bar. Unlike many of the Productivity Reports provided you at month end, this Chart does not include reversals of previous month’s payments (if any). The Table below the chart lists Responsible Attorney Totals in order of highest to lowest for year to date payments. If you have chosen to view the Dashboard for one Responsible Attorney rather than the entire Firm, that attorney will be the only attorney listed in the Summary Table. To view the Client‐Matter Detail for a Responsible Attorney, double click on their name and the list of their Client‐Matters will be display ordered by highest to lowest year to date amounts. You may sort this list by clicking on any column header.

WIP and AR Chart                                                             

26.png

The WIP and AR Chart is a Pie Chart that allows you to toggle between Work in Process and Accounts Receivable and it provides a breakdown by aging category. The five aging categories are 0-30 days, 31-60 days, 61-90 days, 91- 120 days and Over 120 days. To view the Client‐Matter Detail for WIP or AR, double click on the chart and the list of Client‐Matters will be displayed ordered from the highest to lowest Total WIP or Total AR. You may sort this list by clicking on any column header.  

 

With the exception of the Firm Summary, charts may be individually printed by right clicking in the Chart and choosing the Print option.  You may zoom in on a section of the Chart by holding down your left mouse button and dragging to the right. To un-zoom, drag to the left. You may move the chart data up and down by using the scroll button on your mouse. You may move the chart data to the left or right by holding down the right mouse button and dragging to the left or the right. Changes you make are NOT saved so exiting the Firm Performance Dashboard will revert it all back to the system defaults.

Was this article helpful?

/