The 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 to ensure all agreements are profitable. The metrics are broken down per agreement type, company, and trend graphs to determine correct agreement prices and effective management of agreement labor costs. 

List of Dashboards

Dashboard Name

Description

Agreement Profitability - SummaryThis 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 labor hours vs. the target, and the profit margin %.

Agreement Profitability - Margin ReviewThis 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.
Agreement Profitability - Effective RateThis 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

Value = Addition Price = Quantity × Unit Price

For agreements with an annual billing cycle, Total Value is divided by 12 to show the monthly value.

BilledSum of [ (Actual Quantity × Unit Price) + Service Total ] for all invoices within the selected date range
Addition CostsSum of (Actual Quantity × Unit Cost) for all invoices within the selected date range

Can be included or excluded using the slicer
ProfitBilled - (Addition Costs + Labor Costs)
MarginProfit ÷ Billed
Actual Labor HoursTotal 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 RateProfit ÷ 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.

Calculation:
{ [Target Total Cost Margin % - (Addition Costs ÷ Billed) ] × Billed } ÷ Average Hourly Labor Rate

Agreement Profitability - Summary Dashboard

The Summary 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.

The available slicers are Addition Cost (Exclude, Include), Date Range (Invoice Date), and Agreement Types

agreement type summary
  agreement summary

Agreement Profitability - Agreement Details Dashboard

The Agreement Details 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 labor hours vs. the target, and profit margin.

The available slicers are Addition Cost (Exclude, Include), Date Range, and Agreement Types

agreement details dashboard

Agreement Profitability - Margin Review Dashboard

The Margin Review 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.

The available slicers are Company, Date Range, and Agreement Types

margin review dashboard

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

effective rate dashboard

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.

 target cost margin