Recording Stock for Tax Reporting

Any advice...I keep my Excel income and expenses spreadsheet but not sure if I should record all stock as I buy it as a monthly expense or just the cost of the actual items I sell and then keep the cost of remaining stock at hand as a separate thing?