Imagine opening an Excel file named Canara_Bank_NF902_Mar2025.xlsx . It looks like this:
The most practical method to manage this process is by creating or obtaining a dynamic, self-calculating .
In this section, = Opening Balance + Stock "In" – Stock "Out".
: The stock value reported must be fully covered by an active bank-hypothecated insurance policy. Ensure your policy expiry date and covered value are noted on the form. canara bank stock statement form nf 902 excel format
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.
Receipts/purchases brought into the facility during the month. Consumption/dispatches moving out of the facility. Closing volumetric stock and individual item unit rates. Part B: The Production and Sales Review
Form NF 902 is the official stock statement template used by Canara Bank. Borrowers use it to declare the value of their inventory (raw materials, work-in-progress, finished goods) and book debts (debtors) to the bank. Why Banks Require Form NF 902 : The stock value reported must be fully
Contact your Canara Bank branch credit officer or relationship manager — they provide the official Form NF 902 Excel template and any branch-specific instructions.
This is the core of the statement. You must break down your inventory by category and valuation:
The is a mandatory monthly declaration for businesses holding Cash Credit (CC) or Overdraft (OD) facilities. It provides a snapshot of current inventory and receivables, which the bank uses to calculate your Drawing Power (DP) —the actual amount you can withdraw from your sanctioned loan limit. 📂 Key Components of NF 902 Your Excel sheet should have formulas to populate
I can provide the exact layout or formula configurations based on your loan terms.
This header section establishes the identity of the account. It includes: Name of the borrowing unit Cash Credit / Overdraft account number Statement date (usually the last working day of the month) Sanctioned limit amount 2. Stock and Inventory Details
The NF 902 is divided into two primary sections to provide a complete view of business operations: