Canara Bank Stock Statement Form Nf 902 Excel Format -

The Canara Bank Stock Statement Form (also known as the "OCC Stock Statement cum MSOD") is available for download on the official Canara Bank website

under the "Downloads" section. While the bank primarily provides PDF versions, you can find editable formats on platforms like to export into Excel or Word. Key Components of Form NF 902 The statement generally consists of two parts: Part A: Stock Statement Commodity Details

: Item description, quantity (opening/closing), unit rate, and total value. Storage Info : Specific godown addresses where stock is held. Stock Categories

: Breakdowns for raw materials (imported/indigenous), stock-in-process, finished goods, and consumable spares. Calculation of Drawing Limit canara bank stock statement form nf 902 excel format

: Adjustments for margins and excluded categories like slow-moving stocks or goods held on credit. Part B: Production and Sales Statement

Actual production and sales figures compared to projections for the current period and year. Details on receivables (sundry debtors) and creditors. Filing Requirements

: The borrower must declare that the goods are their absolute property and are fully insured. Submission The Canara Bank Stock Statement Form (also known

: Typically submitted monthly or quarterly to the branch manager to determine the drawing power of a Cash Credit (CC) account.

: Items like drugs or chemicals older than 6 months or expiring soon must be specifically disclosed. Canara bank stock statement form: Fill out & sign online

Access the Canara Bank website or use reliable sources to download the NF902 in the desired format, such as PDF or Excel. NF 902 Stock Statement | PDF | Money - Scribd Step 7: Print or Export as PDF for

2. Why the Excel Format is Essential

Traditionally, business owners filled this form by hand monthly. However, an Excel format is highly recommended for several reasons:

  • Auto-Calculation: It eliminates manual arithmetic errors in total values and Drawing Power calculations.
  • Data Validation: Excel can be set up to flag if your stocks fall below the required margin percentage.
  • Digital Records: It creates a searchable archive of your monthly stock positions, useful for internal audits and GST reconciliation.
  • Easy Submission: Most Canara Bank branches now accept soft copies via email or the Canara Bank CBOP (Centralized Banking Operations) portal.

Step 7: Print or Export as PDF for Physical Submission

Even if you maintain Excel, many branches still require a signed hard copy. From Excel, go to File > Export > Create PDF/XPS to generate a professional-looking statement.

Introduction

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.