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!
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!
The MSPbots Profit Insights App is a dynamic tool designed to shed light on your company's financial performance. It offers an all-encompassing view of your profitability, efficiency, and fiscal health by meticulously examining financial data, including total billed, gross revenue, effective rate, and contribution rate. Whether you're a business owner, service manager, or a key stakeholder, the dashboards and widgets within the app offer real-time insights that empower you to make informed decisions, evaluate performance comprehensively, and take timely action.
What's covered in this article:
- What are the dashboards available in the MSPbots Profit Insights App?
- 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?
What are the dashboards available in the MSPbots Profit Insights App?
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 | 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:
Gross Margin = Total Revenue - (Labor Cost + Product Cost)
Margin % (Margin Percentage):
Margin % evaluates profitability as a percentage of Total Revenue and is calculated as follows:
Margin % = (Gross Margin / Total Revenue) * 100
Contribution Rate:
Contribution Rate measures the proportion of revenue that contributes to profit. The calculation is as follows:
Contribution Rate = (Total Billed - (Labor Cost + Product Cost)) / Total Actual Hours
Effective Rate:
Effective Rate represents the revenue generated per hour of labor and is calculated as:
Effective Rate = Labor Revenue / Total Actual Hours
Labor Gross Margin:
Labor Gross Margin assesses the profitability of labor-related revenue and expenses, calculated as:
Labor Gross Margin = Labor Revenue - Labor Cost
Product Gross Margin:
Product Gross Margin evaluates the profitability of product-related revenue and expenses, calculated as:
Product Gross Margin = Product Revenue - Product Cost
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.