Canara Bank Stock Statement Form Nf 902 Excel Format High Quality

Canara Bank NF 902

The form is a standard "OCC Stock Statement cum MSOD" (Monthly Selection of Operational Data) required by the bank to assess the creditworthiness of a business and determine its monthly drawing limits. Essential Components of Form NF 902

Official Source

: The Canara Bank Website usually provides these forms under the "Downloads" or "Customer Corner" section. canara bank stock statement form nf 902 excel format

  1. Using Estimated Figures: Bank auditors physically verify stock periodically. Inflated quantities or rates will lead to penal interest or account classification as NPA (Non-Performing Asset).
  2. Ignoring Slow-Moving Stock: If you don’t age your stock, the bank may assume it is all fresh, but a surprise inspection will reveal the discrepancy.
  3. Incorrect Margin Application: Some borrowers apply a uniform margin. Check your sanction letter – margins differ for raw material (e.g., 25%), finished goods (30%), and work-in-progress (40%).
  4. Missing Insurance Details: Your Excel statement should have a note or column indicating the insurance policy number and expiry date. Without insurance, stock is not considered valid security.
  5. Circular References in Formulas: Double-check that your total value does not depend on the drawing power cell. That will break the calculation.
  6. Submitting in .xlsm (Macro-Enabled) Format: Canara Bank systems often block macros for security. Always save as standard .xlsx or .xls.

While the bank primarily provides this in PDF format, you can find editable versions through several channels: Official Website : Navigate to the section on the Canara Bank homepage to find NF 902 - Stock Statement Excel/XLS Formats : Third-party document repositories like often host community-uploaded versions for easier data entry. Online Editors : Platforms like Canara Bank NF 902 The form is a

Drawing Limit Calculation

: A summary that subtracts margins (e.g., 20-25%) and excluded categories (like stocks purchased on credit) from the total value to determine the bank's maximum allowable credit. While the bank primarily provides this in PDF

Option 2: Create Your Own in 5 Minutes

The Canara Bank Stock Statement Form (also known as the "OCC Stock Statement cum MSOD") is available for download on the official Canara Bank website

Q1: Is NF 902 applicable only for manufacturing units?

6. Conclusion