CORAA
AI Modules/Working Papers/AR Ageing
Sch III Amendment 2021· पत्र

AR Ageing

Trade receivables एजिंग buckets per Schedule III amendment 2021.

AR Ageing per Schedule III buckets

The 2021 amendment to Schedule III mandates specific एजिंग buckets for trade receivables: कम than 6 महीने, 6 महीने to 1 वर्ष, 1 to 2 वर्ष, 2 to 3 वर्ष, and over 3 वर्ष. CORAA composes these buckets automatically. Party-wise एजिंग unlocks at Tier II (Party Master loaded); bill-wise precision at Tier III (Bill पंजीकरण करें loaded). Receivables over 3 वर्ष are auto-flagged as खंड 41(1) cessation candidates.

  • Five buckets per Sch III amendment 2021
  • Secured, Unsecured, Doubtful वर्गीकरण
  • Party-wise एजिंग at Tier II
  • Bill-wise precision at Tier III
  • खंड 41(1) Income Tax Act cessation candidates flagged
  • प्रोvision for doubtful debts adequacy check
Two paths, one ledger

The old way, and ours.

Two paths to the same audit conclusion. One leaves traces; the other doesn't.

Traditional

The old way

  • -AR एजिंग extracted from accounting system at वर्ष-end only
  • -Bucket boundaries set per Sch III amendment but applied manually in Excel
  • -खंड 41(1) cessation analysis a separate exercise
  • -प्रोvision adequacy assessed on aggregate, not party-by-party
AR एजिंग build समय: 2-4 घंटे. Cessation समीक्षा: often deferred to Form 3CD finalization.
CORAA

On the Ledger

  • लाइव एजिंग computation as of any reference date
  • Secured / Unsecured / Doubtful split per Sch III amendment
  • Per-party एजिंग once Party Master loaded
  • Per-invoice एजिंग once Bill पंजीकरण करें loaded
  • Auto-flagging of receivables over 3 वर्ष for Sec 41(1) समीक्षा
AR एजिंग instant. Cessation candidates surface before fieldwork concludes.
How it works

Three steps. Every trace logged.

Step 01

Reference date selection

Pick the Balance Sheet date (typically मार्च 31) or any other reference date. CORAA computes the दिन outstanding for every receivable as of that date.

Step 02

Bucket allocation

Each receivable falls into one of the five Sch III amendment 2021 buckets. The bucket totals roll up to the Trade Receivables line on the Balance Sheet. CY and PY एजिंग rendered side by side.

Step 03

Cessation समीक्षा

Receivables over 3 वर्ष are candidates for write-off under खंड 41(1) of the Income Tax Act (cessation of liability, reverse for assets). The ऑडिटर समीक्षाएँ each, decides to provide or write off, and the disposition feeds Form 3CD Clause 16.

Inside the module

What you actually get.

Schedule III amendment 2021 buckets

Five buckets exactly as mandated. The bucket boundaries are non-negotiable and CORAA's render matches the regulator's exact text.

  • कम than 6 महीने
  • 6 महीने to 1 वर्ष
  • 1 to 2 वर्ष
  • 2 to 3 वर्ष
  • Over 3 वर्ष

Secured / Unsecured / Doubtful split

Each bucket further splits by सुरक्षा: Secured (against assets, guarantees), Unsecured, and Doubtful (provision-eligible). The वर्गीकरण feeds नहींte 19 Trade Receivables.

  • Secured: party-level सुरक्षा flag
  • Unsecured: default for trade receivables
  • Doubtful: provision-eligible per AS 4
  • कुल by वर्गीकरण on नहींte 19

खंड 41(1) cessation flagging

Receivables over 3 वर्ष prompt Sec 41(1) समीक्षा. If the party has clearly ceased to exist or pay (winding up, NCLT order, prolonged absence), the receivable is written off; otherwise a provision is created.

  • Auto-flag for >3 वर्ष receivables
  • Cessation evidence capture
  • Write-off vs provision decision
  • Feeds Form 3CD Clause 16 disposition

प्रोvision for doubtful debts

AS 4 prescribes a provision for doubtful debts based on the ऑडिटर's expectation of recoverability. CORAA suggests a provision based on एजिंग distribution; the ऑडिटर confirms or adjusts.

  • AS 4 provision logic
  • Ageing-based suggestion
  • ऑडिटर adjustment with rationale
  • प्रोvision flows to नहींte 19 and P&L
Frequently asked

Answers, up front.

Without the Party Master, CORAA can still produce aggregate एजिंग buckets at Tier I (because वाउचर carry dates regardless of party identity). The ऑडिटर sees totals per bucket but not the party-level breakdown. Tier II unlocks party-wise distribution; Tier III unlocks bill-wise precision.
Two signals: (1) ऑडिटर manually flags the party as Doubtful in the Party Master, or (2) CORAA's provision logic flags receivables that have crossed the 1-वर्ष boundary without payment activity. The ऑडिटर confirms before the वर्गीकरण locks.
हाँ. CARO Rule 11(e) requires the Trade Receivable Turnover Ratio. CORAA computes it as Net Credit Sales divided by Average Trade Receivables; the figure flows to the Schedule III Ratios tab and to CARO 2020 Clause 3(xi)(e). Variances over 25% from PY require ऑडिटर explanation.
See it on a real ledger

Run ar ageing on one of your engagements.

Bring a Trial Balance and a General Ledger. We'll walk through working papers end-to-end on your data, not a sandbox.

Start the free trial →Book a walk-through
AR Ageing Audit Working Paper | Schedule III Buckets | CORAA | CORAA