What Is an AP Aging Report?

An AP aging report is the operational backbone of every accounts payable function. It presents a complete, current listing of every vendor invoice that has been received and recorded but not yet paid — organized by vendor and stratified by the number of days each invoice has been outstanding. It is the report that answers the questions every controller, AP manager, and CFO needs to start their week: what do we owe, to whom, how urgently, and what are the cash flow implications of paying it?

The AP aging report serves as the primary reference document for payment run planning, the primary input to short-term cash flow forecasting, the primary reconciliation schedule for period-end close, and the primary support document for auditors confirming the accounts payable balance on the balance sheet. It is, in short, the most important recurring financial report in the accounts payable function — and in most organizations, it is still produced manually from ERP exports into Excel, on an inconsistent schedule, with data that is already partially stale by the time it reaches the people who need to act on it.

Unlike the AR aging report — which is a collections tool that identifies money the company has already earned but not yet received — the AP aging report is a cash management and liability control tool. It shows money the company legitimately owes but has not yet paid, and it helps management decide when to pay it, in what order, and whether any strategic payment timing decisions (capturing early payment discounts, stretching terms to preserve cash, prioritizing key supplier relationships) are available.

The AP aging report also serves as the primary completeness check on the accounts payable balance. The sum of all open invoice balances in the aging report should equal the accounts payable current liability on the balance sheet. If it does not — if the aging report total differs from the GL AP control account balance — there is a data integrity problem that must be resolved before financial statements are issued. This reconciliation is one of the most fundamental periodend close procedures in financial accounting, and building it into the automated reporting workflow eliminates one of the most common sources of close delays.

Why Organizations Use AP Aging Reports

Payment Run Planning and Prioritization The AP aging report is the AP team’s daily payment planning tool. By organizing invoices into aging buckets — and surfacing the invoices closest to or past their due dates — it gives AP managers the prioritized payment queue they need to decide which vendors to pay in the current payment run, which can be deferred, and which require escalation for approval. Organizations that manage payment runs from the AP aging report consistently have lower rates of late payments, fewer vendor disputes, and bettermanaged vendor relationships than those that rely on ad-hoc ERP lookups.
Early Payment Discount Capture Many vendor invoice terms include early payment discounts — typically expressed as “2/10 Net 30,” meaning a 2% discount is available if the invoice is paid within 10 days. On an annualized basis, a 2/10 Net 30 discount represents a 36.7% return on the capital deployed to pay early — significantly more attractive than most short-term investment alternatives. Capturing these discounts systematically requires an AP aging report that surfaces discount expiry dates alongside due dates, so the AP team can prioritize discount-eligible invoices before the window closes.
Cash Flow Forecasting The open AP aging schedule is the most reliable near-term cash flow forecast available for payment obligations. By organizing invoices by due date — this week, next week, next month — the aging report provides finance and treasury teams with the specific cash outflows they need to plan liquidity, schedule payment runs, and manage credit line utilization. This forward-looking dimension of the AP aging report is typically not provided by standard ERP aging outputs, which show aging as of today but do not project future due dates in a cashplanning-friendly format.
Vendor Relationship Management Past-due invoices — invoices that have exceeded their payment terms — create strain in vendor relationships. Vendors who are consistently paid late may withdraw trade credit, require advance payment, or deprioritize service delivery. AP aging reports that surface past-due balances allow AP managers to proactively communicate with affected vendors, explain payment timing, and manage expectations before the relationship deteriorates. For strategic suppliers — those supplying critical components, services, or materials where supply chain disruption would be costly — proactive past-due management through the AP aging report is a supply chain risk management tool.
Period-End Close and Balance Sheet Reconciliation At every month-end, quarter-end, and year-end close, the accounts payable team must reconcile the AP aging report to the AP control account in the general ledger. The sum of all open invoice balances in the aging report must equal the AP balance on the balance sheet. Any discrepancy — from timing differences, voided invoices without reversals, or posting errors — must be investigated and resolved before financial statements can be issued. Automated AP aging with built-in GL reconciliation validation dramatically accelerates this close procedure and eliminates the manual reconciliation spreadsheet that most AP teams maintain separately.
Audit Support and Completeness Testing External auditors use the AP aging report for two primary audit procedures. First, they confirm individual vendor balances — selecting vendors from the aging report and requesting confirmation that the buyer’s records agree to the vendor’s records. Second, they test for unrecorded liabilities — searching for invoices received after the period-end date that relate to goods or services delivered before period-end, which should have been accrued in the closing period. A clean, well-organized AP aging report with complete vendor detail and accurate invoice dates significantly reduces auditor fieldwork time and the risk of audit adjustments.
Vendor Concentration and Spend Analysis AP aging reports that include vendor category and spend data allow procurement and finance teams to monitor vendor concentration — the percentage of total AP represented by the top 5 or top 10 vendors. High vendor concentration creates supply chain risk (over-dependence on a single supplier) and negotiating leverage risk (vendor knows they represent a large share of the buyer’s spend). AP aging data is the first step toward a broader spend analysis that informs procurement strategy and vendor diversification.
1099 and Tax Compliance Support Year-end payment history — the cumulative payments to each vendor across the full calendar year — is the basis for 1099-NEC and 1099-MISC reporting. AP aging systems that track not just open invoices but complete payment history by vendor, with vendor tax identification numbers and 1099 eligibility flags, provide the data infrastructure needed to produce accurate 1099 reports without manual year-end reconstruction from payment records.

