Streamline Your Logistics Invoice Format in Excel for Education

Logistics invoice format in excel for Education

in this video i'm going to show you how you can create your invoice template i will be doing it in microsoft word but if you want to use the google docs or google slides or powerpoint you can follow along because all these softwares have these similar features so without any further ado let's get started so i have a blank one page microsoft word document open so first of all we have to do the page setup and for that you can go to the layout and then size and from here you can select the required size either lighter i am going to keep it as a4 the next step is to change the margins click margins custom margin and i'm going to keep 0.5 all around so in my case the unit is inches in case uh you are using the uh word processor in centimeters then you have to calculate it yourself or you can convert the centimeters into inches and then click ok so now our margin is set and now we are going to start making the invoice by giving the heading first so i've kept the font to 28 to keep it at this font so this is our invoice heading and now uh towards the right side of the page you have to give the either logo of your business or you can give the address in my case i'm just going to add the address here and for that i'm going to insert the table so to insert the table click insert go to the table and we are going to select the single column and around four rows give the name of your business so here you have to add the address of your business so we have to add one more row and uh in that we're going to add our telephone number so i'm just giving a imaginary number i am not really sure that what is the code for uk so as it is just a sample you will modify that this invoice template link will be available in the description for you you can just download that and amend this template as per your own requirement so i've reduced the font of that rest to 10 and now we just have to hide this table so we'll be selecting no border so here we are going to write the first line that is the invoice number and date and then we are going to add the underline just to fill in this space then we are going to add the date so the next we are going to add the build to and for that we are going to again insert a table but this time we'll keep one column and one row so we are going to add this bill true and i'm going to fill this with black name address email phone number so we are going to copy this bill number again and paste it here and here we are going to add the table with four columns and 12 rows so these are eight rows we are going to add four more increase the width of the row i'm going to keep it 0.4 and then we'll make the first column larger in width because we have to write the items which we are selling over here so for the rest of the three columns i am going to distribute these columns equally here we are going to add the subtotal we'll write sales tax saving and the last is grand total so here we're going to merge these uh columns and rows you can write anything over here you can give your signatures here at the bottom we are going to again copy this black single row table and paste it over here and we'll write the thank you message increase the width of this row by 0.4 make it in the center and increase the font around 20. now is the last step and that is to save this invoice as a template so whether you want to save it as a pdf if you want to reproduce it or if you want to take multiple pages you just have to go here click save as click the pc where you want to save it give the name and from the file type you can select the pdf but in our case we are going to save it as a template for the template so we are just going to click save so now our invoice is ready and if i want to save it as a pdf i can also do that just by changing this to pdf and clicking save and as you can see that it has automatically opened this pdf page in any case i have given the link of this invoice template in the description below you can visit the link and buy it from my store on a very nominal price both pdf and word would be available and if you want to see more digital products videos like this do subscribe to this channel and thanks for watching till the end