If you're a business owner with a working capital loan from Canara Bank, you're likely familiar with the monthly hustle of submitting stock statements. The
form is more than just paperwork; it’s the key to maintaining your liquidity. US Legal Forms What exactly is the NF 902? The NF 902 is an OCC Stock Statement cum MSOD
(Monthly Stock & Operational Data). It provides the bank with a snapshot of your inventory, including: Raw Materials: Both imported and indigenous. Stock-in-Process: Valuation based on the cost of production. Finished Goods: Valued at cost or market price, whichever is lower. Consumable Spares: Essential operational items. Why Use an Excel Format?
While the bank often provides PDF templates, many businesses prefer Excel formats for several reasons: Auto-Calculations:
Excel can automatically subtract "Excluded Categories" (like stocks purchased on credit) and apply bank margins to calculate your Net Drawing Limit instantly. Reduces manual entry errors in high-volume inventory lists. Historical Tracking:
Easily compare month-on-month production and sales figures in one workbook. Key Sections to Watch Out For Part A: Stock Statement:
Focuses on current stock value (usually in Lakhs) minus items like slow-moving stock or goods in transit. Part B: Production & Sales:
Captures actual vs. estimated figures for the current year to help the bank assess your business health. Drawing Limit Analysis:
The critical calculation where the bank's margin (e.g., 25%) is applied to the net value of your hypothecated stock. How to Get Started You can typically download the NF 902 form from the official Canara Bank website
under the "Downloads" section. Many third-party financial platforms also offer fillable Excel templates that mirror the official structure for easier digital submission. step-by-step guide
on setting up the auto-calculation formulas in Excel for this specific form?
AI responses may include mistakes. For financial advice, consult a professional. Learn more NF 902 Stock Statement | PDF | Money - Scribd
Canara Bank Stock Statement Form NF 902: A Guide to Downloading and Using in Excel Format
Canara Bank, one of the leading public sector banks in India, provides its customers with a stock statement form, commonly known as NF 902. This form is used to request a statement of shares or securities held in a demat account. In this post, we will guide you on how to download the Canara Bank stock statement form NF 902 in Excel format and provide some useful information on how to use it.
What is Canara Bank Stock Statement Form NF 902?
The Canara Bank stock statement form NF 902 is a standardized form used to request a statement of shares or securities held in a demat account. The form is used by investors to obtain a consolidated statement of their holdings in various scrips.
How to Download Canara Bank Stock Statement Form NF 902 in Excel Format?
You can download the Canara Bank stock statement form NF 902 in Excel format from the bank's official website. Here are the steps: canara bank stock statement form nf 902 excel format
How to Fill and Use Canara Bank Stock Statement Form NF 902 in Excel Format?
Once you have downloaded the form, you can fill it out in Excel format. Here's a step-by-step guide:
Submission and Contact Information
After filling out the form, you need to submit it to the bank or depository participant. You can submit the form:
If you have any questions or need assistance, you can contact Canara Bank's customer support:
Conclusion
The Canara Bank NF 902 form is a standard "OCC Stock Statement cum MSOD" (Monthly Selection of Operational Data) required by the bank to assess the creditworthiness of a business and determine its monthly drawing limits. Essential Components of Form NF 902
To develop an accurate Excel-based stock statement, ensure your file includes the following sections based on the official NF 902 structure:
Header Information: Business name, address, and the specific date (e.g., "Statement as of October 31, 2023"). Stock Inventory Table: Commodity Description: Specific item names.
Quantity Tracking: Columns for Opening Stock, Stock "In" (purchases), Stock "Out" (sales), and Final Closing Stock.
Valuation: Unit rate and total value (typically calculated at market rate, landed cost, or invoice price).
Classification of Assets: Breakdown of Raw Materials, Stock-in-Process, Finished Goods, and Consumable Spares.
Excluded Category Section: Values to be deducted for calculating drawing limits, such as: Stocks purchased on credit (Trade Creditors). Slow-moving or obsolete stocks. Goods in transit or held in outstation godowns.
Declaration: A legal statement confirming the goods are the absolute property of the borrower, are fully insured, and have no prior charges. Steps to Create an Excel Stock Statement
Download a Reference: While the Canara Bank Download Center primarily provides PDF/HTML formats, you can find editable templates on platforms like Scribd or US Legal Forms.
Automate Calculations: In your Excel sheet, use formulas to automatically calculate: Final Stock = Opening Stock + Stock In - Stock Out. Total Value = Final Stock * Unit Rate.
Net Drawing Power = (Total Value - Exclusions) * (1 - Bank Margin %). If you're a business owner with a working
Validate Data: Ensure the figures in your Excel sheet match your physical inventory count and align with your financial ledger for that month.
Submission: Print the finalized Excel sheet and sign it with an authorized stamp before submitting it to your respective branch. Why Banks Require NF 902
Regular submission of this form is crucial for maintaining your Cash Credit (CC) account. It provides the bank with financial transparency, ensures compliance with banking regulations, and allows for the periodic adjustment of your credit limits based on real-time inventory health.
Do you need a step-by-step Excel formula guide for calculating the Drawing Power within this form?
AI responses may include mistakes. For financial advice, consult a professional. Learn more Download Center - Canara Bank
The Canara Bank Form NF 902 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
The form is typically divided into sections to provide a comprehensive view of business assets:
Part A: Stock Statement: Details quantities and market values of Raw Materials, Work-in-Process (WIP), and Finished Goods.
Part B: Production & Sales: Summarizes the month’s sales figures and production levels to verify business activity.
Calculation of Drawing Power: Subtracts "Excluded Categories" (like stocks purchased on credit or slow-moving items) and applies a bank-mandated margin (typically 25%) to the total value.
Borrower Declaration: A formal statement confirming the goods are the borrower's property, are fully insured, and are valued accurately. 📊 Excel Format Structure
While the bank often provides physical copies, many businesses use an Excel format for faster calculation. You can create or find templates that include these columns: Item Description: Name and grade of the commodity. Quantity: Number of units/weight in stock. Rate: Current market value or cost price per unit. Total Value: Auto-calculated (Quantity × Rate).
Location: The specific godown or warehouse address where items are stored. 📥 Where to Find & How to Submit
Canara Bank NF 902 form is the standard "OCC Stock Statement cum MSOD" (Monthly Selection of Operational Data) used by borrowers to declare inventory and calculate drawing limits for cash credit accounts. Where to Download
While the bank primarily provides this in PDF format, you can find editable versions through several channels: Official Website : Navigate to the section on the Canara Bank homepage to find NF 902 - Stock Statement Excel/XLS Formats : Third-party document repositories like often host community-uploaded versions for easier data entry. Online Editors : Platforms like
allow you to fill, sign, and export the form electronically. Core Components of Form NF 902
The form is divided into two primary sections to provide a complete financial snapshot of your inventory: Part A: Stock Statement & Drawing Limit Commodity Details Visit the Canara Bank website at www
: Table for raw materials, stock-in-process, and finished goods, including quantity, unit rate, and total value. Excluded Categories
: Section to deduct stocks purchased on credit, goods hypothecated to other banks, or slow-moving items from the total value. Drawing Limit Calculation
: Formula to apply the bank’s sanctioned margin (e.g., 25%) to the net stock value to arrive at the current drawing limit. Part B: Production and Sales Statement Monthly Performance
: Data on actual production and sales achieved during the month. Receivables & Creditors
: Details of outstanding book debts and sundry creditors to help the bank assess liquidity. Submission Requirements
: Typically submitted monthly (usually by the 7th or 10th of the following month) to keep the drawing limit active. Verification
: Must be signed by authorized personnel; for larger limits, a Chartered Accountant certificate may be required for book debt verification.
: The form requires confirmation that the declared stock is fully insured against fire and other risks. specific local Canara Bank branch contact to confirm their preferred submission method?
AI responses may include mistakes. For financial advice, consult a professional. Learn more
Canara Bank NF 902 Stock Statement Form | PDF | Money - Scribd
If you are a borrower with Canara Bank (earlier Syndicate Bank) availing a Cash Credit (CC) or Overdraft (OD) facility against inventory or stock, you are required to submit a monthly stock statement. The specific form used is Form NF 902.
Traditionally a physical form, most business owners and CAs now prefer the Excel format of NF 902 for easier calculation, auto-totaling, and digital submission.
In this post, we provide a complete guide to the Canara Bank Stock Statement Form NF 902, its components, and how to create/use it in Excel.
| Sl. No. | Description of Goods | Unit (Nos/Kgs/Ltrs) | Quantity | Rate per Unit (₹) | Total Value (₹) | Classification | Age of Stock (Days) | Remarks | |---------|----------------------|---------------------|----------|-------------------|-----------------|----------------|----------------------|---------| | 1 | Steel Coils | Kgs | 5000 | 80 | 400,000 | Raw Material | 45 | - | | 2 | Finished Pipe | Nos | 1200 | 250 | 300,000 | Finished Goods | 30 | - |
When downloading and using the Excel template, ensure the following columns are accurately filled:
| 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 |