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!
Page History
The Financial Suite for Autotask integration 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 breakdown of metrics according to contract type, company, and trend graphs to determine if contracts are priced correctly or if labor costs should be managed more effectively. the correctness of contracts and effectiveness of labor costs management.
This page discusses the following about the Financial Suite integration with MSPbots:
Table of Contents |
---|
How to
...
install the Financial Suite for Autotask
...
Integration
...
CurrentlyFor now, the Financial Suite is installed by the MSPbots Support Team only. Contact us for an installation of the app is upon client requestFinancial Suite. 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 timeUTC-6
How to
...
access the Financial Suite for Autotask Integration
...
Note |
---|
You must have the following before you can access the Financial Suite for Autotask Integration:
|
...
|
To access the app and view the dashboard and settings, go to Appson the MSPbots menu and
1. After the installation, Login to MSPBots
2. Go to Apps page. Then, click Financial Suite for Autotask Integration on the Apps tab.
3. This opens the financial suite dashboards and settings.
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. |
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 |