Checkout Optimisation: Six Practical Tips for UK Businesses
Read our guide to learn how to improve your checkout with clearer prices, simpler forms and better payment journeys.
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.)
| Section | Key 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 report | Set 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 report | Review the total, overdue share, supplier concentration and changes since the previous report before investigating individual invoices. |
| How to use the report to improve cash flow | Turn approved due invoices and exceptions into a prioritised payment and follow-up plan. |
| How automation can support AP ageing reports | Scheduled reports can reduce preparation time, but due-date logic, cut-offs and exceptions still need review. |
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.
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.
An ageing bucket is a time interval used to group an outstanding amount. A common layout is:
| Bucket | Typical interpretation when ageing by due date |
|---|---|
| Not due or current | The invoice isn't due on the report date. |
| 1–30 days overdue | Recently past due; check the payment run and any exceptions. |
| 31–60 days overdue | A continuing overdue balance that needs an owner and next action. |
| 61–90 days overdue | A balance that may need escalation or supplier follow-up. |
| 90+ days overdue | An 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
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 invoice | Due date | Ageing result |
|---|---|---|
| Supplier A — GBP 1,200 | 1 October 2026 | 14 days overdue; 1–30 days |
| Supplier B — GBP 800 | 30 October 2026 | Not yet due; current |
| Supplier C — GBP 2,500 | 15 August 2026 | 61 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. |
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.
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:
The purpose affects whether you need summary totals, invoice detail, disputed balances, currency columns, expected payment dates or a forward-looking “not due” view.
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.
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.
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.
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.
Perform these checks before distributing the report:
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.
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:
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.
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.
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:
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)
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.
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.
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.
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.
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:
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.
Read our guide to learn how to improve your checkout with clearer prices, simpler forms and better payment journeys.
Read our guide to learn what the Direct Debit Guarantee covers, how to claim a refund, cancel a payment and resolve collection errors.
Read our guide to learn how hosted payment gateways work, compare integration options and check costs, PCI responsibilities and payouts.
Learn how to create and read an AP ageing report. Our guide covers buckets, AP invoice checks, cash-flow actions and payment workflows for UK finance teams.
Learn what nostro and vostro accounts are, as well as how they work and key differences between them in our guide, written for UK businesses.
Learn how payment clearing and settlement works, how the stages differ and what UK businesses should track when payments are in progress.