Canara Bank Stock Statement Form Nf 902 Excel Format -

Specific reporting for goods older than six months or those nearing expiration (especially for pharmaceuticals/chemicals). How to Prepare Form NF 902 in Excel

To create an efficient Excel template for your monthly submissions, follow these structural steps: Stock Statements to Bank - Dhruva Industrial Consultants

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

Opening stock, items received, items sold/dispatched, and final closing stock units.

Details of the godown or warehouse where the goods are stored. Part B: Declarations and Financial Data: Specific reporting for goods older than six months

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:

It verifies that the goods serving as collateral are adequately insured and held in approved locations. Key Components of the Stock Statement Understanding Form NF 902 Opening stock, items received,

Clear identification of items (raw materials, work-in-progress, finished goods).