How to Create AP Ageing in an ERP: A Creditors Ageing Your Accounts Team Does Not Rebuild Every Friday
For accounts heads and owners of Indian SMEs who need to know, any day of the week, how much is owed to suppliers and how much of it is already late.
If you are working out how to create AP ageing, you probably already have the raw material: a list of supplier bills and the payments made against them. The ageing simply sorts what is still unpaid by how long it has been outstanding.
The trouble in most SMEs is that the ageing is a weekly export. Someone pulls the creditors list, removes bills that were paid, adjusts part payments by hand and sorts into columns. By Tuesday the sheet is out of date, and a supplier spelt two ways shows up twice.
This guide covers the rules of a correct ageing, an illustrative example from a Rajkot engineering firm, and how Apragya's Purchase and Payables app builds it from posted bills.
How to create AP ageing, step by step
AP ageing, or creditors ageing, lists every unpaid supplier bill and places it in a time bucket based on how long it has been outstanding. The usual buckets are not yet due, 1 to 30 days, 31 to 60 days, 61 to 90 days and over 90 days.
Two decisions shape the report. First, the date you age from: the due date shows lateness against agreed credit terms, while the invoice date shows the age of the liability. Second, what is aged: it should be the unpaid balance after part payments, advances and debit notes, not the full bill.
The totals must agree with the supplier control account on the same date. If they do not, look for unposted payments, unadjusted advances or duplicate supplier records.
- Post every supplier bill with its invoice date, due date and credit terms.
- Record payments, advances and debit notes against the bills they settle.
- Choose whether to age from the due date or the invoice date.
- Group the unpaid balances into standard day buckets, supplier by supplier.
- Agree the total with the supplier ledger for the same date.
- Review the oldest buckets and schedule those payments first.
Before and after a live creditors ageing report
Built from posted bills
- Buckets recomputed from bills and payments
- Only the unpaid balance of each bill is aged
- One vendor record behind bills, orders and payments
- Overdue bills picked straight into a payment run
How Apragya builds the accounts payable ageing report
Step 1 of 5
Start from posted bills
Only the unpaid balance of each bill is aged, so part payments are not overstated.
- Start from posted bills: Only the unpaid balance of each bill is aged, so part payments are not overstated.
- Standard buckets: Current, 1 to 30, 31 to 60, 61 to 90 and over 90 days, with a total.
- Due or invoice date: Due date by default; switch to invoice date when auditors ask.
- Vendor view: Search a supplier to see its open bills and total outstanding.
- Into payment runs: Pick due and overdue bills into a batch for approval and payment.
An example: a Rajkot engineering firm's month end
Take an illustrative maker of diesel engine parts in Rajkot with about 110 active suppliers of castings, bearings and packing. The owner wanted to know which suppliers were at risk of holding dispatches because of late payment.
One supplier's position, aged
Casting supplier, open bills
Not yet due; no action needed.
Due last week, part paid.
Nothing in this bucket.
Missed because of a duplicate name.
Shows how late each bill really is.
Overdue bills picked for Friday.
The three old bills went into Friday's payment run with the owner's approval. The part-paid bill showed only its balance, so nobody overpaid it. The accountant stopped building the sheet by hand, and the owner now reads the ageing himself before the weekly production meeting.
Vendor ageing analysis: what a good ageing must get right
An ageing is only trusted if it agrees with the ledger. That needs one supplier record, part payments and debit notes reflected, and a clear choice of the date bills are aged from. Anything rebuilt from an export will drift from the books within days.
Ways to produce an AP ageing, compared
| Feature | Exported spreadsheet | Apragya Purchase and Payables |
|---|---|---|
| Source | A copy of the creditors list | Posted bills and payments |
| Part payments | Adjusted by hand | Only the balance is aged |
| Freshness | As old as the export | Recomputed on request |
| Supplier duplicates | Common | One vendor record |
| Next action | Separate payment sheet | Bills picked into a payment run |
Checked against public information on 16 September 2026.
What sets Apragya apart for a creditors ageing report
One vendor record
Bills, orders, receipts and payments share the supplier.
Payment timing help
A payment agent can suggest when to pay, for review.
Part of analytics
Ageing sits beside spend trend and top vendors.
Multi-company
Each company aged on its own, or together.
Access by role
Clerks, managers and owners see what they should.
CSV export
Vendor-wise ageing exported for review or audit.
See the AP ageing feature for more detail, and plan payments with payment runs. Supplier bills themselves are covered under purchase invoices.
Getting started
- Bring open supplier bills in at a period start.
- Merge suppliers that exist under two names.
- Record part payments and debit notes against bills.
- Read the ageing by due date and flag the oldest.
- Put overdue bills into the next payment run.
The first live ageing usually finds a bill that everyone assumed was paid.
What it costs to start
AP ageing, answered
Which buckets are used?
Due date or invoice date?
Can I see one supplier only?
Does it cover more than one company?
What does it cost to start?
Know what you owe before the supplier calls
Post your open bills, read the ageing and plan the next payment run from it.