Collection Realization Rates the Clio Way: Have you looked at yours lately
Wednesday, August 7, 2019
Collection Realization Rates the Clio Way: Have you looked at yours lately?
By: Peggy Gruenke, Owner CPN Legal
The financial health of your law firm—or any business—is ultimately dependent on three components:
1. Get the work: This means selling your product – yes, you are a salesperson disguised as a lawyer.
2. Do the work: The lawyering part of your job.
3. Get paid for the work: You have to collect money to actually earn it.
For all three components, you need to keep a steady stream into your business and also monitor your results to make sure your business is financially healthy. Envision a pipeline with a steady flow of water. A clog or a leak at any point in the pipe will affect the output of the entire pipeline. All three components work together to keep a steady flow.
Instead of waiting until an expensive clog develops, keeping an eye on the flow of your business will save you money and headache in the long run. Monitoring the flow is essential to making sure you are maintaining a profitable business. In order to keep an eye on things, you need meaningful metrics for profitability. For law firms, one key metric is something referred to as realization rates. There are two types of realization rates that come into play in the financial management of a law firm: Billing Realization and Collection Realization. Both of these metrics measure the amount of water that is getting through your pipeline.
With the growth of cloud-based technologies, the accessibility and collection of data has evolved significantly over the past decade. The truth of the matter is that 5 to 8 years ago a solo or small firm attorney simply did not have the law firm management products that are available today. So the concept of producing realization and profitability reports was simply out of the question due to resources needed to collected and compile meaningful reports and the amount of time it would take to sift through the data even if it was being collected.
Collection Realization Rates
I am going to start with the end in mind and talk about collection. With Clio you can track and measure your firm’s collection realization rates, revenue, and profitability. Your ability to collect what you billed is not only a financial indicator but quite often it is a measurement of your client’s satisfaction with the work product. So at the heart of it, the collection realization rate and the rate of payment is a direct correlation to your client’s level of satisfaction and your profitability. Happy clients pay their bills.
Focus on the overall health of your firm by increasing realization rates and monitoring expenses.
The collection realization rate is the simplest of realization rates to calculate. Just what is it and how do you use Clio to calculate and track this rate?
Your collection realization rate is the percentage of your billed fees which are actually collected.
Collected Fees/Billed Fees = Collection Realization
Once a bill is sent out using Clio’s new billing workflow, there are three possible outcomes:
1) The bills gets paid in full in one payment or over time (100% collection realization)
2) The bill gets partially paid with eventually a write-off of the unpaid balance (Less than 100% collection realization)
3) The bill never gets paid and it is a total write off (0% collection realization rate)
Using Clio to Get Your Data
In Clio, the data to calculate your collection realization rate is in a report called Revenue Report. With all of this great data at your fingertips, you can calculate the below collection realization reports for different periods of time: monthly, quarterly, and yearly.
1) Collection realization for the whole firm
2) Collection realization by responsible attorney
3) Collection realization by matter
4) Collection realization by client
5) Collection realization by billing type (flat fee vs. hourly)
6) Collection realization by practice area
7) Track your trends in each area with a chart
My suggestion is to create these reports monthly with YTD data by selecting the date range for current year. A monthly snapshot will exclude payments outside of your date range and thus will not be a true picture of collection activity.
The key to having all of the relevant data at your fingertips is sending the report to a CSV file. The CSV file includes more data than is on the report and you can sort the data to produce one of the above reports.
Once the data is exported, convert the file to an Excel format so you can work some magic with formulas and charts. The key columns of data you want for the purpose of collection realization are below. The columns in Yellow are added with formulas embedded. The formulas are using the data Clio provided in the report. In the example below, Billing Type has been added. It is not currently in the Revenue Report but easy enough to add using a Clio Custom Field if this metric is important to you.
The below spreadsheet shows collection realization by matter and practice areas:
With these reports, the power of data is right at your fingertips – I love it! Give me an Excel spreadsheet and I can sort, sum, calculate, evaluate, and make decisions. You can’t argue with real numbers. The above spreadsheet shows the collection realization rate by individual matter and by practice area. Also note that Clio is separating Time value from Expenses: more good data for evaluating the firm’s ability to recover firm-paid client costs.
The spreadsheet below shows the collection realization rate sorted by responsible attorney. This may highlight a problem area you did not know existed. Mr. Jasper probably needs to improve his client selection, get more money up front, or do a better job of keeping his clients happy.
What is a good collection realization rate?
The goal for your firm-wide collection realization should be 90% or higher. Now that you have your realization data, you can create some “what-if” scenarios to visually see how focusing on improving your collection realization directly affects your revenue and profitability. You can also see the importance of digging deeper into the data and not focusing just on the firm-wide number. By looking at the data by practice area or responsible attorney, you can determine where to focus your efforts for improving your realization rate. In the above example, at the bottom of the spreadsheet you can see the effect of increasing your collection realization rate and it’s effect on revenue.
The one measurement I found rather interesting is the collection realization rate for hourly vs. flat fee work. For the data I’ve shown, I know that a large percent of the flat fees are collected up front. This is not a measurement of flat fee profitably – this topic is for another article. For the hourly work, this particular firm is not diligent about getting retainers up front. The numbers speak for themselves.
So What is the Data Telling You?
If you think of it in terms of dollars and cents, in this example the firm’s overall collection realization rate is 73%. You are collecting 73 cents out of every dollar you bill. 37% of all billed revenue is getting written off after the bill goes out the door. These write-offs could be a result of any of the below or a combination:
• Bills not getting out the door on a regular schedule
• Bills going out incorrectly
• Bad collection practices
• Dissatisfied clients because bills were late, bill were incorrect, or poor client management.
With Clio, you have the tools to help manage the first three scenarios using the new billing workflow and using the accounts receivable report and statements of accounts. The most successful billing and collection procedures are a result of delegating one person for getting the bills out and the money in the door. This person can set up workflows and processes they can manage and stay on top of. You can use Clio to help manage your collection process by keeping notes, assigning tasks, and using the new task lists for follow-up and sending regular reminders during the month.
A well-designed and -implemented collection procedure will help improve your collection realization rate and result in increased revenue. However, I have also found these tasks are not the best use of a lawyer’s time and resources. Billing and collections are two tasks that can be easily outsourced, especially if you are using cloud-based platforms.
Now that You Know Your Number, How Do You Make it Better
After creating your collection realization worksheet and monitoring it monthly, if you are below the 90% minimum level, here are some ways you can improve this rate:
• Create a firm-wide rule to request and collect an adequate advance fee deposit for every case. Now that you have data available to see the positive affect on such a policy, you can reward the attorneys who are following this rule.
• Get better at case/client selection and listen to your gut.
• Really look at what practice areas are most profitable and which ones are having a negative impact on collection realization.
• Make sure your written fee agreement details your expectations of payment, as well as what will happen if payment isn’t received timely.
• Bill timely and prepare bills that are easy to read.
• Develop, follow, and delegate a collections policy that goes into effect immediately when an account first becomes past-due.
If you are not growing your practice, the answer may not be to only market more. The answer may lie within realization data. Understanding the affect your collection realization rates have on your bottom line should be motivation enough to start monitoring and tracking these numbers today!
CPN Legal Blog
07/01/2020 - The Value of a Cash Flow Repor
10/11/2019 - Year End Collections: Tips for
08/07/2019 - Collection Realization Rates t
10/23/2016 - Year-end planning: Collect Dat
09/12/2016 - Year-end planning for lawyers:
07/14/2016 - The 6 Month Financial Checkup:
05/31/2016 - How to Ditch That Unprofession
05/28/2016 - Evolution of Marketing for Law
02/15/2016 - 5 Checklists to add efficiency
03/01/2015 - Implementing project managemen
02/09/2015 - Use LinkedIn’s Relationships T
01/04/2015 - Is 2015 going to be a profitab
01/04/2015 - Is 2015 going to be a profitab
12/09/2014 - Clio Turns Tasks into Processe
11/25/2014 - Back to Basics: 20 Tips to emp
11/23/2014 - Holiday season and networking
10/26/2014 - Lawyers, do you have a game pl
10/15/2014 - Collection Realization Rates:
10/12/2014 - Focus on managing processes, n
10/09/2014 - Would You Pass a Trust Account
10/09/2014 - The Evolving Role of a Paraleg
10/06/2014 - A Clio Workflow for Collecting
09/28/2014 - The Evolution of Online Market
09/24/2014 - Clio Emerges as a Platform not
09/13/2014 - Are you going to be left behin
07/31/2013 - Lawyers: Managing Your Online
07/17/2013 - If You’re Going to be on Linke
04/29/2013 - One Way to Differentiate Yours
04/19/2013 - More Favorite Products from 20
04/18/2013 - A Sampling of My Favorite Prod
04/14/2013 - Tips from ABA TechShow: iPad A
04/03/2013 - Headed to ABA LegalTech Show
02/10/2013 - LinkedIn Tips for Lawyers #1:
02/04/2013 - Thinking About Blogging – Just
01/07/2013 - IOLTA Tip #3: Properly Maintai
12/10/2012 - Tip #2: IOLTA/Credit Cards – N
11/27/2012 - Handling Credit Card Payments
11/12/2012 - Some random tips and ideas to
10/23/2012 - More WOW Tips for Retaining Cl
10/21/2012 - History of Social Media – Info
10/07/2012 - If You Give a Client a Cookie,
10/02/2012 - In the Stands or On the Track:
09/24/2012 - One simple change to create a
09/19/2012 - Attraction vs Retention Market
09/03/2012 - A Cyclist’s Perspective on Fee
08/12/2012 - Where’s the Money – Managing t
08/04/2012 - Where’s the Money – Keep a Reg
07/29/2012 - Where’s the Money – Another Pe
07/22/2012 - An Informed Client is a Happie