Step 1 > 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 Xero. 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


1. Click on New, and create a mapping for each expense type in the following expense Account Types:
  • Expense Internal
  • Expense External



2. Update the record supplying the following as indicated:
  • 1. Account Type: [Expense Internal / Expense External]
  • 2. Table: Expense Type
  • 3. Record: [Each Record in List]
  • 4. Account: Your expense account to allocate expense costs to.
  • 5. COGS: (Leave Blank)
  • 6. Non-Product ID: (Leave Blank)
3. 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.

Navigate to Setup Tables > GL Accounts:


1. Click on New, and create a mapping for each expense type in the following expense Account Types:
  • Expense Offset
2. Update the record supplying the following as indicated:
  • 1. Account Type: Expense Offset
  • 2. Table: Expense Type
  • 3. Record: Owner
  • 4. Account: Your Unpaid Expense Claim Account (Liability)
  • 5. COGS: (Leave Blank)
  • 6. Non-Product ID: OFFSET
3. Save each record.

Next Step: Setup Wise-Sync Expense Options