Free debtor ageing check for audit season

Old Debtors? Know the Audit Risk Before Your Auditor Asks.

Every outstanding invoice on your books gets categorized by age, and the older it is, the more questions it raises. See exactly where you stand, and what your options actually are.

Sound familiar?

The audit question usually arrives before the answer is ready.

01Flagged

Old balances appear

Your trade receivables ageing report shows invoices sitting beyond one year.

02Asked

Auditor wants a reason

You need to explain whether each debtor is recoverable, doubtful, or ready for write-off.

03Checked

GST still matters

Writing off the debtor does not bring back GST already paid on that invoice.

04Decided

Balance sheet gets cleaner

A recovery plan before books close is often easier than defending stale receivables later.

That is why the calculator starts with the ageing schedule your auditor will read first.Once the old balances are visible, the next step becomes much clearer.

Debtor Ageing & Audit-Risk Calculator

Enter your top overdue accounts. The risk updates live.

Total Outstanding₹2,50,000
Debtor / CustomerOutstanding AmountInvoice DateBucketAction
<6 months
6m-1y
Not yet due / Less than 6 months₹2,50,000100% of total
6 months - 1 year₹00% of total
1 - 2 years₹00% of total
2 - 3 years₹00% of total
More than 3 years₹00% of total
Receivables Your Auditor Will Likely Question₹00% of total receivables are older than 1 year
Audit ReadinessLow RiskMinimal audit queries expected
III
Schedule III disclosure view

Companies disclose trade receivables in these ageing categories. When older buckets carry large balances, auditors typically expect a clear management explanation.

This tool provides an indicative ageing analysis based on the Schedule III (Division II) trade receivables disclosure categories. It does not constitute an audit opinion, tax advice, or a formal provisioning recommendation.

What are your options?

Recover, provide, or write off. Each has a different impact.

01

Recover It

The cleanest option. If recovered before your books close, the balance disappears from the ageing report entirely. No provisioning, no write-off, no questions.

02

Provide for It (Doubtful Debt)

You set aside a provision against the debt. This hits your P&L this year but keeps the option to recover later. It does not reduce your tax liability directly.

03

Write It Off (Bad Debt)

To be tax-deductible under Section 36(1)(vii), the debt must be actually written off in your books and must relate to income already accounted for. Writing off the debt does not recover the GST you already paid to the government.

Most businesses only consider write-off because recovery feels too difficult or too late. Often, it isn't.