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 Agreement Profitability dashboards Financial Suite for ConnectWise Manage provides insights on key metrics such as Profit Margin, Effective Rate, and Contribution Rate to enable Business Owners and Service Managers in ensuring that all of their business owners and service managers to ensure all agreements are profitable. A breakdown of these metrics The metrics are broken down per agreement type/company as well as trend graphs are included so that it would be easy for users to determine whether agreements are priced correctly or if agreement labor costs should be managed more effectively., company, and trend graphs to determine correct agreement prices and effective management of agreement labor costs.
Table of Contents
List of Dashboards
Dashboard Name | Description |
|---|---|
| Agreement Profitability - Summary | This dashboard shows the total billed, margin, effective rate, contribution rate, and profit per agreement type. It also contains graphs showing the monthly trend for the KPIs. |
| Agreement Profitability - Agreement Details | 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 the following: labor hours vs. the target, and the profit margin %. |
| Agreement Profitability - Margin Review | This dashboard contains a table that displays all companies under each agreement type with and their monthly margins. This allows users to see the trend and to determine which companies should be looked into. |
| Agreement Profitability - Effective Rate | This dashboard shows effectiveness rates per customer and agreement type with a breakdown of billed, addition costs, and labor hours. |
| (SETTINGS) Financial Suite App Settings Form | This contains settings for dashboards under the Financial App for ConnectWise Manage Integration. For the Financial suite, users can set the Target Profit Margin for computation of the Target Hours. |
Terms and Calculations
Term | Definition/Calculation |
|---|---|
| Value |
Sum of addition price for all agreements
If annual, monthly value is from Total Value divided by 12
If monthly, with addition price, Value = addition price
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. |
Agreement Profitability - Summary Dashboard
The Summary dashboard Dashboard shows the total billed, margin, effective rate, contribution rate, and profit per agreement type. It also contains graphs showing the monthly trend for the KPIs.
Available The available slicers are : Addition Cost (Exclude, Include), Date Range (Invoice Date), and Agreement Types
Agreement Profitability - Agreement Details Dashboard
The Agreement Details dashboard 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 the following: labor hours vs. the target, and profit margin.
Available The available slicers are : Addition Cost (Exclude, Include), Date Range, and Agreement Types.
Agreement Profitability - Margin Review Dashboard
The Margin Review dashboard Dashboard contains a table that displays all companies under each agreement type with their monthly margins. This allows users to see the trend and determine which companies should be looked into.
Available The available slicers are : Company, Date Range, and Agreement Types
.
Agreement Profitability - Effective Rate Dashboard
The Effective Rate Dashboard shows effective rates per customer and agreement type with a breakdown of billed, addition costs, and labor hours.
The available slicers are Addition Cost (Exclude, Include), Date Range, and Agreement Types.
Financial Suite App Settings
Target Margin Settings: Users can set the target cost margin (Addition Costs + Labor Costs) for the calculation of target labor hours.
| Content by Label | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Overview
Content Tools