Reviewing Accounts Payable Ageing: What to Look For Each Month

An accounts payable ageing report lists every unpaid supplier bill, grouped by how long it has been outstanding. Reviewed monthly, it does three jobs: it confirms that the payables balance in your books is correct, it catches errors such as duplicate bills and unapplied payments, and it helps plan payments so that important suppliers are paid on time and cash is not spent earlier than needed. Most small businesses look at receivables ageing carefully and payables ageing hardly at all, which is how late fees, lost discounts and damaged supplier relationships creep in.

Reading the report

A typical ageing report groups balances by days since the bill date or since the due date.

Illustrative figures.

The total must agree with the trade payables balance in the general ledger. If it does not, find the difference before doing anything else. Common causes are entries posted directly to the payables control account instead of through a supplier account, and opening balances that were never cleared.

The monthly review: seven checks

1. Old balances

Every bill over 90 days needs an explanation. The usual ones are a dispute over quality or quantity, a bill waiting for a credit note, a missing approval, or a payment already made but not matched. An old balance with no explanation is often an error.

2. Debit balances

A supplier account showing that the supplier owes you money usually means an advance paid, a payment recorded twice, a credit note posted without the matching bill, or a payment applied to the wrong supplier. Each needs investigating. Genuine advances should be tracked separately and adjusted against bills when they arrive.

3. Possible duplicates

Look for the same supplier with the same amount on or near the same date, or the same bill number entered twice. Duplicates often arise when a bill arrives by email and again in paper form. Most accounting software can flag repeated bill numbers for a supplier; switch that setting on.

4. Unapplied payments and credit notes

Payments sitting on account, not matched to specific bills, make the ageing look worse than it is and can lead to paying the same bill twice. Match them.

5. Goods received but not billed

Compare goods received records with bills entered. Goods delivered near month-end without a bill are a liability that should be accrued, or the month’s costs and payables are understated.

6. Supplier statements

For the largest suppliers, reconcile their statement to your supplier account each month or quarter. Differences usually reveal bills you have not received, payments they have not applied, or disputed items that one side has forgotten.

7. Unusual suppliers

Scan for suppliers you do not recognise, new suppliers with large balances, and payees whose bank details have recently changed. These are simple checks against both error and fraud.

Deciding what to pay first

Payables ageing is also a cash planning tool. A sensible order of priority:

1. Statutory dues and payments with legal consequences, including salaries and taxes, which sit outside the payables ledger but compete for the same cash.
2. Critical suppliers whose delays would stop operations.
3. Bills with worthwhile early-payment discounts.
4. Everything else by due date, paying on the due date rather than early.

Suppliers registered as micro or small enterprises must be paid within the agreed period, which cannot exceed 45 days from acceptance of the goods or services (15 days where nothing is agreed), under section 15 of the Micro, Small and Medium Enterprises Development Act, 2006. Late payment carries compound interest at three times the RBI bank rate under section 16, and for tax year 2026-27 section 37(2)(g) of the Income-tax Act, 2025 allows the expense only in the year it is actually paid if it is paid beyond that limit. Flag these suppliers in the ledger, confirm their status with your accountant, and build the deadlines into the payment calendar.

Is an early-payment discount worth it?

A supplier offers 2% off if you pay 30 days early. Paying ₹98 now instead of ₹100 in 30 days is like earning ₹2 on ₹98 for one month, roughly 25% a year on a simple annualised basis.

If the business has spare cash earning far less than that, or an overdraft costing less, taking the discount is usually good value. If paying early would push the business into expensive borrowing or leave it short of cash, it may not be.

Stretching payables: the limits

Paying later keeps cash in the business, but it has costs. Suppliers price in slow payers, withdraw credit, deprioritise deliveries and talk to each other. Agree longer terms openly rather than simply paying late, and keep to whatever is agreed.

What good looks like

At month-end, the ageing total agrees to the ledger, there are no unexplained balances over 90 days, debit balances are understood, large suppliers are reconciled, and the next month’s payments are planned against expected cash. For most small businesses, this takes an hour. To see how payable days feed the funding need, try the working capital calculator.

Where this fits

• The other side of working capital: customer not paying: what to do
• How payables affect the cash cycle: cash conversion cycle explained
• Where the review sits in the month: month-end close checklist
• Planning payments against cash: 13-week cash flow forecast