Accounts Payable Ageing: A Monthly Small-Business Review

Start with the report date and ageing basis. Invoice-date ageing measures time since the bill date; due-date ageing measures time against the payment due date. A bill can be old by invoice date while still within agreed credit terms. Read the settings before treating a bucket as overdue.

Run the report for the month-end being reviewed. Check that it includes all supplier accounts and that its total agrees with the corresponding payable balances in the books. If it does not, resolve the difference before using it to approve payments.

• ✓Confirm the report date, filters and treatment of credit balances.
• ✓Check whether ageing uses invoice dates or due dates.
• ✓For due-date ageing, check that recorded terms agree with the supporting documents.
• ✓Identify advances, credit notes and payments shown separately from bills.
• ✓Keep the original report and a corrected version so adjustments remain traceable.

Use the bucket boundaries shown in your report. The table below assumes due-date ageing. For every overdue balance, record what caused it, who will resolve it and what happens next. A bucket identifies a question; it does not answer it.

Compare the supplier's statement with your party ledger at the same cut-off. Match individual invoices, credit notes and payments as well as the closing balance. If the statement covers a different period, explain the intervening entries first.

1. Match the opening balance or carry forward the last agreed reconciliation.
2. Tick matching invoices using their references and amounts.
3. Match credit notes to returns, shortages or agreed adjustments.
4. Match payments using bank references and supplier allocations.
5. List every unmatched item, its evidence, the responsible person and the next action.
6. Correct supported errors, rerun the report and retain unresolved differences.

For a bill missing from your books, obtain the invoice and check delivery or service acceptance before posting it. For a payment missing from the supplier statement, share the payment reference through the agreed channel. Do not enter a balancing adjustment just to make the totals agree. The monthly bank reconciliation guide covers the related bank-side checks.

Keep the recorded balance and the dispute status separately visible. Note the amount questioned, the reason, the supporting documents and the person handling it. A short delivery to the godown, a rate disagreement and a returned item each need different evidence.

Where only part of a bill is disputed, identify the undisputed portion and review its payment separately. Confirm the treatment with the supplier and your accountant where necessary. Keep the original due date visible; moving it forward would hide the age of the unresolved item.

Compare invoice references, supplier accounts, amounts and supporting documents. Search variations in spaces, slashes and leading zeros. Check whether the same supplier has more than one account. Two entries with the same amount are a reason to investigate, not proof of duplication.

Trace suspected duplicates to the original invoice, purchase record, delivery evidence and bank payment. Correct a confirmed duplicate through a documented accounting entry. Also check whether a payment sits unallocated while the invoice remains open. Do not send a second payment until that possibility is resolved.

Illustrative example only: a shop's report shows Rs 90,000 overdue to one supplier. Review finds a confirmed duplicate bill of Rs 15,000 and a bank payment of Rs 20,000 awaiting allocation. After the duplicate is corrected and the payment is allocated, Rs 55,000 remains open.

Of that remaining balance, Rs 10,000 concerns a documented shortage awaiting resolution. The review therefore separates Rs 45,000 for payment consideration from Rs 10,000 under dispute. It does not treat the disputed amount as cancelled or change its original due date.

Keep a separate check for suppliers whose status may bring MSME payment obligations into scope. The MSME Development Act sets payment and interest rules for buyers of goods and services from qualifying micro and small enterprises. A normal payment queue or an ageing bucket is not a substitute for checking the applicable requirements.

Use the existing MSME registration and MSME Form 1 payment reporting guides as starting points. Ask your CA to confirm which suppliers and obligations apply, including any reporting or tax consequences. Check the relevant official portal or your CA for current requirements; this guide states no statutory payment period or reporting deadline.

• ✓A corrected ageing report reconciled to the books.
• ✓A supplier reconciliation with explained differences.
• ✓A payment proposal showing approved bills and cash required.
• ✓An exception list covering disputes, duplicates, missing documents and unapplied entries.
• ✓A named owner and follow-up point for every unresolved item.

Pass the approved proposal into the weekly supplier payment routine. Before releasing money, check for payments made since the report cut-off. Keep account-detail changes subject to a separate verification and approval process.

• Calling every old invoice overdue without checking the ageing basis.
• Paying from a supplier statement without matching the underlying bills.
• Clearing an old balance without evidence supporting the adjustment.
• Netting credits and advances against unrelated invoices without checking allocation.
• Letting disputed items remain open with no owner or next action.

The monthly review checks recorded supplier bills. Keep a separate list of received goods or accepted services still awaiting invoices, and discuss their accounting treatment with your accountant. An ageing report alone cannot show everything that may need recording.