This sample template allows users to analyze the business condition such as profitability and the inventory status. It is more like a inventory tracking spreadsheet. Inventory is almost like cash for business houses and if you maintain small business then it becomes even more complex to manage it.
This sample template may lack full capabilities as it is for example only. It is advised to read the instructions first to understand how it works. In stock codes sheet you can input stock,its description code and quantity in hand ,usage etc.
In stock movement sheet you can input the movement of the stocks,than there is variance report which will help you to determine any sort of stock variances. Sales and profitability report is also there.