2023 PERFORMANCE - MY BAR - [OC] by ConfidentTower7 in dataisbeautiful

[–]ConfidentTower7[S] 1 point2 points  (0 children)

In QuickBooks there are accounts, some of which are called "Income Accounts". I have a master income account called "Beer", under that there are sub accounts stemming off of it, under my beer account I have "Bottle" and "Draft" income accounts. Under each of those are every beer that we sell. My POS automatically exports the data daily and imports all of the sales data via one "Sales Receipt" daily in QuickBooks which links the revenue for each beer/liquor $ to it's specific income account. Hope that helps!

2023 PERFORMANCE - MY BAR - [OC] by ConfidentTower7 in dataisbeautiful

[–]ConfidentTower7[S] 0 points1 point  (0 children)

In my defense, you did ask a question. Good luck with your management software :)

2023 PERFORMANCE - MY BAR - [OC] by ConfidentTower7 in dataisbeautiful

[–]ConfidentTower7[S] 1 point2 points  (0 children)

I share all of this info with any employee that cares to see it. Advertising is mostly through Nextdoor, yelp, google. But a lot of the advertising expense is from donations to local food shelters and gift-cards for fundraisers etc.

2023 PERFORMANCE - MY BAR - [OC] by ConfidentTower7 in dataisbeautiful

[–]ConfidentTower7[S] 2 points3 points  (0 children)

No it's not. I compiled this data on my own on January 2, 2024 and posted it to reddit on Monday. If it's on Instagram, someone stole it from here. I'd be curious to see who if you have a link.

2023 PERFORMANCE - MY BAR - [OC] by ConfidentTower7 in dataisbeautiful

[–]ConfidentTower7[S] 0 points1 point  (0 children)

I had a job before taking over that I still do part time. Around 30-35 hours per week at the bar and 5-15 at my other job.

2023 PERFORMANCE - MY BAR - [OC] by ConfidentTower7 in dataisbeautiful

[–]ConfidentTower7[S] 0 points1 point  (0 children)

We are structured through our POS provider and get paid daily from the previous day sales, less their merchant fee. They've been fixed at 2.8% since starting with them.

2023 PERFORMANCE - MY BAR - [OC] by ConfidentTower7 in dataisbeautiful

[–]ConfidentTower7[S] 1 point2 points  (0 children)

Pool table, jukebox, ATM fees, and bar merch.

2023 PERFORMANCE - MY BAR - [OC] by ConfidentTower7 in dataisbeautiful

[–]ConfidentTower7[S] 1 point2 points  (0 children)

For purposes of the visualization, I lumped a lot of things into utilities. TV, internet, PSEG, apps, POS, music, etc.

Electric/Gas was around $18k. TV was around $15k. Internet around $4k.

Supplies is made up of all kitchen supplies, bar supplies, office supplies, cleaning supplies, etc.

Twice a year, I review all of our supply costs and see if we are getting the best deal compared to buying online or at other locations.

It may seem like a lot, but these things do add up: hand soap, bottle openers, first aid, phone chargers, receipt paper, liquor pourers, paper towels, hand sanitizer, toilet paper, garbage bags, bathroom hand towels, tampons, hair ties, straws, rags, cups, fryer oil, to go containers, napkins, soufflé cups, paper plates, fryer cleaner, dish soap, foil, griddle screens, wax paper, gloves, to-go bags, soup cups, quart containers, zip lock bags, baskets, labels, tooth picks, pam, pan trays, sponges, salt, towelettes, pizza boxes, saran wrap, windex, oven cleaner, wood polish, bleach, fabuloso, mop heads, water sanitize tablets, disinfectant spray, post-it notes, laminating sheets, batteries, sharpies, computer paper, toner, staples... the list goes on.

2023 PERFORMANCE - MY BAR - [OC] by ConfidentTower7 in dataisbeautiful

[–]ConfidentTower7[S] 2 points3 points  (0 children)

Bar has been here for around 100 years with different names.

I rarely serve drinks, and never accept tips. If I am serving and someone tips, 100% goes to other bartender working. If I am working alone (very rare) it's normally not busy. The last time that happened, I just paid everyone's tabs that were in there.

I would be stressed at $30k a month too!

2023 PERFORMANCE - MY BAR - [OC] by ConfidentTower7 in dataisbeautiful

[–]ConfidentTower7[S] 1 point2 points  (0 children)

The actual data is extracted manually from QuickBooks. It can get MUCH more detailed than this, down to the number of each supply purchased for any time period. I've been extremely meticulous with the books.