Trade Payables Ageing: Building the Working and Checking MSME Classification

Scope: Schedule III Division I trade-payables presentation; illustrated for FY 2025-26. Verification date: 11 October 2026.

Begin with invoice data, not just creditor totals

A supplier's closing balance may include old invoices, recent purchases, disputed bills and an advance. Using only the net balance loses the information needed for a meaningful trade-payables ageing note. Obtain invoice-level outstanding data and confirm the allocations of payments and credit notes.

Division I uses payable-ageing bands of less than one year, one to two years, two to three years and more than three years, with separate MSME/other and disputed categories. The ageing is based on the due date; where no due date is specified, the transaction date is relevant. Unbilled dues are identified separately. Identify amounts not yet due separately from overdue amounts in the supporting reconciliation.

Create a supplier master and a transaction working

The supplier master should contain a stable code, legal name, PAN where available, registration evidence and the classification applicable to the review period. Keep the supplier's declaration and the date on which the evidence was obtained. A ledger name containing “MSME” is not sufficient evidence by itself.

The transaction working should contain invoice date, contractual due date, outstanding amount, dispute status and payments allocated after year-end. Link it to the supplier master using a code rather than a name that staff may type differently each month.

Worked example at 31 March 2026

Assume the following fictional invoices remain unpaid. Supplier classifications and due dates have already been checked for this example.

These invoices total ₹2,50,000. Suppose the ledger additionally includes ₹30,000 of unbilled goods received and ₹20,000 of supplier advances recorded as debit balances. Identify those components separately; do not simply net every debit balance against the invoice ageing. Confirm the required presentation and any legally supportable set-off.

Do not confuse ageing with the MSME tax working

The ageing note tells a reader how long amounts have been outstanding. The FY 2025-26 income-tax working examines relevant micro/small-enterprise payments and statutory timing for Section 43B(h), alongside Form 3CD reporting. A “less than one year” balance can still require a payment-timing review.

Keep the two calculations connected through invoice identifiers but in separate columns. The tax working needs facts such as acceptance, applicable payment terms and actual payment dates. The ageing table alone cannot establish tax deductibility. Medium-enterprise status and other supplier circumstances also require their own analysis.

Resolve the exceptions

• Invoices missing from the purchase register but included in supplier confirmations.
• Payments posted to the wrong supplier or not allocated to invoices.
• Credit notes received after closing that may affect year-end estimates.
• Disputed amounts labelled as ordinary undisputed dues.
• Unverified supplier classifications carried forward unchanged.

Assign an owner and resolution date to each exception. Obtain management's response and record the preparer's conclusion. Reconcile the final ageing to the payables note and the balance sheet, including separately identified adjustments.

When preparing financials through assureOffice or another Schedule 3 financial builder, import or enter reviewed workings rather than assuming the accounting ledger contains every disclosure fact. Check the exported table, comparative figures and units. A well-presented note starts with a reliable supplier and invoice dataset.

Separate settlement timing from supplier status

A payment made after year-end can help validate an outstanding balance, but it does not remove that balance from the year-end ageing population. Preserve the reporting-date snapshot, then use subsequent settlement as supporting evidence. Keep debit supplier balances and advances visible rather than netting them casually against old invoices.

Maintain a status-change log for supplier information received during preparation. Record the evidence, effective period and reviewer conclusion, including how it affects the disclosure working. If the evidence is incomplete, flag the item for resolution. A blank classification field should not silently become a confirmed non-MSME conclusion.

Related articles

• Trade Receivables Ageing under Schedule III: A Worked Excel Example
• TDS Reconciliation for Tax Audit: Books vs Challans vs Returns
• Excel Power Query for Accountants: Reconcile Two Registers without Repeated Copy-paste

Sources and references

• Schedule III, Companies Act, 2013 — India Code
• ICAI Guidance Note on Division I — Non Ind AS Schedule III
• CBDT Form 3CD — prescribed particulars, including amendments