Years ago we actually used Excel to manage our reagent and chemical inventory. Every shelf, drawer, freezer unit or box in the lab had an assigned number. Every room had an assigned number. Each reagent or chemical received was numbered and dated on the container. We did an annual inventory check, sorted by storage location to update and verify. The Excel sheet had dates rec'd so we could screen for different dates. It was easy to use and we could prepare printouts for lab safety inspections, restricted drug storage, etc.