Expense Analysis workpaper (EXP)

How the EXP workpaper is populated from current year GL, which expense categories are excluded, and how it organises sections.

The Expense Analysis (EXP) workpaper reconciles all expense accounts that don't have their own dedicated workpaper. Each expense category gets its own section, allowing individual review and approval.

Data extraction

Automatically populated based on current year General Ledger (GL) Details for account codes mapped to expense categories in Chart of Accounts (CoA) mapping. Expenses that have their own dedicated workpapers are excluded from EXP.

Excluded categories

The following expenses have their own workpapers and therefore do not appear in EXP:

  • Accident Compensation Levy (ACC)
  • Accountancy (ACT)
  • Entertainment (ENT)
  • Non-Deductible Expenses (NDE)
  • Fines (part of NDE)
  • Wages (WRC)

Section structure

There is a separate section for each expense category based on the CoA mapping. Use the toggle to switch between:

  • Viewing all sections
  • Viewing only unreconciled sections

Manual journals

Any journal posted to an account code mapped under an expense category in CoA Mapping will automatically appear in that account category's workpaper section as a new line item.

Balance per GL

Sum of all the codes mapped under each expense category in CoA Mapping.

How to access

  1. Go to Jobs and open the relevant job.
  2. Click the Workpapers Icon or navigate to Results then Workpapers.
  3. Select EXP on the Workpapers Dashboard.