Datagate: How to Export Invoices to Connectwise Manage
Table of Contents
Scope
The following steps will show you how to export invoices to ConnectWise Manage.
Requirements
- Access to Datagate
- Connectwise Integrations
- Products Created in ConnectWise Manage.
Export Invoice
- Navigate to Invoicing
- Switch to Action Invoices
- Select the invoices you want to export.
- Note: To ensure you only select invoices for the period you want to bill, first Search by Invoice Date
- Click the Actions Button and Select Export Invoice
- It is going to ask you if you are sure. Select Yes.

- Set the Type of Export to ConnectWise Multiline. Then click Export.

- Note: If this is the first time you have exported to ConnectWise, please review all the steps below before starting. You may need to set up some new Products in ConnectWise before beginning.
- Note: You can terminate the wizard at any step except the final step, and the invoices won’t be exported.
- In the next couple of screens, you will need to select information regarding your export.
-
General Settings

- They're useful if you have a large number of agreements or Products in ConnectWise - it speeds up the following screens and reduces the number of items to select from
-
Agreements Mapping

- Choose the agreement you'd like to export your charges to
-
Grouping Type

- Choose how you'd like to group (sum) any Usage charges
-
Services Mapping

- Choose the ConnectWise product to map each Usage charge to
-
Product Mapping

- If you have the ConnectWise Product Sync enabled, your Products are already in the agreement. You don't want to export them again, so check the box “Exclude Recurring Products”
- If the ConnectWise Product Sync is not enabled, you do want to export your recurring charges, so select a ConnectWise product(s) to map the Datagate products to
-
Surcharge Mapping (mostly used in USA)

- Leave the box "Combine Surcharges with Taxes" unchecked.
- If you have a Surcharge, typically a Cost Recovery Fee in USA, select a ConnectWise product to map the charge to
-
Tax Mapping - USA and Canada only
- Select a ConnectWise Product for each tax
- Don't export taxes: taxes will not be exported to ConnectWise.
- Multiline taxes: Each tax can be mapped to its own ConnectWise Product. Different taxes can be exported to the same ConnectWise Product.
- Split Taxes by State: An option if you want to split Sales tax for different States into different ConnectWise Products
- Select a ConnectWise Product for each tax
-
Existing Items

- Always choose to Keep Existing Items
-
Price Calculation

- This is for usage.
- If you select Summarized (the most common), usage charges will be sent to ConnectWise with Quantity=1 and Amount=$total amount for that usage.
- If you select "Average Payment", the number of minutes (or MB etc, depending on the Usage unit) will be sent to ConnectWise in the Quantity field. The Unit Amount will be averaged so the line has the correct value
- This is for usage.
-
General Settings
- Select Export, once the export has been completed, the Connectwise Agreement will have an Additional line for each appropriate invoice line from the Datagate Invoice.
Note: The next step is to invoice the agreement in ConnectWise. Once your agreements are invoiced, you have the option to update the ConnectWise invoice number to match the Datagate one. This would be used if the Datagate-formatted invoice PDF is sent to the customer.
Update the ConnectWise Invoice Number
- From Invoicing/Action Invoices, select the same invoices
- Then export invoices.
- ConnectWise Invoice Number sync.
-
Note: A common accounting practice when there are interfaces, is to reconcile the invoice dollar amounts between ConnectWise and Datagate. Datagate recommends
-
Note: A common accounting practice when there are interfaces, is to reconcile the invoice dollar amounts between ConnectWise and Datagate. Datagate recommends