Autograph Beverage Inventory Made Easy

Digisign alcohol inventory

hi friends today I'm going to teach all how to make a bar inventory in Excel first of all let us open an excel sheet and in this second column and then in the first column in the second row let us enter date then give a column and enter opening balance for B this transforming balance second received I receive it is sealed sources that come in and then say what shall we have on the day then anything complimentary is there if any and then the closing bell CB stands for closing balance and I'm the column last column we are going to have a variance Regan's means whether is plus or minus okay now let's enter the date of the month of August - 18 2018 and then in yeah there we go then drag this till let's study first and that we throw 3330 first there we go to the first and below doctor 31st just leave arrow and type in total total okay there we go and now let's highlight this with the book box let's put a box yeah added this and then go out and select this and selector box same thing here that's how that this dragged it down to the total then go let's go very good at all in the first crow will highlight this from here to here and then merge it modded so that becomes a one cell and now when Jesus a dark box like you know there's a box here here we go okay let's reduce the width of the column by highlighting this to be yeah there we go and let's get this column let us make it small yeah there we go then and under below and that's the seats column right send the receive column below let's enter a formula by going up here what are some click on the Sun and then drag it here the 31st this is to know with the how many bottles you have purchased for the particular month now same formula you copied for the three for the sales and to the complementary so you will know how many series are there and how many complementary you have for the month just forget the same formula the same thing I had coffee juice to the last one so we will know how much variances are there like how many plus four how many - at the end of the month as I Danny short already are running exists now this is let us put it in the formulas now what is called a closing balance closing balance is required to open the bracket opening balance plus yes you close the bracket - again upon the bracket sale plus complimentary right and that's callosum balance let's drag this down till till you cut it first there we go now what is radiance radiance is just again equal to its operating balance of the next day - closing balance or the previous day so this for one item now you want to have so suppose this is mineral water you won't have years you have to have whiskey so just I let this whole problem I levy coffee and leave a column figured and placed it there you got another one right again you want one more now just for here now you want for whiskey put here taste again here on ye got again you need another one for wine suppose click here this right suppose we go now we've got four columns now let us decrease decrease the size of this middle column and again I like this and decrease the rate again to our game again because I get small thought the gaps to divide the items again handed this decreases again I love this [Music] what is this the closest now we have see there's a gap in between each items [Music] we are journalists in here again references and more the center let's put mineral water here and my water is [Music] but what he got the next one will put a beer brother su advertiser here here will have a whiskey Jack Daniels a is Danielle and next layer will have wine like suppose to him back turn language or it's a white wine this is how we make it how it looks and now I'll show you how it works suppose you're opening balance of manure water is 5 this is a difference showing in the closing balance five is a closing balance and Sheen minus 5r evidence that because you have not entered the second they suppose you'll be seat five on first she's applause investors come and now suppose the salt to see that's been defense in the frozen that is a to the diamonds suppose calm down give us one just plus one enter seven and then the second day suppose when you take a physical stop and if we see that you've ever got eight bottles of mineral water just per se see the radiance and trying one Vince record one axis with closing balances seven and you got eight services so suppose if you're opening balance is okay you got it Plus so there's a closing balance is six make it six see the difference here in radiance we've got minus one means you are having - one shot there one bottle short in one second because our closing damage is 7 and what if your closing balance is opening that into seven let's see this change seven so there is no variance Mencia then it's correct and again there was a sale of three on second no complementary balances closing balances for again here they are closing down the suppose you're out of stock up for opening balance you just copy this formula here down drag it down say suppose here it was six so you got to access it's simple so same thing with Budweiser Jack Daniel and the wine but here now suppose you all want to know how many cases have gone like this formula which I put here just divided by the number of bottles in a case suppose you in our case you're having 12 water so divided by 12 for because so not entered of course and we made here well I received 12 balls you know it's one case same thing here but wiser / 24 verse 24 bottles in one carton Swan taiga 24 that is so so right and now why now of this is Jack Daniels like general whiskey you have to / [Laughter] / friendly fire because the window enter into a system 25 Mack system as suppose you received 25 thanks it's one bottle see that down change this wheel is taking place it means one bottle you received and here suppose in Budweiser they received 24 bottles so see that you know this is one carton a Budweiser and suppose the wine for wine is in glasses so how many does Ramon what will fire glasses so suppose you received on water five glasses just spy glasses so you go down go down and change the formula here because / means one bottle my glass is in fat loss one bottle that's how it is and now see this now we cannot see what is on top ours down when when you drag and you drag this aside and they try to scream decide if one we will see the date see this they won't be able to see the date see I'm bagging it cannot see the date when your parent bagging down you cannot see that so let us highlight let us freeze the pins but keeping the cursor here you keep the cursor here right on the date front and the Delta column this kids the crap outta here and go to you and then there is a option called free spins pretty space please now see I suppose I go down and he see this see okay this is how it is and now suppose I'm going and going to the right taking my croissant to the right see this did you see there got it I then go down top so you need only want a bit column will be only once but will have multiple item follow-ups like for your mail whatever wiser like Danielle and the wines of whiskey's or vodka or whatever product you have in your work according to that I hope you like my video and if there is anything please press the like button and share it with your people with all the four friends so that it be easy for them to do an inventory in Excel without any headache and your boss also will be happy thank you for seeing my video and watching my video goodbye [Music]