✅ 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 typical NF 902 statement is divided into two primary sections: Part A: Stock Statement
Usually submitted by the 7th or 10th of every month for the previous month's end.
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.
In simple terms, this form is your declaration to the bank about:
✅ 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 typical NF 902 statement is divided into two primary sections: Part A: Stock Statement canara bank stock statement form nf 902 excel format
Usually submitted by the 7th or 10th of every month for the previous month's end. ✅ Submit NF 902 every month within 7 days of month-end
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. ✅ Always keep a signed copy (physical or
In simple terms, this form is your declaration to the bank about:
Get the latest news, free activities, teacher tips, product info, and more delivered to your inbox.