The Financial Suite for Autotask Integration provides insights on key metrics such as Profit Margin, Effective Rate, and Contribution Rate to ensure profitability. The metrics breakdown according to contract type, company, and trend graphs determine the correctness of contracts and effectiveness of labor cost management.
This page discusses the following about the Financial Suite integration with MSPbots:
The Financial Suite app is pre-installed with your MSPbots subscription and is available in the Apps section.
You must have a successful Autotask integration with MSPbots before you can access the Financial Suite for Autotask Integration. Only users with admin and financial roles can access the Financial Suite. |
To access the Financial Suite app and view the dashboard and settings, go to Apps on the MSPbots menu and click Financial Suite for Autotask Integration.
The Contract Profitability Summary dashboard shows metrics like total billed, margin, effective rate, contribution rate, and profit per contract classification. It also contains graphs showing the monthly trend for these KPIs. The results on this dashboard are filtered using the Date Range, Contract Type, and Company Name slicers.
The Contract Detail dashboard shows a breakdown of the same metrics as the Contract Profitability Summary dashboard but on a per contract-company level. It also contains graphs for the trend of the labor hours vs. target and profit margin %. The results on this dashboard can be filtered using the Date Range and Contract Type slicers.
The Margin Review dashboard displays the trend of the monthly margins of all the companies under each contract classification. It allows business owners and service managers to determine the companies for observation. The results on this dashboard are filtered using the Date Range, Contract Type, and Company Name slicers.
The Effective Rate dashboard shows the effective rates for each customer and the contract classification with a breakdown of billed, additional costs, and labor hours The results are filtered using the Date Range, Contract Type, and Company Name slicers.
This dashboard contains the Contracts Financial Suite Settings where the target cost margin is set.
| Terms | Calculations |
|---|---|
Value | Value = Quantity × Unit Price |
Target Hours | Budgeted hours to achieve the Target Total Cost Margin %, which is set in the Contract Financial Suite Settings for App Packages dashboard. |
Profit | Billed - (Service Cost + Labor Costs) |
Margin | Profit ÷ Billed |
| Effective Rate | (Billed - Service Cost) ÷ Labor Hours (If the labor hours is < 1, then it is rounded off to 1.) |
| Contribution Rate | Profit ÷ Labor Hours (If the labor hours is < 1, then it is rounded off to 1.) |
| Billed | The sum of [(Actual Quantity × Unit Price) + Service Total] for all invoices within the selected date range |
| Ave. Hourly Labor Rate | The average of the hourly labor rates of all active technicians with a work type tagging |
| Service Costs | Sum of (Actual Quantity × Unit Cost) for all invoices within the selected date range |
| Actual Labor Hours | Total recorded hours for a contract |