How AP Aging Is Calculated — Step by Step

Step 1: Determine the Aging Basis

Step 2: Calculate Days Outstanding

Step 3: Assign Aging Buckets

Step 4: Calculate Bucket Values

Step 5: Aggregate by Vendor

Step 6: Reconcile to General Ledger

Common KPIs and Data Elements

Invoice-Level AP Aging Data

Invoice Number
Vendor Name and Vendor ID
Invoice Date
Invoice Due Date
Payment Terms (Net 30, Net 45, 2/10 Net 30, etc.)
Original Invoice Amount
Partial Payments Applied
Credit Memos Applied
Open Balance (invoice amount minus payments and credits)
Days Outstanding (from invoice date)
Days Past Due (from due date — negative if still within terms)
Aging Bucket Assignment (Current / 1–30 / 31–60 / 61–90 / 90+)
Early Payment Discount Available (amount and expiry date)
Discount Window Status (open, closed, captured)
PO Match Status (matched to PO, unmatched, three-way match pending)
Invoice Hold Flag and Hold Reason
Approval Status (approved for payment, pending approval) 1099 Eligible Flag

Vendor-Level AP Summary

Total Open Balance (all invoices)
Current Balance (within terms)
1–30 Days Past Due Balance
31–60 Days Past Due Balance 61–90 Days Past Due Balance
90+ Days Past Due Balance
% of Balance Past Due
Total Available Discounts (open discount windows)
Credit Limit (if vendor extends credit)
Last Payment Date and Amount
Average Days to Pay (historical)
YTD Payments to Vendor
1099 YTD Payments

Portfolio-Level AP Summary

Total AP Balance (all vendors)
Total Current AP
Total Past Due AP (by bucket)
Total 90+ Days AP (highest risk)
AP Concentration (top 5 / top 10 vendors as % of total)
Total Discounts Available (open windows)
Total Discounts Expiring This Week
Total Invoices on Hold
Total Invoices Pending Approval
Accrued AP / GR-NI (goods received not yet invoiced)
AP GL Reconciliation Status (reconciled / discrepancy amount)

Performance and Working Capital KPIs

DPO — Days Payable Outstanding: (AP Balance ÷ COGS) × Days in Period
DPO Trend (current vs. prior 3, 6, 12 months)
Early Payment Discount Capture Rate (discounts taken ÷ discounts available)
Annualized Value of Uncaptured Discounts
Invoice Processing Cycle Time (receipt to posting)
% of Invoices Paid On Time
% of Invoices Past Due
Vendor Statement Reconciliation Items (open discrepancies)

