Next due
20 OCTGSTR-3B · Summary return · Sep 2026in 2 days 21 OCTTax Audit Report · Form 3CA/3CB · AY 2026-27 · extended from 30 Sepin 3 days 30 OCTAOC-4 · Financial statements · FY 2025-26in 12 days 7 NOVTDS / TCS deposit · Deducted in Oct 2026in 20 days 11 NOVGSTR-1 · Outward supplies · Oct 2026in 24 days 15 NOVPF & ESI · Contributions · Oct 2026in 28 days 21 NOVITR filing · Audit cases · AY 2026-27 · extended from 31 Octin 34 days 29 NOVMGT-7 / 7A · Annual return · FY 2025-26in 42 days
All due dates
Template

Debtors Ageing Template

See exactly which customers owe you money and for how long, split into ageing bands so you can prioritise collections and control cash flow.

DEBTORS (ACCOUNTS RECEIVABLE) AGEING

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

#Customer NameGSTINCredit Days0-30 days31-60 days61-90 days90+ daysTotal Due
1[Alpha Retail Pvt Ltd][27AAAC...][30][85,000][20,000]——[1,05,000]
2[Beta Enterprises][29ABBC...][15][10,000]—[18,000][12,000][40,000]
3[Gamma Traders][URP][0]———[7,500][7,500]
 Total  [95,000][20,000][18,000][19,500][1,52,500]

How to use: Place each open invoice into the ageing band based on its invoice/due date. Compare each customer against their agreed credit days — anything in 60+ needs a reminder call, and 90+ balances should be escalated or provided for as doubtful debts. Reconcile the total with your ledger receivables and use it to plan monthly cash flow.

Before you use it — fill in / check

  • Customer name
  • GSTIN
  • Agreed credit days
  • 0-30 days
  • 31-60 days
  • 61-90 days
  • 90+ days
  • Total due

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.