Summary: A stock and receivables audit is a special purpose assignment conducted at the request of a lending institution to verify current assets offered as security and report on their validity, adequacy and quality. The article emphasizes that examining debtor realisation trends and ageing over at least three consecutive months provides a more reliable basis for assessing receivable quality than a single-month snapshot. Practitioners should analyse realisation rates, movement of balances across ageing buckets, concentration of receivables, debtors beyond the permissible credit period, unusual collection patterns, related-party exposures and supporting documentation. Ageing schedules must be verified against party-wise ledgers, and ineligible debtors should be excluded while recomputing drawing power. The report should quantify declining realisation trends, overdue receivables and any overstatement of drawing power using precise, factual observations. The assignment does not involve expressing an audit opinion but requires objective reporting to enable banks to assess the quality of receivable security and monitor credit exposure appropriately.
Page Contents
- Introduction
- Why Stock Auditors Should Review at Least Three Months of Debtor Data Before Certifying Drawing Power
- Understanding Realisation: What the Practitioner Tracks
- The Realisation Rate Formula
- Worked Example: Realisation Trend Computation
- Ageing Analysis: Structure and Interpretation
- Ageing Statement: Three Month Comparison
- What the Stock Auditor Should Look for in the Trend
- Impact of Ineligible Debtors on Drawing Power: How Stock Auditors Should Compute and Report Variances
- Stock and Receivables Audit Report: Why Observations Must Be Quantified, Evidence-Based and Unambiguous
- Conclusion
Introduction
A stock and receivables audit is a special purpose assignment undertaken by a Chartered Accountant at the request of a lending institution. Its scope, methodology and reporting obligations are governed by the ICAI Guidance Note on Reports or Certificates for Special Purposes (Revised 2016). The engagement does not constitute a statutory audit and the practitioner does not express an audit opinion on the financial statements of the borrowing entity. The assignment is limited to the verification of current assets offered as security and to reporting on matters that affect the validity, adequacy, and quality of that security.
Among the current assets that banks hypothecate, trade receivables often represent the largest single component after raw material and finished goods inventory. A bank advancing working capital credit against receivables does so on the assumption that collections will flow in within the periods contemplated in the sanction terms. When that assumption is not borne out in practice, the drawing power computation overstates the eligible security, the borrower draws more than the recoverable value of the asset base supports, and the bank is exposed to a credit risk it has not quantified.
A single month statement of debtors tells the practitioner very little beyond a balance. When statements are available for three or more consecutive months, a pattern emerges. That pattern, if read correctly, reveals far more about the health of the debtor book than any individual month can show. This article sets out the analytical approach a practitioner should apply when examining debtor realisation trends and ageing across a minimum of three months in a stock and receivables audit context.
Why Stock Auditors Should Review at Least Three Months of Debtor Data Before Certifying Drawing Power
The ICAI Guidance Note on Reports or Certificates for Special Purposes emphasises that the practitioner must have a reasonable basis for any assertion made in the report or certificate. A single month snapshot of debtors is not a reasonable basis for an assertion about debtor quality. It reflects only what was outstanding on one date. It does not show whether earlier balances were collected, restructured, or simply rolled over into fresh invoices.
The RBI circular on the loan system for delivery of bank credit (circular dated December 2018) requires that for borrowers with aggregate fund-based working capital limits of Rs. 150 crore and above, the drawing power for book debts be established on a sound and verifiable basis. While that circular addresses the bank’s own internal discipline, it signals the regulatory expectation that receivable quality is not a point-in-time assertion. It is a dynamic position that must be tracked over time.
Sanction letters for working capital credit facilities typically prescribe a debtor cover period, commonly 30, 45, 60 or 90 days. A practitioner who examines only one month’s statement cannot verify whether the ageing profile at that date reflects the normal cycle or is a temporary anomaly. Three months of data provides enough of a window to identify whether slow movement is systematic or episodic.
Standard practice in well-run engagements, and increasingly the expectation of audit committees and bank credit risk teams, is that the practitioner collects statements for a minimum of three months preceding the date of the report. Where the sanction terms permit debtors beyond sixty days, the collection window should be extended to cover at least as many months as the maximum eligible period.
Understanding Realisation: What the Practitioner Tracks
Debtor realisation in the context of a stock and receivables audit means the actual cash collected from trade debtors within the engagement period. It is distinct from the billing cycle, from credit note reversals, and from contra adjustments. The practitioner is concerned with one fundamental question: of the debtors outstanding at the beginning of each month, how much was actually collected in cash during that month?
The practitioner compares the opening debtor balance in month one with the closing balance in month two, adjusting for fresh sales invoiced during the intervening period. The difference, net of credit notes, represents collections. That figure, expressed as a percentage of the opening balance, is the realisation rate for the month. Repeated across three or more months, it becomes a trend.
The Realisation Rate Formula
Realisation Rate (%) = [Opening Debtors + Sales During Month – Closing Debtors – Credit Notes] divided by [Opening Debtors + Sales During Month – Credit Notes] x 100
A realisation rate consistently above eighty-five percent across three months suggests a healthy collection cycle. A rate that has progressively declined from ninety percent in month one to seventy percent in month three is a warning. A rate that dropped sharply in month two and partially recovered in month three warrants inquiry into what happened in month two.
Worked Example: Realisation Trend Computation
The following example illustrates the computation of the realisation trend for a manufacturing borrower with a cash credit facility. All amounts are in lakhs.
| Particulars | Month 1 (Apr) | Month 2 (May) | Month 3 (Jun) |
| Opening Debtors (A) | 480.00 | 510.00 | 580.00 |
| Add: Sales During Month (B) | 320.00 | 380.00 | 290.00 |
| Less: Credit Notes (C) | 12.00 | 15.00 | 8.00 |
| Gross Receivable Pool (A+B-C) | 788.00 | 875.00 | 862.00 |
| Closing Debtors (D) | 510.00 | 580.00 | 620.00 |
| Implied Collections (A+B-C-D) | 278.00 | 295.00 | 242.00 |
| Realisation Rate (%) | 35.27% | 33.71% | 28.07% |
Reading the numbers above, the realisation rate has fallen from 35.27 percent in April to 28.07 percent in June. Stated differently, collections as a proportion of the eligible pool have declined by over seven percentage points across three months. The closing debtor balance has grown from ₹ 480.00 lakhs to ₹ 620.00 lakhs even as sales in June were lower than in April. This combination, rising debtor balance with falling sales and falling realisation rate, is a substantive observation.
The practitioner is not concluding that the debtors are irrecoverable. The practitioner is reporting a trend that the bank must factor into its credit monitoring and that, if it continues, will result in the drawing power overstating the recoverable value of the security.
Ageing Analysis: Structure and Interpretation
Debtor ageing classifies outstanding receivables by the number of days elapsed since the date of invoice. The standard buckets used in bank sanction terms are: up to thirty days, thirty-one to sixty days, sixty-one to ninety days, ninety-one to one hundred and eighty days, one hundred and eighty-one days to one year, and beyond one year. Some sanction letters combine the last two into a single bucket described as overdue.
The practitioner must obtain the ageing schedule from the borrower for each of the three months under review and must verify it against the sub-ledger or party-wise ledger. An ageing schedule provided as a summary total without party-level detail is not a verifiable document. Where the borrower cannot provide party-level ageing, that limitation must be clearly stated in the report.
Ageing Statement: Three Month Comparison
| Ageing Bucket | Apr (Lakhs) | Apr % | May (Lakhs) | May % | Jun (Lakhs) | Jun % |
| 0 to 30 days | 210.00 | 41.2% | 215.00 | 37.1% | 195.00 | 31.5% |
| 31 to 60 days | 160.00 | 31.4% | 175.00 | 30.2% | 185.00 | 29.8% |
| 61 to 90 days | 85.00 | 16.7% | 110.00 | 19.0% | 140.00 | 22.6% |
| 91 to 180 days | 40.00 | 7.8% | 65.00 | 11.2% | 80.00 | 12.9% |
| 181 days to 1 year | 12.00 | 2.4% | 10.00 | 1.7% | 15.00 | 2.4% |
| Beyond 1 year | 3.00 | 0.6% | 5.00 | 0.9% | 5.00 | 0.8% |
| Total | 510.00 | 100% | 580.00 | 100% | 620.00 | 100% |
The shift in the composition of the debtor book is evident. The proportion of fresh debtors, being those in the zero to thirty day bucket, has fallen from 41.2 percent in April to 31.5 percent in June. The sixty-one to ninety day bucket has moved from 16.7 percent to 22.6 percent. The ninety-one to one hundred and eighty day bucket has grown from 7.8 percent to 12.9 percent. In absolute terms, the sub-ninety day debtors are ₹ 455.00 lakhs in April and have moved to ₹ 520.00 lakhs in June, while the overdue debtors beyond ninety days have grown from ₹ 55.00 lakhs to ₹ 100.00 lakhs, an increase of ₹ 45.00 lakhs in three months.
What the Stock Auditor Should Look for in the Trend
The practitioner is not a credit rating analyst and does not express a view on the creditworthiness of the borrower’s customers. The practitioner is a special purpose assurance provider whose obligation is to report on the quality and verifiability of the security offered to the lending bank. The following are the specific conditions that must be examined when reviewing debtor trends and ageing.
1. Migration of Balances Across Ageing Buckets
When the same party names appear in progressively older buckets across three months, the balances are not being collected, they are ageing in place. A balance that was in the thirty-one to sixty day bucket in April and appears in the sixty-one to ninety day bucket in May and in the ninety-one to one hundred and eighty day bucket in June without a fresh invoice to explain its continued presence is a stale debtor being carried forward.
The practitioner should ask for a party-wise comparison of the sub-ledger across all three months. When the same party name with approximately the same balance moves steadily into older buckets, the debtor is, in effect, a funded receivable, not a trade receivable. This distinction matters because funded receivables do not qualify as eligible security under most sanction terms.
2. Large Concentration in a Single Party or Group
A debtor ageing schedule that shows sixty percent or more of the total receivables concentrated in one or two parties creates a qualitatively different risk from a diversified book. The concentration risk is compounded if those parties are related to the borrower, are located in the same group of companies, or are entities where the borrower also appears as a creditor. The practitioner should specifically check whether any debtor in the schedule is also listed in the creditors schedule and report cross-holdings.
The RBI Master Direction on Frauds – Classification and Reporting by Commercial Banks and Select Financial Institutions (updated periodically) identifies circular transactions between related parties as a vulnerability pattern in working capital accounts. The practitioner is not making a fraud determination, but the reporting of such cross-holdings allows the bank to apply its own credit risk and fraud risk assessment.
3. Debtors Beyond the Permitted Period
Every sanction letter specifies the maximum age of eligible debtors. Typically this is sixty days, though some facilities extend to ninety days. Debtors beyond the permitted period are ineligible for inclusion in the drawing power computation. The practitioner must identify the amount of ineligible debtors in each month and must recompute the drawing power excluding those amounts.
Where ineligible debtors have been included in the drawing power statements submitted by the borrower to the bank, the practitioner must state so clearly in the report. This is not a discretionary observation. The ICAI Guidance Note on Reports or Certificates for Special Purposes requires that the special purpose report not omit information that would be material to the purpose for which the report is being issued. A bank acting on an overstated drawing power computation is not in a position to monitor the security adequately.
4. Sudden Spike in One Month Followed by a Drop
A realisation trend that shows a sharp jump in collections in one month, sometimes called a clean-up, followed by the reappearance of the same or similar balances in the following month is a pattern worth examining closely. It can indicate that a related party or sister concern has temporarily transferred funds to the borrower’s account at the date of the stock audit or at the month end to improve the apparent debtor position, with those amounts being returned or re-advanced shortly thereafter.
The practitioner cannot conclude on such a pattern without additional evidence. However, the practitioner can compare the bank account statement for the three months with the debtor schedule for the same period. If large credits appear in the bank account at or around month ends that are not reflected in the invoicing pattern, that discrepancy is an observation to be recorded in the working papers under SA 230 of the ICAI Standards on Auditing, as adapted for special purpose assignments.
5. Debtors Not Supported by Invoices or Delivery Evidence
The sub-ledger ageing is a summary document. Its underlying basis is the invoice-by-invoice ledger. For older debtors, particularly those beyond ninety days, the practitioner should call for the original invoice copies, delivery challans, and acknowledgements. Where the borrower cannot produce these documents for significant balances, those balances cannot be treated as verified receivables. The fact of non-production must be stated in the report.
Impact of Ineligible Debtors on Drawing Power: How Stock Auditors Should Compute and Report Variances
The practitioner’s primary output on the debtor side is the revised drawing power computation after excluding ineligible debtors. The following example continues from the worked example above. All amounts are in lakhs.
| Particulars | Jun (Lakhs) |
| Total Outstanding Debtors per Sub-ledger | 620.00 |
| Less: Debtors beyond 90 days (ineligible) | 100.00 |
| Less: Related party debtors (sanction terms) | 45.00 |
| Eligible Debtors for Drawing Power | 475.00 |
| Margin Prescribed in Sanction Letter (25%) | 118.75 |
| Drawing Power on Eligible Debtors | 356.25 |
| Drawing Power per Borrower’s Own Statement | 465.00 |
| Excess Drawing Power as per Borrower | 108.75 |
The excess of ₹ 108.75 lakhs represents the amount by which the borrower overstated the drawing power in the statement submitted to the bank. The practitioner does not instruct the bank to reduce the limit. The practitioner states the facts. The credit decision rests with the bank.
Stock and Receivables Audit Report: Why Observations Must Be Quantified, Evidence-Based and Unambiguous
The stock and receivables audit report is a special purpose document. Its language must be precise, factual, and unambiguous. General statements such as some debtors appear to be old or the realisation trend shows a decline are not sufficient. The report must state the amount, the period, the direction of movement, and the basis of the conclusion.
A well-constructed observation on debtor trend would state: Based on the debtor sub-ledger statements furnished for the months of April, May, and June, the realisation rate has declined from 35.27 percent in April to 28.07 percent in June. The debtors outstanding beyond ninety days have increased from ₹ 55.00 lakhs (10.8 percent of total debtors) in April to ₹ 100.00 lakhs (16.1 percent of total debtors) in June. Accordingly, the eligible debtors for the purpose of drawing power computation as at 30 June have been reckoned at ₹ 475.00 lakhs after excluding ₹ 145.00 lakhs on account of overdue and related party debtors. The drawing power on account of debtors works out to ₹ 356.25 lakhs against ₹ 465.00 lakhs as stated in the borrower’s own submission.
The above language fulfils the reporting standard required under the Guidance Note. It is factual, quantified, and references the documents examined. It does not express an opinion on the creditworthiness of the borrower or of its customers. It allows the bank credit team to act on the information with full clarity as to what was found and what was excluded.
Conclusion
Debtor realisation trend and ageing analysis is not an optional enhancement to a stock and receivables audit. It is the core of what the assignment requires when the security includes book debts. A single month snapshot is a photograph. Three months of comparative data is a film. The photograph shows what is; the film shows what is happening. Banks lend against what will happen, which is to say against the expectation of future collections. The practitioner who tracks the trend gives the bank the information it needs to assess whether that expectation is being met.
The computations set out in this article are not complex. They require nothing more than the debtor statements, the sub-ledger, and the bank account for the same period. What they require that no formula can provide is the practitioner’s willingness to look at the numbers over time rather than at a point in time, and to report what the trend reveals without tempering the language to suit the convenience of either the borrower or the lender.
That willingness is what makes the special purpose assignment worth the fee that is paid for it.
*******
Disclaimer: This article is written for general professional information. It represents the personal views of the author based on professional experience and does not constitute legal, regulatory, or professional advice applicable to any specific engagement. Readers are advised to refer to the applicable sanction terms, RBI Master Directions, ICAI Guidance Notes and Standards, and the specific circumstances of each engagement before reaching conclusions. Nothing in this article supersedes, modifies, or interprets any RBI Master Direction, any ICAI Guidance Note, any ICAI Standard on Auditing, any bank’s internal policy, or any contractual term in any sanction letter. In the event of any inconsistency between the views expressed here and the applicable regulatory, professional, or contractual framework, the applicable framework shall prevail. The worked examples in this article are illustrative only and are not drawn from any actual audit engagement. No company name, borrower name, or bank name has been used. The examples should be adapted to the specific terms of each engagement. The author accepts no liability for any loss, damage, or professional consequence arising from the use of any content, format, or computation methodology in this article.
Author Bio
