If you combine all materials in one sheet, you cannot simply use K2 + E3 . You must calculate balance based on the specific Item Code .
=IF(D2="In", G1+C2, G1-C2) (Assuming G1 is previous balance) Material Stock Register Format In Excel
How to Maintain Daily Stock in Excel — Download Free Template If you combine all materials in one sheet,