What Is AP Ageing? Meaning, a Worked Example and How to Use the Report
For accountants, purchase heads and owners managing supplier dues: what AP ageing shows and how to turn it into a payment schedule.
What is AP ageing? It is the list of your unpaid supplier bills, sorted into buckets by how long they have been due. It answers two questions at once: whom do we owe, and who has been waiting too long?
In many SMEs the answer lives in the owner's head and a stack of bills in a drawer. Suppliers who shout get paid; quiet ones wait. Over time, a few old bills turn into disputes, lost discounts and a supplier who stops extending credit.
Here is the answer in full, an illustrative example and how Apragya builds the report from the ledger itself.
AP ageing meaning, and how the buckets work
AP ageing, or accounts payable ageing, is a report that lists what you owe suppliers and groups each unpaid bill by its age. Common buckets are not yet due, 1 to 30 days, 31 to 60, 61 to 90 and over 90 days.
Age can be measured from the due date, which shows how overdue a bill is, or from the bill date, which shows how old it is regardless of credit terms. A bill on 60-day terms raised 45 days ago is not late on the due-date view, but sits in 31 to 60 on the bill-date view.
A worked example: you owe 12 lakh in total. 7 lakh is not yet due, 3 lakh is 1 to 30 days overdue, 1.5 lakh is 31 to 60 days and 50,000 is past 90 days. The 50,000 needs a reason: a dispute, a missing credit note or a forgotten bill.
Many businesses also check that supplier dues under the MSMED Act are paid within the agreed or statutory period. Check the current rules with your adviser.
- Pick the as-on date and the basis: due date or bill date.
- Total unpaid bills for each supplier into the age buckets.
- Investigate everything in the oldest bucket first.
- Plan the next payment run from what is due and overdue.
- Re-run the report after payments and compare with last month.
What an out-of-date creditors ageing report costs
Unhappy suppliers
Old dues strain the relationships you rely on for credit and priority.
Lost discounts
Early-payment terms expire while bills sit unsorted.
Forgotten disputes
Short supplies and credit notes stay open for months.
Poor cash planning
Payments are made in the order people ask, not the order they fall due.
An example: a Jaipur handicraft exporter
Take an illustrative exporter with about 90 suppliers of wood, brass and packing material. The accountant runs the ageing report on the due-date basis before the weekly payment run.
The oldest bucket, bill by bill
- Packing cartons, AprilRate on the bill differed from the order.Mismatch
- Brass fittings, MayCredit note for a rejected lot never posted.Missing
- Sheesham planks, MaySimply forgotten; paid in this run.Overdue
- Polish and lacquerAgreed with supplier; due next week.Checked
- Transport billsWaiting for proof of delivery.Pending
The oldest bucket fell from 2.3 lakh to 40,000 in a fortnight. One supplier issued the missing credit note, another agreed the rate, and the forgotten planks bill was paid before the supplier had to call.
How Apragya builds the accounts payable ageing report
Step 1 of 5
From the ledger
Ageing is computed live from posted entries in the payables account.
- From the ledger: Ageing is computed live from posted entries in the payables account.
- Due date or bill date: Choose the basis; bills without a due date age on a 30-day default.
- By supplier: See buckets for each supplier and export the list.
- By company: Run it for one company or consolidated.
- Into a payment run: Pick what is due and pay it in a batch, with TDS worked out.
Why AP ageing buckets should come from the books
A report built from a separate sheet is only as good as the last update. When ageing reads the same ledger that bills and payments post to, it is right the moment a payment is made.
A spreadsheet ageing list, against Apragya
| Feature | Spreadsheet list | Apragya |
|---|---|---|
| Source | Updated by hand | Posted bills and payments |
| Basis | Usually one fixed view | Due date or bill date |
| Partial payments | Easy to miss | Reflected in the balance |
| Disputes | Notes elsewhere | Bill, match result and history together |
| Next step | Separate payment list | Straight into a payment run |
Checked against public information on 16 September 2026.
What sets Apragya apart for payables
Three-way match
Bill totals are checked against the order and receipt before approval.
Bills read by AI
Supplier bills arrive as PDFs and are read, not retyped.
Verified suppliers
GSTIN, PAN and bank details checked at onboarding.
AI you can put to work
An agent can explain why each old bill is still open.
Audit log
Who approved and paid, and when, is logged.
Access by role
Buyers, approvers and accounts see what they should.
See the AP ageing, payment runs and three-way match exceptions features. The mirror term is AR ageing.
Getting started
- Post all open supplier bills with their due dates.
- Run the ageing report on the due-date basis.
- Take the oldest bucket and find a reason for each bill.
- Fix disputes and missing credit notes.
- Plan the weekly payment run from the report.
After the first clean-up, a weekly look at the report is usually enough.
What it costs to start
Accounts payable ageing, answered
Is AP ageing the same as a creditors ageing report?
Which basis should we use?
Why do some bills show as overdue even though terms are long?
Should advances to suppliers appear?
What does it cost to start?
See who has waited too long
Post your open bills and run the ageing report before the next payment run.