Cash Flow Payment Forecast

Payments Due This Week
Payments Due Next Week Payments Due in 30 Days
Payments Due in 31–60 Days
Payments Due Beyond 60 Days
Discount Windows Closing This Week
Critical Vendor Payments (supply chain priority flag)

Common Filters and Parameters

As-Of Date — current open AP or historical point-in-time aging for any prior date
Aging Basis — invoice date, due date, or receipt date
Entity / Legal Entity — single entity or multi-entity consolidated
Vendor / Supplier — single vendor detail or all-vendor summary
Vendor Category — by supplier type, spend category, or product/service line
Aging Bucket — all, current only, past-due only, 90+ days only
Payment Terms — filter by specific terms (Net 30, Net 45, etc.)
Hold Status — all invoices, held only, or active (exclude holds)
Approval Status — all, approved, pending approval
Discount Window — all, discount-eligible only, discount-expiring-this-week
Minimum Balance — suppress vendors with balances below a threshold
1099 Eligible — filter for annual tax reporting
Currency — functional currency or multi-currency for international vendors
Intercompany Flag — include or exclude intercompany payables; show separately
PO Match Status — matched, unmatched, or pending three-way match
Comparison Period — current vs. prior month, prior quarter, or prior year

Common Reporting Challenges

AP Aging Does Not Reconcile to the GL

The single most common AP reporting problem is an aging report total that does not agree to the AP control account balance in the general ledger. This is a period-end close finding that must be resolved before financial statements are issued — and investigating it manually (comparing subledger entries to ledger postings, tracing voided invoices, identifying timing differences) is time-consuming and stressful under deadline pressure. Common causes include: invoices voided in the AP module without a corresponding GL reversal, payments posted to the GL before the AP module is updated, cutoff differences when the subledger and ledger close at slightly different times, and unapplied payments sitting in a clearing account rather than applied against specific invoices. Automated reconciliation validation — comparing the aging total to the GL balance automatically at close — converts this reactive scramble into a proactive detection process.

Timing Differences Between Invoice Receipt and Posting

In organizations where invoice processing takes days or weeks — due to approval workflows, three-way matching delays, or high invoice volumes — invoices received before period-end may not be posted to the AP module until after period-end. This creates a cutoff problem: the expense belongs in the closing period, but the invoice is not in the AP aging report for that period. Building systematic accrual reports for invoices received but not yet posted (goods received/not invoiced, or GR/NI) alongside the AP aging is essential for accurate period-end accruals.

Unapplied Payments and Credit Memos

When a payment is processed without being matched to a specific invoice — or when a vendor issues a credit memo that is not immediately applied to an open invoice — the AP aging report shows those invoices as still open, overstating the true amount owed. Separately tracking unapplied payments and open credit memos, and surfacing them in the AP aging report as offset items, is an important data quality requirement for accurate aging presentation

Early Payment Discount Tracking at Scale

Organizations that receive hundreds or thousands of invoices per month from dozens of vendors — each with potentially different payment terms and discount provisions — cannot manually track discount window expiry for each invoice. Without systematic discount tracking, AP teams default to paying at the due date regardless of discount availability, leaving significant value uncaptured. Automated discount window alerts — surfacing discount-eligible invoices in a dedicated section of the AP aging report — directly improves the economics of the AP function.

Three-Way Match Holds

Many organizations require three-way matching before an invoice can be approved for payment: the invoice must match the purchase order, and the purchase order must match the goods receipt. When invoices fail the three-way match — because quantities differ, prices differ, or a goods receipt has not been entered — the invoice goes on hold. Held invoices accumulate in the AP aging report and can significantly distort the aging picture: they appear as current or past-due, but they are not eligible for payment until the hold is resolved. AP aging reports must clearly identify and flag held invoices separately from clean, payable invoices.

