An accounts payable ageing report shows finance teams which supplier invoices are due, overdue or need checking before the next payment run. This view of open balances can support cash planning and help teams follow up on exceptions before missed payments or month-end surprises.

This guide explains what an AP ageing report contains and how to create one as a UK business. We've explained how to choose ageing buckets, interpret results and avoid data and control errors in detail.

Send payments with Wise Business 🌍

Note: Wise Business offers a free Essential plan for basic spending and transferring. If you need to receive money, set up direct debits, or generate invoices, you'll pay a one-time £50 setup fee to unlock the Advanced features.

Wise services and features are not available in all regions, country and product restrictions apply. Visit wise.com to check availability, and for fee details and terms for your region, visit our pricing page for Wise Business.

This content is provided for general educational and informational purposes only. It is not intended to provide legal, tax, financial, investment or professional advice and should not be relied upon as such.)

Key takeaways

What is an accounts payable ageing report?

An accounts payable ageing report, also called an aged payables report or AP ageing report, groups outstanding amounts owed to suppliers into time-based intervals. Some teams use the US spelling “aging”. A report can summarise balances by supplier or show the individual invoices that make up each balance.

the report can show outstanding invoices, credit memos and payments for vendors, with either a summed vendor balance or a detailed document breakdown. The report typically lists unpaid invoices across configurable ageing periods.

One thing to note is that the report isn't a record of invoices entered during a period. Rather, it's a view of open payable positions at a stated “as at” date, using a defined ageing basis and including relevant credits, payments and adjustments.

What does an AP ageing report include?

Supplier legal name and supplier ID
Invoice or credit-note number
Invoice date and posting date
Payment due date and payment terms
Original invoice amount and open balance
Payments, credits, prepayments or disputed amounts
Transaction currency and, where needed, the reporting currency and exchange-rate method
Ageing basis, such as due date or invoice date
Ageing bucket, such as current, 1–30, 31–60, 61–90 and 90+ days
Payment status, hold status or dispute flag
Purchase order, goods-received or approval reference
Total by supplier, currency, entity and report

A supplier summary is usually easier for managers to scan. For payment operations and audit support, retain a drill-down to the underlying invoices and transactions.

Accounts payable ageing buckets explained

An ageing bucket is a time interval used to group an outstanding amount. A common layout is:

Data criteria can be based on transaction date, due date or document date, and intervals defined in days or months. The report can also group outstanding payables into ageing categories and calculate them by invoice date or due date.

Example: calculating an AP ageing report

The figures below are illustrative. Assume the report date is 15 October 2026, the report ages balances by due date, and the buckets use full days overdue.

The calculation works only if the due dates and open balances are reliable. Building the report therefore starts with its date and source ledger.

Discover Wise Business 🔎

Wise Business offers a free Essential plan for basic spending and transferring. If you need to receive money, set up direct debits, or generate invoices, you'll pay a one-time £50 setup fee to unlock the Advanced features.

How to create an accounts payable ageing report

1. Set the report date and purpose

Choose the date the report should describe. Month-end reporting, a weekly payment run and a cash forecast may need different dates or views.

Decide whether the report is for:

Payment prioritisation
Cash-flow forecasting
Month-end close
Supplier statement reconciliation
Audit evidence
Working-capital or treasury review

The purpose affects whether you need summary totals, invoice detail, disputed balances, currency columns, expected payment dates or a forward-looking “not due” view.

2. Confirm the source ledger is complete

Before exporting, post or include invoices, credit notes, payments and adjustments up to the report date. Check that the accounts payable subledger reconciles to the relevant general-ledger control account.

If you produce the report before the invoice-import or payment-posting cut-off, label it as preliminary. Don't use a preliminary total as a final cash commitment without recording the limitation.

3. Choose the ageing basis

Select the due date when the main question is “what is overdue?” Select the invoice or transaction date when the main question is “how long has this balance been open?” Use document date only when your system and process define it consistently.

Record the choice in the report parameters and use the same basis when comparing periods. Changing from invoice date to due date can make the ageing profile look different without any change in the underlying liabilities.

4. Define the intervals and filters

Set the buckets, currency view, entities, suppliers, payment statuses and inclusion of zero balances. Include or exclude disputed, held and unapplied items deliberately, and explain the choice.

For a larger organisation, run separate views for legal entity, business unit, currency, supplier group and payment owner. Keep a consolidated view for liquidity planning, and review it alongside entity-level exceptions.

5. Run summary and detail versions

The summary shows how much the business owes each supplier and how much sits in each bucket. The detailed report shows which invoices make up each total.

Use both where the system allows it. A summary-only report can hide duplicate invoices, a payment posted to the wrong supplier, a credit balance or a disputed invoice that changes the apparent exposure.

6. Validate totals and exceptions

Perform these checks before distributing the report:

Total open AP agrees to the reconciled subledger and control account, subject to documented timing differences.
Invoice counts and balances reconcile to the prior report after explaining movements.
Credit notes and unapplied payments are visible and assigned to an owner.
Duplicate invoice numbers, suppliers and amounts have been reviewed.
Invoices with missing or implausible due dates are corrected or flagged.
Foreign-currency balances use the stated reporting-rate method.
Payments posted after the report cut-off aren't backdated into the report.
Held, disputed and approved invoices are clearly distinguished.

7. Save the parameters and evidence

