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!


You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

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



NoDashboardsDescription
1Financial 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 %.

2Financial 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.
3Financial Dashboard - Margin ReviewThe 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.
4Financial Dashboard - Effective RateThis dashboard shows effective rates per customer and contract classification with breakdown of billed, addition costs, and labor hours.
NoSettingsDescription
1Contracts Financial Suite SettingsThis 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.

Calculation:
{[Target Total Cost Margin % - (Service Cost ÷ Billed)] × Billed} ÷ Average Hourly Labor Rate

ProfitBilled - (Service Cost + Labor Costs)
MarginProfit ÷ Billed
Effective Rate(Billed - Service Cost) ÷ Labor Hours (if labor hours is < 1, then it is rounded off to 1)
Contribution RateProfit ÷ Labor Hours (if labor hours is < 1, then it is rounded off to 1)
BilledSum 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 CostsSum of (Actual Quantity × Unit Cost) for all invoices within the selected date range
Actual Labor HoursTotal 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

  • No labels