I need a to keep an accurate count of my inventory. I built a detailed excel program, But it only works when I fill in every column. For instance. Column 1 is Amount sold, which is done every date, column 2 and 3 is Loose and Cooler, which is a physical count. Column 4 is Supplied, which is done everytime we get a shipment. Column 5 and 6 are Jeff and Shift, which are free beers given to the owner Jeff and to the bartenders after their shift.
I need to keep an accurate count of the inventory, but when a physical count is done the inventory needs to be updated, as well as calculate the difference, such as broken or stolen items. I need history of inventory as well as a history of the difference for each product and a daily difference.
Can anyone help me, I can send you my excel file for better understanding.
I need to keep an accurate count of the inventory, but when a physical count is done the inventory needs to be updated, as well as calculate the difference, such as broken or stolen items. I need history of inventory as well as a history of the difference for each product and a daily difference.
Can anyone help me, I can send you my excel file for better understanding.
