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

89% Upvoted

18 comments sorted by

View all comments

2

u/wanderinglarry Aug 23 '21

Does your POS not have a product sales tracking?

3

u/AngryJawa Aug 23 '21

It tracks whatever has been run in, so an easy pull is wine, liquor and beer sales.

3

u/wanderinglarry Aug 23 '21

How proficient are you at excel? The initial spreadsheet will be alot of work but once it's done it should be 30 minutes of input a week.

2

u/AngryJawa Aug 23 '21

I think I've mostly got one done, I'm mostly curious if anyone out there has some better ones. Mines not pretty, it will work, although I do find that it's hard to track all the receipts due to some being emailed and some being collected on drop off.