Sheet template · Operations
Purchase Order Tracker
Track purchase orders from request through expected delivery and receipt without pretending to create procurement documents.
Small operations and purchasing teams coordinating vendor orders without a full procurement system.
Sign in to start an independent editable workbook from this Sheets template.
Structured preview
Purchase Order Tracker at a glance
Preview only8 columns · 3 sample rows
| PO number | Vendor | Order date | Expected date | Item / description | Amount | Status | Received date |
|---|---|---|---|---|---|---|---|
| PO-1042 | Northwind Office | 2026-09-18 | 2026-09-25 | Shipping labels | $640 | Ordered | |
| PO-1043 | Harbor Supplies | 2026-09-20 | 2026-09-27 | Packing materials | $420 | Partially received | 2026-09-23 |
| Order total | =SUM(F4:F6) |
This tracks purchasing status and timing; it is not a purchase-order document generator.
What's included
- PO and vendor register
- Order and expected delivery dates
- Receipt status and received date
- A total amount formula for active orders
How to use it
- 1Assign a PO number and capture the vendor as soon as an order is placed.
- 2Update status and received date as shipments arrive.
- 3Use the total as a planning view and keep source documents in the workspace where your team can find them.
Continue exploring