Canara Bank Stock Statement Form Nf 902 Excel Format |work| Jun 2026

This is the most critical operational component of the Excel sheet. It applies the bank's approved margins to your net stock and eligible debtors. Designing the Drawing Power Formula in Excel

List your stock items systematically. Ensure your valuation matches your stock register. Use the classic formula in your Excel cells:

The Canara Bank stock statement form NF 902 is a document that provides a detailed record of a company's stock holdings, including the quantity, value, and other relevant information. This form is specifically designed for businesses that have a current account with Canara Bank and hold securities, such as shares, bonds, or debentures.

: Typically required monthly by a specific date to ensure continuous access to credit limits. canara bank stock statement form nf 902 excel format

Your final Drawing Power is either the Total Computed DP or your Sanctioned Limit , whichever amount is lower . Structure of an Ideal NF 902 Excel Template

A standard NF 902 Excel sheet is divided into distinct sections to capture your company's short-term liquidity position. 1. Header Information Company name and registered address. Sanctioned Cash Credit / Overdraft limit amount.

: Use the MIN function to ensure the calculated DP does not exceed your actual sanctioned credit limit. This is the most critical operational component of

This statement serves as a legally binding declaration to the bank regarding the status of your inventory, supporting the drawing power of your CC account.

The bank uses this data to calculate your . Drawing power is the actual amount you can withdraw from your sanctioned cash credit limit, based on the value of your active stock and outstanding debtors minus credit received. Key Components of Form NF 902

:Filter out old invoices based on your sanction criteria (e.g., excluding debtors older than 90 days). Excel Formula: =SUM(Debtors_Under_90_Days_Cells) Ensure your valuation matches your stock register

The final section utilizes the data above to calculate your actual eligible borrowing limit for the month, factoring in the bank's prescribed . Step-by-Step Guide: How to Fill the Excel Form

Usually submitted by the 7th or 10th of every month for the previous month's end.

The Canara Bank stock statement form NF 902 is an essential document that helps customers to report their stock holdings and comply with the bank's requirements. By preparing and submitting the form in Excel format, customers can ensure accurate record-keeping, informed decision-making, and compliance with tax regulations. We hope that this article has provided a comprehensive guide on how to prepare and submit the Canara Bank stock statement form NF 902 in Excel format.

: Borrowers must declare that reported values are accurate and that the inventory is adequately insured. Where to Obtain the Form

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