=SUM(Opening_Stock + Received_Qty - Issued_Qty) Stock Value: =Closing_Stock * Unit_Rate
Date,Material Code,Material Description,Transaction Type,Ref No.,Receipt Qty,Receipt Rate,Receipt Value,Issue Qty,Issue Rate,Issue Value,Running Balance 01-Jan-24,CMT-01,OPC Cement (53 Grade),Opening Balance,OB-001,500,5.00,2500,,,0,500 05-Jan-24,CMT-01,OPC Cement (53 Grade),Issue,MIN-101,,,0,200,5.00,1000,300 10-Jan-24,BRK-02,Clay Red Brick,Receipt,GRN-202,1000,0.25,250,,,0,1000 12-Jan-24,BRK-02,Clay Red Brick,Issue,MIN-102,,,0,400,0.25,100,600 Material Stock Register Format In Excel
(Where Column E is Quantity, Column C is Item Code, A5 is the target Item Code on the summary sheet, and Column B tracks "IN" transactions). Running Balance 01-Jan-24
Even with a perfect format, users make errors. Avoid these: OPC Cement (53 Grade)