Canara Bank Stock Statement Form Nf 902 Excel Format May 2026

Here are the typical columns in NF 902 stock statement:

| Item No. | Description of Goods | Quantity | Unit | Purchase Price (Rs.) | Market Price (Rs.) | Total Value (Rs.) | Margin % | Eligible Stock Value (Rs.) | |----------|----------------------|----------|------|----------------------|--------------------|-------------------|-----------|----------------------------|

Plus header details:

To create it yourself: Open Excel, add these columns, save as .xlsx or .xls.

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

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 Here are the typical columns in NF 902

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

Visit your home branch and ask the relationship manager or loan officer for the latest Excel template of NF 902. Many branches maintain a soft copy on their internal system and can email it to you.

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.

This is the mathematical logic the bank uses. Your Excel sheet should have formulas to populate this automatically based on the data in Section B. To create it yourself : Open Excel, add

The Logic in Excel:

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.

Total Value of Stock (₹): _________________
Less: Stock not to be financed (₹): _________________
Net Stock considered for Drawing Power (₹): _________________
Drawing Power (DP) = 75% (or applicable margin %) of Net Stock: _________________
Certified that:

Signature of Borrower/Authorised Signatory
Date:
Place:
For Canara Bank use only:
Verified by Officer: _____________
Date: _____________