Canara Bank Stock Statement Form Nf 902 Excel Format (2026)

By following the guidelines and steps outlined in this article, customers can easily prepare and submit the Canara Bank stock statement form NF 902 in Excel format.

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.

Opening stock volume and value from the previous report period. canara bank stock statement form nf 902 excel format

(Note: Canara Bank typically applies a 25% margin on stock, meaning you get 75% DP).

No. Traders, distributors, and even service providers holding consumable inventory for working capital loans from Canara Bank must file Form NF 902. By following the guidelines and steps outlined in

The final section where the bank's margin (typically 25%) is deducted from the net stock value to arrive at the DP. How to Prepare the Statement in Excel

Use one worksheet for the inventory table and a separate summary sheet for calculations. Freeze the header row for easy data entry. Enable for the "Classification" column (allow only Raw Material, WIP, Finished Goods, Consumables). For branches with moderate inventory volumes, it’s a

Debts older than 180 days (generally excluded from Drawing Power calculations) 4. Creditors and Sundry Liabilities

Regular submission of this form is crucial for maintaining your 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.

25% (The bank finances 75% of your net stock value).

To build a robust automated template, incorporate these essential Excel functions: