How the Epicor AP Aging Report Works
The report uses open accounts payable transactions and assigns their outstanding balances to aging periods based on a selected reporting date. When the report ages invoices by due date, it shows how far each obligation is from its contractual payment deadline. When it uses invoice date, it shows how long an invoice has been outstanding since it was issued or recorded.
Common aging buckets include current, 1–30 days, 31–60 days, 61–90 days, and over 90 days. Each bucket aggregates the balances of transactions that fall within its date range. The report may also provide supplier-level details, invoice references, due dates, and remaining balances to help users trace totals back to individual documents.
- Current invoices: Obligations that have not yet reached the relevant overdue threshold.
- Recently overdue: Invoices that need payment scheduling or a check of approval status.
- Older overdue balances: Items requiring investigation of disputes, missing credits, or delayed processing.
- Long-outstanding balances: Transactions that may need supplier-statement review, escalation, or correction before close.
Key Calculations and a Practical Example
When aging is based on the due date, overdue days can be calculated as follows:
Days overdue = Report as-of date − Invoice due date
For example, assume a supplier invoice has an outstanding balance of $12,500 and a due date of September 1. If the report's as-of date is October 11, the invoice is 40 days overdue. Under standard aging ranges, the $12,500 balance belongs in the 31–60 day bucket, provided no payment, credit, or adjustment has reduced the amount.
The total for an aging bucket is the sum of the outstanding balances assigned to that period. Adding the bucket totals should reconcile with the total open AP balance included by the report's filters. Differences can arise when users compare different reporting dates, currencies, transaction selections, or treatments of credits and unapplied transactions.
How to Interpret Aging Results
A large balance in older buckets can indicate delayed approvals, unresolved supplier disputes, missing transaction information, or payment timing that needs review. However, age should be considered alongside agreed payment terms: an invoice may be old by invoice date but not yet overdue under its contractual terms.
A high current balance may reflect normal purchasing activity and invoices scheduled for upcoming payment runs. A low total outstanding balance may indicate that invoices have been settled or that purchasing activity has changed. Neither result should be interpreted alone. Compare aging patterns across periods and review them alongside payment schedules, purchase volumes, available liquidity, and supplier priorities.
For instance, if a business sees $40,000 move into the 61–90 day bucket, the AP manager can examine invoice approvals, supplier correspondence, credit notes, and payment records. Identifying the reason for the increase helps determine whether to release an approved payment, resolve a dispute, or correct an accounting record.
Connecting Aging Reports to AP Workflows
Reliable aging depends on accurate invoice data and transaction status. Consistent invoice processing captures invoice dates, due dates, supplier details, amounts, and coding information. invoice matching compares invoices with relevant purchase orders and receipt records, helping teams verify amounts before posting and payment. The Vendor Invoice Processing 2025: AI Supplier Workflow Guide provides additional context on capture, validation, matching, and posting practices that support a dependable AP workflow.
Within accounts payable, clear approval ownership helps invoices progress through review and posting. AP Invoice Matching Approval concerns authorization or review of invoice-matching results, while Accounts Payable Matching Approval describes matching authorization in the wider AP process. A defined Payment Approval process establishes who can authorize the release of funds.
AP Automation Software can coordinate invoice handling and payment planning, while payments workflows help teams schedule approved obligations against due dates. Accurate vendor management keeps supplier records and communication details current. The procurement process also contributes to AP accuracy by maintaining purchase-order and receiving information that can support invoice verification.
Where suppliers need visibility into invoice progress, the practices described in How Vendor Portals Improve Invoice Transparency can help communicate receipt, approval, and payment milestones without relying solely on individual follow-ups.
Best Practices for Reviewing the Report
Establish a consistent review routine and document the reporting parameters used. This makes comparisons between reporting periods more meaningful and helps managers assign clear actions to overdue items.
- Confirm the as-of date, aging basis, company, supplier filters, and currency settings.
- Prioritize overdue invoices by amount, contractual terms, supplier importance, and operational impact.
- Review credit balances, disputed invoices, duplicate entries, and unmatched supplier statements.
- Assign an owner and next action to each material overdue balance.
- Reconcile report totals to the AP control account and investigate material differences before financial close.
Use the results to coordinate upcoming payments, maintain appropriate cash reserves, and communicate realistic payment dates to suppliers. A regular review also helps distinguish routine payment timing from items that require immediate investigation.
Summary
The Epicor AP Aging Report groups outstanding supplier invoices by age so finance teams can monitor overdue liabilities, investigate open items, and prioritize payment activity. Correct report settings, accurate invoice data, clear approval workflows, and reconciliation to the general ledger help make the report useful for supplier management, financial reporting, and cash-flow planning.