# How to Create a Purchase Order Format in Excel – 7 Steps

The  sample dataset showcases information on ordered products. To create a purchase order format:

### STEP 1 – Enter the Company Information

• Enter the company information (Company Name, Street Address, ZIP Code, Phone, Email & Fax number) on the top-left side of the excel sheet:

### STEP 2 – Add Purchase Order Details

• Add the details the Order Date and Purchase Order (PO) Number.

### STEP 3 – Create the Vendor Information Section

• Keep the information about the vendor on the left side (Name of the owner, Company Name, Street Address, ZIP Code, Phone, and Email address).
• On the right side, enter the shipping address.

### STEP 4 – Create Shipping Details Fields

• Add Shipping Method, Terms, and Delivery Date.

### STEP 5 – Create a Description box for the Ordered Products

• Include: Item Code, Items, Quantity, Unit Price, and Total amount.

• To calculate the Total price of each item, multiply the Quantity by the Unit Price. Use the formula below in F20:
`=D20*E20`

### STEP 6 – Create a Segment to Sum the Total

• Add  Subtotal, Tax, Shipping Cost, Other costs, and the TOTAL amount.

`=SUM(F20:F25)`

• To determine the TOTAL amount, enter the formula:
`=SUM(F27:F30)`

• Create space to add the Signature and Date at the bottom.

### Final Output

This is the purchase order format:

<< Go Back to Excel Order Form Template | Accounting Templates | Excel Templates

Get FREE Advanced Excel Exercises with Solutions!
Mursalin Ibne Salehin

Mursalin Ibne Salehin holds a BSc in Electrical and Electronics Engineering from Bangladesh University of Engineering and Technology. Over the past 2 years, he has actively contributed to the ExcelDemy project, where he authored over 150 articles. He has also led a team with content development works. Currently, he is working as a Reviewer in the ExcelDemy Project. He likes using and learning about Microsoft Office, especially Excel. He is interested in data analysis with Excel, machine learning,... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF