An MSME manufacturer in Nagpur with a Rs 1.5 crore CC limit from SBI had been submitting stock statements showing inventory valued at Rs 2.2 crore every month. The statements were prepared by the accountant using a rough estimate - not from the stock register or ERP. When SBI commissioned a stock audit in March 2026, the CA found actual stock worth only Rs 1.4 crore. The drawing power dropped from Rs 1.65 crore to Rs 1.05 crore overnight. The borrower's CC outstanding of Rs 1.35 crore now exceeded the DP by Rs 30 lakh - triggering excess drawing regularisation.
The root cause was not fraud - it was sloppy stock statement preparation. The accountant had been using the same approximate figures month after month, not updating for stock consumed in production, dispatched to buyers, or written off as scrap. For MSME borrowers who lack dedicated inventory management systems, this is the most common path to a banking crisis - a stock statement that does not match reality.
This guide explains how to prepare the stock statement correctly - section by section, with a worked example - so your drawing power stays accurate and your CC/OD account stays healthy.
What Is a Bank Stock Statement and Why Does It Matter?
A bank stock statement (also called an inventory statement) is a periodic declaration by the borrower to the bank showing the current value of stock and receivables held as security for the working capital facility (CC/OD). The bank uses the stock statement to compute drawing power - the maximum amount the borrower can utilise from the CC/OD limit.
The stock statement is not just a formality. It is the basis on which the bank decides whether the borrower's CC/OD account is regular (within drawing power), irregular (temporarily exceeding DP), or out of order (exceeding DP for 90+ days - NPA classification under RBI IRACPD 2025). An inaccurate stock statement - whether overstated or understated - creates problems. Overstatement inflates DP and masks excess drawing. Understatement unnecessarily restricts the borrower's credit availability.
Businesses requiring professional stock reconciliation and stock audit services to verify the accuracy of their stock statements can engage a CA-led team for on-site physical verification, ERP-to-statement reconciliation, and drawing power computation - ensuring the statement submitted to the bank matches physical reality.
Key Terms You Should Know
- Drawing Power (DP): Maximum amount the borrower can utilise from CC/OD. Computed from the stock statement: (eligible stock × (1 - stock margin)) + (eligible debtors × (1 - debtor margin)). Recalculated by the bank every time a new stock statement is submitted.
- Eligible Stock: Stock that qualifies for drawing power computation. Total stock minus ineligible items: obsolete, expired, stock older than bank's prescribed ageing limit (90/180 days), uninsured stock, stock at unapproved locations, disputed/rejected stock.
- Margin: The percentage of eligible stock/debtor value that the bank excludes from DP as a safety buffer. Typically 25% for stock (borrower gets 75% credit) and 40% for debtors (borrower gets 60% credit). Specified in the sanction letter.
- Paid Stock: Stock for which the borrower has paid the supplier. Banks typically include only paid stock in DP computation. Unpaid stock (creditors for purchases) is deducted from total stock to arrive at paid stock.
- Ageing Limit: The maximum age of stock the bank will consider for DP. Typically 90-180 days depending on the industry and bank policy. Stock older than the ageing limit is excluded from eligible stock even if it is physically present.
Who Must Submit Stock Statements?
- All CC (Cash Credit) borrowers - the stock statement is a condition of the CC sanction letter
- All OD (Overdraft) borrowers where the facility is secured by stock and/or book debts
- MSME borrowers with MUDRA, CGTMSE, or other government-backed working capital loans - if the loan is secured by stock hypothecation
- Consortium borrowers - the stock statement is submitted to the lead bank and shared with all consortium members
- Multiple banking arrangement borrowers - submit to each bank in their prescribed format
- Traders, manufacturers, and service companies with inventory-based working capital facilities
MSME manufacturers in Pune requiring help with stock statement preparation and stock audit in Pune can engage a CA team for monthly reconciliation, DP computation, and statement preparation in the bank's specific format.
Submission Frequency and Deadlines
| CC/OD Limit | Typical Submission Frequency | Deadline | Consequence of Late Submission |
|---|---|---|---|
| Up to Rs 1 crore | Quarterly | Within 7-10 days of quarter-end (bank-specific) | DP frozen at last submitted statement; penal interest may apply |
| Rs 1-5 crore | Monthly | By 7th-10th of the following month | DP not updated; account may be classified as irregular if DP falls |
| Rs 5-25 crore | Monthly + quarterly stock audit | By 7th of following month | Stock audit commissioned; DP reduction if audit finds discrepancy |
| Rs 25 crore+ | Monthly + quarterly stock audit + possible concurrent audit | By 7th of following month | Enhanced monitoring; any delay flagged in bank's internal risk report |
Note: The exact deadline and frequency are specified in the sanction letter. Always check your sanction letter for the submission date. Most banks require submission within 7-10 days after the end of the period. Some banks (SBI, PNB, BOB) provide their own Excel format; others accept a standard format. If you are unsure about the format, ask your relationship manager.
How to Prepare the Stock Statement: Step-by-Step
1. Conduct a physical stock count (or reconcile ERP data) as of the statement date.The statement date is typically the last day of the month or quarter. On that date, count or reconcile: raw materials in stock (quantity and value), WIP at each production stage, finished goods in the warehouse, stores and spares, and scrap/rejection. If you use Tally or an ERP, generate a stock summary as of the statement date - but verify it against physical reality. For businesses with company registration and bank borrowing, maintaining a stock register that updates in real-time (through ERP or Tally) is the foundation for accurate stock statements - retrospectively creating statements from memory is the primary source of errors.
2. Classify stock by category as required by the bank's format. Most banks require stock split into: (a) Raw Materials, (b) Stock-in-Process (WIP), (c) Finished Goods, (d) Stores & Spares, (e) Packing Materials. For each category, list: opening stock (from previous statement), purchases/receipts during the period, consumption/dispatch during the period, and closing stock. Value each category using the cost method specified in your accounting policy (FIFO or weighted average).
3. Calculate paid stock by deducting creditors for purchases. Paid stock = Total closing stock value minus creditors for stock purchases (unpaid supplier invoices as of the statement date). Banks compute DP on paid stock, not total stock. This is where many MSMEs make errors - they report total stock without deducting unpaid creditors, inflating the DP base. Cross-verify creditors with your accounts payable ledger.
4. Prepare the book debts (receivables) section. List total debtors as of the statement date with an ageing breakdown: 0-90 days, 90-180 days, 180-365 days, and above 365 days. Most banks exclude debtors older than 90 or 180 days from eligible debtors. List your top 5-10 debtors by value. Banks also exclude related-party debtors and disputed debtors from eligible debtors.
5. Confirm insurance details. The stock statement must declare that the stock is insured. Provide: policy number, insurer name, sum insured, validity period, and bank's name as loss payee. If insurance has lapsed or the sum insured is less than the stock value, the bank may exclude the uninsured/underinsured portion from DP.
6. Complete the certification and submit in the bank's prescribed format. Sign the borrower's certification declaring that the stock is the borrower's own property, is free from any other lien or charge (except the bank's hypothecation), and the statement is true and correct. Submit in the bank's prescribed format (Excel or PDF) by the deadline. Keep a copy for your records.
Sample Stock Statement: Rs 80 Lakh CC Borrower (MSME Manufacturer)
The following table shows a sample quarterly stock statement for a manufacturing MSME with Rs 80 lakh CC limit, as of 31 March 2026.
| Section | Particulars | Opening (1 Jan) | Additions | Consumption/Sales | Closing (31 Mar) |
|---|---|---|---|---|---|
| A. STOCK | |||||
| Raw Materials | Rs 22,00,000 | Rs 45,00,000 | Rs 38,00,000 | Rs 29,00,000 | |
| Work-in-Process | Rs 8,00,000 | Rs 32,00,000 | Rs 30,00,000 | Rs 10,00,000 | |
| Finished Goods | Rs 35,00,000 | Rs 42,00,000 | Rs 48,00,000 | Rs 29,00,000 | |
| Stores & Spares | Rs 3,00,000 | Rs 2,50,000 | Rs 2,00,000 | Rs 3,50,000 | |
| Packing Materials | Rs 1,50,000 | Rs 3,00,000 | Rs 2,80,000 | Rs 1,70,000 | |
| Total Stock | Rs 69,50,000 | Rs 73,20,000 | |||
| B. DEDUCTIONS | |||||
| Less: Stock > 180 days old | (Rs 4,50,000) | ||||
| Less: Obsolete/rejected stock | (Rs 2,20,000) | ||||
| Less: Creditors for purchases (unpaid) | (Rs 12,00,000) | ||||
| Paid Eligible Stock | Rs 54,50,000 | ||||
| C. BOOK DEBTS | |||||
| Total Debtors | Rs 42,00,000 | ||||
| Less: Debtors > 90 days | (Rs 8,00,000) | ||||
| Less: Related party debtors | (Rs 3,50,000) | ||||
| Eligible Debtors | Rs 30,50,000 | ||||
| D. DRAWING POWER | |||||
| DP from Stock (Rs 54.5L × 75%) | Rs 40,87,500 | ||||
| DP from Debtors (Rs 30.5L × 60%) | Rs 18,30,000 | ||||
| Total Drawing Power | Rs 59,17,500 | ||||
| CC Limit Sanctioned | Rs 80,00,000 | ||||
| Max Drawable (lower of DP and Limit) | Rs 59,17,500 | ||||
| CC Outstanding as on date | Rs 55,00,000 | ||||
| Available Headroom | Rs 4,17,500 |
Key Observation: Although the CC limit is Rs 80 lakh, the actual drawable amount is only Rs 59.17 lakh - because the DP is lower than the limit. If the borrower draws Rs 80 lakh (up to the sanctioned limit), the account would be "out of order" by Rs 20.82 lakh. This is why accurate stock statement preparation matters - it tells the borrower how much they can actually use, not just what the sanction letter says.
Common Mistakes MSME Borrowers Make in Stock Statements
Mistake 1: Using estimated figures instead of actual stock data. Many MSME accountants prepare the stock statement from memory or rough estimates - not from the stock register, ERP, or physical count. This creates a persistent gap between reported and actual stock that compounds every month. Always base the statement on the stock register closing balance as of the statement date.
Mistake 2: Not deducting creditors for purchases (unpaid stock). Banks compute DP on "paid stock" - stock for which the supplier has been paid. If you report total stock without deducting outstanding creditors, you are inflating the DP base. Always deduct accounts payable for stock purchases from the total stock to arrive at paid stock.
Mistake 3: Including ineligible stock - obsolete, expired, overage. Stock older than the bank's ageing limit (typically 90-180 days), obsolete stock, expired raw materials, and rejected/returned goods must be excluded from the statement. Including them inflates DP and creates a discrepancy that the stock audit will catch. Review your ageing report before preparing the statement.
Mistake 4: Not reconciling stock statement with GST returns. The purchase and sales figures in the stock statement should be reconcilable with GSTR-3B (purchases and sales for the period). Major discrepancies - stock statement shows Rs 45 lakh purchases but GSTR-3B shows Rs 35 lakh - trigger both bank and GST scrutiny. Employers filing GST return filing must ensure that stock movements (purchases, sales, returns) match between the stock statement, stock register, and GST returns - this three-way reconciliation is the gold standard for accuracy.
Mistake 5: Submitting late or in the wrong format. Late submission means the bank cannot update DP - and if the CC outstanding exceeds the last-computed DP, the account may be flagged as irregular. Using a generic format when the bank has prescribed its own Excel template leads to rejection and resubmission delays. Always check the sanction letter for the format and deadline.
Consequences of Incorrect or Late Stock Statements
| Issue | Bank Action | Borrower Impact |
|---|---|---|
| Late submission (beyond deadline) | DP frozen at last statement value; penal interest may be charged | Credit availability not updated; may restrict operations if DP falls |
| Stock statement inflation discovered during stock audit | DP recalculated on actual stock; excess drawing notice issued | Must repay excess within 30-90 days or face NPA classification |
| Persistent non-submission (3+ months) | Account classified as irregular; bank may freeze CC operations | No access to working capital; bank may initiate recovery proceedings |
| Fraudulent stock statement (deliberate inflation) | Reported to RBI as fraud; criminal complaint under Section 406/409 IPC | Prosecution of borrower and authorised signatories; asset seizure under SARFAESI |
| Format non-compliance (wrong template) | Statement rejected; borrower asked to resubmit | Effective late submission; DP not updated until correct format submitted |
How the Bank Uses the Stock Statement
When the bank receives the stock statement, the credit department performs the following checks before updating the drawing power.
- Arithmetic verification - do the opening stock, additions, consumption, and closing stock figures balance mathematically?
- Trend analysis - are the figures consistent with the previous month's statement and the borrower's business pattern? A sudden 40% increase in closing stock without corresponding purchase invoices is flagged.
- Creditor deduction - is creditors for purchases correctly deducted to compute paid stock?
- Ageing compliance - has the borrower excluded stock older than the prescribed ageing limit?
- Insurance validity - is the insurance policy current, and does the sum insured cover the stock value?
- Debtor ageing - has the borrower excluded debtors older than the prescribed limit and related-party debtors?
- Cross-verification (for larger accounts) - does the stock statement match the purchase/sales trends in the borrower's bank account transactions?
How Stock Statements Connect with Other Compliance Areas
Stock statements connect directly with statutory audit (closing stock verification for financial statements), GST compliance (purchase/sales reconciliation), income tax (closing stock valuation affects taxable income), and the periodic stock audit that the bank commissions to verify the statements.
For MSMEs, the stock statement is also an internal management tool. The discipline of preparing an accurate monthly stock statement - even if the bank requires it only quarterly - forces the business to maintain up-to-date stock records, identify slow-moving inventory early, and monitor the relationship between purchases, production, sales, and closing stock. Businesses that treat the stock statement as "just a bank form" miss this management value.
The stock statement, when accurate, also becomes the foundation for the year-end closing stock figure in the financial statements. If the monthly/quarterly statements have been prepared accurately throughout the year, the year-end stock figure is already verified - reducing the time and effort needed for the statutory audit.
Bank-Specific Stock Statement Formats: What Varies
| Feature | SBI Format | PNB Format | HDFC/ICICI Format | Generic Format |
|---|---|---|---|---|
| Format type | Excel with pre-defined tabs | Excel with proforma | PDF or Excel | Excel or manual |
| Stock categories | Raw material, WIP, FG, stores, spares - separate tabs | Single consolidated sheet with rows per category | Category-wise with sub-totals | Flexible - borrower defines categories |
| Debtor ageing required | Yes - 0-90, 90-180, 180-365, 365+ | Yes - 0-90, 90-180, 180+ | Yes - varies by bank | Recommended |
| Creditor deduction | Explicit row for creditors | Included in paid stock computation | Explicit section | May not be pre-formatted |
| Insurance declaration | Separate section with policy details | Combined with certification | Separate section | May not be pre-formatted |
| Projected vs actual | Some formats require projected and actual figures | Actual only | Varies | Actual only |
| Where to get format | Branch RM or SBI corporate website | Branch RM | Relationship Manager or online portal | Standard template from CA/auditor |
Tip: Always use the bank's own format if provided. If the bank does not have a prescribed format, use the standard ICAI Technical Guide format and confirm with your relationship manager before the first submission. Switching formats mid-year creates reconciliation problems.
Key Takeaways
The stock statement is not a formality - it is the document on which the bank computes drawing power. An inaccurate statement either inflates DP (creating hidden excess drawing) or understates DP (unnecessarily restricting credit). Both are problems. The statement must be prepared from actual stock records, not estimates.
MSME borrowers must deduct creditors for purchases from total stock to arrive at paid stock - this is the most commonly missed step. They must also exclude obsolete, expired, and overage stock. The DP is computed on paid, eligible stock - not total stock.
The stock statement should be reconcilable with three sources: the stock register (physical/ERP data), GST returns (purchases and sales for the period), and the bank account (purchase payments and sales receipts). A three-way reconciliation prevents discrepancies that trigger bank scrutiny.
Late submission freezes DP at the last-submitted value. If the CC outstanding exceeds the frozen DP for 90+ days, the account is classified as NPA under RBI norms. Timely submission - within the deadline specified in the sanction letter - is non-negotiable.
The stock statement is also a management tool. MSMEs that prepare it accurately every month (even if the bank requires it only quarterly) gain early visibility into slow-moving inventory, production efficiency, and cash conversion cycle - insights that improve business performance beyond banking compliance.
Need Help with Stock Statement Preparation or Stock Audit?
Preparing accurate stock statements, maintaining three-way reconciliation (stock register + GST returns + bank account), and ensuring drawing power stays healthy requires disciplined inventory management - something many MSMEs struggle with when handling it in-house.
Explore our stock audit services - CA-led physical verification, stock statement preparation assistance, drawing power computation, bank format compliance, GST reconciliation, and periodic on-site audits. Available across India with dedicated teams in Pune, Mumbai, Delhi, Bengaluru, and Chennai.
For queries, reach out at +91 945 945 6700 or WhatsApp us directly.
