Skip to main content
Apragya AIFree quotation builderQuotation builderQuote builderno signup
How-to guide

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.

An accounts head sorting coloured folders into five trays by age

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.

  1. Post every supplier bill with its invoice date, due date and credit terms.
  2. Record payments, advances and debit notes against the bills they settle.
  3. Choose whether to age from the due date or the invoice date.
  4. Group the unpaid balances into standard day buckets, supplier by supplier.
  5. Agree the total with the supplier ledger for the same date.
  6. 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.

  1. Start from posted bills: Only the unpaid balance of each bill is aged, so part payments are not overstated.
  2. Standard buckets: Current, 1 to 30, 31 to 60, 61 to 90 and over 90 days, with a total.
  3. Due or invoice date: Due date by default; switch to invoice date when auditors ask.
  4. Vendor view: Search a supplier to see its open bills and total outstanding.
  5. 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

  1. Not yet due; no action needed.

  2. Due last week, part paid.

  3. Nothing in this bucket.

  4. Missed because of a duplicate name.

  5. Shows how late each bill really is.

  6. Overdue bills picked for Friday.

Three bills in the 61 to 90 day bucket explained why the foundry had slowed its dispatches.

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.

Five trays of slips with three old ones clipped beside an engine casting
The three oldest bills of the casting supplier, pulled out and scheduled for Friday's payment run.

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

FeatureExported spreadsheetApragya Purchase and Payables
SourceA copy of the creditors listPosted bills and payments
Part paymentsAdjusted by handOnly the balance is aged
FreshnessAs old as the exportRecomputed on request
Supplier duplicatesCommonOne vendor record
Next actionSeparate payment sheetBills 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

  1. Bring open supplier bills in at a period start.
  2. Merge suppliers that exist under two names.
  3. Record part payments and debit notes against bills.
  4. Read the ageing by due date and flag the oldest.
  5. 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

INR 3,999
Starter, a month
Up to 10 users, CRM and HR plus Purchase and Payables
2,000
AI Credits a month
Included on Starter
Free
Up to 3 users
CRM, HR and Vendor Onboarding

AP ageing, answered

Which buckets are used?
Current, 1 to 30 days, 31 to 60 days, 61 to 90 days and over 90 days, with a total outstanding.
Due date or invoice date?
Due date by default, which shows how overdue a bill is. Invoice date is available for the view auditors often ask for.
Can I see one supplier only?
Yes. Search the supplier to see its open bills, and export the vendor-wise ageing to CSV.
Does it cover more than one company?
Yes. With multi-company on, each company's payables are aged separately or together.
What does it cost to start?
Purchase and Payables is available from the Starter plan, INR 3,999 a month for up to 10 users, which includes CRM and HR plus a choice of enterprise apps and 2,000 AI Credits a month. Pro, at INR 7,999 a month, covers 25 users and every enterprise app.

Know what you owe before the supplier calls

Post your open bills, read the ageing and plan the next payment run from it.