Canara Bank Stock Statement Form Nf 902 Excel Format _hot_

Ultimate Guide to Canara Bank Stock Statement Form NF 902 Excel Format

Always get a stamped received copy of the NF 902 form from the branch or keep email confirmation if sent electronically. Frequently Asked Questions (FAQ)

: Raw materials (imported/indigenous), stock-in-process, and finished goods.

AI responses may include mistakes. For financial advice, consult a professional. Learn more NF 902 Stock Statement | PDF | Money - Scribd

Banks exclude older debts from the Drawing Power calculation. The threshold is typically 90 days. Excel can categorize this using simple formulas. : Fully considered for DP. Debts exceeding 90 days (Ineligible) : Excluded from DP. Total Value of Debtors : Sum of both categories. 4. Drawing Power (DP) Calculation Block canara bank stock statement form nf 902 excel format

Total Drawing Power=Stock DP+Debtors DPTotal Drawing Power equals Stock DP plus Debtors DP

: Always deduct unpaid stock (Sundry Creditors). Failing to do so violates banking compliance and constitutes over-reporting.

Generally, the stock value is calculated on the cost price exclusive of GST, as GST is a recoverable input tax credit.

A stock statement is a periodic report that provides a detailed account of the stock your business holds. For Canara Bank, this is typically required on a monthly basis from account holders under facilities like , ensuring the bank's exposure remains secured against existing stock. Ultimate Guide to Canara Bank Stock Statement Form

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

This is the core mathematical engine of the Excel sheet. It applies the bank-approved bank margins to your eligible assets.

This is the main body of the Excel sheet. It should be formatted with the following columns:

Focuses on current stock value (usually in Lakhs) minus items like slow-moving stock or goods in transit. Part B: Production & Sales: For financial advice, consult a professional

Borrowers holding working capital facilities like Cash Credit (CC) or Overdraft (OD) accounts with Canara Bank must submit a monthly stock statement [1]. This mandatory compliance document uses . It details the value of inventory and debtors used as collateral for the bank loan [1].

Do you need a for calculating the Drawing Power within this form?

: A formal sign-off by the borrower certifying that the figures match the company's books of accounts. Why You Need an Excel Format for NF 902

: If you use accounting software like Tally, you can often generate a stock statement and export it directly to Excel using the Alt+P or Export function. Compliance Note Canara Bank Stock Statement NF-902 Form | PDF - Scribd

Net Eligible Stock=Total Stock Value−Sundry CreditorsNet Eligible Stock equals Total Stock Value minus Sundry Creditors Step 3: Categorize Book Debts