how to maintain stock in excel

Stock Register may be define as live document/file/software record which is used for maintaining company’s stock.