Expense GL Mappings in ConnectWise Manage

GL Mapping of Expense Types

The most comprehensive way to map the GL Accounts for Expenses is to complete the mapping at an Expense Type. This will provide you with the ability to map each type (Mileage, Cabs, Airfares, Accommodation) to corresponding expense accounts in the accounting package. It is also important to consider the Cost of Goods Sold implications if you extensively use Expenses for Reimbursable Activities, which are billed to Clients.

Create a new GL Mapping for Each Expense Type 

  1. Click on System
  2. Click on Setup Tables
  3. Type in 'GL Accounts' in the Table field
  4. Click on New, and create a mapping for each expense type in the following expense Account Types:

    Expense Internal

    Expense External

  5. Update the record supplying the following as indicated :

    a) Account Type: [Expense Internal / Expense External]

    b) Table: Expense Type

    c) Record: [Each Record in List]

    d) Account: Your expense account to allocate expense costs to.

    e) COGS: (Leave Blank)

    f) Table: Expense Type

  6. Non-Product ID: (Leave Blank)
  7. Save each record.
Create a new GL Mapping for Expense Offset 
The expense offset account is used to allocate "Non-Reimbursable" company expenses, which effectively pushes the liability to a clearing account for re-allocation as required. Wise-Sync manages the Offset Account as part of the Expense Setup. You can however map a record for due process.
  1. Navigate to Setup Tables > GL Accounts
  2. Click on New, and create a mapping for each expense type in the following expense Account Types:

    Expense Offset

  3. Update the record supplying the following as indicated:

    a) Account Type: Expense Offset

    b)Table: Expense Type

    c)Record: Owner

    d) Account: Your Unpaid Expense Claim Account (Liability)

    e) COGS: (Leave Blank)

    f) Non-Product ID: OFFSET

  4. Save the Record
P
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.