How to create Stock-Purchase-Sales Reconciliation (Inventory Report)

Hi everyone. Great POS app and very helpful materials. BTW, I am new to the site and the app.

I have this question regarding a daily stock inventory report that I am planning to create. Basically, the business is a bar with sales of spirits, beer, etc. Spirits are sold in shots (40ml), quarter, half and full bottle. I have multipliers of 25, 4, 2 and 1 to go with the sale of spirits (choices). See sample excelsheet I produced for the same purpose.

I would appreciate some help with a tutorial and or if someone can point me to one for creating a detailed Stock Inventory Report. This is really appreciated.