Purchase Order Template for Excel
Do you need a simple and yet professional software solution for creating purchase orders that is right for your business or a purchase order software that helps to create your own purchase order forms? Why not try our free Purchase Order Template for Excel that is designed from scratch and works in nearly any major spreadsheet program like Excel, OpenOffice Calc or Google Docs. You can customize it to create your own printable purchase order forms.
The purchase order template was originally designed to complement our sales invoice template and packing slip, which means that all this templates can work hand-in-hand and represent a perfect solution as for you as well as customers that buy from you.
Purchase Order Template
for Excel®, OpenOffice
After downloading this spreadsheet first you'd need is to customize for your business and update it with your company details such as company name, billing and shipping address, by updating values in square brackets [...], there is also more, this version will also let you select a colour for your template from the drop down menu.
If you are planning to use this spreadsheet with more then one supplier, you can then create template for each vendor that you are going to use your purchase order with, by updating values in cells relevant to a vendor.
When you are done customizing, save it as a template (.xlt) file, in-fact we suggest to create templates for each vendor, to avoid typing new vendor details again and again.
After completing your purchase order, the best and possibly the fastest way is to convert or print it in-to a PDF file (this may require an additional software like Adobe® Acrobat or similar) and then send a PDF file via e-mail to your supplier. You may also need to save a copy for your own records.
by Alex Bejanishvili of Spreadsheet123.com
PO 1.01 (Trial)
Requirements
Microsoft Excel® 2002(XP) or Higher
License
User License Agreement
Help & Questions?
Contact Us
Support
Visit Support Page
Purchase Order Pro
Professional Version PO1.05
The professional version of our purchase order contains a landscape version in addition to the standard portrait provided above. Both versions have identical functionality and can easily be customized to meet requirements of your business.
All Spreadsheet123 trademarks, logos, links and copyright notices are placed outside of the printing areas and will not be shown when printed.
Specifications of the unlocked Purchase Order
- Unlocked - so that you can customize it a bit more
- Contains Fields for: Logo & Company info
- Ability to add more rows
- Technical Support (for 90 days)
- 3 Bonus Spreadsheet Included
PO 1.05
File Type
zip
File Size
~57.0 KB
Requirements
Microsoft Excel® 2002(XP) or Higher
(PC & Mac)
License
Company Use EULA
Bonus #1: Purchase Order with Customers List
Version of the spreadsheet, which also contains a list of customers, on the separate worksheet. You can select your customer ID from the drop down list, which automatically populates cells containing your customer information.
See screenshot
Bonus #2: Purchase Order with Products List
Yet another modification very similar to the one above, that allows to create and maintain a list of your favourite products (a Price List) that also contains an item code and unit price. Once you populate this list with products that you commonly buy, creating purchase orders wont take much of your time, since you can select products from the drop down menu in the description column of the main worksheet.
See screenshot
Bonus #3: Purchase Order PRO
Version that contains list for up to 5 different suppliers and 5 different product lists accordingly, which means that you can create one template and use it to order from 5 different suppliers.
See screenshot
Buy unlocked version of Purchase Order Template risk free with 90 day full money-back guaranty!
Configure your browser to allow pop-ups before proceeding to payments screen.
If for any reason you are not able to download this template after making a payment through PayPal, use our Contact Us form to contact us with your Paypal Transaction ID.
Using the Purchase Order Template?
All values placed within [square brackets] must be replaced with values relevant to your company or to your supplier.
- Company Name and Address: Change the name to the name of your company at the top of the page then scroll down to the bottom of the form to enter your company address.
- Vendor: Replace values in the cells containing information about your supplier. Value entered in the cell containing [Name], [Phone], [Fax] and [E-mail] will also replace values in the part of the form that contains contact information of the vendor.
- Ship To: Should contain a name and address of your company or a name and address of the branch, where you want the goods to be shipped to.
- Ship Via: The cell should contain the name of a shipping carrier company requested by the buyer such as DHL, UPS, FedEx or any other.
- Shipping Method: For common trading terms used in shipping goods internationally check Shipping or F.O.B. at Wikipedia.
- Shipping Terms: The field usually describes the payment terms, method of payment or when the payment is due.
- Notes and Instructions: This block is used for explanation or any special instructions such as delivery or payment terms usually set by the vendor.
Printing and Sending your Purchase Order
You can print your saved purchase order and then send it by standard mail service or fax it to the supplier, but the much quicker way is to convert it or print it as PDF with help of a PDF conversion software like Adobe® Acrobat or similar, and then send it via e-mail.
Other Purchase Order Software
- Purchase Order Templates on Microsoft Office Online.
More Related Templates by Spreadsheet123
Share our Purchase Order Template
If you did find our purchase order useful and would like to recomend it to others on your blog, website, Facebook or Twitter, please use the HTML code below. Thank you in advance.
