Effortlessly Create Bulk Invoices with the Bulk Invoice Generator from Excel for Operations

Bulk invoice generator from excel for Operations

hello everyone this is Arun and today in this video I'm going you to provide a walk through of an automated uh invoice generator so here it is an Excel sheet it generates an automatic PDF invoice through this data so this is a um firework data where we have wholesale retail and case prices and we have the quantity as well so we have prar this sheet uh using ex sheets and then we have a button over here which get which will which when submitted then the print out of that uh invoice will get sated so we have this data sheet where we can put our stocks uh data that we need to purchas so the First Column this one is a drop down column where we need to select which kind of uh product that we need to select so we have three options here first is the retail then whole and in the case so whole whole sale retail as well as case now here we have three columns retail wh sale and case we have the pric is uh provided here and then the description left here in the C colum uh the G column is a total column where once we select the whole this drop down let's say whole save prices and if I put the quantity here then the price will get Chang automatically so we have quantity one for whale so we have 150 so it will provide you 15 let suppose I put the quty to here then um it will provide us the total for 300 and if I change this to let's say I am changing to then 500 will be there because 250 is on price so this is the logic there putting the quantity and then the total Val change now uh this is uh Dynamic uh sheet so we can fill let's say I'm filling here full sale for one and then uh selecting as SP forties and then the other one is we can this one as well so total four products I'm selecting here I have a lot of products here and the prices as well so I mean it's it's a huge database that we now uh we have a service invoice as well so this is a fireworks invoice uh for my that we have created in the now um this is the perit and we we have a lot of available so let's go the print button now I'm clicking on the print button now this is generated this is the PDF file that has been generated from uh from the macro so to quantity this is our logo this is our Firs so let me show you the PDF file so here is our PDF file and uh open here is a PDF file that has been generated automatically so this is the two quantity of whole prices this is the price that we put here and the total is reflecting and so on this is uh this is the price U the last one the one month 12 month that we entered here I mean this is the column or packaging part Edge column so we to put the packaging over here as well when we are sending the invoice so this is a dynamic uh program that we created to generate the PDF invoices uh once we select all our products and put the quantity uh by selecting wholesale retail case so then uh if and once we uh submitted this one then we once we click on the print button then our invoice is generated where the file is already saved so my macro file is saved in this folder wherever I mean it's uh saved on my desktop so here is inv folder where my file is saved so this invoices is generated over here and uh we can just send this invoice to our customers so I mean this is a customized uh invoice that we created for one of our clients so if you are interested in the same uh invoice then you can just reach me out over my email address uh or Whatsapp uh I will share you both of them online description part of this video so yeah you can just teach me out you get this file or you need some customizations on in this F so I hope you enjoyed this video and it might be helpful for you as well so thanks for watching this video and have a good day we'll talk soon thank you