A complete NF 902 statement generally includes two main sections:
It verifies that the goods serving as collateral are adequately insured and held in approved locations. Key Components of the Stock Statement
Banks typically offer credit after deducting a "margin" (e.g., 25%) from the total stock value. canara bank stock statement form nf 902 excel format
Opening stock, items received, items sold/dispatched, and final closing stock units.
To create an efficient Excel template for your monthly submissions, follow these structural steps: Stock Statements to Bank - Dhruva Industrial Consultants A complete NF 902 statement generally includes two
Details of the godown or warehouse where the goods are stored. Part B: Declarations and Financial Data:
The is a mandatory monthly stock statement required from borrowers who maintain an Open Cash Credit (OCC) account. While the official form is often distributed in PDF format, many businesses prefer an Excel format to automate calculations for Drawing Power (DP), which determines the actual amount they can withdraw from their sanctioned credit limit. Understanding Form NF 902 To create an efficient Excel template for your
Clear identification of items (raw materials, work-in-progress, finished goods).
Specific reporting for goods older than six months or those nearing expiration (especially for pharmaceuticals/chemicals). How to Prepare Form NF 902 in Excel
