1, first of all, according to the content of the following chart will need to show the data and name of the inbound and outbound warehouse into the excel table.

2, in addition to entering the name of the time, in the form of entering the number of purchases, and corresponds to the number of monthly out of stock.

3, and then need to set the formula to calculate the inventory balance, in cell F3 enter the formula: C3-E3, that is, the number of purchases minus the number of warehouses.

4, the inventory balance of all products calculated and add a line at the bottom of the form "Total" line, the number of all the statistics can be.