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 enable business owners and service managers to ensure profitability. The metrics are broken down per contract type, company, and trend graphs to determine if contracts are priced correctly or if labor costs should be managed more effectively.
How to Install the Financial Suite for Autotask integration
Currently, the installation of the app is upon client request. Please contact us through the ff:
Support Email Address: support@mspbots.ai Phone: 1-312-205-5608 Support Hours: 8:00 AM to 5:00 PM CST Chicago time
|
---|
How to Access the Financial Suite for Autotask integration
1. Login to MSPBots
2. Go to Apps page. Then, click Financial Suite for Autotask Integration.
3. This opens the financial suite dashboards and settings.
List of Dashboards and Settings
No | Dashboards | Description |
---|---|---|
1 | Financial Dashboard - Contract Detail | This dashboard shows a breakdown of the same key metrics from the Summary Dashboard but on a per contract-company level. It also contains graphs that show the trend of the following: labor hours vs the target, profit margin %. |
2 | Financial Dashboard - Contract Profitability Summary | This summary dashboard shows total billed, margin, effective rate, contribution rate, and profit per contract classification. It also contains graphs showing the monthly trend for these KPIs. |
3 | Financial Dashboard - Margin Review | The Margin Review dashboard contains a table that displays all companies under each contract classification with their monthly margins. This allows users to see the trend and determine which companies should be looked into. |
4 | Financial Dashboard - Effective Rate | This dashboard shows effective rates per customer and contract classification with breakdown of billed, addition costs, and labor hours. |
No | Settings | Description |
---|---|---|
1 | Contracts Financial Suite Settings | This dashboard contains the Contracts Financial Suite Settings to set the target cost margin. |
Terms and Calculation
Terms | Calculation |
---|---|
Value | Value = Quantity × Unit Price |
Target Hours | Budgeted hours to achieve the Target Total Cost Margin %, which can be 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 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) |
Billed | Sum of [ (Actual Quantity × Unit Price) + Service Total] for all invoices within the selected date range |
Ave. Hourly Labor Rate | Average of all hourly labor rate 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. |
Contact Support
For any queries and concern, you can contact us on the following:
Support Email Address: support@mspbots.ai
Phone: 1-312-205-5608
Support Hours: 8:00 AM to 5:00 PM CST Chicago time