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:
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:
- A step-by-step template for tracking purchase orders in one single place.
- How to best track your purchase orders. What information to capture and who should be responsible for updating the purchase order information.
- How to get better visibility into your purchase.
So before we get started, Download the purchase order tracker:
And then follow along to learn the step-by-step process for tracking purchase orders.
Table of Contents
Step 1: Make a copy of the purchase order template
This tracker is a Google Spreadsheet.
There are two ways to use this tracker.
- You can either make a copy and keep on using the google spreadsheet.
- 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.
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.
- Just use this field as the total order amount.
- 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:
- Identify one primary person who is responsible for updating the tracker.
- You can identify a backup so that if one person is not available, the tracker can be updated by someone else.
- 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:
- Reduced time in tracking purchase orders.
- Better delivery compliance because you can track delivery performance data.
- Better spend visibility because you can see what is being purchased and by whom.
Want to see a better way to track your purchase orders? Click on the button below to schedule a product tour.