If want to see your inventory detail in 1 Click then this template if for you. You can easily update stock in and stock out.
See reports like safety inventory stock level SKU wise
Zero balance SKU report
SKU wise report
Date wise report
Use excel vba and formula to automate it so that you will get your result by just put the number in the cells