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

OwnerOfficeWorkgroup
Wise-SyncMelbourneSales
Wise-SyncMelbourneHelpdesk
Wise-SyncMelbourneDevelopment
Wise-SyncMelbourneSales
Wise-SyncVancouverSales
Wise-SyncVancouverHelpdesk
Wise-SyncLondonSales
Wise-SyncLondonHelpdesk
Wise-SyncAucklandSales
Wise-SyncAucklandHelpdesk

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 an office level, available at the (Invoice or Purchasing) record level.
  > Eg, Melbourne, London, Vancover, Auckland.
 
2. Workgroup - Ability to segment income and expense at a workgroup level
  > Eg. Helpdesk, Sales, Development

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