AP Aging Report Overview

Last reviewed: June 9, 2026

On this page

The Accounts Payable Aging Report shows open payable balances by vendor and age bucket, with optional invoice-level detail.

What this report is for

Use AP Aging Report to review vendor balances that remain payable and to understand how old those balances are.

This report is read-only. It does not create vendor invoices, record payments, apply credit, change due dates, or clear accruals.

Screen paths

Dashboard > Finance > Payables > AP Aging Report
Dashboard > Finance > Reports > AP Aging Report

Report controls

Control	Use
Search	Search by vendor code, vendor name, or invoice number.
`Expand All` / `Collapse All`	Show or hide invoice detail rows.
`Copy for Excel`	Copy the current report view for spreadsheet use.
`Print PDF`	Download the AP aging report as a PDF.
`Refresh`	Reload the report data.

When a search matches an invoice number, PAX expands the matching vendor detail so the invoice can be reviewed in context.

Report columns

The vendor summary table shows:

Column	What it means
`Vendor Code`	Vendor code.
`Vendor Name`	Vendor name.
`Current`	Open payable amount not yet overdue.
`1-30 Days`	Open payable amount in the 1-30 day aging bucket.
`31-60 Days`	Open payable amount in the 31-60 day aging bucket.
`61-90 Days`	Open payable amount in the 61-90 day aging bucket.
`91+ Days`	Open payable amount in the 91+ day aging bucket.
`Total Due`	Total open payable amount for the vendor.

The footer shows total amounts for the current view. If the report is filtered, the footer totals reflect the filtered vendors.

Invoice detail

Select a vendor row, or use Expand All, to show invoice-level detail.

Invoice detail rows show:

Invoice number or invoice ID.
Invoice date.
Due date when available.
Overdue day badge when the invoice is overdue.
The invoice balance in the correct aging bucket.
Total due for the invoice.

Use invoice detail to identify which vendor invoices need review or payment follow-up before recording payments in Vendor Payments Overview.

What happens behind the scenes

Opening, refreshing, searching, expanding, copying, or printing the report does not change records.

PAX loads AP aging summary data and invoice detail data, then groups open vendor invoice balances into these buckets:

Current
1-30 Days
31-60 Days
61-90 Days
91+ Days

The report is based on current payable balances. If totals appear wrong, review the related vendor invoices, vendor payments, vendor credit, and check-run status before posting any corrections.

Troubleshooting

A vendor does not appear

Likely cause: The vendor has no open AP balance in the report data, or the current search filter excludes the vendor.

Safe fix: Clear the search field and refresh the report. Review the vendor invoice and payment history if the vendor should have an open payable balance.

Contact support if: A known unpaid vendor invoice is missing from the report.

An invoice is in the wrong bucket

Likely cause: The due date on the vendor invoice may be different than expected.

Safe fix: Review the invoice due date in Vendor Invoices. If the invoice is unpaid and editable, correct the invoice instead of entering a manual journal entry.

Contact support if: The due date is correct but the aging bucket is still wrong.

Report totals do not match another finance report

Likely cause: AP aging is an open-balance aging report. Other reports may use invoice date, payment date, GL posting date, or accrual movement.

Safe fix: Confirm the date basis and record basis before comparing totals.

Contact support if: The same invoice population and balance basis still do not reconcile.