Best Practice: Law firm finances - the Monday Morning Report
Asked and Answered
By John W. Olmstead, MBA, Ph.D, CMC
Q. 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.
A. 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:
- Cash in bank balances for each account
- Bills due this week (vendors, payroll, taxes, draws)
- Anticipated payments from clients (new engagement retainers - flat fee and time bill)
- AR Balance
- Work in process balance
- Number of new retained matters for the month
- 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, (www.olmsteadassoc.com) is a past chair and member of the ISBA Standing Committee on Law Office Management and Economics and author of The Lawyers Guide to Succession Planning published by the ABA. For more information on law office management please direct questions to the ISBA listserver, which John and other committee members review, or view archived copies of The Bottom Line Newsletters. Contact John at jolmstead@olmsteadassoc.com.