902 Excel Format [repack] - Canara Bank Stock Statement Form Nf

Generally found under the 'Downloads' > 'Forms' section, labeled as "Stock Statement - NF902."

For businesses operating with a Cash Credit (CC) or Overdraft (OD) facility from Canara Bank, regular submission of the stock statement is not just a formality—it is a mandatory compliance requirement. The is the official document used to report the value of inventory and receivables to the bank on a monthly or quarterly basis.

Instead of recreating the document every month, you simply update the raw numbers in your saved Excel template, saving hours of administrative work. canara bank stock statement form nf 902 excel format

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

A standard Canara Bank Stock Statement Excel template is divided into four critical sections: 1. Basic Borrower Information Generally found under the 'Downloads' > 'Forms' section,

Run a stock valuation report from your accounting software (Tally, Zoho Books, SAP) as of the last day of the month.

: Applies the bank's predefined safety margin percentage to establish the final net Drawing Power. Step-by-Step Guide to Formulating the Excel Sheet | Item No

: Section to deduct stocks purchased on credit, goods hypothecated to other banks, or slow-moving items from the total value. Drawing Limit Calculation

Form NF 902 is designed to give the bank a transparent view of your business's operational health. It is divided into two primary sections:

The form is the official "Stock Statement Cum MSOD" used by borrowers to report inventory and sales details for Cash Credit (CC) or Open Cash Credit (OCC) accounts. While the bank primarily provides this in PDF format, many businesses use Excel versions to automate the calculation of drawing limits and stock values. Key Components of Form NF 902