I didn't know what you bought every day, so I assumed the name and model. The original quantity is how much you have left at the beginning of each month and the end of last month. The warehousing and warehousing are the quantities you purchased and delivered. The actual quantity is your current inventory. How much to buy or ship every day, fill in the corresponding figures in the warehouse and warehouse. Next is your last actual inventory.

The formula is: original quantity+receipt-issue = your actual quantity now.

Moreover, it can clearly calculate the number of each variety in and out of the warehouse in a month.

I hope I can help you and adopt it. ~~