Canara Bank Stock Statement Form Nf 902 Excel Format !link! File

Canara Bank Stock Statement Form NF 902: A Guide to Downloading and Using in Excel Format

Data Validation

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).

Mandatory Details to Fill in NF 902

• Consistency: Ensure the stock figures in NF 902 match your GST returns (GSTR-3B) and closing balance sheets. Discrepancies trigger audits.
• Ageing Analysis: Be careful with the "Book Debts" section. Debts overdue by more than 90 days are often not considered valid security by Canara Bank and will be deducted from your Drawing Power.
• Signatures: Even if you prepare the Excel sheet digitally, print it, sign it (and have a partner/co-borrower sign it), scan it, and submit the PDF. Digital signatures (DSC) are required for large corporate accounts but smaller MSMEs usually submit physical signatures on the printed Excel sheet.

While the bank often provides PDF templates, many businesses prefer Excel formats for several reasons: Auto-Calculations: canara bank stock statement form nf 902 excel format