Canara Bank Stock Statement Form Nf 902 Excel Format |link| Access

Drawing Power (DP) = 75% (or applicable margin %) of Net Stock: _________________

: If you use accounting software like Tally, you can often generate a stock statement and export it directly to Excel using the Alt+P or Export function. Compliance Note Canara Bank Stock Statement NF-902 Form | PDF - Scribd

To obtain the Canara Bank stock statement form NF 902 in Excel format, follow these steps:

: Sundry creditors represent unpaid stock. You must deduct them from the gross stock value to calculate net security. canara bank stock statement form nf 902 excel format

| Sr. No. | Particulars | Opening Balance | Stock "In" | Stock "Out" | Closing Stock | | :--- | :--- | :--- | :--- | :--- | :--- | | a. | Raw Materials & Consumable Store | | | | | | b. | Stock in Process | | | | 18,71,500 | | | | 18,33,252 | 18,31,572 | 18,69,820 | |

Need the Canara Bank Stock Statement Form NF 902 in Excel format? Learn how to download, fill, and use the official stock audit format for CC/OD limits.

Copy the quantities and values into the respective Raw Material, WIP, or Finished Goods columns. Drawing Power (DP) = 75% (or applicable margin

Forgetting to deduct Sundry Creditors inflates your DP artificially, which can lead to audit penalties.

This is the most critical block in the Excel sheet. It automatically applies bank margins to arrive at the final eligible drawing limit.

: It prevents data entry mistakes in totals, unpaid stock deductions, and ageing buckets. | Raw Materials & Consumable Store | | | | | | b

Open a new Excel workbook. Label the main tab NF 902 Monthly Statement .

Dedicate rows 1 through 5 to corporate header details: , and Godown Storage Locations . Data Architecture Matrix

The is a mandatory monthly disclosure document required from business borrowers who utilize working capital facilities like Open Cash Credit (OCC) or Overdraft (OD) limits. This form acts as proof of the underlying inventory that backs the bank's credit exposure, serving directly as the foundation for calculating your monthly Drawing Power (DP) . Managing this document manually can lead to computational errors, delayed submissions, and unexpected drops in available loan funds. Transitioning the NF 902 format into an automated Excel spreadsheet streamlines data collation, ensures accurate margin deductions, and helps maintain active access to your working capital limit. Master Structural Framework of Form NF 902

To ensure your digital layout matches the bank's requirements exactly, ask your or Relationship Manager to email you the official layout specifications for Form NF 902. You can easily replicate their exact row and column structure right into your Excel spreadsheet.