Term Loan workpaper (TLN)

How to remap accounts under Term Loan, how the workpaper adapts to multiple loan agreements, and how Balance per GL splits into Current and Term.

The Term Loan (TLN) workpaper reconciles each term loan agreement separately, splitting the balance between the current portion (due within 12 months) and the term portion (due after 12 months). Like the Hire Purchase (HP) Liability workpaper, it requires account remapping before use when a business holds multiple loans.

Data extraction

This workpaper is manual. Users need to enter the details manually.

Re-mapping accounts (first step)

Before using the workpaper, remap all accounts under Term Loan to Term Loan 1 and Current Portion of Term Loan 1, Term Loan 2 and Current Portion of Term Loan 2, and so on, depending on the job:

  1. Click the Edit button.
  2. Map the accounts under the Chart of Accounts (CoA) Mapping column.
  3. Save the changes.

Section structure

After re-mapping the accounts and saving changes, separate sections for each Term Loan Account are populated in the workpaper. For example, if account codes are re-mapped between Term Loan 1 and 2, the workpaper will display two loan schedules.

Use the toggle to switch between:

  • Viewing all sections
  • Viewing only unreconciled sections

Balance per General Ledger (GL)

  • Balance per GL (Current): Balance of account codes mapped under the respective Current Portion of Term Loan Account.
  • Balance per GL (Term): Sum of mapped accounts for the Term Loan Account.

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 TLN on the Workpapers Dashboard.
  4. Click Edit and complete the account remapping before entering data.