How the Report Works in Sage 100
The report uses accounts payable records to present vendor balances according to their due dates or aging basis. Depending on the selected options, it may show invoice references, transaction dates, due dates, open amounts, vendor identifiers, and aging bucket totals. Finance teams can review the overall liability position or narrow the output to selected vendors, dates, or other available criteria.
The report is most useful when its reporting date and aging basis are consistent with the question being investigated. For example, a report run for a month-end close should reflect the intended cutoff date so the team can distinguish obligations due before period-end from those due afterward. Review the selected parameters before comparing results across periods.
How to Read Aging Buckets
Each aging bucket shows the amount of unpaid invoices falling within a defined period. Current balances generally represent invoices not yet overdue under the selected basis. Older buckets highlight obligations that have remained outstanding for longer and may need follow-up with the vendor, purchasing team, or invoice approver.
- Current: Amounts that are not yet overdue and can be included in upcoming cash planning.
- 1–30 days overdue: Recently past-due invoices that may require payment scheduling or a review of approval status.
- 31–60 days overdue: Balances that warrant checking for missing documentation, disputed charges, or delayed authorization.
- 61–90 days overdue and older: Long-outstanding items that may need escalation, vendor reconciliation, or investigation of unapplied credits.
Older balances do not automatically mean an invoice is valid and ready for payment. Confirm the invoice, receipt of goods or services, credit notes, and any payment already issued before deciding on the next action.
Worked Example and Financial Impact
Assume a company has five open vendor invoices with balances of $4,000 current, $2,500 overdue by 1–30 days, $1,800 overdue by 31–60 days, $900 overdue by 61–90 days, and $300 overdue by more than 90 days. The total outstanding accounts payable is $9,500, calculated by adding all five balances: $4,000 + $2,500 + $1,800 + $900 + $300 = $9,500.
In this example, $5,500 is overdue, while $4,000 remains current. The finance manager can use that split to prioritize overdue invoices, confirm which payments are ready for release, and reserve cash for obligations coming due. If an older invoice is awaiting a purchase receipt or approval, the report provides a starting point for resolving the hold rather than paying without verification.
Using Aging Results to Manage Accounts Payable
The report supports daily payment planning, month-end close, supplier communication, and short-term cash forecasting. Reviewing it alongside procurement records can help explain whether an invoice is awaiting a purchase order, receipt, or confirmation of the goods or services. Consistent vendor management also helps maintain accurate supplier details and provides a clear route for resolving invoice questions.
Invoice-level review matters because the aging report summarizes open balances rather than explaining every reason an item remains unpaid. A disciplined invoice processing workflow can connect invoice capture and validation with coding, approval, posting, and payment preparation. For teams seeking more standardized handling, AP Automation Software can support invoice processing and payment planning, while keeping the report useful for reviewing obligations and exceptions.
Where a company uses invoice matching, staff can compare invoice details with purchase orders and receipt records before releasing an item for payment. Guidance such as Vendor Invoice Processing 2025: AI Supplier Workflow Guide can provide additional context on capture, validation, matching, and posting steps. These checks improve the quality of the open-payables information used in the report.
Reconciliation, Controls, and Best Practices
For reliable results, reconcile the report total to the accounts payable control account in the general ledger for the same reporting date. Differences may arise from cutoff timing, unposted transactions, report criteria, or adjustments recorded in one area but not another. Investigate the cause before using the figures for financial reporting.
When invoice capture and validation are part of the workflow, accounts payable teams can review the supporting documents and approval status before an item becomes a planned payment. How Vendor Portals Improve Invoice Transparency also offers useful context for communicating invoice status and progress with suppliers. Within the approval process, AP Invoice Matching Approval concerns authorization after invoice details are checked, while Accounts Payable Matching Approval supports controlled review within the broader AP workflow. Before issuing funds, Payment Approval establishes that the payment has received the required authorization. Once approved, scheduled payments should align with due dates, cash availability, and company policy.
Teams may also compare aging trends across periods, investigate recurring old balances, and document explanations for material items. Use consistent report parameters and retain supporting reconciliations so reviewers can reproduce the figures during close or audit procedures. accruals and other period-end adjustments should be reviewed separately where applicable, because an aging report of open AP transactions does not necessarily represent every expense incurred but not yet invoiced.
Summary
The Sage 100 AP Aging Report organizes unpaid vendor balances by age, helping finance teams monitor overdue obligations, plan cash needs, prioritize follow-up, and support month-end reporting. Its value depends on accurate transaction records, appropriate report parameters, and reconciliation to the general ledger. Use it alongside invoice documentation, approval records, and payment status to make informed decisions about which liabilities need attention and when cash should be released.