Purchase Order Tracking Template
If you have many vendors or suppliers and create more than just a few purchase orders per year, you will want to use some type of PO tracking system. For tracking large numbers of orders, you may want to look for custom PO software or a database solution. However, if you just need something simple for now, this purchase order tracking template may be just right. You can use it along with our free purchase order template.
Use this spreadsheet to list all the purchase orders that you create, track their progress (draft, paid, complete, etc.), and create simple summary reports of how much you have paid to individual suppliers.
Purchase Order Tracker
for Excel
Download
⤓ Excel (.xlsx)"No installation, no macros - just a simple spreadsheet"
We Recommend ...
The Purchase Order Tool by Someka.net allows you to create POs as PDFs, select from a product list, and keep a database of past orders.
Learn More ►Description
List all your purchase orders and display a summary of payments made to all or individual vendors. You can choose to show all purchase orders or just the orders for a particular supplier, using Excel's built-in filtering feature.
Instructions are included within the worksheet.
This spreadsheet does not include a purchase order form. You can use this spreadsheet to track any PO form that you want - it does not have to be a PO template from TotalSheets.com.
Features
- Includes a payment/aging summary for all orders or for individual vendors.
- Use Excel's Sorting and Filtering feature to sort by date, PO number, vendor, etc.
- Customize the list of options that show up in the Status drop-down box.
- Gray-out rows by entering a Status of "Complete" when a delivery is received. (This is done using )
- Set the status of an order to "Draft" to keep it from showing in the aging summary.
- No VBA/macros
Purchase Order Generator and Tracker
Created By: Someka Excel Solutions
Description
If you need to create purchase orders and track your PO history, we recommend you try this premium template from our trusted affiliate partner* Someka.net.
Main Features:
- Customize the purchase order form
- Edit both a product and supplier database
- Generate new purchase orders and track all orders created
*TotalSheets may receive a commission if you purchase this product.
