Skip to content
The title slide and first slides of the Purchase Order template

Purchase Order

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
3
Difficulty
Beginner
Updated
November 6, 2026

Every slide (3)

Overview

This purchase order template gives you a form to raise an order and a log to track every order. The Purchase Order tab holds the buyer, the supplier, delivery details and approval, then the items you are buying, shipping, tax and the total. The Orders tab lists each order with its supplier, value and status, so you can see what is waiting for approval and what has arrived.

It comes with sample data for a small events business. Make a copy, replace the sample rows with your own, and the amounts, totals and tax update on their own. Use the status dropdown on the Orders tab to keep the log current.

Useful for

  • Raising orders for printing, stationery and equipment hire
  • Tracking which orders are waiting for approval
  • Keeping a record of supplier spend for each month

What's included

  • 3 tabs: Purchase Order, Orders, How to use
  • Purchase Order: a ready-to-fill form
  • Orders: a table
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Purchase Order tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Is this Purchase Order template free?

Yes. The Purchase Order template is free to download and use. Make a copy in Google Sheets or download the Excel file.

Does it work in Excel?

Yes. Download the .xlsx file and open it in Excel, Google Sheets or another compatible spreadsheet app. The formulas, dropdowns and totals work in both.

Can I change the tax rate?

Yes. Change the Tax rate cell on the Purchase Order tab and the tax and total update straight away.

  • #purchase-order
  • #purchase-order
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More purchase order templates

See all 4

Also in Business operations

All business operations templates
Get this template

Preparing your template…