✦Template Printable Ideas Insights

"Create Purchase Order in Excel"

By

Creating a purchase order (PO) in Excel is a crucial step in managing your business' supply chain. It helps you keep track of what you've ordered, when it's due, and how much it costs. Here's a step-by-step guide to create a purchase order in Excel, ensuring you cover all essential aspects and keep your records organized.

Before starting, ensure you have the latest version of Excel. For this guide, we'll be using Excel 2016 or newer, which includes the modern style of themes and formatting.

Setting Up Your Purchase Order Template

First, let's create a basic PO template. Open a new workbook, and on the first sheet, add the following fields:

Order Form Template Excel Download At Templatecom
Order Form Template Excel Download At Templatecom
Purchase Order with Price List
Purchase Order with Price List
Purchase Order Template for Excel | Simplify Your Business Payments
Purchase Order Template for Excel | Simplify Your Business Payments

1. **Header:** Please, Company Name, Your Company Address, Phone, Email, PO Date, PO Number

2. **Details:** Vendor Name, Vendor Address, Shipping Address (if different), Purchase Order Date, Expected Delivery Date

Top 8 Purchase Order Templates - Excel Word Template
Top 8 Purchase Order Templates - Excel Word Template
Purchase Order Template (Excel, Editable, Printable)
Purchase Order Template (Excel, Editable, Printable)
a blue and white planner with the text, most important tasks plan
a blue and white planner with the text, most important tasks plan

3. **Items:** Item Name, Quantity, Unit Price, Discount (optional), Tax (optional), Line Total

4. **Footer:** Subtotal, Less Discount, Plus Tax, Grand Total, Terms, Valid Till Date

Formatting Your PO Header

Format the header section with a larger, bold font for your company's name and address. Add your company logo or signature for a professional touch. Align the PO date and PO number to the right.

Purchase Order Template for Excel
Purchase Order Template for Excel
Order Form Word Templates – Streamline Your Purchase Process Today
Order Form Word Templates – Streamline Your Purchase Process Today
10 Plantillas gratuitas en formato Excel para realizar ordenes
10 Plantillas gratuitas en formato Excel para realizar ordenes
Purchase Order Template for Excel
Purchase Order Template for Excel
Editable Purchase Order Template: Small Business P.O. Excel (Digital Download)
Editable Purchase Order Template: Small Business P.O. Excel (Digital Download)
Invoice Template for Small Business: Download Free & Printable Forms
Invoice Template for Small Business: Download Free & Printable Forms

**Tip:** Use Excel's Merge & Center feature to combine cells for headings like 'Please, Company Name', and wrap text using Alt + Enter for multi-line headings.

Formatting the Purchase Order Footer

Below your item list, create a footer section. Use the SUM function to calculate the subtotal, and use other formulas to subtract discount and add tax if applicable. Use currency formatting for all monetary fields.

**Note:** You may adjust this based on your accounting practices. Some companies include discount and tax in their pricing or use specific formulas based on their business needs.

Have you ever wondered how to create a delivery tracker in Excel?
Have you ever wondered how to create a delivery tracker in Excel?
Purchase Order Template | Free Printable Invoice for Efficient Business Orders
Purchase Order Template | Free Printable Invoice for Efficient Business Orders
Construction Estimate Template | Word, Excel & PDF Format
Construction Estimate Template | Word, Excel & PDF Format

Adding Items to Your Purchase Order

Now that your template is set up, it's time to add your order details. Start with the first item and fill in the Item Name, Quantity, Unit Price, and any applicable Discount or Tax.

**Formula suggested:** For Line Total, use the formula `= Quantity * [Unit Price]` (without the brackets). This will automatically calculate the total for each item.

Using Excel Functions to Calculate PO Footer

In the footer, use the SUM function to add up all line totals for the subtotal (e.g., `=SUM(E3:E10)`). If you have a discount, minus it from the subtotal (e.g., `=C15*(1-(B15/100))`). Calculate tax based on the tax rate (e.g., `=C15*D15`).

Lastly, sum up subtotal, minus discount, plus tax to find the grand total (e.g., `=C15-D15+D15`).

Allowing for Future Edits and Scaling

While your first PO may seem straightforward, having a structured format makes it easy to add more items, modify quantities, or make other adjustments. Make use of Excel's protection features to lock down final rows, preventing accidental edits to your footer calculations.

Cold تماماً, creating a purchase order in Excel might seem overwhelming initially, but it's an essential process that streamlines your procurement. Once you've set up your template, ordering supplies becomes an efficient and manageable task. Keep refining your template as your business grows and needs change.

Now, go ahead and create your PO with confidence. Happy ordering!