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!
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!
The Financial Suite for Autotask Integration provides insights on key metrics such as Profit Margin, Effective Rate, and Contribution Rate to ensure profitability. The breakdown of metrics according to contract type, company, and trend graphs to determine the correctness of contracts and effectiveness of labor costs management.
This page discusses the following about the Financial Suite integration with MSPbots:
How to install the Financial Suite for Autotask Integration
For now, the Financial Suite is installed by the MSPbots Support Team only. Contact us for an installation of the Financial Suite.
Email: support@mspbots.ai
Phone: 1-312-205-5608
Support Hours: 8:00 AM to 5:00 PM UTC-6
How to access the Financial Suite for Autotask Integration
You must have the following before you can access the Financial Suite for Autotask Integration:
- Installed MSPbots and Financial Suite apps
- A successful Autotask integration with MSPbots
To access the app and view the dashboard and settings, go to Apps on the MSPbots menu and click Financial Suite for Autotask Integration on the Apps tab.
List of Dashboards and Settings
| Dashboards | Description |
|---|---|
| Financial Dashboard - Contract Detail | The Contract Detail dashboard shows a breakdown of the same metrics as the Summary Dashboard but on a per contract-company level. It also contains graphs for the trend of the labor hours vs. the target and profit margin %. |
| Financial Dashboard - Contract Profitability Summary | The Contract Profitablility 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. |
| Financial Dashboard - Margin Review | 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. |
| Financial Dashboard - Effective Rate | 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. |
| Settings | Description |
|---|---|
| Contracts Financial Suite Settings | This dashboard contains the Contracts Financial Suite Settings where the target cost margin is set. |
Financial Dashboard - Contract Detail
To filer the results, the available slicers are for Date Range and Contract Type.
Financial Dashboard - Contract Profitability Summary
To filer the results, the available slicers are for Date Range, Contract Type and Company Name.
Financial Dashboard - Margin Review
To filer the results, the available slicers are for Date Range, Contract Type and Company Name.
Financial Dashboard - Effective Rate
To filer the results, the available slicers are for Date Range, Contract Type and Company Name.
Contracts Financial Suite Settings
Dashboard Terms and Calculations
| 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 |
Overview
Content Tools
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!