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

A/R report for one attorney's matters

rated by 0 users
This post has 5 Replies | 0 Followers

Top 75 Contributor
Posts 60
.CIC
BM CIC
PCL CIC
TM CIC
Mike Lenoir Posted: Wed, Jun 28 2006 8:42 PM

V7

The user wants A/R for one attorney only and matters that have non-zero balances.

Can this be done?

The A/R Summary, which only shows people that owe money, can't be filtered by Matter|Staff or Matter|Originating attorney.

The Aged A/R Report can't be filtered by Staff or Orig. It can be sorted by Orig but then it shows all matters, even ones without balances.

Thanks.

Mike Lenoir

 

 

Mike Lenoir
Matrix Solutions, Inc. Brandon, MS

Top 25 Contributor
Posts 353
.CIC
BM CIC
BMP CIC
PCL CIC
TM CIC
WS CIC
Have you tried using a matter Quick Tab filtered by Staff = the attorney, and Balance > 0, which can be printed, if necessary.

Robert S. McNeill, J.D., Time Matters-Billing Matters-PCLaw CIC, Moderator

OTB Consulting-2009 and 2010 Lexis Platinum Achievement Award-Top Time Matters Producer

Top 50 Contributor
Posts 110
.CIC
BM CIC
BMP CIC
TM CIC

To expand on Bob's recommendation, you can create a custom list view of the Aging fields and then create a filter to show a case/matter only if the balance is greater than 0.  You can them future select or filter by the responsible staff. 

Print using the Custom List. 

 

Sandra H. Adams, (CIC/Moderator) Strategic Legal Technology Consulting, Inc.

Top 10 Contributor
Posts 467
.CIC
BM CIC
BMP CIC
TM CIC

I'd like to add two items to the good responses already provided. As noted, you can create a matter list that includes columns for balance, current, 30 days, 60 days, etc., which represent the aging invoice balances due to the firm. If you filter by a particular staff, (staff field on matter, originating, responsible, etc.), you can tag the records, and click the 'send to Excel' button. (If you don't have the button, check user level settings for matter list toolbar.) In Excel, you can format as dollars, and use that auto-sum button to add the columns and get a report quite quickly. Another option is to download and use the reports package from the Time Matters website. There are many reports available as transfer files for you to import and use in your Time Matters. You can then use the same tag records approach. Filter for the records you want, tag them, click the print button, and select the desired report. Only the tagged records' values will be included in the report. If you feel especially adventuresome, you can modify the report to add sort and sub-total levels.

Kathy Burger PREMIER LEVEL CIC - PCLaw, Time and Billing Matters Plus Certified Kathy Burger Consulting, LLC 200 Windward Ave. Beachwood, NJ 08722 732-279-6301 Kathy@KathyBurgerConsulting.com

Top 50 Contributor
Posts 124
.CIC
BM CIC
BMP CIC
PCL CIC
TM CIC

I would add another suggestion - do the quick tab on the matter list for the balances you want to show (I usually do billable =yes and balance is greater than and less than 0 depending on how they do retainers. On the TM website are a bunch of feature packages that let you do reports - grab the A/R report - while it's a little bit of a pain, you can go to your balances tab, tag the records and print the report through the regular tm print. It's a bit easier for most people than having to do additional steps in excel.

hope this helps

Carol

Carol L. Schlein, Esq. Law Office Systems, Inc. Montclair NJ 973.746.6454 carol@losinc.com www.losinc.com Time Matters/ Billing Matters/ PCLaw CIC /Timeslips Certified Consultant

Top 75 Contributor
Posts 60
.CIC
BM CIC
PCL CIC
TM CIC

Great suggestions! The quick-tab with filter along with a canned A/R report did the trick!

Thanks for the help.

 

Mike Lenoir

 

 

 

 

Mike Lenoir
Matrix Solutions, Inc. Brandon, MS

Page 1 of 1 (6 items) | RSS