The Stock Statement Form NF 902 is not a mere operational document; it is a under your loan agreement. Section 2(b) of the Securitisation and Reconstruction of Financial Assets and Enforcement of Security Interest (SARFAESI) Act, 2002, allows banks to enforce security based on information provided in such statements.
✅ Submit NF 902 every month within 7 days of month-end. ✅ Stock value should be , whichever is lower. ✅ Do not include obsolete / slow-moving stock in pledged stock. ✅ Always keep a signed copy (physical or digitally signed) for bank audit. ✅ If drawing power reduces due to stock shortage, repay excess immediately to avoid penal interest.
| A | B | C | D | E | F | G | |---|---|---|---|---|---|---| | | Particulars / Item Name | Unit | Opening Stock (Qty) | Purchases (Qty) | Sales (Qty) | Closing Stock (Qty) |
: Regular submission (usually monthly) is mandatory to ensure the loan is backed by physical assets. Financial Transparency canara bank stock statement form nf 902 excel format
: Listing of outstanding book debts, categorized by age (usually under 90 days and over 90 days).
: Deducts margins (often 25%) and excluded categories (like credit-purchased stocks) to determine the available limit. Part B: Production and Sales Statement
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. The Stock Statement Form NF 902 is not
This article provides a detailed guide on the NF 902 form, how to prepare it in Excel, and how to ensure it meets the bank's strict requirements.
Canara Bank does not always keep a centrally updated "NF 902.xlsx" file on its public website. However, you can obtain the genuine format through these reliable channels:
: Ready-to-print formats look clean and simplify verification for credit managers. ✅ Stock value should be , whichever is lower
: Unit rate and total value (typically calculated at market rate, landed cost, or invoice price).
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.
: Borrowers must specify the location/address where the stock is stored. Part B: Production and Sales Statement