Canara Bank Stock Statement Form Nf 902 Excel Format May 2026

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

: 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

The Canara Bank Stock Statement Form NF 902 is a mandatory monthly reporting document for businesses utilizing Cash Credit (CC) or Overdraft (OD) facilities. Banks require this form to verify the value of the inventory (hypothecated stock) and determine your Drawing Power (DP)—the actual amount you can withdraw from your sanctioned credit limit at any given time. Key Components of Form NF 902

While often downloaded as a PDF, most businesses convert the structure into an Excel format to automate calculations. A standard NF 902 contains:

Header Details: Name of the unit, account number, and the specific date (e.g., "Stock as on 31/03/2024"). canara bank stock statement form nf 902 excel format

Part A: Inventory Statement: Detailed breakdown of Raw Materials, Work-in-Progress (WIP), and Finished Goods.

Excel Tip: Include columns for Opening Stock + Purchases - Sales = Closing Stock to ensure data consistency.

Part B: Production and Sales: A summary of the month's total production figures and gross sales compared to projected targets.

Excluded Categories: Stocks that cannot be used to calculate DP, such as obsolete items, goods older than six months, or items purchased on credit (Sundry Creditors).

Drawing Power Calculation: The final section where the bank's margin (typically 25%) is deducted from the net stock value to arrive at the DP. How to Prepare the Statement in Excel

Download the Template: You can find sample versions on platforms like Scribd or the Canara Bank Official Site under the "Downloads" or "Forms" section.

Input Physical Stock: Enter quantities and values for each item. Ensure the valuation is based on "Cost or Market Price, whichever is lower".

Deduct Creditors: In Excel, subtract the value of unpaid stocks (Sundry Creditors) from your total stock value. Banks only provide finance on "paid-for" inventory.

Apply Margin: Use a formula to deduct the bank's margin (e.g., Total Net Stock * 0.75) to find your permissible drawing limit.

Certification: The statement must include a declaration that the stocks are the absolute property of the borrower and are fully insured. Important Deadlines and Compliance

Frequency: Usually submitted by the 7th or 10th of every month for the previous month's end.

Insurance: Ensure your stock insurance policy is current and the "Bank Clause" is noted in the policy documents.

Consequences: Delayed submission can lead to "penal interest" or the account being flagged as "irregular," which might freeze your ability to withdraw funds. Canara Bank OCC Stock Statement NF 902 | PDF - Scribd

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. Canara Bank NF 902 form is the standard

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 %).

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

You can copy and paste this directly onto your website, blog, LinkedIn, or share it with clients.

Title: Canara Bank Stock Statement Form NF 902: Download & Excel Format Guide

Meta Description: Need the Canara Bank Stock Statement Form NF 902 in Excel format? Learn how to download, fill, and use the official stock audit format for CC/OD limits. Title: Canara Bank Stock Statement Form NF 902:

Key sections and fields (typical Excel layout)

Key Points to Remember

✅ Submit NF 902 every month within 7 days of month-end.
✅ Stock value should be at cost or market value, whichever is lower.
✅ Do not include obsolete / slow-moving stock in pledged stock.
✅ Always keep a signed copy (physical or digitally signed) for bank audit.
✅ If drawing power reduces due to stock shortage, repay excess immediately to avoid penal interest.

Main Table Columns (create these as headers in Row 1)

| Sl. No. | Description of Goods | Unit | Quantity | Rate per Unit (₹) | Value (₹) | Particulars of Stock (Own/Consignment/Joint) | Location / Godown | Remarks | |---------|----------------------|------|----------|-------------------|-----------|-----------------------------------------------|-------------------|---------|

Excel Formulas to add

If you need a ready-to-download Excel template, search online for:
"Canara Bank NF 902 format excel"
or ask your branch for the official blank format — many bank branches provide the .xlsx file on request.

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:

  1. Visit the Canara Bank website at www.canarabank.com.
  2. Click on the "Downloads" tab.
  3. Select "Forms" from the dropdown menu.
  4. Scroll down to the "Depository Services" section.
  5. Click on "Stock Statement Form (NF 902)".
  6. 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?

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

  1. Open the downloaded form in Excel.
  2. 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).
  3. Specify the depository participant (DP) name and ID.
  4. Provide the ISIN number or scrip name and quantity held.
  5. 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:

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

Conclusion

Common weaknesses / pitfalls

Why is the Excel Format Preferred Over Paper or PDF?

While Canara Bank may accept handwritten forms or printed PDFs in some branches, the Excel format has become the gold standard for several compelling reasons:

  1. Automatic Calculations: Excel can auto-calculate totals, drawing power, and stock aging using formulas. This reduces human arithmetic errors that are common in manual statements.
  2. Easy Data Validation: You can set dropdowns for stock types (e.g., "Raw Material," "Finished Goods") and use conditional formatting to highlight slow-moving stock.
  3. Audit Trail: Excel preserves formula history and allows you to track changes. If the bank questions a number, you can show exactly how it was derived (e.g., =Quantity * Cost Per Unit).
  4. Electronic Submission: Many branches now accept stock statements via email. Attaching an Excel file (or a printout derived from it) is faster than filling a paper form by hand.
  5. Reusability: Once you create a master Excel template in the NF 902 structure, you can reuse it month after month by just updating quantities and rates.

Q3: What is the penalty for late submission of NF 902?

A: Late submission often triggers an increase in interest rate (e.g., +2% p.a.) or a flat penalty per day of delay. In some cases, the bank may freeze the drawing power until compliance.