Payables Aging Reports Guide

How to use A/P Aging Summary, A/P Aging Detail, and the month-wise payables aging reports to monitor overdue vendor balances and manage accounts payable review in QBM.

Purchasing & Vendors Accounts Payable End-User Guide

Overview

Payables aging reports help you review what is owed to vendors and how long balances have remained unpaid. They support payment planning, supplier follow-up, and closing review.

SummaryHigh-level overdue payables review.
DetailSupporting lines behind overdue vendor balances.
Month-WiseBroader trend analysis over the year.

Reports Covered

Report Menu Path Main Use
Payables Aging Summary Reports > Vendors > A/P Aging Summary Quick review of overdue vendor balances.
Payables Aging Detail Reports > Vendors > A/P Aging Detail Detailed supporting view of outstanding vendor balances.
Payables Aging Summary by Month Reports > Vendors > A/P Aging Summary by Month Month-by-month aging trend review for payables.
Payables Aging Detail by Month Reports > Vendors > A/P Aging Detail by Month Detailed month-wise payables aging investigation.

Common Filters

Field Or Option What It Means
Vendor Review one vendor or the full supplier list.
Date / Date Range Selects the aging date or period you want to review.
Display Type Choose list or graph where the summary report supports visual output.
Graph Type Where available, choose vertical, line, or pie to present payable aging visually.

What Aging Means

Payables aging groups vendor balances by how long they have remained unpaid. It helps the business decide what is current, what is coming due, and what is already overdue.

Use summary first: Start with the summary report to see which suppliers need action, then move to the detailed report for the supporting lines.

How To Use The Reports

  1. Run Payables Aging Summary for the selected review date.
  2. Use vendor filtering if one supplier account needs special review.
  3. Move to Payables Aging Detail when you need invoice-level support.
  4. Use the month-wise versions when finance wants to review whether payables pressure is increasing or improving through the year.
  5. Use graph view for management discussion and list view for payment planning or export.

Best Practice

  • Use the same aging date when comparing supplier balances across teams.
  • Review aging before payment runs so priority suppliers are clear.
  • Use month-wise versions when management wants trend review instead of only the current position.
  • Investigate unusual balances before finalizing payables aging for reporting.
Important: Aging results depend on bills, credits, and vendor payments being recorded and allocated correctly in QBM.