Create a simple column chart for the current month’s category-wise sales.Similarly, create boxes and give a link for the “Current Month Stock In” and “Current Month Stock Out.”.Like this, we must do the same for “Available Stock Value.”.Draw one more text box under this and link to the calculation sheet for “Available Stock Now” cells.Draw a text box and type “Available Stock Now.”.First, name the heading “Inventory Control Template.”.We need to create an excel dashboard for our inventory control template.Arrive category-wise current month sales and stocks available.Now, the current month’s stock inflow and stock outflow have arrived.We have applied the formula, which will automatically create the first day and last day of the current month. Create the current month’s starting date and ending date.We have added an available stock column and available stock value column from the product list table. We first need to arrive at the “Total Stock Available” and the “Total Stock Value” in the calculation sheet.Now, we need to create more sheets called “calculations.” First, we have created a “Product Master Sheet,” “Stock Incoming Tracker,” and “Stock Outgoing Tracker.” Then, we arrived at the available stock by deducting stock received from a stock sold. Now, arrive at an available stock value by multiplying the available stock by Unit Price. This sheet would give me how many stocks are available for each product. Then, we have deducted the quantities sold data from the stock outflow sheet. The technique we have used here is: first, we have arrived at how many units were received from the vendors from the stock inflow sheet.In the “Product Master” sheet, arrive at how many units are available as the stock in the warehouse.

This sheet is to update when the actual sale happens. Now, create one more sheet for “Product Inflow.” This sheet is to add all the incoming items from the vendors.This sheet should include all the product’s basic information. The first thing is we need to create a product master.

Stock register format in excel