Visit your home branch and ask the relationship manager or loan officer for the latest Excel template of NF 902. Many branches maintain a soft copy on their internal system and can email it to you.
Here’s a simplified visual of how the Excel should look:
CANARA BANK – FORM NF 902 Stock Statement for the month ending: 30/04/2025 Borrower: ABC Traders | A/C No: 1234567890S.No | Item | Unit | Open | Purchase | Sale | Close | Rate | Close Value | Pledged 1 | Steel Coils | Kgs | 500 | 300 | 400 | 400 | 150 | 60,000 | 60,000 2 | Cement bags | Nos | 200 | 100 | 50 | 250 | 400 | 1,00,000 | 1,00,000 | Total | | | | | | | 1,60,000| 1,60,000
Drawing Power @ 75% = ₹1,20,000
Always submit your stock statement within the stipulated time (usually within 10-15 days of the month-end). Delayed submissions can lead to a reduction in your Drawing Power or penalties from the bank.
Disclaimer: This post is for informational purposes only. While we strive to provide accurate templates, banking forms may be updated by the bank from time to time. Always cross-verify with the official Canara Bank website or your branch relationship manager.
The Canara Bank Stock Statement Form NF 902 is a vital monthly reporting document for businesses with Cash Credit (CC) or Overdraft (OD) accounts. While it primarily captures inventory data to determine a company's "Drawing Power," its history is rooted in the bank's century-old mission of financial transparency. Download Form NF 902 (Excel & PDF)
You can find and fill the form through the following sources:
Excel Format: Search for "Canara Bank Stock Statement Form NF 902 Excel" on Google Drive where user-uploaded templates are often stored. canara bank stock statement form nf 902 excel format
Official Website: Navigate to the Downloads section of the Canara Bank official site; it is listed as "NF 902 - Stock Statement".
Online Fillable Templates: Platforms like DocHub and signNow provide interactive versions for digital signing. The "Interesting Story": A Century of Growth
The NF 902 form isn't just paperwork; it’s a tool that evolved alongside one of India's oldest financial institutions.
Founding Roots: Founded in 1906 as the Canara Hindu Permanent Fund by Ammembal Subba Rao Pai, the bank was built on the principle of social responsibility.
The Drawing Power Game: Borrowers often find the NF 902 "interesting" because it determines how much of their sanctioned loan they can actually use that month. If your stock is low, your "Drawing Power" drops, even if the bank has approved a higher limit.
Operational Milestones: The bank transitioned from a local fund to a global entity, becoming the first Indian bank to receive ISO certification for "Total Branch Banking" in 1996.
Modern Era: In 2020, Canara Bank merged with Syndicate Bank, making it the fourth largest public sector bank in India and centralizing thousands of these stock statements into a massive digital database. Core Components of NF 902 A standard submission must include: Canara Bank Stock Statement NF-902 Form | PDF - Scribd
The Canara Bank Form NF 902 is a mandatory monthly stock statement required from borrowers who maintain an Open Cash Credit (OCC) account. While the official form is often distributed in PDF format, many businesses prefer an Excel format to automate calculations for Drawing Power (DP), which determines the actual amount they can withdraw from their sanctioned credit limit. Understanding Form NF 902
The NF 902, officially titled the OCC Stock Statement cum MSOD (Monthly Statement of Operations and Data), serves as a report on the quantity and value of inventory held by a business. This statement is used by the bank to: Visit your home branch and ask the relationship
Calculate Drawing Power (DP): Banks typically offer credit after deducting a "margin" (e.g., 25%) from the total stock value.
Assess Financial Health: Monitoring inventory levels helps the bank evaluate the operational stability of the borrowing entity.
Ensure Compliance: It verifies that the goods serving as collateral are adequately insured and held in approved locations. Key Components of the Stock Statement
A complete NF 902 statement generally includes two main sections: Part A: Detailed Stock Position:
Commodity Description: Clear identification of items (raw materials, work-in-progress, finished goods).
Quantity Tracking: Opening stock, items received, items sold/dispatched, and final closing stock units.
Valuation: Unit rate and total value of each item as of the statement date.
Storage Location: Details of the godown or warehouse where the goods are stored. Part B: Declarations and Financial Data:
Production & Sales Statement: Summary of monthly production and sales figures. Always submit your stock statement within the stipulated
Insurance Details: Confirmation that the stock is insured against risks like fire and theft.
Aging Report: Specific reporting for goods older than six months or those nearing expiration (especially for pharmaceuticals/chemicals). How to Prepare Form NF 902 in Excel
To create an efficient Excel template for your monthly submissions, follow these structural steps: Stock Statements to Bank - Dhruva Industrial Consultants
I’m unable to generate or provide an actual Excel file (.xlsx or .xls) directly. However, I can give you the exact column structure of Canara Bank Form NF 902 (Stock Statement format) so you can easily recreate it in Excel yourself.
1 | Steel Rods | MT | 10 | 50,000 | 5,00,000 | Own | Warehouse A | -
2 | Cement Bags | Bags| 500 | 400 | 2,00,000 | Consignment| Site B | New stock
Various financial portals, CA websites, and forums provide editable NF 902 templates. Ensure the layout matches the bank’s current guidelines. Check for the following:
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.
In simple terms, this form is your declaration to the bank about:
The bank uses this statement to monitor the primary security of your loan. Submitting Form NF 902 periodically (usually monthly or quarterly) is a covenant in your loan agreement.
Add:
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.
The Logic in Excel: