Canara Bank Stock Statement Form Nf 902 Excel: Format

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.

Determine the margin (e.g., 25% or 30%) agreed with Canara Bank to find the net eligible stock value. canara bank stock statement form nf 902 excel format

This statement serves as a legally binding declaration to the bank regarding the status of your inventory, supporting the drawing power of your CC account. For businesses operating with a Cash Credit (CC)

| Sr. No. | Particulars | Opening Stock | Stock "In" | Stock "Out" | Closing Stock | | :--- | :--- | :--- | :--- | :--- | :--- | | a. | Raw materials & consumable stores | | | | | | i | Imported | | | | | | ii | Indigenous | | | | | | b. | Stock in process | | | | | | c. | Finished goods | | | | | | d. | Consumable spares | | | | | | | | | | | | This statement serves as a legally binding declaration

Populate the stock description, quantities, and rates based on your physical verification.

Excel formulas can instantly calculate the total stock value, less margin, and eligible drawing power.

A typical NF 902 form in Excel will include several tables and sections that need to be filled out. The most critical sections, based on a sample statement, are outlined below.