The is more than a compliance document – it is a tool for financial discipline. By creating a robust, formula-driven Excel template, you not only please your bank manager but also gain real-time insight into your inventory turnover, slow-moving stock, and actual drawing power.
: Search for "Canara Bank Stock Statement Form NF 902 Excel" on Google Drive where user-uploaded templates are often stored. canara bank stock statement form nf 902 excel format
: A signed statement confirming the goods are the borrower's property, are fully insured, and are held in trust for the bank. How to Prepare the Statement in Excel The is more than a compliance document –
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 : A signed statement confirming the goods are
: Goods received ("In") and goods sold ("Out") during the period. Closing Stock
Net Eligible Stock=Total Stock Value−Sundry CreditorsNet Eligible Stock equals Total Stock Value minus Sundry Creditors Step 3: Categorize Book Debts
Only if you export to .xlsx format or print it. However, Google Sheets formulas work similarly, but ensure you are not sharing the sheet with an unsecured link.