Create GL Mapping Records to Map Non-Product Revenue Accounts to QuickBooks Online Account Numbers

In this section we will be mapping the non product revenue and cost of goods sold (COGS) account numbers from QBO into the GL Mapping Tables for Revenue Tables in ConnectWise. If you are looking to make changes to your Chart of Accounts in QBO, it is recommended that you complete any account changes (numbering), before commencing the GL Mapping in ConnectWise.

There are several considerations when mapping non product revenue and COGS through the GL Accounts Setup Table. If you need assistance or clarification we suggest you review the Getting Started - Connectwise GL Mapping knowledge base articles.

The notable difference between revenue from Products and non-products is that Wise-Sync will require a Non-Product ID in order to post 'Non Product' revenune, for example Service Revenue. Including the Non-ProductID helps by using QBO products items for these revenue lines, allowing you to run reports for product items sold in QBO. This can provide effective segmentation by using different non-product ID's for your revenue centers.

When entering revenue for each account line in the Setup Tables > GL Accounts, the corresponding COGS account must be entered for all revenue entries. This account is referred to when goods are sold, such as by those who have the procurement module in ConnectWise. Although not all accounts will have a COGS account, Wise-Sync requires that both the Revenue "Account" and the "COGS" account are entered for validation purposes. For accounts that do not have a direct COGS account (or ones which will rarely be sold), it is recommended that you enter and refer these revenue accounts to a "All other COGS" account.

How to Setup your GL Accounts to Map Revenue In ConnectWise

Information you'll need..

  1. Your revenue and Cost of Goods (expenses) accounts List from QBO.
  2. An understanding of how your Connectwise data is structured with the view of mapping to a corresponding revenue and expense account in QBO.
  3. A List of Non-Product ID's for allocation in QBO

To get Started, the following records need to be created at the desired level for revenue segmentation in QBO. The following Revenue Accounts will need to be mapped a corresponding QBO account.

  • Revenue
    > Revenue from all other Sources (Service Revenue, Special Invoices).
  • Revenue-Agreements
    > Revenue from Agreements (Billing Amount)
  • Revenue-Expenses
    > Revenue from Expenses(Billed to Client)

Note for users with Multiple Companies in Wise-Sync: It is possible to define different levels of output for for different locations in connectwise, although this would require clear segmentation between your revenue streams. It is recommended that you maintain a consistent set of accounts between your QBO organisations to simplify the complexity of your GL Mapping requirements. The above only applies where the same account number is used for each revenue or COGS account.

Scenarios on Revenue & Expense Segmentation

If you are looking to understand further how segmentation might work for your company structure, the following scenarios help to step you through the way in which data can be extracted from ConnectWise to provide you with the most appropriate method of segmentation.

Revenue:

  • My Company: Owner Level
  • My Company:  Structure Level
  • My Company: Group Level
  • Project: Type
  • Service: Type
  • Charge Code
  • Individual Project

Revenue Agreements:

  • My Company: Owner Level
  • My Company:  Structure Level
  • My Company: Group Level
  • Agreement: Type


Step 1: System > Setup Tables


  1. Search for the Setup Table "GL Accounts"
  2. Select the "GL Accounts" Setup Table

Step 2: Confirm Revenue & Expense Account Numbers in QBO


  1. Log into your QBO organisation and from the top settings menu click on: Settings > Chart of Accounts
  2. Click in the filter to limit the results to your Service Revenue Accounts by typing a relevent search term  I.e. "MSA".
  3. Take Note of your "Agreement Revenue" accounts details for each account required:
    1. Code
    2. Name

Repeat the same steps (3-4) above for the corresponding Agreement Expense Accounts. If you do not have a direct COGS account (as this is normaly payroll / labour account), then it is recommended that you allocate the COGS for each to a generic COGS account such as "All Other COGS"


Step 3: Create a New GL Mapping for Agreement Revenue & COGS Accounts 

In the following scenario, we will map to the most detailed agreement revenue output level, which is the "Agreement Type". This will provide for the segmentation of revenue and expenses (where the agreement type is used on procurement items) to this level. As the agreement type is for "Services" which are not attributable to any product.

NOTE: A Non-Product ID must be specified for each record which uses this type.


  1. Select the Account Type from the Drop Down List
  2. Select the Table (Agreement Type) to refer the mapping to the agreement type level.
  3. Select the Record based on the table
  4. Enter the "QBO Revenue Account Number" for the corresponding QBO chart of accounts number.
  5. Enter the "QBO COGS Account Number" for the corresponding QBO chart of accounts number. If there is not a direct match, enter your "All Other COGS Account".
  6. Enter a "Non-ProductID" which will be allocated to all revenue for this agreement type.
  7. Save the Record, and continue

Repeat the above steps for each of the following Account Types:

  • Revenue
  • Revenue-Agreements
  • Revenue-Expenses