CIC Solutions Forums
Certified Independent Consultant Solutions Forums for
LexisNexis® Practice Management Products
Time Matters - PCLaw - Billing Matters - Browser Edition - HotDocs

Matter classification report

rated by 0 users
This post has 1 Reply | 0 Followers

Top 500 Contributor
Posts 1
Dera Pease Posted: Thu, May 10 2007 4:07 PM

I would like to run a report that showed income/fees billed received in the matter classification code areas (estates, personal injury, etc).  How can I accomplish this?

Thank you

Practice Advantage 8.0 

Top 10 Contributor
Posts 1,196
.CIC
BM CIC
TM CIC
Billing Matters does not have a standard report that totals fees billed by Matter Classification Code, but many firms are interested in this information. With the addition of Departments to Billing Matters, you can set up this report with some effort. You only have to go through the setup work once. As long as you assign Departments to new Matters as you add them, you can run the report showing billed fees and billed hours any time.

First, decide on the Departments or practice areas you want for your reports. Group your Matter Classification Codes into Departments. For example, you might group PINJ-Pers Injury and PIA-PersInj Auto together in a PI-Personal Injury department. EST-Est Planning and PROB-Probate might go into another Department, EP-Estate Planning & Probate.

Create a Department for each one:
Main Menu | Setup | Accounting Options | Departments

Create a Billing Preferences Template for each Department. If you already have templates for some or all of your classifications of Matters, it is a good idea to modify them instead of adding new Templates.

Create a new Billing Preferences Template for EP-Estate Planning & Probate (or modify each existing Billing Preferences Template that you use for these Matters).
Go to: Main Menu | File | Setup | Templates | Billing Preferences
On the Accounts Receivable tab, select the corresponding Department.
Repeat these steps for each Department.

Next, assign Departments to your existing Matters. Go to the Matter List and filter it to show all the Matters in your first Department, EP. To filter the Matter List:
Go to Main Menu | Search | Classification Codes
Press the lookup button and select each of the codes for your first Department.
Tag all these Matters.

To set the correct Department for these Matters:
Main Menu | Process | Change Billing Preferences
Select the proper Billing Preferences Template in the first field.
Scroll down to the bottom of the Available Preferences and select Dept, the fifth from the bottom.
Press OK.

Repeat this process for each other Department by filtering, tagging and processing the Matters. Once your Matter are assigned to Departments, you can run reports by Department.

To run a Standard Report that shows billed hours and billed fees by Department:
Go to: Main Menu | Reports | Standard Reports | Staff | Profitability
On the Filter tab, select the time period you want in Date Range.
Press Preview.

The Profitability Report by Department by Staff shows statistics on Fees and Hours, with subtotals for Departments and for Staff. The numbers included are:
Fees Worked   Billed Value   Profitability %      Hours Worked   Hours Billed   Eff. Bill Rate

To show amounts paid by your clients in each Department as opposed to amounts billed is another matter. Hopefully the two numbers are equal and you won't need another report!

If you do need the numbers for amounts received by Department , you can run another Standard Report once for each Department:
Go to: Main Menu | Reports | Standard Reports | Transactions | Receipt Allocation Report
On the Filter tab, select the time period you want in Date Range.
Also on the Filter tab, select a Department.
On the Options tab, select Staff.
Press Preview.
Repeat for each Department.
You can save the report settings so that you do not need to set them each month or quarter when you want to run the reports.

The Receipt Allocation Report shows statistics for fees and expenses that were billed and those that were paid.

As you add new Matters, be sure that each one is assigned to the correct Department. Selecting a Classification Code will not do that automatically. You need to apply a Billing Preferences Template that assigns the Department or select the Department manually on the Accounts Receivable tab of a new Matter's Billing Preferences.

Wells Anderson, JD, CIC / Moderator
800.575.0007 - Edina, MN - © 2012
www.activepractice.com
Free Time Matters Webinars monthly on the second Friday

Page 1 of 1 (2 items) | RSS