For Canara Bank use only: Verified by Officer: _____________ Date: _____________
: In your Excel sheet, use formulas to automatically calculate: Final Stock = Opening Stock + Stock In - Stock Out . Total Value = Final Stock * Unit Rate . canara bank stock statement form nf 902 excel format
Creating an error-free stock statement is straightforward if you follow a systematic approach. For Canara Bank use only: Verified by Officer:
(Note: This is a formatted template. Please verify the format with your local branch manager, as regional variations sometimes exist. If the link is not active, you can create your own in Excel by replicating the headers: Date, Particulars of Stock, Quantity, Value, Receivables, Total Value, Margin %, and Drawing Power.) (Note: This is a formatted template
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).