Purchase Order Tracking Spreadsheet Free

Struggling with tracking purchase orders? 

Growing companies often struggle with the increased volume of purchase orders and without a central place, it is a nightmare to track what is being delivered and what is still open from the vendor. 

With an order tracking process, you can see results like this:

Before and after_purchase_order_tracking

Without a central place to track purchase orders, you are constantly in your inbox trying to figure out the status of the orders.

And when the volume increases, so do the email volume and back and forth with different stakeholders. 

The best approach is to implement a purchase order tracking system but if you are just getting started, you can start using a spreadsheet for order tracking too. 

In this article we are going to cover:

  1. A step-by-step template for tracking purchase orders in one single place. 
  2. How to best track your purchase orders. What information to capture and who should be responsible for updating the purchase order information.
  3. How to get better visibility into your purchase.

So before we get started, Download the purchase order tracker:

Purchase Order Tracker Template

And then follow along to learn the step-by-step process for tracking purchase orders.

 

Step 1: Make a copy of the purchase order template

This tracker is a Google Spreadsheet.

There are two ways to use this tracker.

  1. You can either make a copy and keep on using the google spreadsheet.

Copy Google Spreadsheet

  1. If you would like to download it to your machine, then choose the Download option and choose Microsoft Excel

Step 2: Review the fields under the Data tab

All the fields for tracking the purchase orders are under the Data tab.

Purchase order tracker fields

Here is an overview of the fields:

Purchase order #: 

This is the purchase order number that you have assigned to the purchase order. it might be tempting to make this number complex based on what is ordered, who ordered it. 

We recommend keeping this as a simple sequential number so that it is easy to track. 

Created date:

This is the date when the order was created and issued to the vendor. 

Order contact:

This is the name of the contact person who is placing the order. Let’s say if you are creating orders on behalf of other users, you want to keep a track of who is ordering products or services. 

Supplier name:

Name of the supplier to whom the purchase order is being issued. 

Order amount:

The final amount of the order. If you have shipping and taxes on each order, then you have two options. 

  1. Just use this field as the total order amount.
  2. Or create additional columns to track order subtotal, taxes, and shipping cost. 

Ship to location:

This is the delivery address of the product or service. In case of a drop ship, enter the final destination. 

Order status: 

This is to track the lifecycle of the purchase order. A purchase order could have the following status:

Issued: When the order is first issued to the vendor, it would have the status as “Issued”.

Acknowledged:  The order moves to the Acknowledged status when the vendor acknowledges that they have received the purchase order and it has been accepted.

ASN Provided: ASN (Advance Shipping notice) is a notification from the vendor that the requested product has been shipped. The vendor provides the Shipping information so that you can track order delivery. 

Partially Delivered: If the order is not fully delivered then it should be in the partially delivered status. This could happen in cases where the product is back-ordered. 

Delivered: When the order is fully delivered, the status should change to deliver. 

Closed: When the order is fully delivered and invoiced. 

Delivery Status:

This field helps to easily track what has been delivered and for where you need to follow up with the vendor. 

The values could be Not Started, On the way, and Completed

Vendor Comments:

Any specific comments from the vendor regarding this purchase order.

Change order:

A flag to track if the purchase order has been changed since it was issued to the vendor. 

Change Comments:

In case the order is changed, then this field can be used to track what has changed since the order was issued. 

Step 3: Review the Summary Dashboard

The order tracking sheet also has a summary dashboard to give you an overview of the order status at a glance.

Here is how it looks:

There are four graphs but you can always add more to customize the way you want to track and report the order status. 

Purchase order by supplier:

This graph shows the count of the purchase orders by vendors. For example, Dell has 3 purchase orders.

Delivery status:

This is the overall delivery status of the purchase order. This graph helps you to quickly track what has been delivered and what is not. 

Purchase order status:

This graph shows the overall status of the purchase orders. For example how many are acknowledged or how many PO’s are just issued but not acknowledged by the vendor.

Amount by supplier:

This graph summarizes the total amount or Spend with each vendor. This graph is helpful to understand your total Spend across different suppliers. 

Step 4: Add any additional fields to the purchase order spreadsheet

After you have reviewed the tracker, you might realize that you need additional fields to track information about your orders.

For example, if you need to configure the product before it is delivered to a customer, then that would probably need additional information like the final ship date.

Some customers like to track information like required date and promise date so that they can track whether the vendor is delivering as per the promise date or not. 

This can help track delivery performance over time. 

These are just examples, but feel free to make a copy of the purchase order template and then customize it per your needs. 

Step 5: Define Ownership 

It is great that you have a tracker now for maintaining the information about the purchase orders.

But who is going to maintain it?

And that is why many teams fail to make effective use of purchase order tracker spreadsheets. 

If you let everyone update the sheet then it is going to be a mess!

So here is what we recommend:

  1. Identify one primary person who is responsible for updating the tracker. 
  2. You can identify a backup so that if one person is not available, the tracker can be updated by someone else. 
  3. If you want employees to track the order status on their own, you could just open the tracker in a view-only mode for the rest of the team.

If you have a purchasing department, then the ownership should sit with the purchasing department. 

Otherwise, Have someone from the operations team manage the tracker for you. 

Now your turn!

Clients who have moved to a central purchase order tracking process see an immediate impact in the following areas:

  1. Reduced time in tracking purchase orders.
  2. Better delivery compliance because you can track delivery performance data.
  3. Better spend visibility because you can see what is being purchased and by whom.

Get started today. If you haven’t already don’t that, click on the link below to download the template.


Purchase Order Tracker Template

Schedule a Demo

See ProcureDesk in action!

Schedule
3C Cost Control Framework

Learn how to implement an effective Cost Control process.

Download

Struggle free purchasing

If You would like to experience a struggle free purchasing & invoicing process, click on the link below to book a demo

Schedule Your 30 Minutes Demo Now