How an AP Aging Report Works
An AP aging report starts with open supplier invoices recorded in the accounts payable ledger. Each invoice is matched with its invoice date, due date, outstanding amount, supplier, payment terms, and relevant accounting information. The system then assigns each unpaid balance to an aging bucket based on the selected reporting method.
Some businesses age invoices from the invoice date, while others use the due date to distinguish invoices that are not yet payable from those that have become overdue. Using due-date aging is particularly useful for payment planning because it separates upcoming obligations from amounts requiring immediate attention.
Effective invoice processing provides the underlying data for an accurate aging report. Capture, extraction, validation, matching, GL coding, approval, and posting should maintain consistent invoice references and amounts throughout the AP workflow.
AP Aging Buckets and Calculation
A common approach divides open invoices into defined time periods. The report can show both the number of invoices and the outstanding monetary value in each bucket.
Invoice Age = Report Date − Invoice Due Date
For example, if an invoice was due on June 1 and the AP aging report is prepared on June 21, the invoice is 20 days overdue and falls into a 1–30-day overdue bucket. If the outstanding balance is $25,000, that $25,000 contributes to the corresponding aging category.
The report can also calculate the proportion of total outstanding AP represented by each bucket. If total outstanding payables are $1,000,000 and invoices more than 90 days overdue total $120,000, the over-90-day balance represents 12% of outstanding AP.
Interpreting AP Aging Results
A relatively high current balance generally indicates that a significant portion of supplier obligations is still within agreed payment terms. A larger overdue balance can indicate that payment timing requires review, while a growing older balance can warrant investigation of disputed invoices, approval status, missing documentation, or supplier-account issues.
- Current: Invoices are generally within their agreed payment period and can be incorporated into scheduled cash planning.
- 1–30 days overdue: Recent overdue balances can be reviewed for approval, payment scheduling, or documentation status.
- 31–60 days overdue: Older obligations may require closer supplier and internal workflow review.
- 61–90 days overdue: Material balances can affect supplier relationships and should receive focused follow-up.
- Over 90 days: Long-outstanding balances may require reconciliation, dispute resolution, or management attention.
Age alone does not establish why an invoice remains unpaid. A legitimate dispute, contractual hold, scheduled payment term, or pending approval can produce an aged balance with a valid business explanation.
Invoice Matching and Approval Controls
Accurate aging depends on reliable invoice matching and approval records. invoice matching connects invoice information with purchase orders, receipts, quantities, prices, and other supporting records before payment is scheduled.
AP Invoice Matching Approval describes the approval stage associated with confirming that an invoice has passed the applicable matching requirements and can proceed through the AP workflow.
Similarly, Accounts Payable Matching Approval provides a defined approval concept within accounts payable workflows, helping organizations maintain consistent controls around invoice verification and payment readiness.
The educational guide Vendor Invoice Processing 2025: AI Supplier Workflow Guide covers invoice capture, validation, matching, posting, accuracy, and supplier collaboration, which are closely connected to the quality of the underlying AP aging data.
Cash Flow, Payments, and Supplier Management
An AP aging report supports cash-flow planning by showing which obligations are due now and which can be scheduled later according to contractual terms. Finance teams can combine aging information with available cash, expected collections, discounts, and payment calendars when determining payment priorities.
Payment Approval is the formal authorization step that allows an approved payable to proceed toward payment. Keeping approval status visible in the aging report helps distinguish invoices that are ready for payment from invoices awaiting an internal decision.
The payments workflow can then use approved invoice balances, due dates, supplier terms, and available cash information to support payment scheduling and liquidity management.
vendor management also benefits from AP aging visibility because finance teams can identify recurring overdue balances, monitor supplier obligations, and coordinate invoice-status communication with vendors.
AP Automation and Procurement Integration
AP Automation Software can automate invoice processing and payment planning while maintaining structured AP data for reporting and control. When invoice records, approvals, due dates, and payment information remain connected, aging reports can provide more timely visibility into outstanding obligations.
The procurement function also affects AP aging because purchase requisitions, purchase orders, supplier selection, receiving records, and approvals establish much of the information needed to validate supplier invoices.
The guide How Vendor Portals Improve Invoice Transparency examines how invoice-status visibility can support supplier communication across capture, processing, validation, approval, and payment stages. Better visibility into these stages can make aging balances easier to interpret.
Within broader accounts payable workflows, teams can connect invoice data, approval status, payment planning, and supplier records to create a more complete view of outstanding obligations and working-capital requirements.
Best Practices for AP Aging Reports
- Use consistent aging logic based on clearly defined invoice or due dates.
- Reconcile the aging report with the AP subledger and general ledger at each reporting period.
- Separate disputed, held, approved, and scheduled invoices where the reporting system supports these statuses.
- Review older balances by supplier, business unit, currency, invoice type, and responsible owner.
- Compare aging trends across reporting periods to identify changes in outstanding obligations.
- Use payment terms and contractual due dates when planning cash outflows and supplier payments.
Summary
An AP Aging Report organizes unpaid supplier invoices by age, giving finance teams visibility into current and overdue obligations. By combining invoice balances, due dates, approvals, matching information, supplier records, and payment status, the report supports cash-flow planning, supplier management, reconciliation, and financial reporting. Consistent aging rules and reliable AP data make the report a practical tool for managing working capital and payment decisions.