: Lists outstanding book debts, often categorized by age (e.g., those more than 6 months old). Usage & Review
Form NF 902 is the standardized stock and receivables statement format prescribed by Canara Bank. It acts as a financial health monitor for the bank to assess the value of the primary security hypothecated against a working capital loan. Why Banks Require Form NF 902
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.
Plus :
Manually filling out a paper-based NF 902 form is time-consuming and prone to mathematical errors. Utilizing an Excel template provides distinct operational advantages:
: It helps track unpaid stocks and aging debtors.
When downloading and using the Excel template, ensure the following columns are accurately filled: canara bank stock statement form nf 902 excel format
: The stock and debtor values in Form NF 902 must match your monthly trial balance and inventory ledgers perfectly.
Create an "Age in Days" column. Use a formula if you have receipt dates: =IF(TODAY() - Receipt_Date > 90, "Slow/Non-moving", "Fast Moving") Most banks will exclude or heavily discount stock older than 90–180 days from drawing power.
: Use =SUM(Cell1:Cell2) to aggregate stock values and creditors. : Lists outstanding book debts, often categorized by age (e
: Ready-to-print formats look clean and simplify verification for credit managers.
Captures actual vs. estimated figures for the current year to help the bank assess your business health. Drawing Limit Analysis:
