How Epicor AP Aging Works
AP aging uses open accounts payable transactions and compares their relevant dates with a selected as-of date. Depending on the report settings, invoices may be aged by due date or invoice date. Aging by due date is particularly useful for identifying payment obligations that have passed their contractual deadlines, while invoice-date aging shows how long invoices have been outstanding since receipt or entry.
To interpret the report correctly, users should confirm the aging basis, reporting date, currency, supplier filters, and whether credits or other adjustments are included. These settings affect which bucket contains each transaction and the total outstanding balance.
- Current: Invoices that have not yet reached the selected aging threshold or due date.
- 1–30 days: Recently overdue invoices that may need payment scheduling or supplier communication.
- 31–60 days: Obligations that may require follow-up on approvals, disputes, or payment status.
- 61–90 days: Older outstanding items that merit review against contractual commitments and supplier relationships.
- Over 90 days: Long-outstanding balances that may need investigation, dispute resolution, or reconciliation.
Understanding AP Aging Buckets and Calculations
Aging buckets classify invoices according to the number of days between the selected reference date and the report's as-of date. When aging by due date, the overdue days can be calculated as:
Days overdue = Report as-of date − Invoice due date
For example, assume an invoice for $12,500 was due on September 1 and the report date is October 11. The invoice is 40 days overdue, placing it in the 31–60 day bucket when those standard ranges are used. If no payment, credit, or adjustment has been applied, the outstanding amount remains $12,500.
The total in each bucket is the sum of the open balances assigned to that range. Adding the bucket totals should reconcile to the report's included outstanding AP balance, subject to the report's filters, currencies, and treatment of credits or unapplied transactions.
What High and Low Aging Balances Indicate
A large balance in older buckets can indicate that invoices are awaiting approval, payments are delayed, suppliers have raised disputes, or transaction records need review. It may also reflect deliberately negotiated payment terms, so age alone does not establish that a balance is overdue or requires immediate payment.
A larger current balance can reflect normal purchasing activity and invoices that are not yet due. A smaller overall aging balance may indicate that liabilities have been settled or that fewer invoices remain open. Finance teams should interpret both the bucket distribution and total AP alongside payment terms, cash availability, purchase volumes, and the company's operating cycle.
For example, if a supplier account has $40,000 in the 61–90 day bucket, the AP manager can review invoice approvals, supplier correspondence, credit notes, and payment records to determine why the balance remains open. Resolving the underlying items helps prioritize payments and supports more reliable financial reporting.
Using AP Aging to Improve Invoice and Payment Controls
AP aging becomes more actionable when connected to invoice capture, validation, approval, and posting processes. Accurate invoice processing helps ensure supplier names, invoice dates, due dates, amounts, and payment status are recorded consistently. AP Invoice Matching Approval describes the authorization or review step associated with matching an invoice to supporting records, while Accounts Payable Matching Approval relates to validating matching results within the wider AP workflow.
A defined Payment Approval process ensures that payment authorization follows company policy before funds are released. AP Automation Software can support invoice processing and payment planning, while automated payments workflows help teams coordinate due dates and approved obligations. Procurement controls and vendor management also help maintain reliable supplier details and resolve invoice questions before they remain outstanding for extended periods.
When reviewing the Vendor Invoice Processing 2025: AI Supplier Workflow Guide, finance teams can compare their own capture, validation, matching, coding, and posting practices with approaches to improving invoice workflow consistency. Effective invoice matching helps confirm that invoices align with purchase orders and receipts before approval and payment. Clear supplier updates, including practices discussed in How Vendor Portals Improve Invoice Transparency, can also help stakeholders understand invoice status and the next required action.
Best Practices for Reviewing Epicor AP Aging
Use a consistent review process so the report supports operational decisions rather than serving only as a month-end snapshot. Compare current and prior periods, investigate material changes in older buckets, and assign clear ownership for unresolved items. Review the report together with payment schedules, supplier statements, and the general ledger to understand the full position.
- Run the report using a clearly documented as-of date and aging basis.
- Prioritize overdue invoices by amount, supplier importance, contractual terms, and business impact.
- Investigate credit balances, duplicate records, disputed invoices, and differences between supplier statements and ERP balances.
- Track reasons for delayed approvals or payments and assign follow-up actions to specific owners.
- Reconcile report totals to the relevant AP control account and explain material differences before financial close.
Summary
Epicor AP Aging helps finance teams organize open supplier invoices by age, assess overdue obligations, and prioritize follow-up. Its value depends on correct report settings, reliable invoice dates and due dates, accurate transaction status, and regular reconciliation. Used alongside invoice controls, approval workflows, and payment planning, AP aging supports stronger supplier relationships, clearer liability reporting, and better working-capital decisions.