Template

Creditors Ageing Template

Track how much you owe each supplier and for how long, bucketed into ageing bands so nothing (especially MSME dues) slips past its due date.

CREDITORS (ACCOUNTS PAYABLE) AGEING

Company: [Name]  |  As on [DD/MM/YYYY]  |  Amounts in ₹

#Supplier NameGSTINMSME?0-30 days31-60 days61-90 days90+ daysTotal Payable
1[Supplier A Pvt Ltd][27AAAC...]Yes[40,000][15,000]——[55,000]
2[Traders B][29ABBC...]No[20,000]—[8,000][5,000][33,000]
3[Services C LLP][06ADCE...]Yes[12,000]———[12,000]
 Total  [72,000][15,000][8,000][5,000][1,00,000]

How to use: For each supplier, place the outstanding invoice value into the correct ageing bucket based on invoice date. Flag MSME vendors (Udyam-registered) — under Section 43B(h), payment beyond 45 days is disallowed for tax and attracts interest. Clear 90+ day balances first and reconcile the total with your GSTR-2B input.

Before you use it — fill in / check

  • Supplier name
  • GSTIN
  • MSME status
  • 0-30 days
  • 31-60 days
  • 61-90 days
  • 90+ days
  • Total payable

How to use this template

  1. Read through and replace every [bracketed] or blank placeholder with your actual details.
  2. Delete any clause that doesn't apply and add anything specific to your situation.
  3. Click Print / Save as PDF to download, or Copy text to paste into your letterhead.
  4. Get it signed / stamped / notarised as required, and keep a copy for your records.

This is a general, editable template for convenience only — not legal advice. For anything material, have a professional review it. TaxClue isn't liable for how it's used.