Canara Bank Stock Statement Form Nf 902 Excel Format Today
After filling out the form, you need to submit it to the bank or depository participant. You can submit the form:
While the bank often provides PDF templates, many businesses prefer Excel formats for several reasons: Auto-Calculations:
A: The benefits include easy data entry, automated calculations, and easy analysis of financial data.
Actual production and sales figures compared to projections for the current period and year. Details on receivables (sundry debtors) and creditors. Filing Requirements canara bank stock statement form nf 902 excel format
Using 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.
✅ Submit NF 902 every month within 7 days of month-end. ✅ Stock value should be , 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.
Manually filling out a paper-based NF 902 form is time-consuming and prone to mathematical errors. Utilizing an Excel template provides distinct operational advantages: After filling out the form, you need to
Once you have prepared the Canara Bank stock statement form NF 902 in Excel format, you need to submit it to the bank. Here are the steps to follow:
Borrowers enjoying working capital limits like Cash Credit (CC) or Overdraft (OD) against inventory and receivables must submit a stock statement periodically. At Canara Bank, this official declaration is known as . Submitting this form in an Excel format automates calculations, reduces errors, and ensures seamless compliance with banking norms. What is Canara Bank Form NF 902?
You can download a ready-to-use Excel template from our resource section. (On your actual site, insert a download link button here. For reference, users can search "NF 902 Excel Format RBI Guidelines" or request from branch.) Details on receivables (sundry debtors) and creditors
Canara Bank generally requires the NF 902 form to be submitted by the 10th or 15th of every month for the previous month's data. Late submissions trigger penal interest. How to Get the NF 902 Excel Format
Canara Bank generally excludes debtors older than 90 days from the drawing power calculation. 4. Creditors Information Total amount owed to suppliers.
Note: If your calculated Drawing Power (₹1,05,000) is lower than your sanctioned limit (e.g., ₹2,00,000), you can only draw up to ₹1,05,000. If your DP is higher than your sanctioned limit, your withdrawals remain strictly capped at your sanctioned limit. Important Rules and Common Mistakes to Avoid
With the form signed and stamped, Arjun’s drawing power was updated. By the afternoon, the funds he needed to purchase a new high-speed sewing machine were available in his account. 🛠️ Key Components of an NF 902 Excel Sheet