Pre-Setup Connectwise > GL Mapping > Understanding the Levels

Understanding the Levels when defining GL Mapping

There are several levels in which the data can be exported to xero, understanding what the levels are in ConnectWise is fundamental in the output into Xero.

  1. Company Structure
  2. Accounting System Setup (ConnectWise)
  3. GL Mapping
  4. XERO Chart of Accounts
  5. Connectwise to XERO Chart of Accounts mapping

In each of these areas, incorrect configuration will result in either a batch record validation error (inability to post into xero) or data being posted into an incorrect account in Xero.

The following provides learning suggestions in understanding the management of data in both systems:

Company Structure

Your company structure in ConnectWise will provide for facility to break down the revenue and expense based on this structure.The following table provides segmentation options in the Accounting Interface, for a company with three billing locations, each with different workgroups.


Based on the above table, the following would be the ways in which you could segment the data to provide either granular or top level considated data through to Xero.

  1.  Owner- Most top level, provides no further segmentation

    > Eg. Wise-Sync

  2.  Office - Ability to segment income and expense at a workgroup level

    > Eg. Melbourne, London, Vancover, Auckland.

  3.  Workgroup - Ability to segment income and expense at a workgroup level

    > Eg. Helpdesk, Sales, Development


It is important to plan how you would like the data to map from ConnectWise, as once invoices and purchase orders are closed, the GL Mapping has already been created. In order to re-create the GL Entries, the invoice or purchase order will need to be re-opened.

Paul is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.