{"id":215,"date":"2010-09-10T09:02:44","date_gmt":"2010-09-10T09:02:44","guid":{"rendered":"http:\/\/supplychain-mechanic.com\/?p=215"},"modified":"2017-09-03T12:27:08","modified_gmt":"2017-09-03T12:27:08","slug":"creating-a-purchase-order-template-using-microsoft-excel","status":"publish","type":"post","link":"https:\/\/supplychain-mechanic.com\/?p=215","title":{"rendered":"Creating a Purchase Order Template using Microsoft Excel"},"content":{"rendered":"

A purchase order is a document that is used when a business purchases products or services from another business \u2013 it is usually sent to the supplier (either as a document or as a EDI\/Electronic message) and describes what part\/products are required coupled with what price is being paid and what terms and conditions apply. In the purchasing process \u2013 it will typically come after the requisition and supplier sourcing phase.<\/p>\n

While purchase orders can include a number of different attributes (check out our article on key things to include in your purchase order template<\/a>) there are some basic concepts that all purchase orders will contain<\/p>\n

1\/ Your company details
\n2\/ Your supplier details
\n3\/ Your Purchase Order number or reference
\n4\/ Information about what you want to purchase (including quantity and price)<\/p>\n

Creating a Purchase Order Template<\/p>\n

Here\u2019s our guide on how to produce a generic purchase order template in Excel \u2013 if you\u2019d rather not use a spreadsheet application to produce your template word processing software will do just fine as well. Check out the video below and you\u2019ll see how we\u2019ve structured our template.<\/p>\n

1\/ Starting with a new workbook enter some information about your company including:<\/p>\n

\u2022\tYour Company Name (and logo)
\n\u2022\tYour Company Address
\n\u2022\tYour Company contact details<\/p>\n

2\/ Enter some reference information about the Order including<\/p>\n

\u2022\tA Title that reads \u201cPurchase Order\u201d \u2013 this clearly identifies what the document is
\n\u2022\tA Purchase Order Number
\n\u2022\tThe Date of the order (this could be the date that the order was raised).<\/p>\n

3\/ Enter contact details for your supplier include their company name and address<\/p>\n

4\/ Enter some information about where you want your order delivered too (this is often referred to as a \u201cship to\u201d address). <\/p>\n

5\/ In the middle of the document create a table where you will record the items you\u2019ll want to purchase. Include room to record the following<\/p>\n

\u2022\tPart Number
\n\u2022\tPart Description
\n\u2022\tQty (how many your buying)
\n\u2022\tPrice Each
\n\u2022\tTotal Price.<\/p>\n

6\/ Add an area under your table where you can record the total price for your order include some cells that will calculate any tax or ancillary costs that you\u2019ll be charged.<\/p>\n

7\/ Create a text box that you can use to record additional information or notes to accompany your order.<\/p>\n

8\/ Include a sign off block as necessary<\/p>\n

9\/ Add some contact information on the buyer (or who is responsible for your purchase order.)<\/p>\n

10\/ Consider how you will include any terms and conditions that apply to your order<\/p>\n

11\/ Add some color and some formatting<\/p>\n

<\/param><\/param><\/param><\/object><\/p>\n","protected":false},"excerpt":{"rendered":"

A purchase order is a document that is used when a business purchases products or services from another business \u2013 it is usually sent to the supplier (either as a document or as a EDI\/Electronic message) and describes what part\/products are required coupled with what price is being paid and what terms and conditions apply. […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[42,44,43],"class_list":["post-215","post","type-post","status-publish","format-standard","hentry","category-blog","tag-excel","tag-order","tag-template"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7Ittq-3t","_links":{"self":[{"href":"https:\/\/supplychain-mechanic.com\/index.php?rest_route=\/wp\/v2\/posts\/215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/supplychain-mechanic.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/supplychain-mechanic.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/supplychain-mechanic.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/supplychain-mechanic.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=215"}],"version-history":[{"count":1,"href":"https:\/\/supplychain-mechanic.com\/index.php?rest_route=\/wp\/v2\/posts\/215\/revisions"}],"predecessor-version":[{"id":216,"href":"https:\/\/supplychain-mechanic.com\/index.php?rest_route=\/wp\/v2\/posts\/215\/revisions\/216"}],"wp:attachment":[{"href":"https:\/\/supplychain-mechanic.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/supplychain-mechanic.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/supplychain-mechanic.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}