Background: AP Aged Trial Balance Report

Use the AP Aged Trial Balance Report (NTB) program to print an aging schedule for selected vendors by invoice date or due date. See Road Map for work flow.

You can print the report any time; typically, you print it at month-end.

This topic has these subtopics:

Aging Periods
Trial Balance Report

Aging Periods

The program groups invoices in five periods aged by either the invoice due date or invoice date. You can set the number of days a period with the Select number of days in aging Program option. For standard 30-day periods, the program groups invoices into these periods:

  • Current: 1-30 days

  • 30 days: 31-60

  • 60 days: 61-90

  • 90 days: 91-120

  • 120 days: over 120 days

For 10-day periods, the program groups aged invoices as follows:

  • Current (1-10 days)

  • 10 days: 11-20

  • 20 days: 21-30

  • 30 days: 31-40

  • 40 days: over 40 days

Trial Balance Report

The report includes this information:

  • Organization code

  • Vendor number

  • Vendor name

  • Invoice number

  • Terms

  • Currency

  • Currency reported in

  • Transaction type: BF: Fixed billing, BI: Billing invoice, CM: Credit memo, CP: Cash payment, DM: Debit memo

  • Invoice number or Reference and Due date or Invoice date if you selected the Include reference/invoice date fields? Program option; if output to a file, the information is included regardless of the option

  • Invoice age in days

  • Invoice balance for the current aging period, second, third, fourth, or fifth aging period

  • Organization code, payment number, transaction type, due or invoice date, and payment amount

  • Invoice balance for each aging period

  • AP report total and the total balance for each aging period

  • File output includes vendor name