Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Client profitability and service performance - Identify profitable services or clients and costs that impact margins negatively by tracking revenue, expenses, and profitability trends over time. 
  • Cost analysis - Determine areas where costs can be optimized or reduced. 
  • Forecasting and planning - Utilize historical data to plan strategically and create forecasts and projections for future revenues, expenses, and overall profitability. 
  • Identifying growth opportunities - Scale profitable areas and services and explore new avenues for growth from data that helps you understand what's working well financially. 
  • Risk management - Analyze data to identify and proactively mitigate potential risks before they become significant issues. 

Who can use the

...

MSPbots Profit Insights App?

...

The MSPbots Profits Insights App dashboards are available to ConnecWise Manage users. Only users with the admin role can modify the settings.

...

Each of the MSPbots Profits Insights App dashboards offers unique insights into your financial landscape. Below are the dashboard overviews. These dashboards are discussed below.  

Profitability Analysis Dashboard 

The Profitability Analysis dashboard provides a comprehensive overview of the profitability of all agreements within a specified period and enables helps businesses to assess their revenue, expenses, and profitability across different types of agreements. Use the data in the widgets to make data-driven decisions for optimizing costs and enhancing revenue. 


...

Dashboard Name

...

Description

...

Overview

These are the widgets in the Profitability Analysis Dashboard. 

WidgetsDescriptionWhen to Use

Total Billed of All Agreements

This widget displays the total amount billed across all agreements within the selected time frame. It offers a holistic view of revenue generated from all types of agreements.

Image Added

  •  Monitoring overall performance

Use the Total Billed of All Agreements widget to quickly assess the total revenue generated by all agreements, providing an overview of your financial performance.

Total Billed of Recurring Agreements

This widget displays the total billed amount for recurring agreements. Recurring agreements typically involve regular payments, such as subscriptions or service contracts.

Image Added

  •  Differentiating recurring from non-recurring revenue

The Total Billed of Recurring Agreements widget helps distinguish between ongoing revenue streams and one-time transactions.

 

Total Billed of Non-Recurring Agreements

This widget presents the total billed amount for non-recurring agreements. Non-recurring agreements typically involve one-time transactions, such as product sales or project-based services.

Image Added

  •  Differentiating recurring from non-recurring revenue

The Total Billed of Non-Recurring Agreements widget also helps distinguish between ongoing revenue streams and one-time transactions.

Total Billed of Unspecified Type of Agreements

This widget tracks the total billed amount for agreements with unspecified or undefined types and may include agreements that lack clear classification or labeling.

Image Added

  •  Identifying Unknown Agreement Types 

The Total Billed of Unspecified Type of Agreements widget can highlight agreements that require further classification or attention.

 

Profitability Analysis by Agreement Type

This widget provides a breakdown of profitability based on different agreement types. It allows users to assess which types of agreements contribute the most to overall profitability.

Image Added

  •  Analyzing Agreement Types 

The Profitability Analysis by Agreement Type widget identifies the most profitable agreement categories and those that contribute significantly to revenue.

 

Total Billed by Agreement Type

This widget displays the total billed amount categorized by agreement types. It helps users understand the revenue distribution across various agreement categories.

Image Added


  •  Analyzing Agreement Types 

The Total Billed by Agreement Type widget also identifies which agreement categories are most profitable and contribute significantly to revenue.

Gross Margin by Recurring Type

This widget focuses on the gross margin of recurring agreements. Gross margin is a critical indicator of profitability, representing the difference between revenue and the cost of goods or services sold.

Image Added

  •  Evaluating Gross Margin  

Use the Gross Margin by Recurring Type widget to assess the profitability of recurring agreements. 


Gross Margin - Last 12 Months 

This widget provides an overview of the gross margin for the past 12 months. Monitoring gross margin trends over time can help identify areas for improvement or growth. 

Image Added

  •  Evaluating Gross Margin  

Use the Gross Margin - Last 12 Months widget to track trends over time. 

Margin Percentage - Last 12 Months

This widget calculates and displays the margin percentage for the last 12 months. Margin percentage is a key performance metric that reflects the profitability of agreements relative to their costs.

Image Added

  •  Evaluating Gross Margin  

