Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 Addresssupport@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:

  • Installed MSPbots and Financial Suite apps
  • A successful Autotask integration

...

  • with MSPbots 

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.

     Image Removed

3.  This opens the financial suite dashboards and settings.

financial suite autotaskImage Added

List of Dashboards and Settings

...

...


DashboardsDescription
1
Financial Dashboard - Contract Detail
This

The Contract Detail dashboard shows a breakdown of the same

key

metrics

from

as the Summary Dashboard but on a per contract-company level. It also contains graphs

that show

for the trend of the

following:

labor hours vs. the target

,

and profit margin %.

2

Financial Dashboard - Contract Profitability Summary 
This 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.
3
Financial Dashboard - Margin ReviewThe Margin Review dashboard
contains a table that displays all
displays the trend of the monthly margins of all the companies under each contract classification
with their monthly margins4
.
This allows users to see the trend and determine which companies should be looked into.
It allows business owners and service managers to determine the companies for observation.
Financial Dashboard - Effective Rate
This
The Effective Rate dashboard shows the effective rates
per
for each customer and the contract classification with a breakdown of billed,
addition
additional costs, and labor hours.


No
SettingsDescription
1
Contracts Financial Suite SettingsThis dashboard contains the Contracts Financial Suite Settings
to set
where the target cost margin is set.

Dashboard Terms and

...

Calculations

...


Terms 
Calculation 

Calculations                  

Value

Value 

Value = Quantity × Unit

Price

Price 

Target Hours


Budgeted hours to achieve the Target Total Cost Margin %, which

can be

is set in the Contract Financial Suite Settings for App Packages dashboard.

Calculation:


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

Profit

Profit 

Billed - (Service Cost + Labor Costs) 
Margin

Margin 

Profit ÷
Billed
Billed 
Effective Rate

(Billed - Service Cost) ÷ Labor Hours (

if

If the labor hours is < 1, then it is rounded off to 1.)

Contribution Rate

Profit ÷ Labor Hours (

if

If the labor hours is < 1, then it is rounded off to 1.) 

Billed
Sum

The sum of [(Actual Quantity × Unit Price) + Service Total] for all invoices within the selected date range

Ave. Hourly Labor Rate
Average

The average of

all

the hourly labor

rate

rates 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
.