Supplier Payables Aging Report

The Supplier Payables Aging Report is used to track the amounts owed by the business to suppliers, find out how many invoices are unpaid, and monitor the remaining balance for each supplier up to a specific date. This report helps the business owner organize payments and cash flow planning more accurately.

What Does the Report Display?

The report displays every supplier with outstanding invoices along with the following data:

• Supplier name (entity)

• Supplier reference number

• Amount owed to the supplier

• Number of outstanding invoices (shown in parentheses)

• Report date

• Total outstanding balance

The number shown in parentheses represents the number of outstanding invoices that:

• Have a status of Approved or Partially Paid

• Have not been fully paid as of the report date

How Are Outstanding Amounts Calculated?

• The report displays only the remaining balance from each invoice.

• If the invoice is partially paid:

  • Only the unpaid portion is displayed.

  • Whenever an additional payment voucher is assigned to the invoice, the outstanding balance decreases in the report.

• When the invoice is fully paid and its status is changed to Paid:

  • The invoice automatically disappears from the report.

Important Notes

• If a supplier payment voucher is added but not assigned to any invoice:

  • It does not affect the report

  • It does not reduce the total outstanding amounts

• The impact occurs only when the voucher is assigned to the invoice.

Invoice Statuses That Are Included or Excluded from the Report

Not Included in the Report

• Draft

• Awaiting Approval

• Fully Paid

Included in the Report

• Approved

  • They appear until a payment voucher is fully assigned to them.

• Partially Paid

  • Only the remaining balance is displayed.

  • They disappear upon full payment.

What Date Does the Report Rely On?

• The report relies on the invoice issue date.

• It reviews all invoices owed to the supplier up to the date you specify in the filter.

Interacting with the Report

When Clicking on the Supplier Name

• The supplier details are opened.

• The following appear:

  • All supplier invoices

  • All transactions related to it

• You can track the status of each invoice in detail through them.

Available Filter Options in the Report

You can control the display of data using the following filters:

1) Specific Date

• Displays invoices outstanding up to a specific date.

2) Comparison with a Previous Period

You can compare with:

• Previous year

• Previous month

• Previous quarter

• Previous week

3) Number of Comparison Periods

• You can select from one period to 13 periods.

• This means:

  • If you select Previous year and number of periods = 2
    → A comparison for the previous 2 years is displayed.

  • If you select Previous month and number of periods = 3
    → A comparison for the last 3 months is displayed.

Exporting the Report

• The report can be exported to:

  • Excel

  • PDF

• The export is based on the current filter.

• The exported data exactly matches what is displayed in the report.

When Should I Use the Supplier Payables Aging Report?

• To find out:

  • How much is owed in invoices to each supplier

  • The number of unpaid invoices

• To organize:

  • Payment priorities

  • Cash flow planning

• To track suppliers with:

  • Old or accumulated invoices