Canara Bank Stock Statement Form Nf 902 Excel Format !!install!! May 2026

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:

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.

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

The Canara Bank Form NF 902 is the standard "OCC Stock Statement cum MSOD" used by borrowers with Cash Credit facilities to report monthly inventory and sales. While the official form is often distributed as a PDF, it is frequently converted into Excel format to automate the calculation of Drawing Power (DP). Standard Report Structure (NF 902)

A complete stock statement report typically includes the following sections:

Header Details: Company name, account number, and the statement date (as of the last day of the month). Part A: Inventory Details:

Categories: Raw materials (imported/indigenous), stock-in-process, and finished goods. canara bank stock statement form nf 902 excel format

Data Points: Description of commodity, quantity, unit rate, and total value.

Exclusions: Items to exclude from drawing power, such as slow-moving stock (older than 6 months), obsolete items, or stocks purchased on credit.

Part B: Production & Sales: Monthly breakdown of opening stock, stock "in," stock "out," and final closing stock.

Part C: Receivables & Creditors: Age-wise breakup of book debts (within/beyond 90 days) and sundry creditors.

Drawing Power (DP) Calculation: Total value of eligible stock minus the prescribed margin (e.g., 25%) to determine the net drawing limit. Downloading & Preparation

You can obtain the form or digital versions through these platforms:

Official Sources: Check the Downloads section on the Canara Bank Official Website for the most recent official NF 902 PDF. Editable Formats:

Scribd provides user-uploaded Excel (.xlsx) templates that include pre-built calculation formulas.

Platforms like US Legal Forms and DocHub offer fillable PDF versions that can be edited online or converted.

Software Export: If you use accounting software like Tally, you can often generate a stock statement and export it directly to Excel using the Alt+P or Export function. Compliance Note Canara Bank Stock Statement NF-902 Form | PDF - 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:

Visit the Canara Bank website at www.canarabank.com.
Click on the "Downloads" tab.
Select "Forms" from the dropdown menu.
Scroll down to the "Depository Services" section.
Click on "Stock Statement Form (NF 902)".
The form will be downloaded in PDF format. You can convert it to Excel format using online tools or software.

How to Fill and Use Canara Bank Stock Statement Form NF 902 in Excel Format? The Canara Bank Form NF 902 is a

Once you have downloaded the form, you can fill it out in Excel format. Here's a step-by-step guide:

Open the downloaded form in Excel.
Fill in the required details, such as:
- Account holder's name and address.
- Account number.
- Date of request.
- Type of statement required (e.g., holding statement or transaction statement).
Specify the depository participant (DP) name and ID.
Provide the ISIN number or scrip name and quantity held.
Sign and date the form.

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:

Online: Upload the filled form on the Canara Bank website or the depository participant's website.
Offline: Send the filled form to the bank or depository participant's office by post or in person.

If you have any questions or need assistance, you can contact Canara Bank's customer support:

Phone: 1800 425 0018 (toll-free).
Email: customer.support@canarabank.com.

Conclusion

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 Visit the Canara Bank website at www

Option 1: How to Get the Official Form

Visit the official Canara Bank website → "Downloads" → "Forms" → Look for Stock Statement (Form NF 902)
Contact your branch manager – they can provide the Excel template
Check your loan documents – sometimes included with working capital/cash credit accounts

Method 3: Third-Party Reliable Sources (Use with Caution)

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:

The template should have no external links or macros (to avoid security flags).
Columns should match the bank’s audit requirements.
It should contain the mandatory certifications.

3. Anatomy of the Stock Statement (Excel Structure)

If you are creating or downloading an Excel template for NF 902, it must contain three distinct sections to be compliant with Canara Bank standards.

If you need the actual Excel template

Contact your Canara Bank branch credit officer or relationship manager — they provide the official Form NF 902 Excel template and any branch-specific instructions.

If you want, I can:

Draft a sample NF 902-style Excel layout (column names and formulas) you can paste into Excel, or
Provide a short template CSV you can download and open in Excel. Which would you prefer?

The Canara Bank Form NF 902, also known as the OCC Stock Statement Cum MSOD, is a mandatory monthly or quarterly document for borrowers holding an Open Cash Credit (OCC) account. It details the borrower's inventory and sales to help the bank calculate the current Drawing Limit based on the value of hypothecated goods. Key Sections of Form NF 902

The form is typically divided into two main parts to capture both inventory value and operational performance: Part A: Stock Statement (Inventory Details)

Commodity List: Includes columns for commodity description, opening stock, units added ("in"), units removed ("out"), and final closing stock.

Valuation: Requires the weight/quantity, rate per unit, and total value (usually calculated at market rate or cost price, whichever is lower).

Godown Details: Borrowers must specify the location/address where the stock is stored. Part B: Production and Sales Statement

Operational Figures: Requires data on gross/net sales and actual production during the period compared to estimates.

Receivables & Creditors: Includes an age analysis of book debts (receivables) and details of sundry creditors for purchases. Calculations & Declarations

Drawing Limit Calculation: A summary that subtracts margins (e.g., 20-25%) and excluded categories (like stocks purchased on credit) from the total value to determine the bank's maximum allowable credit.

Declaration: A signed statement confirming the goods are the borrower's property, are fully insured, and are held in trust for the bank. How to Prepare the Statement in Excel

While the official form is often provided as a PDF, many businesses use Excel for automated calculations. A standard Excel template should include the following headers:

Item Description: Raw materials, semi-finished, or finished goods.

Opening Balance: Stock quantity and value at the start of the month.

Receipts/Purchases: Quantity and value added during the month. Sales/Issues: Quantity and value reduced during the month.

Closing Stock: Final figures used for the drawing power calculation.

Formula-based Margin: Automatically deduct the bank-mandated margin (e.g., Total Value * 0.75 for a 25% margin). Submission & Resources NF 902 Stock Statement | PDF | Money - Scribd