Use the Margin Percentage - Last 12 Months widget to get insight into the percentage of revenue retained as profit.

Agreement Profitability by Company

...

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.

...

image-2023-10-2_1-20-14.pngImage Removed

...

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

...

. Other than providing insights into financial performance

...

, it also

...

highlights 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.

...

image-2023-10-2_17-20-8.pngImage Removed

 

Image Added

These are the widgets in the Profitability Analysis Dashboard. 

WidgetDescriptionWhen to use
Profitability Analysis by Company

This widget offers a comprehensive view of profitability by breaking down the data by individual companies. It allows users to evaluate the financial performance of different business entities within the organization. 

Image Added

  • Gathering Company-Specific Insights 

Utilize the "Profitability Analysis by Company" widget to evaluate the financial performance of individual companies within your organization. This insight can inform resource allocation, investment decisions, and business strategy.

Margin Percentage - Last 12 Months

Monitoring margin percentage over the last 12 months is crucial for assessing the profitability of agreements. This widget helps in tracking the profitability trend and identifying areas that may require attention or improvement. 

Image Added

  • Margin Percentage Trends

Keep a close eye on the "Margin Percentage - Last 12 Months" widget to identify long-term profitability trends. Understanding these trends can aid in strategic planning and cost optimization efforts.

Contribution Rate - Last 12 Months

The Contribution Rate is a vital metric that measures the proportion of revenue that contributes to profit after covering direct costs. Examining this widget over the past year helps businesses understand their ability to generate profit from their revenue.

Image Added

The "Contribution Rate - Last 12 Months" widget provides insights into how efficiently revenue is converted into profit. Evaluate this metric to identify areas where cost control or revenue enhancement is needed.
Total Billed by Recurring Type - Last 12 Months

This widget breaks down the total billed amount by different recurring agreement types. It provides insights into revenue distribution across various recurring agreement categories.


Recurring Agreement Analysis: Use "Total Billed by Recurring Type - Last 12 Months" to assess the revenue distribution among different recurring agreement types. This can guide decisions regarding pricing, marketing, and resource allocation.

Total Actual Hours by Recurring Type - Last 12 MonthsThis widget tracks the total actual hours spent on different recurring agreement types over the last 12 months. It is essential for understanding resource utilization and optimizing operations. 

Resource Utilization: The "Total Actual Hours by Recurring Type - Last 12 Months" widget helps in understanding how resources are allocated across different recurring agreement types. This data can inform staffing decisions and service level improvements.

Agreement Profitability

The Agreement Profitability by Company

...

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

...

dashboard offers a comprehensive view of your business'

...

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


Image Added


The Agreement Profitability Dashboard serves as a powerful tool for monitoring financial performance, identifying trends, and fostering data-driven decision-making. Regularly reviewing these widgets empowers businesses to optimize their profitability and ensure sustainable growth. Below are the widgets in the Agreement Profitability Dashboard. 

WidgetDescriptionWhen to use
Agreement Revenue TrendThis widget displays the monthly trend of total billed amounts, providing insights into the revenue generated by your agreements over time. Analyzing this trend helps you understand the growth or fluctuations in revenue.Revenue and Margin Trends: Utilize the "Agreement Revenue Trend" and "Agreement Gross Margin Trend" widgets to track the monthly performance of your agreements. Identify patterns, spikes, or dips in revenue and margin to guide strategic decisions.
Agreement Gross Margin Trend

The Agreement Gross Margin Trend widget illustrates the monthly trend in gross revenue, which represents the total revenue minus the cost of goods or services sold. Monitoring this trend is essential for assessing your profitability over time. 

image-2023-10-2_19-38-13.pngImage Removed

Profit Margin Analysis By CompanyVisualize monthly margins for all companies, allowing you to identify trends and pinpoint companies that may require further investigation.

Image Added

Revenue and Margin Trends: Utilize the "Agreement Revenue Trend" and "Agreement Gross Margin Trend" widgets to track the monthly performance of your agreements. Identify patterns, spikes, or dips in revenue and margin to guide strategic decisions.
Contribution Rate - Last 12 Months

Contribution rate widget shows the monthly trend of contribution rates over the last 12 months. Contribution Rate is computed as:

Contribution Rate = (Total Billed - (Labor Cost + Product Cost)) / Total Actual Hours

