Canara Bank Stock Statement Form Nf 902 Excel Format May 2026

The morning sun cut through the dusty blinds of Arjun’s small office in Bengaluru. On his desk sat a mountain of paperwork and a cooling cup of filter coffee. Arjun was the proprietor of "Evergreen Textiles," a thriving small business that had recently secured a working capital limit from Canara Bank.

The form is typically divided into sections to provide a comprehensive view of business assets: canara bank stock statement form nf 902 excel format

Row 1-5: Bold header with branch address, loan a/c number, and statement period. Row 7: Column headers – Sl No, Item Description, HSN Code, UOM, Qty, Rate, Value, Stock Type, Aging (Days), Remarks. Rows 8-25: Inventory data with alternating row colors for readability. Row 26: TOTAL : =SUM(Value_Range). Row 28: Less: Obsolete/Stock > 90 days : manually entered or extracted via SUMIF. Row 29: Eligible Stock Value : formula. Row 30: Margin @ 25% : =Eligible*0.25. Row 31: Drawing Power : =Eligible - Margin. Row 33-40: Declarations – "We hereby certify that the stock is insured...", signature line, date, place. Row 41: Prepared by and Checked by with date stamps. The morning sun cut through the dusty blinds

Step 7: Print or Export as PDF for Physical Submission

Even if you maintain Excel, many branches still require a signed hard copy. From Excel, go to File > Export > Create PDF/XPS to generate a professional-looking statement. As specified in your loan agreement (commonly monthly

Section C: Drawing Power Calculation

This is the mathematical logic the bank uses. Your Excel sheet should have formulas to populate this automatically based on the data in Section B.

When to submit

• As specified in your loan agreement (commonly monthly or quarterly)
• On demand by bank during credit reviews or inspections
• Alongside statutory audit/stock verification reports if required