Free Purchase Order Template Word+Excel 3 Min Reading. Making an official purchase order template can be a pretty hefty task, we offer you here a purchase order template so you do not have to worry about making a purchase order from the scratch. But before we get into the details of the template, I would like to explain to you what a purchase. Purchase Order No - purchase order numbers can be in any format and are used as the primary reference for including the purchase order details on the PO sheet. If you are only going to use the template for supplier invoices, this column can be left blank or you can enter purchase orders in any generic numerical sequence.

If you have many vendors or suppliers and create more than just a few purchase orders per year, you will want to use some type of PO tracking system. For tracking large numbers of orders, you may want to look for custom PO software or a database solution. However, if you just need something simple for now, this purchase order tracking template may be just right. You can use it along with our free purchase order template.

Use this spreadsheet to list all the purchase orders that you create, track their progress (draft, paid, complete, etc.), and create simple summary reports of how much you have paid to individual suppliers.

⤓ Download

Template Details

License: Private Use
(not for distribution or resale)

'No installation, no macros - just a simple spreadsheet'

We Recommend ...

The Purchase Order Tool by Someka.net allows you to create POs as PDFs, select from a product list, and keep a database of past orders.

Learn More ►

Description

List all your purchase orders and display a summary of payments made to all or individual vendors. You can choose to show all purchase orders or just the orders for a particular supplier, using Excel's built-in filtering feature.

Instructions are included within the worksheet.

This spreadsheet does not include a purchase order form. You can use this spreadsheet to track any PO form that you want - it does not have to be a PO template from Vertex42.com.

Features

• Includes a payment/aging summary for all orders or for individual vendors.
• Use Excel's Sorting and Filtering feature to sort by date, PO number, vendor, etc.
• Customize the list of options that show up in the Status drop-down box.
• Gray-out rows by entering a Status of 'Complete' when a delivery is received. (This is done using Conditional Formatting)
• Set the status of an order to 'Draft' to keep it from showing in the aging summary.
• No VBA/macros

References

• Create a Drop Down List in Excel at vertex42.com

Po Template Excel Microsoft

Related Content

Making an official purchase order template can be a pretty hefty task, we offer you here a purchase order template so you do not have to worry about making a purchase order from the scratch. But before we get into the details of the template, I would like to explain to you what a purchase order really is, and why it is so important in the business world. You may also need a Sales Invoice Template.

Po Template Excel Free Download

When you start a new company, you are surely aware of the fact that it is not a one-man job. It requires a whole lot of social and professional interaction, it requires manpower, it requires ideas, and most important, it requires products. The business may entail a lot of other goals and objectives, but we can all agree that it can simply be defined as selling and buying products to make a profit.

So every company/ business that wants to make a name for itself knows what the business world demands. It is competitive and knows no mercy; you have to constantly put up new products, more products. In other words, you have to have something different on the plate. you may be looking for Travel Itinerary Template.

With that being said, making and releasing products in itself could be a problem. You just do not make one overnight and start selling it the next day, you would need employees, and the primary requirement in making new products is the resources or raw material that ultimately gives you final output. Where do you get these resources? Easy, you purchase them from another seller. That is where you would want to know what a purchase order is and how to use a purchase order template. Download Sales Invoice Template.

What is a Purchase Order?

Po Template In Excel

A purchase order is basically a document the buyer uses to officially list a set of certain products that they have to buy in the future. The significance of this document is that the buyer legally binds a seller by committing to pay to him at a fixed price in the future.

We have all online shopped before, I am sure. Issuing a purchase order can be pretty similar to cash on the delivery online experience. You order a set of items before you pay for them, and you pay for them when they arrive at your doorstep. Although there is a heap of difference, including the fact that a purchase order (in this case) is purely a business-to-business transaction, between the actual processes, the basic outline is pretty similar.

Po Template Excel Free

You want to make a new product, or you want to resupply some old products, you order a list of raw materials, or supplies you would make that particular product with through a purchase order template, the supplier delivers the supplies to you, you pay the supplier after your items have been delivered to you.

Excel Po Tracking Template

What this Purchase Order Template offers you

How can you make a purchase order, you ask? Well here is the fun part, you don’t! Because we offer you here a free purchase order template that you can use. It has everything you would generally need in a purchase order template, and it is very easy to use as well.