Next due
30 OCTAOC-4 · Financial statements · FY 2025-26in 2 days 7 NOVTDS / TCS deposit · Deducted in Oct 2026in 10 days 11 NOVGSTR-1 · Outward supplies · Oct 2026in 14 days 15 NOVPF & ESI · Contributions · Oct 2026in 18 days 20 NOVGSTR-3B · Summary return · Oct 2026in 23 days 21 NOVITR filing · Audit cases · AY 2026-27 · extended from 31 Octin 24 days 29 NOVMGT-7 / 7A · Annual return · FY 2025-26in 32 days 15 DECAdvance Tax · 3rd (75%) instalment · FY 2026-27in 48 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.