Recently, I have received many requests regarding CounselLink Reporting and more specifically the large cache of Standard Reports offered to CounselLink users. As a LexisNexis CounselLink Trainer, I teach clients how to run, manipulate and save these Standard Reports. If you are already leveraging the standard reports, you know they are a great place to begin. They can stand on their own or be modified and edited into a custom layout. But with over 60 standard reports, where does a person begin? Which reports are the most flexible? Which ones are good for daily operations and which ones are better for administrators and executives?
Let’s review some of the most helpful Standard Reports. I’ll preview a few and list others that provide a good start. All of the following reports are found in the Shared Reports folder on the reporting home page.
Reports for the everyday operation of CounselLink
The report prompts you to enter a date range for approved invoices and returns a robust report including approved amount, law firm, matter and invoice identifiers, allocation contacts and client office. This is where you should begin with invoice reports. It is easily modified to fit a wide variety of needs and audiences. Here are some ideas for modification:
- Using the date prompt as a variable, pull last year’s or the year to date spend. Add an invoice object called Invoice Approved Date (Month). Move the object into a row orientation or up into the page-by field to create a month over month report.
- Cut the report data back by removing all invoice and matter specific fields to show annual spend totals on a broader level, by office, by allocation or by law firm.
Invoice Aging or Unapproved Invoices by Owner
Close runners up for the most useful invoice report, these reports will pull all the invoices currently in CounselLink awaiting approval. These reports can help keep invoices from falling through the cracks. The two reports spotlight on slightly different objects. Invoice aging focuses on the age of the invoice. Unapproved Invoices reveal how long users hold invoices. These reports are ready to use with one click or can be easily modified.
Again, if you start anywhere with matter reports, this is the one. The report prompts for the customer office name and matter status and returns a full complement of matter and invoice details. By entering different prompt responses, this flexible report can be as inclusive or exclusive as you need. Here are some ideas for modification
- Leverage the prompt questions to focus the report on closed or active matters or make the report focus on one office or all of them.
- If you have them, add your own custom information field to the report to focus it on the information you find most important.
Other Useful Standard Reports:
- Summary of Approved Timekeeper Offered Fees: A summary report of approved timekeeper rates, billed rates and number of invoices.
- Timekeeper Rate History: Comparative report focusing on timekeeper rate changes. Broken down by Law firm & Fee Structure.
- Budget Report: A great basic report for those using budgets. Inclusive report with budget amounts, budget remaining and percent of budget spent.
- User Login Activity: Great for keeping up with CounselLink user access. This is a corporate User report detailing the number of logins and last login date.
Reports to help guide Corporate General Counsel
Top X Matters by Approved to Date Amount, Top X Law Firms by Approved to Date Amount, Top X Firms Average Hourly Rate
All three of these reports identify the top legal spend and help identify the law firms and matters where you spend the greatest amount of money. You get to decide if you want a top ten or a top twenty. You can also set the date range to pull from, a month, a year, many years or year to date. It’s up to you.
Law Firm Analysis, Budget Dashboard, Departmental Trends
These three are not reports, they are interactive dashboards. There is a quite a buzz stirring around these dashboards, which are optimized for your immediate use with the click of a mouse. If you want a deeper dive into the explanation, use cases and operation, access the recent Feature Friday broadcast. Use these dashboards to:
- Show an interactive breakdown of where spend is allocated.
- Compile a law firm rate analysis.
- View an interactive budget analyses by office, matter type and matter.
- Produce a quick view of legal spend trends, compiled by matter type, Office and Law Firm over the last three years.