Canara Bank Stock Statement Form Nf 902 Excel Format ~repack~ Jun 2026

(Note: This is a formatted template. Please verify the format with your local branch manager, as regional variations sometimes exist. If the link is not active, you can create your own in Excel by replicating the headers: Date, Particulars of Stock, Quantity, Value, Receivables, Total Value, Margin %, and Drawing Power.)

: A formal statement confirming the goods are the borrower's property, are fully insured, and are valued accurately. 📊 Excel Format Structure

Borrowers enjoying working capital limits like Cash Credit (CC) or Overdraft (OD) against inventory and receivables must submit a stock statement periodically. At Canara Bank, this official declaration is known as . Submitting this form in an Excel format automates calculations, reduces errors, and ensures seamless compliance with banking norms. What is Canara Bank Form NF 902?

This comprehensive guide explains everything you need to know about Form NF 902, why an Excel format is essential for your business, and how to fill it out accurately to avoid account freezing or penal interest. What is Canara Bank Form NF 902? canara bank stock statement form nf 902 excel format

Canara Bank NF 902 form is a standard "Stock Statement cum MSOD" (Monthly Selection of Operational Data) used by business borrowers to report inventory levels for Cash Credit (CC)

The form is typically divided into sections to provide a comprehensive view of business assets:

=MIN(Sanctioned_Limit_Cell, (Stock_Drawing_Value + Debtors_Drawing_Value)) Important Rules for Submitting Form NF 902 (Note: This is a formatted template

Ensure your inventory counts and debtor aging reports are generated exactly on the last day of the calendar month to ensure data integrity.

Follow this process to ensure your stock statement is accepted on the first submission.

The is a standardized stock statement form primarily used by businesses holding a Cash Credit (CC) account with Canara Bank. What is Canara Bank Form NF 902

:If the margin is 40%, the bank finances 60% of the value. Excel Formula: =Eligible_Debtors_Cell * 0.60 Determine Total Drawing Power :

| Feature | Benefit | |--------|---------| | | Total, closing stock, and shortage automatically computed | | Error Reduction | No manual addition mistakes | | Professional Look | Neat, printable, and bank-ready | | Easy Modification | Add rows for multiple product categories | | Digital Submission | Email directly to branch manager/relationship manager |

If the bank requires a 40% margin on eligible book debts, you can borrow against 60% of the value. : =Eligible_Debtors_Cell * 0.60 Step 4: Cap the Drawing Power at the Sanctioned Limit

You can copy and paste this directly onto your website, blog, LinkedIn, or share it with clients.