Canara Bank Stock Statement Form Nf 902 Excel Format Now

In this detailed guide, we will cover everything you need to know about the , with a special focus on the Excel format —how to download it, fill it correctly, automate calculations, and avoid common mistakes that lead to penalties or loan rejection. What is Canara Bank Form NF 902? Form NF 902 is the standardized Stock Statement prescribed by Canara Bank (a leading public sector bank in India) for borrowers availing Cash Credit (CC) or Overdraft (OD) limits against the pledge or hypothecation of stock.

Managing inventory financing can be complex, but it doesn't have to be a nightmare. For businesses that rely on Canara Bank for stock or inventory loans (often against the security of raw materials, finished goods, or consumable stores), the Form NF 902 is a critical document. Submitting an accurate, timely, and compliant stock statement is not just a formality—it is the key to unlocking working capital, renewing credit limits, and maintaining a healthy banking relationship. canara bank stock statement form nf 902 excel format

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. Frequently Asked Questions (FAQ) Q1: Is NF 902 applicable only for manufacturing units? A: No. Traders, distributors, and even service providers holding consumable inventory for working capital loans from Canara Bank must file Form NF 902. Q2: Can I submit a scanned image of a handwritten stock statement? A: Technically yes, but many branches now require typed statements (preferably Excel-printed or directly emailed Excel) for clarity and audit trail. Q3: What is the penalty for late submission of NF 902? A: Late submission often triggers an increase in interest rate (e.g., +2% p.a.) or a flat penalty per day of delay. In some cases, the bank may freeze the drawing power until compliance. Q4: Can I use Google Sheets instead of Excel? A: Only if you export to .xlsx format or print it. However, Google Sheets formulas work similarly, but ensure you are not sharing the sheet with an unsecured link. Q5: How often should I submit Form NF 902? A: Typically monthly. Check your loan sanction letter. For large limits (> ₹5 crore), weekly or fortnightly statements may be required. Conclusion – Master NF 902, Master Your Working Capital The Canara Bank Stock Statement Form NF 902 in Excel format is more than a compliance document – it is a tool for financial discipline. By creating a robust, formula-driven Excel template, you not only please your bank manager but also gain real-time insight into your inventory turnover, slow-moving stock, and actual drawing power. In this detailed guide, we will cover everything