Financial Suite for ConnectWise Manage Integration

This app 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 agreements are profitable. A breakdown of these metrics 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.

List of Dashboards

Dashboard Name	Description
Agreement Profitability - Summary	This dashboard shows 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, profit margin %.
Agreement Profitability - Margin Review	This 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.
Agreement Profitability - Effective Rate	This dashboard shows effective rates per customer and agreement type with breakdown of billed, addition costs, and labor hours.
(SETTINGS) ConnectWise Settings for App Packages	This contains settings for dashboards under Financial and Team Utilization suites for ConnectWise Manage Integration. For Financial, 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 annual billing cycle, Total Value is divided by 12 to show monthly value
Billed	Sum of [ (Actual Quantity * Unit Price) + Service Total ] for all invoices within selected date range
Addition Costs	Sum of (Actual Quantity * Unit Cost) for all invoices within selected date range Can be included/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
Contribution Rate	Profit / Labor Hours
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 total billed, margin, effective rate, contribution rate, and profit per agreement type. It also contains graphs showing the monthly trend for the KPIs.

Available slicers are: Addition Cost (Exclude, Include), Date Range (Invoice Date), Agreement Types

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 following: labor hours vs the target, profit margin.

Available slicers are: Addition Cost (Exclude, Include), Date Range, Agreement Types

Agreement Profitability - Margin Review

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.

Available slicers are: Company, Date Range, Agreement Types

Agreement Profitability - Effective Rate

This dashboard shows effective rates per customer and agreement type with breakdown of billed, addition costs, and labor hours.