| A | B | C | D | E | F | G | H | I | J | K | |---|---|---|---|---|---|---|---|---|---|---| | S.No | Item Description | UOM | Qty | Rate (₹) | Total Value (₹) | Date of Purchase | Ageing (Days) | Creditors Name | Creditors Amt (₹) | Remarks |
| S.No | Item | UOM | Qty | Rate | Value | Purchase Date | Ageing | Creditor | Creditor Amt | Net Stock | |---|---|---|---|---|---|---|---|---|---|---| | 1 | Coal | MT | 50 | 8,000 | 4,00,000 | 01-12-2024 | 3 Months | Coal India | 2,00,000 | 2,00,000 | | 2 | Steel Rods | KG | 10,000 | 75 | 7,50,000 | 15-01-2025 | 1 Month | JSW Steel | 4,00,000 | 3,50,000 | | 3 | Packing Bags | PCS | 5,000 | 10 | 50,000 | 01-02-2025 | 0 Months | Local Vendor | 50,000 | 0 | | | | | | | 12,00,000 | | | Total Creditors | 6,50,000 | 5,50,000 | canara bank stock statement format in excel
This draft explores the essential requirements and components for a Canara Bank stock statement in Excel format, specifically focusing on the standard NF-902 form used for Cash Credit (CC) limits. | A | B | C | D
The (primarily form NF 902 or NF 540 ) is a mandatory monthly declaration for businesses with a Cash Credit (CC) or Overdraft (OD) facility. While often provided as a PDF, it is frequently prepared in Excel to automate the calculation of "Drawing Power" (DP) by applying specific margins to inventory and receivables. Typical Excel Format Structure Typical Excel Format Structure