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!


You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

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?


Discover the various dashboards that are at your fingertips for gaining valuable insights into your financial performance:


Dashboard Name

Description

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

This dashboard shows a breakdown of the same key metrics from the Summary Dashboard but on a per agreement-company level. It also contains graphs that show the trend of labor hours vs. the target, and the profit margin %.

Agreement ProfitabilityThis dashboard contains a table that displays all companies under each agreement type and their monthly margins. This allows users to see the trend and to determine which companies should be looked into.
Profit Margin Analysis By CompanyThis 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 for ConnectWise Manage Integration. For the Financial suite, users can set the Target Profit Margin for computation of the Target Hours.



  • Profitability Analysis Dashboard:

Dive into the profitability metrics for all agreements, enabling you to make data-driven decisions for optimizing costs and enhancing revenue.


  • Agreement Profitability by Company Dashboard

Explore profitability trends among your agreements, organized by company. This analysis provides a deep understanding of financial performance on a company-specific level.


  • Agreement Profitability Dashboard

Gain insights into profitability trends for all agreements during specified periods, facilitating cost optimization and revenue growth strategies.


  • Profit Margin Analysis by Company Dashboard

Visualize monthly margins for all companies, allowing you to identify trends and pinpoint companies that may require further investigation.



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:

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.




  • No labels