Create Your Excel Invoice for Inventory Effortlessly

Excel invoice for Inventory

hi so are you looking for an exciting Inventory management system where you can record your in and out of the inventories where you can receive payments from the customer where you can extract the data using different criteria then yes this video is for you let's begin the demonstration first of all you will list down all your items so you will click on inventory info then you will be able to add a new inventory by clicking add new so here let's say you will take your item that says shirts they are comes in pieces let's say and we have an opening inventory of let's say 1000 pieces right and then you can click on update and press yes so you can see your shirt is listed so if you click here you'll be able to see the shirts here I have we have 1000 pieces right and this is also listed in your inventory info sheet you can add as many as uh items you want you can list here so let's say I want to add another item let's say pants so pants comes and let's say pieces again and I have an opening inventory of 500 Pence and I just update it right so you can see when I click on the pens it says 500 and when I click on shirts it says 1000 once you added the item you are not able to change the inventory memes and anything directly from here you of course where you can change the opening number if you want right just change and click on update then we have a record of the customers so you will click on customer info and here you will list down all your customers so let's say you first click add new to add your first customer so my first customer is let's say Excel doors private limited and you can add is all the information what is invoice to the contact the main phone whatever field you are interested to fill you can choose to fill so I just add one two three the contact number let's say one two three four five six seven eight and whatever information you would like to add you can add you can also add as opening balance of what how much money you have to Let's receive from this customer so let's say uh he has 10 000 receivable so I just added 10 000 here and just click on update and press yes so I have successfully added my first customer let's add another customer let's say XYZ private limited and I can also add further information about uh this company if I want and his opening balance let's say is twelve tiles and I click on update and press yes and I successfully added my second customers of course when I'm buying and selling something so I will be having information for the vendors as well so in order to maintain the database for the vendors we have a Defender info tab so we will click here and you will add your first vendor so let's say your vendor is ABC company limited and here you can add his address XYZ Road um Florida right and here you can add his balance so let's say his balance is 15 000 right and you can click update and press here so you successfully added your first vendor similarly you can add another vendor so you can add as many as vendor you want so I just click add new here and my second vendor is uh let's say uh Pakistan company right and one two three and his opening balance is let's say sixty thousand and I just update and press yes so you can see this we have added information the inventory info sheet so we have the opening balance of 1000 so we have available quantity one thousand because there is no in and out yet this is the customer information record you can scroll up and you can see here right similarly here you can see the information for the vendors now uh let's say now you are going to purchase your inventory so when you will purchase something you will purchase from your vendors and you will purchase an item so stock will come inside your Warehouse so you will click on inventory in the inventory in will open this form like that you will select which item you are purchasing so let's say I am going to purchase shirts as soon as I click the shirts it says we have available quantity of 1000 we can see at the right top right side uh from which company I am purchasing I am purchasing this from ABC company let's say so it is also saying okay so we have a balance of 15 000. so let's say now I'm going to purchase 2000 quantities at the price of 100 so my balance is 200 000 now okay so if you want to add any comment you can add and you just click on ADD right so you just edit your first item and once you add all your items you just click on record are you sure you want to record this transaction you press yes and you can see your 15 000 has been adjusted and now uh 100 85 000 is payable to this company and now you have a new Fresh record of 30 000 and same you can see here uh on the individual tabs that your inventory has increased by three thousand by two thousand and your vendor information has been increased by 200 000 the total purchase right similarly let's say now you are selling to your customers so we have these items and we have two customers listed so let's say I'm selling pants uh I'm let's say I'm selling uh I already have 500 pieces available I can see so let's say I'm selling 200 pieces and I am selling at the price of fifth 150 let's say so 30 000 uh is the invoice I can add here okay I have to select the customer so I'm selling this to this company it has 10 000 as a balance I just add here I'm also selling shirt uh to this company and I'm selling 1500 shirts at the price of let's say 700 right and I just add it here same company and I recorded press yes so you can see and now this is the amount receivable from this company and now balance left for the shirt is 1500 and the pens is 300 similar simultaneously right so that's how we just recorded uh our inventory in and our information you can see from here as well that we have uh sold out the shirt and pants ingly so net balance is also coming here moreover I of course when you are buying and selling you will receive and pay to your vendors as well you will receive payments from your customer you will pay to your vendors so let's say your customer came to you okay uh this is the money uh and this is the balance whenever you click the customer you'll be able to see the balance so let's say you receive 500 000 uh from this customer you can select the dates from here and you can it's an optional feed if you want let's say he brought a check to you so you can type or check ABC bang right so it's an open feed you just click on record press yes now you have this palette select 590 000 right for this customer and you just got your payment similarly you can pay to your vendors so whenever you click on the vendor's name you'll be able to see how much you have to pay so now you have to pay a 185 000 to this company so let's say you just go and paid some extra so you will have some deposit with the company so let's say you pay 250 000 right uh with the check or one two three let's say and you just record in price years and now you have 65 000 receivable from this company all this information is being registered in our registered right from which register is coming is getting commands uh who are the parties inventory species quantity price and amount right so all information is being listed here and if you want to pull out uh the data from your register you can click this button pull data right and here you can select the cried area on what criteria you want to pull out the data from your register so let's say I want to take out all the information pertain to excel doors right on this certain date range so all the information we have recorded today so it will bring everything so just click get DF so separate system will separate out the information for you in a separate sheet called Data pulled right we have all the uh data listed here and this is a summary that the total cell we have two transaction uh one uh payment transaction we have done and one and two is the inventory out transactions the sale transaction right so all the information is coming right here so so if you want to have this inventory management system please check out the description and download your copy and if you have not subscribed to this Channel Please Subscribe now and share with others thank you so much