Canara Bank Stock Statement Form Nf 902 Excel Format May 2026

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:

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.

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

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. canara bank stock statement form nf 902 excel format

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 While Canara Bank may accept handwritten forms or

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 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 If you need a ready-to-download Excel template, search

: 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

: 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

A: Typically monthly. Check your loan sanction letter. For large limits (> ₹5 crore), weekly or fortnightly statements may be required.