Sending Billing Statistics to ConnectWise
Invoice Settings
Integration with ConnectWise Manage allows you to send Managed Backup Service billings statistics to ConnectWise. To start using the "send billing" feature, you should configure billing settings. The following billing settings are available:
- Use invoice description from the ConnectWise product
- Send invoice description to ConnectWise. Click on tooltip to see the examples.
Select required option and save the selection
Configuring Billing in ConnectWise
You need to configure the following ConnectWise entities:
- Integrator Login - required for connecting to ConnectWise system;
- Management Solution - allows to set up integration solution;
- Agreement Type - defines a type of integration;
- Agreement for a company - allows to assign a certain company to the integration type;
- Product - defines a product for integration: MBS Backup for Windows;
- Managed Device Integration and Cross-Reference - assigns integrator login to a the integration solution.
Note: Names of Management Solution, Agreement Type and Agreement must be the same.
In our instructions we use the name - ManagedBackupService.
Creating Integrator Login and Enable APIs
Please, find a step-by-step instruction on how to create Integrator login and enable APIs in the following article: Create Integrator Login and Enable APIs.
Creating Management Solution for Managed Backup Service
- Find "Management IT" table in Setup Tables:
Click Management IT option to view the Management Solutions list.
Click New Item icon to create a new Management Solution:
Enter the following name for the management solution: ManagedBackupService.
Drop-down the Management IT Solution list, select Custom and enter the same name for Custom Solution Name: ManagedBackupService.
- Click the Save icon on the toolbar to create a solution.
Creating Agreement Type for Managed Backup Service
Find Agreement Type table in Setup Tables.
Click Agreement Type option to view Agreement Type list.
Click New Item icon to create a new Agreement Type.
Enter the description as ManagedBackupService (similar to Management Solution name):
- Click "Save" icon on the toolbar to create an agreement type.
Create Agreement for ConnectWise Companies
- Select Companies tab on the left pane and click Company
Find a company for each you want to create an Agreement and click on the company to open its properties.
On the company page select Agreements tab in the bottom pane:
- Click New Item to create a new Agreement:
- select Agreement Type that you have previously created: ManagedBackupService
- specify an Agreement Name (that is similar to Agreement Type). In our example it is ManagedBackupService.
- choose whether to have an ending date or not (select No Ending Date in that case)
- Click Save on the toolbar to save changes.
Note: You will need to enter the agreement name on the Managed Backup Service settings for ConnectWise integration.
Repeat 2-5 steps for each company you want to have billing stats about.
Creating Product for Managed Backup Service
Select Procurement on the left pane then click Products.
Click New Item icon to create a new Product:
- specify a product name in Product ID (e.g. OnlineBackup)
Note: You will need this name on the Managed Backup Service settings for ConnectWise integration.
- specify a product description in the Description
- select Managed Services / Managed Services in the Category/Sub Category
- select Software as Product Type
- select Service as Product Class
- specify Customer Description e.g. Managed Backup Service provides a reliable backup solution.
- Click Save on the toolbar to create the product.
Create Cross-References for Managed Backup Service
- Select System on the left pane then click Setup Tables.
- Find Managed Devices Integration table in Setup Tables; click Managed Devices Integration
- Click New Item icon to create a new Managed Devices Integration:
- write ManagedBackupService in the Name and Solution fields
- select your Integrator login from the Integrator Login drop-down list
- Click Save icon on the toolbar. Then the bottom pane becomes available.
- Click New Item in the Cross-References tab to create a new Level:
- select SpaceUsage type
- enter HighLevel in the Level field
- select an agreement type you previously created from the Agreement Type list (i.e. ManagedBackupService)
- specify (or find) a product you have previously created in the Product field (i.e. OnlineBackup).
- select Backup Stats as a Configuration Type
- Click Save on the toolbar to save changes.
Manage Billing In Management Console
To manage billing, perform the following:
- Open the Management Console.
- In the Settings menu, select ConnectWise PSA.
- On Billing tab, select the billing entry and click edit button.
- Configure billing settings.
- Select cost and price settings.
The following settings are available:
- Average cost of used storage. Used storage space and averaged costs per GB will be sent
- Total Cost and Price are sent. Quantity is one. Total cost of used storage space will be sent
- Only Quantity is sent. Used storage space will be sent
- Enable auto-billing, if you want to send bills automatically.
- Save the settings. When auto-billing is enabled, invoices will be generated in Management Console and sent in accordance with the Agreement on the first 3 days of each month.
Send Billing to ConnectWise Manage
To send billing, perform the following:
- Open the Management Console.
- In the Settings menu, select ConnectWise PSA.
- On Billing tab, select the billing entry and click send button.
How to Find Billing Stats in ConnectWise
Open ConnectWise client
Select Companies and then click Company
Find a company name in the Company Name field and open its properties.
Select Agreement tab in the bottom pane. Click on the ManagedBackupService agreement.
Select Additions tab on the Agreement page to see the list of billing stats that have been sent to ConnectWise from Managed Backup Service:
- Click the name of the needed item (The Effective column shows a start date for selected period) to view the billing details:
Troubleshooting
In some cases due to configuration issues the following errors can be returned:
- The Effective Date: ... in agreement addition cannot precede the Billing Start Date: ...
- Effective date: ... cannot precede the agreement billing start date: ... If this is the case, use the following workaround:
- In ConnectWise Admin Console find the company for which the error was reported.
- Click Agreements.
- Click the agreement you want to correct. The Agreement page appears.
- On Additions tab change Effective Date to the same value as Billing Start Date and confirm the change.