Sending Billing Statistics to ConnectWise

The integration with ConnectWise Manage allows you to sync Managed Backup Service billing statistics with ConnectWise. Starting with Management Console version 8.0, you can include the number and cost of activated licenses in the billing data sent to ConnectWise. Existing billing configurations will continue to work, but you can edit them to enable this new feature.

To start using the "send billing" feature, you should perform the following:

1. Map products between ConnectWise and Management Console as described in the Product Mapping article
2. Set invoice settings
3. Enter cost and price settings
4. Configure billing settings for the companies.

Invoice Settings

Invoice settings allow you to set invoice descriptions. The following invoice 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

Cost and Price Settings

For each product (license) being billed, Price and Cost settings must be configured:

• On the Billing tab, click Cost/Price Settings to enter the values for activated licenses.
• If Cost/Price Settings are not configured, the cost and price for these products will default to 0.

For storage account billing, refer to the Billing and Storage Usage article for instructions on setting cost and price settings for backup, restore, and storage limits.

Create / Edit Billing Configuration for Companies

To manage billing, perform the following:

1. Open the Management Console.
2. In the Settings menu, select ConnectWise PSA.
3. On the Billing tab, select the company entry and click the Edit button.

4. The Edit company billing wizard starts. Click +Add configuration to configure billing.

5. Enable auto-billing, if you want to automatically send bills for every month. When auto-billing is enabled, invoices will be generated in the Management Console and sent in accordance with the Agreement on the first 3 days of each month. If auto-billing is disabled, manual sending of bills updates the previous month bill, if this bill is not automatic and creates/updates the temporary bill for the current month.

6. Select ConnectWise products being billed.

7. Select Management Console products being billed.

8. Select ConnectWise agreement for Managed Backup Service.

9. Select what data will be sent to ConnectWise for billing. The following settings are available depending on selected products:
   • Average Cost and Price for all selected products to bill. This option is not available if the storage accounts and licenses are selected in one configuration. It is recommended to create different configurations for licenses and storage accounts in case you need this option.
   • Total Cost and Price for all selected products to bill. (Quantity =1). This option is the only option available if the storage accounts and licenses are selected in one configuration.
   • Quantity only for all selected products to bill
10. Check the billing configuration and save it. This option is not available if the storage accounts and licenses are selected in one configuration. It is recommended to create different configurations for licenses and storage accounts in case you need this option.

Average Cost and Price for all selected products to bill

If only storage accounts are selected:

Quantity = Total Backup (GB) + Total Restore (GB)

Cost = (Total Backup Cost + Total Restore Cost)/Quantity

Price = (Total Storage Limit Cost + Total Backup Price + Total Restore Price)/Quantity

If only activated licenses are selected:

Quantity = Number of Products (activated licenses)

Cost = Total Cost / Quantity

Price = Total Price / Quantity

Total Cost and Price for all selected products to bill (Quantity = 1)

The total cost is calculated. Quantity is 1.

Quantity = 1

Cost = (Total Storage Limit Cost + Total Backup Cost + Total Restore Cost) + (Number of Products * Product Cost)

Price = (Total Storage Limit Cost+ Total Backup Price + Total Restore Price) + (Number of Products * Product Price)

Quantity only for all selected products to bill

In this case, only the number of GB or Licenses is sent depending on the selected products. The price for the service and costs are taken from ConnectWise PSA (price and cost is set in ConnectWise Product).

If only storage accounts are selected:

Quantity = Total Backup(GB) + Total Restore(GB)

Cost = NULL (values will be taken from Connectwise Product’s default values)

Price = NULL (values will be taken from Connectwise Product’s default values)

If only activated licenses are selected:

Quantity = Number of Products

Cost = NULL (values will be taken from Connectwise Product’s default values)

Price = NULL (values will be taken from Connectwise Product’s default values)

Send Billing to ConnectWise Manage

To send billing, perform the following:

1. Open the Management Console.
2. In the Settings menu, select ConnectWise PSA.
3. On Billing tab, select the billing entry and click the send button.

How to Find Billing Stats in ConnectWise

1. Open ConnectWise client

2. Select Companies and then click Company

3. Find a company name in the Company Name field and open its properties.

4. Select Agreement tab in the bottom pane. Click on the ManagedBackupService agreement.

5. Select Additions tab on the Agreement page to see the list of billing stats that have been sent to ConnectWise from Managed Backup Service:

6. 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:

1. In ConnectWise Admin Console find the company for which the error was reported.
2. Click Agreements.
3. Click the agreement you want to correct. The Agreement page appears.
4. On the Additions tab change Effective Date to the same value as Billing Start Date and confirm the change.