Canara Bank Stock Statement Format In Excel ((new)) -

: Platforms like Scribd and DocHub offer downloadable Excel and fillable PDF versions of the NF-902 and NF-540 formats. Canara Bank Occ Stock Statement Form Download - Facebook

: Within the sanctioned cover period (usually 90 days). canara bank stock statement format in excel

To ensure your Excel sheet meets bank standards, include these specific columns: Item Description: Precise name of the commodity or material. Storage Location: Address of the godown where the stock is physically kept. Number of units, weight, or volume. Valuation Rate: The price per unit used for calculation. Total Value: (Quantity × Rate). Ineligible Stock: : Platforms like Scribd and DocHub offer downloadable

| 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 | Storage Location: Address of the godown where the

Select the Total Value column. Go to Home > Conditional Formatting > New Rule . Use the formula:

F20: Total Stock Value G20: =SUM(F9:F19)

F23: Margin @ [25%] (as per bank) G23: =G22*25%