Matter Spend Analytics Dashboard
TeamConnect Business Intelligence provides a number of starter dashboards. These dashboards can be tailored to your individual requirements, as they may not work with your system without customization, and you may need to remap certain fields based on your data model.
Note: The Matter Budget Insights feature is not necessary to utilize this dashboard, which is designed for embedding within matter records.
The minimum version that supports this starter dashboard is TCE 6.3.5 and TCBI 6.3.7
Introduction
The Matter spend analytics dashboard provides valuable information. Enhance your matter with an optional report that provides detailed spend insights, empowering you to make informed decisions about remaining budget. This dashboard addresses the following key spend metrics for the matter:
- The percentage of spend by each vendor
- The percentage of spend by the top 10 task codes (fees and expenses)
- The spend over the last 12 months based on invoice net total amounts
The Matter spend analytics dashboard offers a more intuitive and user-friendly presentation of matter spend data, currently available in TeamConnect's Budget tab. This feature provides visualizations that enable informed financial decision-making and to minimize unnecessary spend. This template shares similarities with other starter templates and it is provided as an additional option for clients to use and customize according to their specific needs.
This report provides matter-specific spend data based on posted invoices and built from the accounts tables which contain spend information already normalized to the base currency.
Spend by vendor: This pie chart shows the percentage of spend by each vendor for this matter.The Spend Analytics Report allows you to understand the spend by vendor, helping you to identify which vendors are spending the most.
Spend by Task Code (Top10): This pie chart shows the percentage of spend by the top 10 highest task codes (fees and expenses) for this matter. This helps in gaining insights into vendor spending habits with a detailed breakdown of spend by task code, enabling you to make informed decisions about vendor expenditures.
Spend: Trailing 12 months: This linear trend chart shows the spend for this matter over the last 12 months based on posted invoice amounts. By monitoring matter's spend trend whether spend is rising, falling, or holding steady enables you to make informed budget decisions.
Detailed specifications
| Widgets | Parameters | Obeys Dashboard filters | Representation |
|---|---|---|---|
|
Spend by vendor |
Categories: Invoice / Invoice Vendor Values: Account / Account Total Spend Widget Filters: Months in Invoice Line Item Service Date = Last 360 Days |
Yes |
Pie Type: classic Labels: Categories, Value, Percent Show 'Others' Slice: values less than 3%, show 7 slices and 'Others' |
|
Spend by Task Code (Top10) |
Categories: Invoice Line Item / Invoice Line Item Task Category Values: Account / Account Total Spend Widget Filters: Months in Invoice Line Item Service Date = Last 360 Days |
Yes |
Pie Type: classic Labels: Categories, Value, Percent Show 'Others' Slice: values less than 3%, show 7 slices and 'Others' |
|
Spend: Trailing 12 months |
X axis: Months in Invoice line item / Invoice line item service date (filtered to Last 360 Days) Values: Account / Account Total Spend Widget Filters: Months in Invoice Line Item Service Date = Last 360 Days |
Yes |
Line Type: straight bold X-Axis & Y-Axis: Grid lines and labels |
Summary
As a quick summary, this dashboard provides insights to key spend metrics, including vendor spend, task code spend, and 12-month spend trends.