Canara Bank Stock Statement Form Nf 902 Excel Format Jun 2026
If your loan facility includes drawing power against book debts, you must list your outstanding invoices. Canara Bank requires an aging breakdown because older debts are considered riskier:
: Excludes stock aged over 6 months or past expiration to protect collateral quality.
| Sl. No. | Description of Goods | Unit (Nos/Kgs/Ltrs) | Quantity | Rate per Unit (₹) | Total Value (₹) | Classification | Age of Stock (Days) | Remarks | |---------|----------------------|---------------------|----------|-------------------|-----------------|----------------|----------------------|---------| | 1 | Steel Coils | Kgs | 5000 | 80 | 400,000 | Raw Material | 45 | - | | 2 | Finished Pipe | Nos | 1200 | 250 | 300,000 | Finished Goods | 30 | - |
: Ensure the sales and stock figures matching your Excel format align with your monthly GST returns. Discrepancies can trigger bank audits.
To automate your Form NF 902 template, use these standard Excel formulas: Step 1: Calculate Net Paid Stock canara bank stock statement form nf 902 excel format
: Listing of outstanding book debts, categorized by age (usually under 90 days and over 90 days).
Open a new Excel workbook. Label the main tab NF 902 Monthly Statement .
You can download the Canara Bank stock statement form NF 902 in Excel format from the bank's official website. Here are the steps:
Delayed submission can lead to "penal interest" or the account being flagged as "irregular," which might freeze your ability to withdraw funds. Canara Bank OCC Stock Statement NF 902 | PDF - Scribd If your loan facility includes drawing power against
Filing an incorrect NF 902 form can result in your account being flagged, penal interest charges, or a temporary freeze on your withdrawals. Keep these rules in mind:
Using an automated Excel template simplifies this process, ensures accurate calculations, and prevents account irregularities. What is Canara Bank Form NF 902?
This comprehensive guide explains everything you need to know about the NF 902 form, its structure, how to fill it out in Excel, and how it impacts your borrowing capacity. What is Canara Bank Form NF 902?
This section tracks physical goods. You must categorize items to allow the bank to apply the appropriate margin: To automate your Form NF 902 template, use
The bank uses this statement to monitor the primary security of your loan. Submitting Form NF 902 periodically (usually monthly or quarterly) is a covenant in your loan agreement.
Failing to declare your sundry creditors constitutes misrepresentation, as the bank cannot finance unpaid inventory.
Goods paid for but not yet physically received. 3. Aging of Book Debts (Receivables)
: Summarizes the month’s sales figures and production levels to verify business activity.
This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.