Keep the report date, ageing basis, bucket definitions, filters, exchange-rate source, export timestamp and reviewer. Save the detail file or system link used to support the summary.

How to read an AP ageing report

Start with the total open balance, then split it into not-due and overdue amounts. A high overdue share can point to a payment-processing issue, cash pressure, disputed invoices or inaccurate terms. A large not-due balance may still need funding if many invoices mature in the same week.

Next, review concentration. Identify suppliers with high balances, longer-overdue items and multiple overdue invoices. Check whether the concentration reflects normal purchasing, a payment-run timing issue, a blocked invoice or a supplier relationship that needs attention.

Then investigate movement by comparing the current report with the previous report by supplier and bucket. Ask:

Which invoices moved into overdue status?
Which balances were paid, credited or reclassified?
Did a new supplier or entity create an unusual increase?
Are old balances reducing or moving from one bucket to another?
Are currency movements changing the reported total?

Finally, separate actionable liabilities from accounting exceptions. A 90+ day balance may be a valid disputed invoice, a credit owed by the supplier, a payment awaiting allocation or a genuinely unpaid liability. The bucket tells you where to investigate; it doesn't explain why the balance exists.

How automation can support AP ageing reports

Some finance systems let teams configure ageing periods, filter report data or schedule report runs. For example, Oracle's report guidance explains how to schedule and run its Payables Invoice Aging Report. A recurring report can help teams review balances on a consistent cadence.

Automation doesn't remove the need for controls. Test the due-date logic, permissions, exchange-rate source, cut-off and exception routing. Keep a human review for unusual balances, supplier-bank changes, duplicate invoices and disputed or high-value payments.

Discover Wise Business

With Wise Business, you can:

🌍 Send money to 70+ countries and pay overseas invoices at the mid-market exchange rate with low, transparent fees and no hidden exchange rate markups (product availability varies by region)
📥 Receive payments in 24 currencies and counting
💵 Get local account details for 8+ currencies, including USD and EUR, to let your customers pay in a currency they know and trust - convenience for them and peace of mind for you
💰 Hold money in 40+ currencies
🔁 Convert currencies anytime at the mid-market exchange rate with low, transparent fees
⚡ Use the batch payments tool to create and send up to 1,000 payments in a single transfer
👥 Run payroll and make international payments for up to 1,000 employees all over the world - including paying suppliers using local payment methods like ACH, SEPA, and Faster Payments
💳 Get business debit cards with 0.5% cashback for you and your team to keep track of team expenses and spend all over the world, with real-time visibility and categorisation. See full cashback terms and conditions
🏢 Manage cash in 55+ currencies across international offices from a single business account and move money between business accounts in seconds (exact speeds can vary depending on individual circumstances and may not be the same for all transactions)
🧾 Connect and sync every business transaction to your favourite accounting software, including Xero, Quickbooks, and more
🔐 Create your own payment approvals process to manage your team better with customised access for different team members, roles and permissions
📑 Create custom professional invoices and schedule invoice payments for future dates
📈 Earn variable returns on GBP, USD and EUR with Wise Interest (Growth not guaranteed. Your balance will go down in the event of a government default or interest rates going negative.)
🔗 Create payment links and QR codes to get paid easily (Card payment acceptance for new Wise Business customers is currently unavailable. Payment methods subject to eligibility and availability.)
⚙️ Automate payouts with the Wise API (comes with 24/7 customer support, a sandbox account to test integrations, API tokens, and clear documents on how to implement and make the most of our API)

Make the wise choice when selecting a business account for your domestic and global needs.

Be Smart, Get Wise.

Wise Interest disclaimer: Growth not guaranteed. Your balance will go down in the event of a government default or interest rates going negative. Taxes may apply. 3.32% variable rate on GBP is based on 7 day performance as of 05 Aug 2026. For full 5-year past performance and fund information, visit https://wise.com/interest. Investments are offered by Wise Assets UK Ltd. (FRN 839689)

Accounts payable ageing report FAQs

What does a 90+ day AP balance mean?

It means the balance falls into a bucket defined as 90 or more days under the selected ageing rule. It may be overdue, disputed, unapplied, duplicated, credited or genuinely unpaid, so check the underlying transactions before paying or escalating it.

How often should a business run an AP ageing report?

Use a cadence that supports your payment runs and reporting close. A finance team may review it weekly for payment planning and at month-end for close, then run an additional report when a significant exception needs investigation. Keep the report date and parameters with each version so results can be compared consistently.

Why might an AP ageing report not match the general ledger?

Check the report date, posting cut-off, filters, currency method, unapplied payments, manual journals and due-date rules. Re-run the report with the same parameters and reconcile timing differences before changing accounting entries.

Does an AP ageing report include payments already made?

It should show the open balance at the selected date after relevant payments and credits have been included or applied. An unapplied payment can leave an invoice appearing open, so review payment allocation and report settings before treating the balance as payable.

Sources:

Overview of Payables Invoice Aging Report | Oracle

Sources last checked on 15 October 2026

*Please see terms of use and product availability for your region or visit Wise fees and pricing for the most up to date pricing and fee information.

This publication is provided for general information purposes and does not constitute legal, tax or other professional advice from Wise Payments Limited or its subsidiaries and its affiliates, and it is not intended as a substitute for obtaining advice from a financial advisor or any other professional.

We make no representations, warranties or guarantees, whether expressed or implied, that the content in the publication is accurate, complete or up to date.