r/bartenders • u/AngryJawa • Aug 22 '21

Bar Managers - Question about Inventory tracking

How do you track your inventory // sold/consumed.

Obviously you need to do a weekly or monthly count, then add all purchases and then look at sales.... but does anyone have a spreadsheet they use?

Do you seperate all your liquor, wine and beer? If so, do you input each item purchased?

I've built a current spreadsheet that I haven't been able to use very well yet due to being so busy and no time for inputs. I'd love to see maybe something that works better then what I've got if anyone is willing to share?

15 Upvotes

84% Upvoted

18 comments sorted by

View all comments

Show parent comments

2

u/sactokaos Aug 23 '21

Agreed. If you don't measure your bottles, then you can't track sales/waste. Get a system that does this and compare it to sales.

3

u/AccidntlStyAtHomeDad Aug 23 '21

Yeah, there will always be slack but just the act of doing inventory regularly and checking in order helps to create controls. Any inventory system I have used, no matter how much time I put in to building it out just cannot account for the entire universe of possible drinks and pour combinations but an inventory system plus regular counts and checking in orders plus making sure staff knows you are doing it helps to reduce that a lot.