N O T I C E
MSPbots WIKI is moving to a new home at support.mspbots.ai
to give you the best experience in browsing our Knowledge Base resources and addressing your concerns. Click here for more info!
Page History
...
Discover the various dashboards that are at your fingertips for gaining valuable insights into your financial performance:
Dashboard Name | Description | Overview |
|---|---|---|
| Profitability Analysis Dashboard | Dive into the profitability metrics for all agreements, enabling you to make data-driven decisions for optimizing costs and enhancing revenue. The Profitability Analysis dashboard provides a comprehensive overview of the profitability of all agreements within a specified time period. This tool enables businesses to assess their revenue, expenses, and profitability across different types of agreements. By utilizing various widgets, users can gain valuable insights into their financial performance and make data-driven decisions to optimize their business strategies. |
|
| Agreement Profitability by Company | Explore profitability trends among your agreements, organized by company. This analysis provides a deep understanding of financial performance on a company-specific level. The Agreement Profitability by Company dashboard offers a detailed analysis of the profitability of all agreements organized by company during a specified time period. This powerful tool not only provides insights into financial performance but also includes crucial trends related to Margin Percentage, Contribution Rate, Total Billed by Recurring Type, and Total Actual Hours by Recurring Type. By examining these key profitability metrics, businesses can gain a comprehensive understanding of their financial health, enabling them to make informed decisions, optimize costs, and formulate strategies for revenue growth and enhanced profitability. |
|
| Agreement Profitability | Gain insights into profitability trends for all agreements during specified periods, facilitating cost optimization and revenue growth strategies. This dashboard offers a comprehensive view of your business's financial performance, with a focus on key metrics such as monthly trends in total billed, gross revenue, and margin. In addition to tracking these critical indicators, the dashboard also provides leader boards highlighting the top 10 companies with the highest and lowest gross revenue. This valuable information empowers businesses to monitor their financial health, make informed decisions, and identify areas for improvement. |
|
| Profit Margin Analysis By Company | Visualize monthly margins for all companies, allowing you to identify trends and pinpoint companies that may require further investigation. This dashboard features a heatmap showcasing monthly margins for all companies, enabling users to visualize trends and identify companies worthy of further investigation. |
|
| (SETTINGS) ConnectWise Manage Agreement Type | This contains settings for dashboards under the MSPbots Profit Insights App for ConnectWise Manage Integration. For the Financial suite, users can set the Target Profit Margin for computation of the Target Hours. |
What are the key financial terms, metrics and calculations featured in the MSPbots Profit Insights App?
...
Within our widgets, you'll find a comprehensive set of financial metrics designed to provide valuable insights into your business's financial performance. These metrics, along with their calculations, include:
Term/ Metric | Definition/Calculation |
|---|---|
| Product Gross Margin | Product Revenue - Product Cost |
| Labor Gross Margin | Labor Revenue - Labor Cost |
| Gross Margin | Total Revenue - (Labor Cost + Product Cost) |
| Margin % or Margin Percentage | (Gross Margin ÷ Total Revenue) * 100 |
| Effective Rate | Labor Revenue ÷ Total Actual Hours |
| Contribution Rate | (Total Billed - (Labor Cost + Product Cost)) ÷ Total Actual Hours |
| Margin | Profit ÷ Billed |
| Actual Hours | Total recorded hours for an agreement |
These metrics offer a comprehensive view of your financial health, efficiency, and profitability. Understanding and utilizing these calculations within your widgets can help guide data-driven decisions, optimize costs, and strategize for revenue growth.
...
- Navigate to Apps, find theMSPbots Profit Insights App, and click it.
- Hover over Settings over Settings and select ConnectWise Manage Agreement Type Settings.
3. When the ConnectWise Manage Agreement Type Settings tab opens, go to the Addition Calculation Setting section and input your company's Agreement Addition Settings and Agreement Settings.
- Click Submit to save.
- Then enter your Agreement Category Settings as well.
- Click Submit to save.
- When done with settings, you are ready to view the data in the dashboards. Hover over the Dashboards and click any of the following to view the results:
...
Overview
Content Tools