: Borrowers often find the NF 902 "interesting" because it determines how much of their sanctioned loan they can actually use that month. If your stock is low, your "Drawing Power" drops, even if the bank has approved a higher limit.
The is a straightforward yet crucial document for your business's financial operations. While a direct download link is not publicly available, the official format is easily obtained by contacting your branch manager. By understanding the form's structure, using Excel's calculation tools for accuracy, and avoiding common pitfalls, you can ensure smooth processing of your CC account and maintain a strong, reliable relationship with your bank.
: Late submission attracts penal interest rates. Key Components of Form NF 902 Excel Template
The , also known as the OCC Stock Statement Cum MSOD , is a mandatory monthly or quarterly document for borrowers holding an Open Cash Credit (OCC) account. It details the borrower's inventory and sales to help the bank calculate the current Drawing Limit based on the value of hypothecated goods . Key Sections of Form NF 902
Generally found under the 'Downloads' > 'Forms' section, labeled as "Stock Statement - NF902." canara bank stock statement form nf 902 excel format
This article is for informational purposes only. Always use the official NF 902 Excel template provided by your Canara Bank branch, as forms may be updated.
You must break down debtors by age (e.g., less than 90 days, 90–180 days, and above 180 days).
To build your own compliant sheet, organize your Excel workbook layout using these columns: Item Description Quantity / Weight Valuation Rate Total Value (Rs.) Creditors Supplier Name Invoice Date Outstanding Amt Book Debts Customer Name Invoice Date Total Invoice Amt Age (Days) Essential Excel Formulas to Embed:
While the exact "Form NF 902" appears to be an internal bank document, the stock statement serves a critical purpose: : Borrowers often find the NF 902 "interesting"
: The bank uses this form to calculate your actual borrowing capacity for the month.
under the "Downloads" section. Many third-party financial platforms also offer fillable Excel templates that mirror the official structure for easier digital submission. step-by-step guide
Form NF 902 is Canara Bank’s standard stock statement template used to report inventory/stock details for borrowers (usually businesses) to the bank. The Excel format collects periodic data so the bank can verify stock levels, margins, and compliance with working-capital limits.
While often downloaded as a PDF, most businesses convert the structure into an to automate calculations. A standard NF 902 contains: While a direct download link is not publicly
Excel Tip: Include columns for to ensure data consistency.
Keeps your monthly data structured uniformly, making historical comparisons easier for your finance team.
AI responses may include mistakes. For financial advice, consult a professional. Learn more