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
Banks typically offer credit after deducting a "margin" (e.g., 25%) from the total stock value.
Unit rate and total value of each item as of the statement date. canara bank stock statement form nf 902 excel format
The NF 902, officially titled the (Monthly Statement of Operations and Data), serves as a report on the quantity and value of inventory held by a business. This statement is used by the bank to:
Opening stock, items received, items sold/dispatched, and final closing stock units. The is a mandatory monthly stock statement required
It verifies that the goods serving as collateral are adequately insured and held in approved locations. Key Components of the Stock Statement
Monitoring inventory levels helps the bank evaluate the operational stability of the borrowing entity. Unit rate and total value of each item
To create an efficient Excel template for your monthly submissions, follow these structural steps: Stock Statements to Bank - Dhruva Industrial Consultants
Summary of monthly production and sales figures.
Clear identification of items (raw materials, work-in-progress, finished goods).