Multi-Currency Vendor Invoices

Organizations that purchase from international vendors receive invoices denominated in foreign currencies. The AP aging report must show each invoice in both the vendor's invoice currency and the company's functional reporting currency — with the exchange rate applied at invoice date — and must handle the accounting for unrealized exchange rate gains or losses that arise when the functional currency value of a foreign-currency payable changes between invoice date and payment date.

Vendor Statement Reconciliation

Vendors periodically issue account statements to their customers showing their version of the account balance — what invoices they believe are outstanding, what payments they have received, and what credit memos they have issued. These vendor statements frequently differ from the buyer's internal AP records. Discrepancies may include invoices the vendor claims were sent that the buyer never received, payments the buyer made that the vendor has not yet applied, or credit memos applied differently by each party. Building vendor statement reconciliation workflow into the AP reporting system — tracking open discrepancy items by vendor with a resolution status — converts this periodic reconciliation exercise from a manual scramble into a systematic process.

Intercompany AP Contamination in Consolidated Reports

In multi-entity organizations, some AP balances represent amounts owed between related entities — a parent company owed by a subsidiary, for example — rather than amounts owed to external vendors. These intercompany payables must be eliminated in consolidated financial statements and excluded from third-party AP analyses. AP aging reports that do not clearly flag intercompany balances overstate the consolidated external AP exposure and create consolidation errors.

Automation and Scheduling Options

Real-Time AP Aging Calculation Engine We build SQL Server AP aging calculation engines that compute each invoice’s days-outstanding and aging bucket assignment dynamically at the time of report generation — based on the current date or any selected as-of date. Every AP aging report reflects the exact state of payables at the moment it is generated, incorporating the latest payments, credits, and new invoices without requiring manual data extraction or refresh.
GL Reconciliation Automation We build automated GL reconciliation queries that run before every period-end AP aging report — comparing the AP subledger total to the AP control account balance in the trial balance. Any discrepancy is flagged in a reconciliation exception report with the specific vendor, invoice, or entry that is causing the difference — directing the investigation to the right place immediately rather than requiring a full manual comparison.
Cash Flow Payment Forecast Engine We build forward-looking payment forecast models that organize open AP invoices by due date — this week, next week, 30-day horizon — and project the expected cash outflow from the AP function for each planning horizon. Early payment discount windows are highlighted separately, with the annualized discount value displayed to support the payment prioritization decision.
DPO Calculation Automation We build DPO calculation pipelines that compute Days Payable
Outstanding at each period-end — using the AP aging balance and COGS data from the same SQL Server data model — trended over time and segmented by entity and vendor category. DPO trend charts are surfaced in the Power BI AP dashboard for management review.
Early Payment Discount Alert System We build discount window tracking logic that calculates the discount expiry date for every discount-eligible invoice, compares it to the current date, and flags invoices whose discount window is closing within a configurable number of days (typically 2–5 days). Daily discount expiry alerts are delivered to AP managers and treasury teams automatically.
Three-Way Match Hold Tracking We build AP hold tracking data models that categorize the reason for each invoice hold — PO quantity discrepancy, price discrepancy, missing goods receipt, approval pending, duplicate suspected — and surface held invoices in a dedicated section of the AP aging report with hold reason and days-in-hold-status. Hold resolution aging (how long each invoice has been on hold) identifies systemic bottlenecks in the invoice approval process.
Vendor Statement Reconciliation Workflow We build vendor statement reconciliation tracking systems that record vendor-supplied statement balances, compare them to internal AP records, identify open discrepancy items, and track each discrepancy through to resolution — with status, assigned owner, and days-open aging for each reconciling item.
Historical Point-in-Time AP Aging We build transaction history data models that retain the complete invoice lifecycle — posting, payments applied, credits applied, voids — so that AP aging can be recalculated as of any historical date. This supports audit confirmation, period comparison, vendor dispute resolution, and lender audit without relying on manually saved prior-period aging reports.
Multi-Entity AP Consolidation We build multi-entity AP consolidation pipelines that aggregate vendor payable data from all legal entities — with intercompany payable flagging, consistent vendor mapping across entities, and currency translation for multi-currency environments — producing both entity-level and consolidated AP aging reports from the same SQL Server data model.
Scheduled Delivery and Alerts AP aging summaries can be scheduled for automatic generation and delivery on daily, weekly, or monthly schedules. Daily discount expiry alerts, weekly AP aging summaries, and monthly DPO reports are delivered to the appropriate finance and treasury stakeholders automatically — without manual report preparation.

