Talk to an Expert
Talk to an Expert ✆ +91 945 945 6700
Stock Audit · 6 min read · Aug 19, 2026

Quarterly Inventory Statement for Banks: How MSME Borrowers Should Prepare It

CA Puja Pradhan

Quarterly Inventory Statement for Banks: How MSME Borrowers Should Prepare It - Featured Image
In this guide

    What a Quarterly Inventory Statement Has to Show

    A quarterly inventory statement has to show the stock and the book debts your business held as at the last day of the quarter, valued on the basis your sanction letter specifies, with the creditors for that stock disclosed alongside. Those four elements are what the lender arithmetic runs on. Valuation is where borrowers most often depart from what the bank expects: stock is generally to be stated at cost or net realisable value, whichever is lower, and never at the price you hope to sell it for. Book debts are usually to be reported with ageing, because receivables beyond a stated period are excluded. The statement matters because it feeds directly into drawing power, the ceiling on what you may actually draw against a sanctioned limit. A statement filed late, filed from an estimate, or filed on the wrong valuation basis moves that ceiling, and the account can be flagged before anybody has looked at the stock.

    Who Has to File One and How Often

    The obligation attaches to the facility rather than to the entity, so whether a business files depends on what it borrowed and on what the sanction says. Working capital limits secured against current assets almost always carry the condition, because the lender has no other way of knowing what the security is worth between verifications. Term loans secured on fixed assets generally do not, since the security does not fluctuate week to week. Monthly against quarterly submission is set by exposure and by how the account has behaved. Smaller facilities commonly file quarterly; larger ones and accounts under closer watch file monthly, and the difference is a credit judgement rather than a rule. Some sanctions require a monthly stock statement and a separate quarterly information return, which are different documents serving different purposes and are frequently confused with each other. What the sanction letter specifies is the answer in every case, and it specifies more than the frequency. It states the due date relative to the period end, the format, the valuation basis to be applied, and what has to accompany the figures, and each of those is a condition rather than a suggestion.

    How the Statement Is Built

    A statement is built from the closed books rather than assembled alongside them, and the sequence matters more than the format. Closing stock is stated by category and by location, because a single consolidated figure tells the lender nothing about where the security sits or what kind of goods it consists of. Raw material, work in progress and finished goods carry different realisation prospects, and stock at a third-party location carries a different risk from stock on the borrower's own premises. Creditors for unpaid stock are then deducted. Goods received but not yet paid for have been financed by the supplier, and including them would mean the bank lends against goods somebody else has already funded. The deduction covers creditors attributable to stock actually held, which is narrower than the trade payables total. Book debts and their ageing complete the statement where the limit extends to receivables. Ageing is not decoration: the sanction generally excludes receivables beyond a stated period from the eligible figure, so a statement giving a single debtors total cannot be used without further work and is usually returned for it.

    Where Statements Get Rejected

    Three failures account for most rejections and all three are avoidable. Valuation inconsistent with the books is the first. The sanction specifies a basis, generally cost or net realisable value whichever is lower, and a statement prepared at selling price, at standard cost without variance adjustment, or at a valuation the ledger does not support will not reconcile when anybody checks. The inconsistency is usually accidental and it looks deliberate. Stock that has not moved but is still carried at cost is the second. Where obsolescence has never been assessed, the statement includes goods that will not realise anything near the figure attached to them, and the lender's exposure is overstated by the whole of the difference. An ageing analysis with a provisioning policy applied consistently is what prevents it, and its absence is visible the moment an auditor runs the ageing that the borrower never did. Late submission is the third and it carries a consequence out of proportion to the delay. A statement filed after the due date leaves the lender computing drawing power on stale figures, and repeated lateness is treated as a covenant failure rather than an administrative slip.

    What the Bank Checks It Against

    A quarterly statement is never read alone. It is checked first against the last audited financial statements, because the closing stock and debtors in the audited accounts are the one figure in the sequence that carries an independent opinion, and a quarter-end position that cannot be traced back to it raises the question of which is wrong. Where the audited figure is materially below what the statements had been reporting through the year, the pattern rather than the single number becomes the finding. It is checked second against the previous quarter's statement, since the movement between two consecutive positions has to be consistent with the sales, purchases and collections reported for the intervening period. A stock figure that moves without a corresponding movement elsewhere is arithmetically difficult to sustain. Third, where a stock audit report exists for the period, the verified position is compared with what the borrower had reported for the same date. That comparison is the most direct test available, and a consistent gap between reported and verified positions across cycles is treated as a reporting problem rather than a valuation disagreement.

    Getting the Quarterly Cycle Right

    A repeatable month-end close is what makes the quarterly statement straightforward, and businesses that treat the statement as a separate exercise from the close find themselves preparing the same numbers twice on different bases. Close the books monthly, reconcile the stock ledger to the general ledger as part of that close, and the quarter-end statement becomes an extract rather than a compilation. Reconcile before submission rather than after. A statement filed and then corrected is worse than one filed slightly later, because the correction appears in the file as a revision and revisions attract attention that the original figure would not have. That means the ageing of book debts, the deduction of creditors for stock, and the exclusion of goods held for others are all settled before the statement goes rather than when the lender queries it. Independent verification protects the number where the facility is large, where the last audit found a variance, or where the statement will support a limit enhancement, since a position confirmed by a stock audit is one the borrower can defend rather than merely assert.

    Related reading

    Share this guide: Link copied!

    What is a stock statement for a bank loan?

    A periodic declaration by the borrower showing the value of stock (raw materials, WIP, finished goods, stores) and book debts (receivables) as of a specific date. The bank uses it to compute drawing power for the CC/OD facility.

    How often must the stock statement be submitted?

    Typically monthly for CC/OD limits above Rs 1 crore, and quarterly for smaller limits. The exact frequency is specified in the sanction letter. Always check your sanction terms.

    What is the format for a bank stock statement?

    Most banks provide their own format (Excel or PDF). SBI, PNB, BOB, and most nationalised banks have prescribed formats. Private banks (HDFC, ICICI, Axis) also provide templates through the relationship manager. If no format is provided, use the standard ICAI format.

    What is "paid stock" in a stock statement?

    Paid stock = total closing stock minus creditors for stock purchases (unpaid supplier invoices). Banks compute drawing power on paid stock, not total stock. This ensures the bank's charge is only on stock that the borrower has actually paid for.

    What happens if the stock statement is submitted late?

    The bank cannot update drawing power. If the CC outstanding exceeds the last-computed DP for 90 days, the account may be classified as NPA under RBI norms. Late submission may also attract penal interest as per the sanction terms.

    Can the bank reject a stock statement?

    Yes - if it is in the wrong format, mathematically inconsistent (closing stock does not balance), missing mandatory sections (insurance, certification), or shows unrealistic figures (sudden stock increase without corresponding purchases). The borrower must resubmit in the correct format.

    Stock statement bank ke liye kaise banayein?

    Sabse pehle statement date (month-end ya quarter-end) pe actual stock count karo ya ERP/Tally se stock summary nikalo. Raw material, WIP, finished goods, stores - sab alag alag category mein likho. Unpaid creditors minus karo (paid stock nikalne ke liye). Book debts mein debtor ageing likho - 90 din se purane debtors alag karo. Insurance details bharo. Certification sign karo. Bank ke prescribed format mein submit karo deadline se pehle.

    Drawing power kya hota hai stock statement mein?

    Drawing Power (DP) = eligible paid stock ka 75% (25% margin bank rakhta hai) + eligible debtors ka 60% (40% margin bank rakhta hai). Aapka CC outstanding DP se zyada nahi hona chahiye. Agar zyada ho gaya toh account "out of order" ban jaata hai - 90 din tak aise rahe toh NPA classify ho jaata hai.

    What stock is excluded from drawing power computation?

    Obsolete/expired stock, stock older than the bank's ageing limit (typically 90-180 days), uninsured stock, stock at locations not mentioned in the hypothecation agreement, disputed/rejected stock, and unpaid stock (creditors for purchases). Only paid, eligible stock qualifies for DP.

    Should I reconcile the stock statement with GST returns?

    Yes - strongly recommended. Purchase figures in the stock statement should match GSTR-3B purchases. Sales figures should match GSTR-1 sales. Discrepancies indicate either stock misreporting or GST non-compliance. Banks and GST officers can both scrutinise these discrepancies.