In the realm of business banking and working capital management, the Stock Statement is a critical document. For borrowers dealing with Canara Bank, this document is officially known as Form NF 902.
While the bank provides a standard physical form, maintaining it in an Excel format is the industry standard for efficiency, accuracy, and easy digital submission. Below is a deep dive into what this form entails, why the Excel format is superior, and a structural breakdown of how to create one.
Ready-to-use template:
📥 [Click here to download NF 902 Excel Format] (Insert your actual download link)
Alternate source:
Visit your nearest Canara Bank branch or ask your Relationship Manager for the official Excel reference format. canara bank stock statement form nf 902 excel format
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 are the typical columns in NF 902 stock statement:
| Item No. | Description of Goods | Quantity | Unit | Purchase Price (Rs.) | Market Price (Rs.) | Total Value (Rs.) | Margin % | Eligible Stock Value (Rs.) | |----------|----------------------|----------|------|----------------------|--------------------|-------------------|-----------|----------------------------| In the realm of business banking and working
Plus header details:
To create it yourself: Open Excel, add these columns, save as .xlsx or .xls.
| Feature | Benefit | |--------|---------| | Auto Calculations | Total, closing stock, and shortage automatically computed | | Error Reduction | No manual addition mistakes | | Professional Look | Neat, printable, and bank-ready | | Easy Modification | Add rows for multiple product categories | | Digital Submission | Email directly to branch manager/relationship manager | Ready-to-use template: 📥 [Click here to download NF
A: No. Traders, distributors, and even service providers holding consumable inventory for working capital loans from Canara Bank must file Form NF 902.
Even a well-formatted Excel stock statement can be rejected if you make these errors:
Canara Bank
Form NF 902
Stock Statement as on [DD/MM/YYYY]
Party Name: ___________________
Account No.: ___________________
Limit Sanctioned: _______________