Get the purchase order forms bar

Video instructions and help with filling out and completing online purchase order forms bar

Hi everybody and welcome to this video on how to create a purchase order template using Excel first of all we're going to begin with a new workbook and we're going to enter some information about ourselves about our company so we'll start off with our company name and our address details now we're just going to put some dummy information here but you get the feel that we're just creating a placeholder to put our address and our company contact details you we'll finish off with our company telephone number she'll just enter here right in the cell and as you can see there's a company address details so the next thing we want to do is just make clear that the document is a purchase order so we're going to enter the words purchase order onto the document add some information about the purchase order number its date and which is at the data so now we've got some basic information about the document and we'll add some inflation now about the supplier the people were buying from or the vendor and just to make things easy here we're just going to cut and paste the our company details and then we can just change the headings to represent the supplier so we'll just change that here to you a vendor company name there we go next we're going to add some information on will be on the products shipped to so are shipped to address and again we'll just cut and paste the address information we've created earlier just to make it nice and easy so the ship to address is telling your supplier where you want your items and send to deliver to and that might be different from your normal business dress so it's important to have that there so we'll just go back to the document header and enter a placeholder for the buyer so the person that's ready to the purchase order and somewhere to record our shipping terms or Incoterms so we'll let just move that up there so here we've begun to add in the information that we'd want to store about the parts we want to order so what part numbers were ordering a description how many we're going to order what price we expect to pay and a column to enable us to add up the total price and we'll just format it here we'll Boldin it okay we'll add some formatting add some gridlines and create a little table here where we can record what we want to order and we'll just do a few rows when I'm going to do that many but again you can add in as many as you like on your purchase order and again we'll have some gridlines here now we'll just tidy up the description area just make that a little bit wider probably ought to do that because your description is going to be words and and typically that'll be bigger than your part number so plenty of space there for a nice description about what we want to order okay we'll jump down to the bottom right hand side now and we'll just begin to add in our subtotals and information about what tax we're going to play on the order and a grand total you might want to as well think about just recording like an other...