Delivery Methods

SSRS (SQL Server Reporting Services)

SSRS is highly effective for automated AP aging report generation — producing formatted aging schedules at invoice level, vendor summary level, and portfolio summary level, with aging bucket columns, hold status flags, discount availability indicators, and entity segmentation. Parameterized SSRS templates allow any AP manager or controller to generate an on-demand aging view — any vendor, any as-of date, any entity — without IT involvement. Scheduled SSRS subscriptions deliver weekly AP aging summaries and payment forecast reports automatically.

Crystal Reports

Many ERP platforms generate AP aging reports through Crystal Reports templates. ReportingGuru modernizes Crystal Reports AP aging packages — improving aging bucket logic, adding due-date aging methodology, incorporating discount window tracking, adding hold status detail, and migrating to SSRS or Power BI where appropriate.

Power BI

Power BI is the most effective platform for interactive AP analytics and cash management dashboards. We build Power BI AP dashboards with real-time aging distribution charts, DPO trend lines, vendor concentration waterfall charts, discount capture rate monitoring, cash flow payment forecasts, and hold resolution aging analysis — all with drill-through from portfolio summary to vendor detail to individual invoice. Power BI dashboards refresh from the SQL Server AP data model on a defined schedule.

Excel Automation

Many finance teams and controllers prefer to work with AP aging data in Excel — for payment run planning, board reporting, audit preparation, and cash flow modeling. We build Excel AP aging workbooks driven by live SQL Server data — automatically populated with current invoice balances, aging buckets, vendor summaries, and payment forecast data — eliminating manual ERP exports, copy-paste, and pivot table rebuilds at each reporting cycle.

Scheduled PDF Reports and Email Delivery

Related Report Pages

Financial & GL Reporting Pages

Balance Sheet — Automate balance sheet reporting alongside budget vs actual analysis — actual asset, liability, and equity balances vs. budgeted positions with lender covenant ratio tracking.

Income Statement / Profit & Loss — P&L actuals that feed every revenue and expense line in every budget vs actual report — with departmental drill-down, cost allocation, and EBITDA variance analysis.

Statement of Cash Flows — Cash flow actuals vs. projected cash flows and free cash flow forecasts — the liquidity and capital deployment dimension of budget vs actual management.

Trial Balance — The validated, exception-checked GL data that feeds every actual line in every budget vs actual report — the foundational data layer for all variance analysis.
Budget vs Actual — P&L actuals vs. budgeted revenue and expense with variance analysis, departmental accountability, and rolling forecast integration.

Investor & Fund Reporting Pages

Financial Statements & KPI Reporting — Fund and portfolio company financial statements incorporating inventory on-hand balances and turnover metrics.

Fund Performance Reporting — Days-on-hand, stockout rates, and inventory turnover tracked as PE portfolio company operational KPIs.

Inventory & Warehouse Pages

Inventory & Warehouse Reporting — Overview of all inventory and warehouse reporting solutions from ReportingGuru.

Inventory Aging — Days-in-stock by item and lot — the obsolescence detection tool that identifies items requiring LCM write-down consideration.

Inventory Valuation — The financial value of aged inventory — cost method valuation by lot that determines the dollar impact of the obsolescence reserve.

Frequently Asked Questions

What is the purpose of an AP aging report?

The AP aging report serves four primary purposes: (1) payment management — prioritizing which vendor invoices to pay in the current payment run based on due dates and discount windows; (2) cash flow forecasting — projecting upcoming cash outflows by due date to support treasury and liquidity planning; (3) period-end close — reconciling the AP subledger total to the AP control account balance in the general ledger; and (4) audit support — providing the detail schedule that auditors use to confirm AP balances and test for unrecorded liabilities.

How does an AP aging report reconcile to the balance sheet?

The total of all open invoice balances in the AP aging report — summed across all vendors and all aging buckets — should equal the accounts payable balance in the AP GL control account, which appears as a current liability on the balance sheet. To perform this reconciliation: run the AP aging report as of the same date as the GL close, compare the aging report total to the AP control account balance in the trial balance, and investigate any difference. Common reconciling items include unapplied payments, voided invoices without GL reversals, and timing differences between subledger and ledger close.

What does it mean when an AP invoice is past due?

A past-due AP invoice is one whose payment due date has passed without the invoice being paid. Past-due status means the buyer has exceeded the payment terms agreed with the vendor. The consequences depend on the relationship and terms: vendors may assess late payment fees (common in some supplier contracts), place the buyer on credit hold (stopping future shipments until the overdue balance is cleared), escalate to collections, or simply note the pattern and factor it into future credit decisions. AP teams use the aging report to identify past-due invoices for prioritization in the next payment run.

What is the difference between aging by invoice date and aging by due date?

Invoice date aging measures how long since the vendor issued the invoice — regardless of when payment is due. Due date aging measures how overdue the invoice is relative to the contractually agreed payment deadline. For payment management purposes, due date aging is more operationally useful because it directly shows which invoices are past their payment commitment. For spend analysis and audit purposes, invoice date aging is more appropriate. Most organizations use due date aging for payment management reporting and invoice date aging for period-end reporting and audit support.

What is Days Payable Outstanding (DPO) and how is it calculated?

DPO measures the average number of days a company takes to pay its vendor invoices. It is calculated as: (Accounts Payable

Balance ÷ Cost of Goods Sold) × Number of Days in Period. Example: $500,000 AP ÷ $3,000,000 COGS × 90 days = 15 days DPO. A higher DPO means the company takes longer to pay — preserving cash but potentially straining vendor relationships. A lower DPO means faster payment — which may capture discounts but uses more cash. DPO is a key working capital efficiency metric tracked alongside DSO (Days Sales Outstanding) and DIO (Days Inventory Outstanding) in working capital analyses.

How should early payment discounts be tracked in an AP aging report?

Early payment discounts should be tracked at the invoice level — recording the discount terms (e.g., 2%), the discount expiry date (invoice date + discount window, e.g., 10 days), the discount dollar amount available (invoice balance × discount %), and whether the discount was captured at payment. The AP aging report should surface invoices with open discount windows in a dedicated section — sorted by expiry date, with the dollar amount available — so AP managers and treasury teams can see at a glance which discounts are closing this week and prioritize payment accordingly.

Can AP aging reports be produced as of a prior date for audit purposes?

Yes. We build transaction history data models that retain the complete AP invoice lifecycle — posting date, payment application date, credit memo date, void date — so that AP aging can be recalculated as of any historical date. This allows the AP team to reproduce the exact aging report as of December 31, March 31, or any other period-end date for auditor confirmation, lender audit, or dispute resolution — without relying on manually saved prior-period aging files.

What is goods received not invoiced (GR/NI) and how does it relate to AP aging?

Goods received not invoiced (GR/NI) — also called accrued AP or uninvoiced receipts — represents goods or services that have been received and recorded in the warehouse management or receiving system but for which the vendor invoice has not yet been received or posted to the AP module. GR/NI balances are not in the AP aging report (because no invoice exists yet) but must be accrued as a current liability on the balance sheet at period-end. Building a GR/NI accrual report alongside the AP aging report gives a complete picture of total AP obligations — both invoiced and accrued.