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
...
- What are the dashboards available in the MSPbots Profit Insights App?Profitability Analysis Dashboard
- What are the key financial terms, metrics and calculations featured in the MSPbots Profit Insights App?
- How can I access MSPbots Profit Insights App?
- How can I start using the MSPbots Profit Insights App?
...
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 Settings | This contains settings for dashboards under the Financial and Team Utilization suites MSPbots Profit Insights App for ConnectWise Manage Integration. For For the Financial suite, users can set the Target Profit Margin for computation of the Target Hours. |
...
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 | Definition/Calculation |
|---|---|
| Value | Value = Addition Price = Quantity × Unit Price |
| Billed | Sum of [ (Actual Quantity × Unit Price) + Service Total ] for all invoices within the selected date range |
| Addition Costs | Sum of (Actual Quantity × Unit Cost) for all invoices within the selected date range Can be included or excluded using the slicer |
| Profit | Billed - (Addition Costs + Labor Costs) |
| Margin | Profit ÷ Billed |
| Actual Labor Hours | Total recorded hours for an agreement |
| Effective Rate | (Billed - Addition Costs) ÷ Labor Hours (if labor hours is < 1, then it is rounded off to 1) |
| Contribution Rate | Profit ÷ Labor Hours (if labor hours is < 1, then it is rounded off to 1) |
| Ave. Hourly Labor Rate | Average of all hourly labor rate of all active technicians with a work type tagging |
| Target Hours | Budgeted hours to achieve the Target Total Cost Margin %, which can be set in the ConnectWise Settings for App Packages dashboard. |
Gross Margin:
Gross Margin measures profitability and is calculated as follows:
...
Overview
Content Tools