Stock database

Hi. I have multiple brands of products and each has a few different 'sub-products'/variants. I am using a basic Excel spreadsheet to calculate stock usage. Every month I have to send in a stocktake ...