Tip:
Highlight text to annotate it
X
There are three stages to completing a Bar-i inventory audit. First of all,
we scan and submit the invoices, preferably before 2:00 PM the day before you
do your counting. Stage two, you do your counting and run the point of sale
report. The third and final stage is to complete the variance report. I'm
going to show you how to do that in this video.
You know when the variance report is ready when you receive your email.
Then we'll go to Internet Explorer and open up the variance report. Like
to find Dropbox using this shortcut on the left here. Find your bar name.
Obviously the variance report is kept here in the variance report folder.
You can double click to open it up. You'll see that each questionable item
that needs to be checked has its own little section. This case we got Coors
Light is showing half a keg more than expected. That's based on a previous
count of 15.3, 36 invoiced. Basically 45 are sold meaning we should have
had 6.3 kegs but we actually found 6.5.
When we want to check our counts we can see down here in this table that
the counts and zone names of what was counted is shown, making it easier
to check. After checking we found that we over counted, so we say decrease
count by one. Then we can move onto the next item.
Our next item is 90 Shilling. Same deal, again, we went and checked the
counts and found we had actually miscounted this. Increase the count by
one. It's helpful when you can to give us a brief explanation, so we're
sure we're making the appropriate adjustments.
The third item is Rumple Minze, it shows 15 missing. We checked our counts
and then realized the problem was this, 15 invoiced, because those had been
sent back. We can indicate here, decrease invoiced by 15. Write an
explanation. Just remember that the easiest way to handle that situation
will be to note on the invoice that the product was not actually received.
Svedka is showing two bottles more than expected. After investigating we've
remembered we made a trip to the store and bought two. We need to indicate
that, again.
Now next item, well *** is showing two units missing. After investigating
we remembered we did not communicate that we leant two bottles of well ***
to the next door bar. We got to make sure we get those back. By indicating
this we can make the appropriate adjustments.
Crown Royal has one unit more than expected. Crown Maple, sorry. That was
simply because we didn't have an invoice for that product when it was
dropped by a rep. We can put that here, received without invoice. It was
one bottle. Let's close that up.
Our seventh item on the report here is the Fireball, popular product at the
moment. We double checked our counts, our invoices, found they were
correct. No adjustment required that is genuinely missing. I should do
that.
Now that we've completed all the items in the variance report, the final
stage is simply to save it and notify Bar-i. This file is already stored in
Dropbox, so we can simply press control S to save it. The final step will
be to send a short email to sc@bar-i.com to let us know that the variance
is completed. We can complete your report and send it back to you.
Thank you for watching.