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.
- Click on System
- Click on Setup Tables
- Type in 'GL Accounts' in the Table field
- Click on New, and create a mapping for each expense type in the following expense Account Types:
Expense Internal
Expense External
- 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
- Non-Product ID: (Leave Blank)
- Save each record.
- Navigate to Setup Tables > GL Accounts
- Click on New, and create a mapping for each expense type in the following expense Account Types:
Expense Offset
- 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
- Save the Record