Law Practice Management Asked and Answered Blog

Category: Report

May 16, 2018

Law Firm Client Surveys – How to Collect and Report the Data


Our firm is a sixteen attorney firm in Chicago. Our marketing committee has been discussing implementing a client survey program. We are not sure where to start or how best to collect and report the data. Your thoughts would be appreciated.


Surveys can be used for a variety of purposes including the following:

I assume that you are planning on doing a client satisfaction survey in order to solicit feedback on how well the firm is meeting client needs, quality of services being provided, and additional needs that the client may have where the firm can provide services.

The type of survey will depend upon whether your clients are individuals or institutional clients such as corporate or governmental. If your clients are institutional I recommend that you conduct telephone structured telephone interviews with these clients using a interview questionnaire consisting of quantitative and qualitative questions. If you have a large number of institutional clients then you may want to consider conducting these interviews with your top fifty, twenty-five, or ten top clients and use a paper mail survey or online survey for the remainder. For individual clients you may want to use a paper survey or online survey for your entire database of individual clients and thereafter a paper mail survey or online survey at the conclusion of a matter. Another option would be to survey a random sample of your clients.

Once the surveys are completed – whether telephone interviews or paper mail or online surveys the questionnaires/surveys will need to be tabulated and provided in some form of a report. Some firms use two Excel spreadsheets – one for the quantitative responses and one for the qualitative/narrative responses for interview and paper mail questionnaires.  Then averages, percentages, and other summary statistics can be calculated for the quantitative responses. If you use an online survey service such as Survey Monkey the tabulation and the statistics will be done already for these surveys. If you have a Survey Monkey account you could also enter your interview questionnaire and paper mail questionnaires responses into Survey Monkey and use it rather than Excel. If you want more sophisticated statistical analysis you might want to look into statistical software such as SPSS which is sold and marketed by IBM.

Once you have summarized analyzed the questionnaires you may want to prepare a summary report document using your word processing software. Include the tabulation, statistical calculations, charts, etc. as attachments to the report.

There are several articles on our website – see links below – that discuss client satisfaction survey programs and how to get started.

Click here for our blog on client service

Click here for our article on client satisfaction

Click here for our article on client surveys 

Click here for our article on analyzing survey results

Click here for our article on developing your client service improvement plan

Click here for our article on tips for rewarding and recognizing employees

John W. Olmstead, MBA, Ph.D, CMC

Jun 06, 2017

Law Firm Collections/Retainer Management – Using a Retainer Follow-up Report


I am the managing partner of a nine attorney general practice firm in the Chicago suburbs. We practice in the areas of estate planning/administration and family law. While our estate planning and uncontested family law work is done on a flat fee basis our estate administration and contested family law work is time billed. We collect initial retainers for these matters but we fail to insure that the retainers are replenished. We are having accounts receivable collection problems as a result. I would appreciate your thoughts.


This is a common problem that I see in firms doing estate administration and especially family law. The best way of managing your accounts receivable is to have less in outstanding accounts receivable in the first place. You do this by staying on top of your retainer balances compared to your work in process and ask the client for additional retainer before the work in process exceeds the retainer balance. In order to stay on top of retainer replenishment you need to develop what I call a retainer replenishment report and have someone assigned to reviewing the report daily and advising responsible attorneys to contact the client when work in process has hit a certain threshold (percentage of retainer used). Some firm’s present the report at a weekly attorney meeting and determinations are made regarding additional retainers to request. Other firms assign the responsibility to the firm administrator to automatically bill for the additional retainer. It is also important to insure that ongoing work is managed in a way that an excessive amount of work is not committed to a matter until the additional retainer replenishment is received.

A retainer replenishment report is not a standard report in many billing systems. You may have to create a custom report in your billing system using a report writer or in a worst case drop a accounts receivable report to an Excel file and add in some columns for the other information.

Here are the suggested data fields/columns for such a report:

Responsible attorney
Client/Matter name
Retainer Balance (typically this would be the balance in the trust account)
Unbilled WIP Fees
Unbilled Cost
Total Unbilled WIP
75% Retainer Threshold
Amount Over/Under Retainer
Additional Retainer Requested
Total Amount Retainer to Bill (Amount WIP over retainer plus additional retainer requested)

Many family law firms have advised me that after learning the hard way they are now doing a good job at this and advising me that they have minimal accounts receivable issues.

Click here for our financial management topic blog

Click here for our law firm profit improvement blog

Click here for articles on other topics

John W. Olmstead, MBA, Ph.D, CMC





Aug 17, 2016

Law Firm Financial Management – Monday Morning Report


I am the owner of a seven attorney firm in New York City. I have a bookkeeper that handles the accounting function. I receive monthly financial reports – but I believe I need a better tool to stay on top of my firm. I feel that I am lost, I don't want to take time to access different software modules such as our billing system, accounts payable system, general ledger system, etc. to get the information that I need to effectively manage the firm. We use Timeslips for billing and QuickBooks for bookkeeping. I would appreciate your thoughts.


I hear what you are saying. Most software program are good at giving you reams of paper in the form of reports but not so good at giving you the summary reports you need. Software companies are beginning to develop dashboards in their systems but the lower end systems do not give you what you need. You might consider tasking your bookkeeper with providing you with a Monday Morning Report (created in Excel) every Monday morning with the following summary information:

  1. Cash in bank balances for each account
  2. Bills due this week (vendors, payroll, taxes, draws)
  3. Anticipated payments from clients (new engagement retainers – flat fee and time bill)
  4. AR Balance
  5. Work in process balance
  6. Number of new retained matters for the month
  7. Total billable hours for each timekeeper (month and year to date)        
If after reviewing the Monday Morning Report you have questions ask for a more detailed report.

Click here for our financial management topic blog

Click here for articles on other topics

John W. Olmstead, MBA, Ph.D, CMC


    Subscribe to our Blog