Accounts Payable Ageing Report: What it is and How to Make One

Saim Jalees

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.

💡 Need to pay an overseas supplier identified in your AP ageing report?
With Wise Business, eligible UK businesses can send money to supported destinations and connect transactions to accounting software for reconciliation. This can support the payment and record-keeping steps after your AP team has reviewed and approved an invoice.

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

SectionKey takeaway
What is an accounts payable ageing report?A snapshot of unpaid supplier balances grouped by how long they've been open or overdue.
What does an AP ageing report include?Supplier and invoice details, due dates, open balances, credits, currencies and totals.
How to create an accounts payable ageing reportSet the date and purpose → check the ledger → choose the ageing basis and buckets → run summary and detail views → validate the figures → save the settings.
How to read an AP ageing reportReview the total, overdue share, supplier concentration and changes since the previous report before investigating individual invoices.
How to use the report to improve cash flowTurn approved due invoices and exceptions into a prioritised payment and follow-up plan.
How automation can support AP ageing reportsScheduled reports can reduce preparation time, but due-date logic, cut-offs and exceptions still need review.

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.1 The report typically lists unpaid invoices across configurable ageing periods.2

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:

BucketTypical interpretation when ageing by due date
Not due or currentThe invoice isn't due on the report date.
1–30 days overdueRecently past due; check the payment run and any exceptions.
31–60 days overdueA continuing overdue balance that needs an owner and next action.
61–90 days overdueA balance that may need escalation or supplier follow-up.
90+ days overdueAn older item to investigate for dispute, credit, payment or data issues.

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

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.

Open invoiceDue dateAgeing result
Supplier A — GBP 1,2001 October 202614 days overdue; 1–30 days
Supplier B — GBP 80030 October 2026Not yet due; current
Supplier C — GBP 2,50015 August 202661 days overdue; 61–90 days
Total open payables: GBP 4,500

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

💡 Several approved overseas supplier invoices due in the same payment run?
With Wise Business, eligible UK businesses can use the batch payments tool to prepare and send up to 1,000 payments together. That can make the approved overseas invoices in one AP payment run easier to send, while invoice checks and approvals stay in your AP process.

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.2 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

wise-business

wise-business-mobile

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.

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.)
  • 🔗 Accept credit and debit card payments in 18+ currencies, or create payment links and QR codes to get paid easily
  • ⚙️ 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.

Register for Wise Business ✍️

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)

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.

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:

  1. Aged Accounts Payable (report) - Business Central | Microsoft Learn
  2. Overview of Payables Invoice Aging Report | Oracle
  3. Vendor aging report - Finance | Dynamics 365 | Microsoft Learn
  4. Aged Payables Report | Sage 50

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.

Money without borders

Find out more

Tips, news and updates for your location