Canara Bank Stock Statement Form Nf 902 Excel Format |work| -
The critical calculation where the bank's margin (e.g., 25%) is applied to the net value of your hypothecated stock. How to Get Started You can typically download the NF 902 form from the official Canara Bank website
Enter your Company Name, Account Number, and the Date of the Stock Statement (e.g., as of 31st May 2026).
Use the formula =SUM(Range) to calculate the total gross value of the stock.
The NF 902 Excel format is a practical, user-friendly template for stock statements that balances regulatory needs and operational usability. Its effectiveness depends on disciplined version control, appropriate protections and validations in the worksheet, and integration with upstream systems to reduce manual entry. For branches with moderate inventory volumes, it’s a solid choice; for high-volume operations, consider moving to an integrated inventory system with periodic NF 902 exports. canara bank stock statement form nf 902 excel format
Create an "Age in Days" column. Use a formula if you have receipt dates: =IF(TODAY() - Receipt_Date > 90, "Slow/Non-moving", "Fast Moving") Most banks will exclude or heavily discount stock older than 90–180 days from drawing power.
Delayed submission can lead to "penal interest" or the account being flagged as "irregular," which might freeze your ability to withdraw funds. Canara Bank OCC Stock Statement NF 902 | PDF - Scribd
Based on recent search trends, there is a rising demand for digital tools to manage this process, with common queries being "stock statement format for canara bank cc account". The critical calculation where the bank's margin (e
: Requires the weight/quantity, rate per unit, and total value (usually calculated at market rate or cost price, whichever is lower).
form is more than just paperwork; it’s the key to maintaining your liquidity. US Legal Forms What exactly is the NF 902? The NF 902 is an OCC Stock Statement cum MSOD
Actual production and sales figures compared to projections for the current period and year. Details on receivables (sundry debtors) and creditors. Filing Requirements The NF 902 Excel format is a practical,
| Item No. | Description of Goods | Quantity | Unit | Purchase Price (Rs.) | Market Price (Rs.) | Total Value (Rs.) | Margin % | Eligible Stock Value (Rs.) | |----------|----------------------|----------|------|----------------------|--------------------|-------------------|-----------|----------------------------|
| Sr. No. | Particulars | Opening Balance | Stock "In" | Stock "Out" | Closing Stock | | :--- | :--- | :--- | :--- | :--- | :--- | | a. | Raw Materials & Consumable Store | | | | | | b. | Stock in Process | | | | 18,71,500 | | | | 18,33,252 | 18,31,572 | 18,69,820 | |