This purchase order template (excel) is a document that you can use to request a purchase from a vendor. Use this template to make your life easier. By having items laid out clearly, this template will save you time when you need to create and fill out purchase orders.

This template was designed in Excel. Alternatively, if you prefer using Word, you can check out CFI's purchase order template (word)! Additionally, this template is part of CFI's small business and start-up templates collection. Check out these templates if you are a small-business owner. Save time and money with these efficient templates!

Components of a Purchase Order

Properly filling out a purchase order requires several pieces of information. All of this information is included in different sections of this purchase order template (excel). As a refresher, here are the different pieces you need to fill out and what they mean.

Company Information: the information relating to your company; the address, phone number, email, and website

Order Information: the date and the purchase order number to identify the order in the future

Vendor Information: the vendor's information; company name, the contact's name, address, and phone number

Shipping Information: where the order will be shipped to; recipient name, company name, address, and phone number

Requisitioner: the person who requested the purchase order

Shipped Via: the shipping method

F.O.B.: stands for 'free on board', the point which ownership is turned over from the buyer to the seller. For example, F.O.B origin means that ownership is transferred the moment it leaves the seller and begins shipping

Shipping Terms: the terms for how the order is sent. For example, prepaid shipping terms means that the buyer has already paid for the shipping within the order, leaving the seller to use those funds to send the order.

Delivery Date: the date the order should be delivered by

Purchase Information: the information associated with the order; item ID (if applicable), description of the item, quantity of the item, per unit price of the item, and the total price of the number of items ordered

Once all this information is filled out, the purchase order template (excel) will calculate the subtotal. Afterward, it will allow you to input a shipping rate and a tax rate. Then, it will calculate the total price of your purchase order.

If you want to learn more about finance for startups, check out CFI's startup financial model template or our startup/e-commerce modeling course!