The is a mandatory monthly stock statement required from borrowers who maintain an Open Cash Credit (OCC) account. While the official form is often distributed in PDF format, many businesses prefer an Excel format to automate calculations for Drawing Power (DP), which determines the actual amount they can withdraw from their sanctioned credit limit. Understanding Form NF 902
Run a stock valuation report from your accounting software (Tally, Zoho Books, SAP) as of the last day of the month.
Setting up the formulas correctly inside your Excel format ensures automated, error-free results. Here is the step-by-step mathematical logic used within Form NF 902:
You can obtain the form or digital versions through these platforms: canara bank stock statement form nf 902 excel format
This table tracks your physical goods. You must list the value of your items and specify their valuation basis (Cost Price or Market Price, whichever is lower). Item Category Description Valuation Basis Total Value (A) Raw Materials [e.g., Steel Sheets] Cost Price Work-in-Progress [e.g., Half-assembled units] Cost Price Finished Goods [e.g., Packaged machinery] Market Price $23,000 3. Book Debts (Debtors) Schedule
| H | I | J | K | L | |---|---|---|---|---| | | Closing Stock Value (₹) | Stock Pledged to Bank (₹) | Deficit (if any) | Remarks |
: 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 The is a mandatory monthly stock statement required
Ensure the automated Excel formulas generate a DP value that covers your current outstanding balance to avoid account tagging issues. Common Mistakes to Avoid
The Canara Bank stock statement form NF 902 is an essential document for businesses to maintain accurate records of their stock holdings. By obtaining the form in Excel format, businesses can simplify data entry, automate calculations, and ensure accuracy in their financial records. This article has provided a comprehensive guide on how to obtain and fill out the NF 902 form in Excel format, highlighting its importance and benefits. If you have any questions or need further assistance, please do not hesitate to contact Canara Bank's customer support or a financial expert.
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. Setting up the formulas correctly inside your Excel
Goods paid for but not yet physically received. 3. Aging of Book Debts (Receivables)
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.