How to maintain stock ledger with B/no, Mfg dtd, Exp.dtd, Received, Issue and balance?
How to maintain stock ledger with B/no, Mfg dtd, Exp.dtd, Received, Issue and balance?
I googled "Excel for stock keeping" and was offered a plethora of free templates. You might start with any of those. Chances are that you will want some features not contained in the template you chose, such as Mfg and Exp dates. You then tweak the template to accommodate your special requirements.
This site is intended to offer help should you have difficulty implementing the changes you can describe.