It provides insights into your ability to generate profit from your revenue while accounting for labor and product costs. 

Image Added

Regularly review the "Margin Percentage - Last 12 Months" and "Contribution Rate - Last 12 Months" widgets to assess your overall profitability. These metrics can guide cost control and revenue enhancement efforts while considering labor and product costs.
Margin Percentage - Last 12 Months

This widget calculates and displays the margin percentage for the last 12 months. Margin percentage is a key indicator of profitability, showing the percentage of revenue retained as profit after covering costs.

Computation:
Margin Percentage = Gross Margin / (Labor Revenue + Product Revenue) 

Image Added

Regularly review the "Margin Percentage - Last 12 Months" and "Contribution Rate - Last 12 Months" widgets to assess your overall profitability. These metrics can guide cost control and revenue enhancement efforts while considering labor and product costs.
Leader Board - Top 10 Highest Gross Revenue

This grid widget presents a leaderboard showcasing the top 10 companies with the highest gross revenue. It allows you to quickly identify your top-performing clients or partners.

Image Added

Identifying Top Performers: The "Leader Board - Top 10 Highest Gross Revenue" widget enables you to identify and recognize your top-performing clients or partners. This information can inform relationship management and growth strategies
Leader Board - Top 10 Lowest Gross Revenue

Similar to the previous leaderboard, this grid widget highlights the top 10 companies with the lowest gross revenue. It can help pinpoint areas where revenue generation may need improvement or where further analysis is required. 

Image Added

Addressing Underperformers: The "Leader Board - Top 10 Lowest Gross Revenue" widget helps identify areas where revenue generation may be falling short. Use this data to investigate and address issues that may be affecting certain agreements.

Profit Margin Analysis By Company

This dashboard features a heatmap showcasing monthly margins for all companies, enabling users to visualize trends and identify companies worthy of further investigation. It simplifies the assessment of profitability trends within your organization. By leveraging the heatmap visualization, users can efficiently identify areas of strength and areas that require attention, ultimately leading to more informed decision-making and improved overall profitability. 

Image Added

Below is the widget in the Profit Margin Analysis by Company Dashboard. 

WidgetDescriptionWhen to use
Margin % By Company - Last 12 Months

This heatmap widget presents a graphical representation of monthly margin percentages for all companies over the last 12 months. Each cell in the heatmap corresponds to a specific company and month, with colors indicating the margin percentage. Users can easily discern patterns and variations in profitability across different companies and periods. 

Image Added

Use this widget to get a visual snapshot of how each company's profitability has evolved over the past year and spot trends, such as improving or declining profitability, across your organization

image-2023-10-3_16-10-13.pngImage Removed

(SETTINGS) ConnectWise Manage Agreement TypeThis contains settings for dashboards under the MSPbots Profit Insights App for ConnectWise Manage Integration. Users can set the Addition Calculation and Agreement Category settings
.


What are the key financial terms, metrics, and calculations featured in the MSPbots Profit Insights App?

...

Within our widgets, you'll find The MSPbots Profit Insights App has a comprehensive set of financial metrics designed to that 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 RateLabor Revenue ÷ Total Actual Hours
Contribution Rate
(
[Total Billed - (Labor Cost + Product Cost)
)
] ÷ Total Actual Hours
MarginProfit ÷ Billed
Actual HoursTotal 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.

...


How to modify the dashboard settings  

...

Here are the steps for setting up the MSPbots Profit Insights App: 

Adjusting the Addition Calculation Settings

  1. Navigate to Apps, find theMSPbots Profit Insights App, and click it.
  2. Hover over Settings and select ConnectWise Manage Agreement Type Settings.

...

4. Click Submit to save.

         

5. Then enter your Agreement Category Settings as well.

          Image Removed

...

Adjusting the Agreement Category Settings 

  1. In the ConnectWise Manage Agreement Type Settings, go to the section on Agreement Category Settings. 
  2. Enter your preferred settings.
    Image Added
  3. Click Submit to save. 

...

  1. Image Modified

...

  1. 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:
    1. Profitability Analysis Dashboard
    2. Agreement Profitability by Company
    3. Agreement Profitability
    4. Profit Margin Analysis By Company