Keeping an updated log of purchase orders and vendor interactions is crucial for businesses of all sizes. Unlike traditional bookkeeping, modern purchase order trackers are automated, so they instantly update key totals, statuses, and follow-ups for you as soon as you enter new PO details or update their payment and delivery status. To offer a reliable solution for managing and tracking POs, we have designed this purchase order tracking template in Excel, well-suited for startups and small businesses.
While Excel-based tools are great for small businesses, they are not a complete ERP system, so they do not enforce approvals, inventory accounting, or audit trails. For that, you need standard accounting software tailored to your unique company/industry context.
Now, let’s start with the basics:
What Are Purchase Orders?
POs are essentially legal agreements between a buyer and the supplier. If there’s a dispute about what was ordered, for how much, or on what terms, this document is your single source of truth. Trackers make sure this information is safely secured. They also help you visualize key metrics about delivery or payment status, ensuring smooth procurement of goods & materials for businesses around the clock.
How Trackers Help
Managing hundreds of orders a month, working with multiple suppliers, or processing orders through separate offices requires a reliable way to manage purchase orders. From order creation and monitoring changes to fulfilment, a structured PO process helps you stay organized, track budgets, and comply with local auditing laws.
To make this easier, our team built a lightweight register to help you track:
- Which POs are issued, to which vendors, and when
- Delivery progress (Delivered vs Pending)
- Payment progress (Paid, Partially Paid, Unpaid, Overdue)
- Outstanding amounts and aging buckets
- Vendor contact lists
You can pair it with our purchase order template to create and issue POs.
A Step-wise Guide to the PO Tracking Template
We have deliberately designed our template for maximum versatility. Suitable for any industry, it benefits learners & seasoned experts alike. If you’re new to PO management or struggle with Excel, you’ll need a quick rundown of the core features of this template before you can start customizing it. The result is a clean, ready-to-print report ready to be shared internally or with external vendors & suppliers.
By tailoring our premade system, users (especially small businesses) can quickly sync the tracker to company-specific workflows.
How To Get Started
Once you download the file in Excel, don’t forget to turn on macros to benefit from the advanced functionalities programmed into the tracker.
Before you start entering data, here’s what you need to handle first:
Step 1: Open the Config sheet to streamline the delivery process and create your own way of tracking the status of POs by marking them as Delivered, Pending, etc. A consistent way of updating PO delivery status enhances visibility & prevents delays, ensuring smooth purchasing operations.
Step 2: Open the Vendor List to fill in the contact details of each supplier or vendor you’re working with. Include their phone number, email ID, and postal address (preferably all three for each vendor). Use Column C to assign a unique Vendor ID to each vendor or supplier. This makes it easier to pull the right vendor into a purchase order, keep records consistent, and avoid duplicate entries (for example, “ABC Traders” vs “A.B.C. Traders”).
Create & Track Purchase Orders
The PO Tracking sheet is the main sheet of this template, where you would be able to track the status of each order.
Each row represents a new order. By default, this sheet allows entry of up to 45 orders, but this limit can be increased. Simply drag and drop the cells in columns B to O to duplicate the formulae onto the new rows, and track as many orders as needed (See How to Scale Up section for more detail).
Our template allows you to categorize orders by date, supplier/vendor, or any custom method better suited to your workflow. Now, let’s quickly go over each column in the PO tracking sheet, what information it requires, and why.
The next P.O. NO.
Cell B5 is programmed to tell the next PO number to assign when you create a new order. This speeds up data entry because you don’t have to guess the next number. It also keeps PO numbers unique, preventing duplicate POs that cause confusion with vendors and accounting.
Right below, in B9, our built-in calendar automatically tells you the date today, so your summaries, aging buckets, and date-based filters stay accurate.
What You Need to Enter Manually
In the PO table, add the following information…
P.O No.
In Column B, assign a serial number to each purchase order. A systematic method for numbering and filing orders facilitates easy identification and tracking. Use a consistent PO numbering format (even if manual), such as PO-2026-001.
A filter is programmed into this column, allowing users to visualize and track specific orders only. For example, if you only want to view information about Order 5,6, and 7, simply click on the filter icon and select these orders. The PO Tracking sheet will adjust to show the selected orders only.
Vendor
In Column C, use our built-in dropdown menu to select the relevant vendor or supplier.
This menu is pulled in from the Vendor List sheet, so you don’t have to type in full vendor names or IDs all over again each time you create a new order (see Step 2 above).
The filter function lets you select any vendor from the list. When you select a vendor, the top info box shows all their details, and all charts and summaries automatically update to reflect only this vendor’s data. This lets you see their position and contribution at a glance, helping you analyze performance and make decisions quickly
P.O. issue date
Specify the exact date the buyer officially creates and sends the purchase order to the supplier. This is when the PO becomes “active” and the terms are formally communicated. In short, the issue date is the timestamp that anchors the PO’s life cycle, from creation to receipt to payment. If someone accidentally raises the same PO twice, the issue date plus PO number helps you spot and prevent duplicate purchasing.
Delivery date
This is when the buyer expects the supplier to deliver the goods or complete the service. It tells the vendor what “on time” means and gives your team a clear target for planning. If there’s a later disagreement (“We didn’t know it was urgent” or “You never gave a deadline”), the delivery date on the PO provides evidence.
Delivery status
Use the dropdown menu to indicate the delivery status of each order. Two options are added by default: ‘Delivered’ and ‘Pending’ but you can add more or replace these using the Config sheet.
Due date
This refers to the date by which the buyer must pay the supplier’s invoice for that PO (or for that delivery). When you have multiple invoices, due dates help you decide what must be paid first.
This function in our template does more than identify the payment due date. It works like this:
Once a purchase order is delivered, the template uses the due date to determine whether the payment is on time, approaching its deadline, or overdue. Excel automatically compares the due date with the current date.
If the due date is in the future, the delivered order is active and not overdue. It remains part of the outstanding balance but is not flagged.
If the due date is today or has already passed and the payment is not fully completed, the Due Date cell turns red, signaling that the order is overdue and requires immediate follow-up.
If the full payment has been made, even after the due date, the order is considered completed. The Due Date cell may appear grey, indicating no further action is needed.
Always fill in the Due Date if you want aging and overdue logic to be meaningful. Not paying by the date can trigger penalties for higher interest charges for businesses.
Key point: All of the rules below only take effect once the purchase order is marked as Delivered. Orders that are still pending or in progress will not trigger due date alerts, payment statuses, or color highlights.
Amounts Due & Paid
In column H write in the exact total sum you need to pay the vendor. In the next column, specify the amount you have already paid them. These two columns help you keep track of outstanding balances, partial payments, and what’s fully settled at a glance, so you can avoid missed payments, duplicate payments, and cash flow disruptions.
Update delivery and payment as things change!
As delivery happens and payments are made, update the Delivery Status, Amount Paid, and key dates. The tracker calculates the rest for you (outstanding, aging, statuses). Review the Summary table (explained below) at the end of each working day to spot overdue payments early, prioritize the oldest outstanding invoices first, and note any pending deliveries that need follow-up with vendors.
How To Scale Up
Key formulas in the sheet are locked to prevent accidental removal, and as a result, the sheet is in Protected Mode. To insert a new row, you must first unprotect the sheet from the Review tab. Now drag the formula into the new row. If you don’t unprotect the sheet first, you only copy the text into the new row, not the formula.
The sheet already includes formulas down the table area, but if you want to scale reliably:
- Extend the PO table downward as needed (copy the formula columns with the same structure).
- Make sure formulas and charts include the expanded range.
What We Calculate For You
Based on what the user manually adds, our tracker instantly calculates:
- Age or how long a PO has been due
- Outstanding Payment Amount
- Payment status
Age
Aging’ is a way to categorize outstanding payment amounts by specifying how many days past the due date they are. In Column J, we compute this number based on the Due Date and Delivered status. We use standard accounting ranges to do this:
- Current: Outstanding amount that is not overdue (due today or due in the future)
- 1–30: Outstanding amount that is 1 to 30 days overdue
- 31–60: 31 to 60 days overdue
- 61–90: 61 to 90 days overdue
- >90: More than 90 days overdue
Outstanding payment amount
Based on the amounts you manually add in Column H & I, the template automatically computes your outstanding payment, so you know what’s still due, what’s already been paid, and which vendor invoices need attention next.
Payment status
The Payment Status cell of the template works in tandem with the due date, amount paid, and amount due.
Once the order is marked as Delivered, the template starts monitoring the Due Date and the payment amount.
As soon as you enter a payment amount (partial or full), the template automatically updates the Payment Status for that delivered order.
The status reflects the combination of how much has been paid and whether the due date has passed. For example:
- If the full amount is entered after the due date, the status becomes Paid – Overdue.
- If the full amount is entered within the due date, the status becomes Paid.
- If no payment is entered and the due date passes, it becomes Unpaid – Overdue.
- If a partial payment is entered before the due date, it becomes Partially Paid.
Additional notes
Use the last column to add any extra information about each PO order. Each note automatically becomes part of the Note dropdown, so you can reuse notes for similar situations. Keep notes concise and only use terms & abbreviations that everyone on the team is familiar with.
Can I add extra columns?
Absolutely! Feel free to add more columns in the PO table to match your process, such as:
- Item category
- Department
- Project/client
- Requester name
- PO description
- Invoice number
- payment terms
- Currency, tax, shipping, received-by
- GRN number
- Approval status (Requested, Approved, Rejected)
Payment summary
Use this summary to get a quick idea of what’s paid and what’s due. We calculate a grand total of paid and due amounts for all your PO orders. See how your overdue or outstanding amounts are ‘aging’ so you can focus on the payments that need attention first—typically the oldest balances (61–90 days and >90 days overdue), then the 31–60 and 1–30 buckets, while keeping an eye on “Current” items that are coming due soon.
Quick Data Visuals
Right above the PO table, we offer built-in charts & graphs to help you quickly visualize vital information about the payment and delivery status of your POs.
The pie chart gives you a snapshot of your PO order by delivery status. Use it to keep track of how many orders are still pending, so you can undertake necessary follow-ups to avoid delays, missed deliveries, or last-minute surprises in your purchasing schedule.
The second bar chart shows how much money you owe and how far past due it is. You can immediately see whether outstanding payments are normal “in-process” items or turning into a backlog that can hurt cash flow planning. It also helps you decide who to pay first. Most teams tackle the oldest bucket first to reduce escalation risk.
Here’s a short example for clarity.
Let’s say, you have unpaid vendor invoices totaling $2,450—with overdue payments spread out like this…
- Current (not overdue yet): $900
- 1–30 days overdue: $600
- 31–60 days overdue: $450
- 61–90 days overdue: $300
- >90 days overdue: $200
As you can see, most of your unpaid payments are still within a normal timeframe, but $500 is 61+ days late, so those vendors should be prioritized to avoid holds, penalties, or supply issues.
What Purchase Order Trackers Do?
- Manage and track orders from creation to completion
- Track vendor transactions and interactions
- Monitor outstanding balances and pending payments
- Maintain accountability for transactions
- Update the status of orders in real time for better monitoring
- Mark milestones within the tracking system
- Ensure smooth procurement processes and improve efficiency
Prevent Procurement Problems with PO Tracker
Purchase Order trackers help your business by preventing common procurement issues such as:
- Sudden price increases
- Risk of miscommunication with vendors/suppliers
- Late, missed, or duplicate payments
- Wasted time on tedious bookkeeping
- General procurement disagreements
Target Users
Whether you’re a budding start-up with limited resources or an independent procurement officer, this template gives you a brilliant kickstart.
This simple but powerful PO tracker is ideal for:
- Small businesses managing purchases manually
- Operations and procurement teams are tracking vendor orders
- Finance & accounts teams following up on overdue payments and balances
- Retail & manufacturing firms that issue POs regularly
- Startups that need visibility without paying for a full procurement system
You Might Also Be Interested In.
- Vendor Check Request Form Template: A formal document used by vendors to request payments from an organization in exchange for any goods or services they have provided.
- Free Request for Quote (RFQ) Template: A formal bid document designed to help you solicit competitive price quotes for your business needs.
- Free Work Order Template (Excel – Google Sheets): A document authorizing the work that needs to be done for a client or customer. Pair up with this Purchase Order template to streamline purchases, control spending, and restock inventory on time.
Disclaimer
This tracker is for informational use and record-keeping purposes only. It does not constitute accounting, tax, legal, or procurement advice. For that, you should consult qualified professionals for compliance and financial reporting needs, as these apply to your company or industry context.
The sheet relies on correct data entry. Incorrect dates, amounts, or statuses will produce incorrect outputs. It is ideal for a single-file workflow. Simultaneous multi-user editing can create version control issues unless managed carefully.
