Canara Bank Stock Statement Form Nf 902 Excel Format Online

Continue with:

| H | I | J | K | L | |---|---|---|---|---| | Rate (per unit) | Closing Stock Value (₹) | Stock Pledged to Bank (₹) | Deficit (if any) | Remarks |

The Canara Bank Stock Statement Form NF 902 is more than just a compliance formality; it is a snapshot of your business health. By migrating this process to a structured Excel format, you not only save time but also gain better visibility into your working capital cycle. Whether you download a template or build your own, ensuring the formulas correctly reflect the bank's margin requirements is key to maintaining a healthy relationship with your banker.

The Canara Bank NF 902 form is the official "Stock Statement Cum MSOD" used by borrowers to report inventory and sales details for Cash Credit (CC) or Open Cash Credit (OCC) accounts. While the bank primarily provides this in PDF format, many businesses use Excel versions to automate the calculation of drawing limits and stock values. Key Components of Form NF 902

The form is typically divided into two major parts to provide a complete picture of the business's current working capital position: Canara Bank Stock Statement NF-902 Form | PDF - Scribd

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)

. While the bank primarily distributes this in PDF format, many businesses recreate it in to automate calculations for Drawing Power (DP). US Legal Forms Purpose and Importance Drawing Power Calculation

: Banks use the statement to determine the maximum amount you can withdraw from your CC limit based on the "Net Value" of your stock after applying a margin (often 25%). Compliance

: Regular submission (usually monthly) is mandatory to ensure the loan is backed by physical assets. Financial Transparency

: It provides a snapshot of raw materials, stock-in-process, and finished goods to assess your company's operational health. US Legal Forms Structure of Form NF 902

A typical NF 902 statement is divided into two primary sections: Part A: Stock Statement

This table requires detailed inventory data as of the last day of the month: Item Description : Clear naming of commodities or products. Opening Stock : Quantity and value at the start of the month. Additions/Sales

: Goods received ("In") and goods sold ("Out") during the period. Closing Stock

: The final quantity and value (at cost or market rate, whichever is lower). Excluded Categories

: You must subtract stocks purchased on credit (Trade Creditors) to find the net hypothecated value. Part B: Production and Sales Statement This section captures overall business performance: Sales Data : Monthly gross and net sales figures. Production : Units produced during the month. Receivables

: Details of outstanding book debts (often required to be listed by age, such as those over 90 days). How to Obtain the Format Bank Stock Statement Format Guide | PDF - Scribd

Using Excel format for Canara Bank Form NF 902 saves time, improves accuracy, and keeps your working capital limit compliant. Whether you are a small trader or a large manufacturer, maintaining a clean digital stock statement helps smooth banking and faster limit enhancements.

Need a customized NF 902 Excel template with formulas and automated drawing power calculation? Let us know in the comments below!

Related Posts:

Disclaimer: This format is a standard representation based on Canara Bank’s prescribed guidelines. Always confirm with your branch for any recent changes to NF 902.

The Canara Bank NF 902 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

To develop an accurate Excel-based stock statement, ensure your file includes the following sections based on the official NF 902 structure:

Header Information: Business name, address, and the specific date (e.g., "Statement as of October 31, 2023"). Stock Inventory Table: Commodity Description: Specific item names.

Quantity Tracking: Columns for Opening Stock, Stock "In" (purchases), Stock "Out" (sales), and Final Closing Stock.

Valuation: Unit rate and total value (typically calculated at market rate, landed cost, or invoice price).

Classification of Assets: Breakdown of Raw Materials, Stock-in-Process, Finished Goods, and Consumable Spares.

Excluded Category Section: Values to be deducted for calculating drawing limits, such as: Stocks purchased on credit (Trade Creditors). Slow-moving or obsolete stocks. Goods in transit or held in outstation godowns.

Declaration: A legal statement confirming the goods are the absolute property of the borrower, are fully insured, and have no prior charges. Steps to Create an Excel Stock Statement

Download a Reference: While the Canara Bank Download Center primarily provides PDF/HTML formats, you can find editable templates on platforms like Scribd or US Legal Forms.

Automate Calculations: In your Excel sheet, use formulas to automatically calculate: Final Stock = Opening Stock + Stock In - Stock Out. Total Value = Final Stock * Unit Rate.

Net Drawing Power = (Total Value - Exclusions) * (1 - Bank Margin %).

Validate Data: Ensure the figures in your Excel sheet match your physical inventory count and align with your financial ledger for that month.

Submission: Print the finalized Excel sheet and sign it with an authorized stamp before submitting it to your respective branch. Why Banks Require NF 902

Regular submission of this form is crucial for maintaining your Cash Credit (CC) account. It provides the bank with financial transparency, ensures compliance with banking regulations, and allows for the periodic adjustment of your credit limits based on real-time inventory health.

Do you need a step-by-step Excel formula guide for calculating the Drawing Power within this form?

AI responses may include mistakes. For financial advice, consult a professional. Learn more Download Center - Canara Bank

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

under the "Downloads" section. While the bank primarily provides PDF versions, you can find editable formats on platforms like to export into Excel or Word. Key Components of Form NF 902 The statement generally consists of two parts: Part A: Stock Statement Commodity Details

: Item description, quantity (opening/closing), unit rate, and total value. Storage Info : Specific godown addresses where stock is held. Stock Categories

: Breakdowns for raw materials (imported/indigenous), stock-in-process, finished goods, and consumable spares. Calculation of Drawing Limit

: Adjustments for margins and excluded categories like slow-moving stocks or goods held on credit. Part B: Production and Sales Statement

Actual production and sales figures compared to projections for the current period and year. Details on receivables (sundry debtors) and creditors. Filing Requirements

: The borrower must declare that the goods are their absolute property and are fully insured. Submission

: Typically submitted monthly or quarterly to the branch manager to determine the drawing power of a Cash Credit (CC) account.

: Items like drugs or chemicals older than 6 months or expiring soon must be specifically disclosed. Canara bank stock statement form: Fill out & sign online

Access the Canara Bank website or use reliable sources to download the NF902 in the desired format, such as PDF or Excel. NF 902 Stock Statement | PDF | Money - Scribd

Form NF 902 is a statutory statement required by Canara Bank from borrowers availing Working Capital Limits (like Cash Credit or Overdraft). It serves two primary purposes:

✅ Submit NF 902 every month within 7 days of month-end.
✅ Stock value should be at cost or market value, whichever is lower.
✅ Do not include obsolete / slow-moving stock in pledged stock.
✅ Always keep a signed copy (physical or digitally signed) for bank audit.
✅ If drawing power reduces due to stock shortage, repay excess immediately to avoid penal interest.

Your Excel form must contain:

⚠️ Note: As per RBI guidelines, stock statements for working capital limits of ₹5 crore and above must be certified by a statutory auditor.

If you cannot find an official version, you can build a compliant NF 902 Excel file using the structure described above. Use Excel’s SUM, SUMIF, and IF functions to automate totals and drawing power.

Example formula for drawing power: =IF(AND(Stock_Type="Finished Goods", Age<90), Total_Value*0.75, IF(Stock_Type="Raw Material", Total_Value*0.80, 0)) (Note: Margin percentages vary per sanction letter; always refer to your loan agreement.)