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
The The MSPbots Profit Insights App offers a comprehensive view of your company's financial performance by providing detailed analytics and data-driven insights. It examines financial data such as total billed, gross revenue, effective rate, and contribution rate to give you a clear understanding of your company's profitability, efficiency, and fiscal health. With real-time data presented through dashboards and widgets, business owners, service managers, and key stakeholders can make informed decisions, evaluate performance comprehensively, and take timely action.
...
The MSPbots Profit Insights App is a valuable tool for analyzing the different aspects of your business like the following:
- 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.
...
The MSPbots Profits Insights App dashboards are available to ConnecWise Manage users. Only users with the admin role can and financial roles can use the app and modify the settings.
What are the dashboards available in the MSPbots Profit Insights App?
...
Widgets | Description | When 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. |
Use the Total Billed of All Agreements widget to quickly assess the total revenue generated by all agreements , providing and to get an overview of your financial performance. |
Total Billed of Recurring AgreementsAgreements | This widget displays the total billed amount for recurring agreements. Recurring agreements , which typically involve regular payments, such as subscriptions or service contracts. |
The Use the Total Billed of Recurring Agreements widget helps to help 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 , which typically involve one-time transactions, such as product sales or project-based services. |
The Use the Total Billed of Non-Recurring Agreements widget also helps to help 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. |
The Use the Total Billed of Unspecified Type of Agreements widget can to 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. |
The Use the Profitability Analysis by Agreement Type widget identifies to identify 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. |
The Use the Total Billed by Agreement Type widget also identifies which to identify the agreement categories that 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. |
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. |
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. |
Use the Margin Percentage - Last 12 Months widget to get insight into the percentage of revenue retained as profit. |
...
These are the widgets in the Agreement Profitability Analysis by Company Dashboard.
Widget | Description | When 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. |
|
Use the |
Profitability Analysis by Company |
widget to evaluate the financial performance of individual companies within your organization. This insight |
is useful in 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. |
|
Use the |
Margin Percentage - Last 12 Months |
widget to identify long-term profitability trends. Understanding these trends |
aids in strategic planning and cost optimization efforts. | |
Contribution Rate - Last 12 Months | The Contribution Rate |
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. |
Use the Contribution Rate - Last 12 Months |
widget |
to provide insights into how efficiently revenue is converted into profit |
and 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. |
Use the 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 Months | This 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. |
Use the Total Actual Hours by Recurring Type - Last 12 Months |
widget to help understand how resources are allocated across different recurring agreement types. This data |
is useful in formulating staffing decisions and establishing service level improvements. |
Agreement Profitability
The Agreement Profitability by Company dashboard offers a comprehensive view of the financial performance 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 leaderboards highlighting the top 10 companies with the highest and lowest gross revenue. This valuable information empowers data enables businesses to monitor their financial health, make informed decisions, and identify areas for improvement.
The Below are the widgets in 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 . Reviewing these widgets regularly allows businesses to optimize their profitability and ensure sustainable growth. Below are the widgets in the Agreement Profitability Dashboard.
Widget | Description | When to use |
---|---|---|
Agreement Revenue Trend | This 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 and fluctuations in revenue. |
Use the Agreement Revenue Trend widget Revenue and Margin Trends: Utilize the "Agreement Revenue Trend" and "Agreement Gross Margin Trend" widgetsto track the monthly performance of your agreements. Identify patterns, spikes, or dips in revenue and margin to guide strategic decisions. |
Agreement Gross Margin TrendTrend | 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. | Revenue and Margin Trends: Utilize the "Agreement Revenue Trend" and "Agreement
|
Contribution Rate - Last 12 Months | The Contribution rate Rate widget shows the monthly trend of contribution rates over the last 12 months. Contribution Rate This 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. |
Use the Regularly review the "Margin Percentage - Last 12 Months " and "Contribution Rate - Last 12 Months" widgetswidget to assess your overall profitability. These metrics can guideThis metric guides cost control and revenue enhancement efforts while considering labor and product costs. |
Margin Percentage - Last 12 Months | This The Margin Percentage - Last 12 Months 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) |
Use the Regularly review the "Margin Percentage - Last 12 Months " and "Contribution Rate - Last 12 Months" widgetswidget to assess youroverall profitability . These metrics can guide cost control and revenue enhancement, control costs, and enhance revenue improvement 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. |
Use the Leader Board - Top 10 Highest Gross Revenue "widget enables you to identify and recognize your top-performing clients or partners. This information can informis helpful in relationship management and growth strategies. |
Leader Board - Top 10 Lowest Gross Revenue | Similar to the previous leaderboard, this This grid widget highlights the top 10 companies with the lowest gross revenue. It can help pinpoint helps spot areas where revenue generation may need improvement or where further analysis is required. |
Use the Addressing Underperformers: The "Leader Board - Top 10 Lowest Gross Revenue "widget helpsto identify areas where revenue generation may be falling short. Use this data to investigate and addressThis data is helpful in investigating and addressing issues that may be affecting certainsome agreements. |
Profit Margin Analysis By Company
...
What are the key financial terms, metrics, and calculations featured in the MSPbots Profit Insights App?
...
The MSPbots Profit Insights App has a comprehensive set of financial metrics that provide valuable insights into your business's financial performance. These metrics, along with their calculations, include:
...
How to modify the dashboard settings
...
Here are This section has the steps for setting up the MSPbots Profit Insights App. Note that only users with admin and financial roles can edit the settings.:
Adjusting the Addition Calculation Settings
...
- In the ConnectWise Manage Agreement Type Settings window, go to the Agreement Category Settings Setting section.
- Enter your preferred settings.
- Click Submit to save.
- Dashboards dropdown menu and select a dashboard.
When done with settings, verify if the values in the dashboards meet your expected results. Click the