
Maximize your bar's profitability with Bar-i's POS integration! Compare exact ounces sold versus poured, track missing servings, and uncover your true achievable liquor cost today.
00:00:02,666 this is Jamie with Barry
00:00:04,100 welcome back to our how it works sales series
00:00:06,400 which is a set of videos that allows you to delve
00:00:08,700 into the functionality of the different functions
00:00:10,566 and modules of Barry's Inventory software
00:00:12,800 so you can decide if it'd be a good fit for your bar
00:00:15,666 so in this video
00:00:16,400 we're gonna be looking at the sales integration
00:00:18,633 and this is all about how we turn the sales
00:00:20,900 data that's contained in your point of sale system
00:00:23,266 Barra
00:00:23,666 integrates with 40 different point of sale systems
00:00:25,600 so all the major brands
00:00:27,166 how do we take that raw sales data
00:00:28,700 showing you how many times each button was pressed
00:00:31,266 into a record of how many ounces were sold
00:00:33,633 so
00:00:33,766 we can compare it and match it up to what was poured
00:00:36,300 in real life what we see a lot of bars uh
00:00:39,100 who come to us struggling with
00:00:41,000 is to deal with the complexity of this
00:00:42,866 and get it matched up with confidence
00:00:44,766 so we see bars using a
00:00:46,700 a manual counting method and Excel spreadsheets
00:00:49,366 or actually in many cases
00:00:50,433 they're using an inventory software
00:00:52,166 but they're not getting the results
00:00:53,500 down to the serving
00:00:54,700 and they kind of have this false sense of security
00:00:56,700 because they're using a dedicated piece of inventory
00:00:58,833 software it's solving the problem
00:01:01,100 unless they're using barcodes and scales
00:01:03,233 and investigating the errors
00:01:04,633 and actively managing
00:01:06,833 the point of sale buttons and all of that typically
00:01:09,633 they're swimming in data
00:01:10,633 and they've got a lack of clarity and
00:01:12,400 visibility into what's happening
00:01:15,100 so let's show you how this works with Bar I as always
00:01:17,900 our pro audits get everything down to the serving
00:01:20,633 and we provide assistance during setup
00:01:22,300 in the first few weeks
00:01:23,600 and then when you've got this nailed
00:01:25,000 you can use the service self service
00:01:27,166 but let's solve the problem first and then worry about
00:01:30,433 uh cutting costs by not having help
00:01:33,066 but the service is element of Barry's
00:01:35,000 important point of differentiation
00:01:36,666 that helps our clients execute to a better level
00:01:39,100 let me show my screen and show how this works
00:01:41,500 uh in detail
00:01:43,366 so here we've got a raw point of sale
00:01:45,500 in this case it's from Hartland point of sale
00:01:47,900 and we've just got this list of how many times each
00:01:50,566 all the buttons how many times they were sold
00:01:53,000 and it's a bit of a mess if we sort this
00:01:56,833 I've sorted this now for the liquor items
00:01:58,766 and just looking here at Tito's
00:02:00,600 we see that
00:02:01,966 this is where we start to see the complexity here
00:02:03,600 so we've got
00:02:05,100 three different buttons that include a sale of Tito's
00:02:09,000 they press three different amounts
00:02:10,400 and the biggest challenge is the single is 1.25 ounce
00:02:13,400 pour the Doubles two and a/2
00:02:15,766 and these guys have a smaller shot size
00:02:17,633 which is 1.1 ounces and so
00:02:20,000 adding that all together to determine how much we sold
00:02:22,400 is a little bit complicated
00:02:23,766 when you've got software it's easy
00:02:26,066 so here we have uploaded that weekly sales report
00:02:29,166 that matches the period uh
00:02:31,000 we're investigating here and we've written recipes
00:02:33,700 so the software tells us how many times each
00:02:36,033 button was sold what the button description is
00:02:37,700 and how many dollars were taken
00:02:39,666 during the recipe setup meeting
00:02:41,100 we learn all about your glassware
00:02:42,600 standard drink sizes signature cocktails
00:02:44,400 all that good stuff
00:02:45,033 so we can write exact recipes for each button
00:02:47,833 so shots 1.1 ounces singles 1.25
00:02:52,400 doubles 2.5 for this bar um
00:02:54,700 most of our clients do 1.5 as a standard
00:02:56,866 but there's a lot of variation around that
00:02:58,433 again it's custom to your bar
00:03:00,166 so here we look at the detailed product viewer
00:03:01,966 where we can see how this turns into a actual
00:03:04,700 sold bottles
00:03:06,566 so 107 sales of a drink that calls for 1.25 ounces
00:03:11,833 means we sold 133.75 ounces
00:03:15,266 which in bottles or units is 3.95
00:03:18,066 and if we do this for each button
00:03:19,800 we can see if there are missing buttons
00:03:21,633 confirm everything is correct and conclude that yes
00:03:24,000 we did in fact sell 5.7
00:03:26,466 and match it up against what we poured
00:03:28,833 so here we are for Tito's
00:03:30,100 these guys are doing a nice job
00:03:33,033 they've accounted for 90 basically four
00:03:36,000 94% but overall for the category they scored 98
00:03:40,833 so
00:03:41,166 Tito's at the moment is performing below the category
00:03:43,600 and is an opportunity
00:03:45,500 of the 33 missing servings in liquor category
00:03:48,500 a third of them or ten and a/2 were from Tito's
00:03:51,566 and
00:03:51,800 we put the context of what you were missing last week
00:03:54,300 so we can see actually
00:03:55,100 they're moving in the right direction
00:03:56,100 the loss has gone from 14 servings to ten and a/2
00:04:01,600 and we do this for every single product at the bar
00:04:04,233 so again we get the category level stats
00:04:07,233 total missing total missing uh units
00:04:11,500 and then if we switch over to the financial side
00:04:14,033 we can see
00:04:15,433 that these 31 missing servings in the category
00:04:18,266 at wholesale cost cost them $34
00:04:21,000 it's resulted in a liquor cost of 19.3
00:04:24,266 and my favourite stat in the
00:04:25,766 in the software is the achievable cost
00:04:27,866 which says what would your liquor cost have been
00:04:31,066 if you weren't missing a single drop
00:04:35,433 so that might never you might never get there
00:04:38,233 but it gives you a point to aim at
00:04:40,166 and again these guys are off by point nine %
00:04:42,833 and in the case of Tito specifically
00:04:45,233 we can see the liquor cost today is 14%
00:04:47,466 but should be 13.1
00:04:49,300 and they're missing $10 worth of the product
00:04:52,500 so if you are not getting this down to the serving
00:04:54,900 level of detail you're having trouble
00:04:56,500 integrating with your point of sale system
00:04:58,000 um reminder we integrate with 40 different systems
00:05:00,233 so all the leading uh restaurant specific square
00:05:03,800 um toast spot on Heartland
00:05:06,833 Aloha you name it
00:05:08,966 we can pull the data
00:05:10,066 and match it up to what you're counting
00:05:11,666 as well as providing a faster way to count
00:05:14,266 thanks for watching and
00:05:15,100 if you're interested
00:05:15,766 in figuring out how we can do this for your bar
00:05:18,233 um please book a demo
00:05:19,033 we'll be happy to dive in thank you
We've performed more than 30,000 bar inventory audits. Learn from our experience