Free Procurement Tracker Template (Excel)

A procurement tracking log, not RFP paperwork

Searches for "procurement templates" mostly turn up government solicitation and RFP document sets - not what a small business or ops team needs day to day. This template is a tracking log: one row per purchase, from request through delivery, so you can see what's on order and what's overdue without a procurement system.

If you need formal solicitation or bid documents for public-sector purchasing, this isn't that. If you need to track what you've ordered, from whom, and whether it's arrived, this is built exactly for that.

What's in the procurement tracker

The Procurement Log sheet holds up to 150 rows. Each row captures the item or description, vendor, quantity, and unit cost, plus four dates - requested, ordered, expected delivery, and received - and a Status dropdown running Requested, Approved, Ordered, Received, or Cancelled.

You set Status yourself as the purchase moves through your process; it's not derived automatically from the dates. That keeps the log accurate even when your real-world process doesn't move in a straight line - an item can sit at Approved for a week before you place the order, and the log reflects that because you're the one flipping the dropdown.

What calculates automatically

Committed cost per row multiplies quantity by unit cost the moment both are filled in. Days late looks at the expected delivery date against today, and only shows a number for items still open - not for anything already marked Received or Cancelled, so a delivered item never falsely reads as overdue.

The summary block totals committed spend across everything still open (Requested, Approved, or Ordered), separately totals what's already Received, counts items currently overdue, and counts total open items - so you get a one-glance view of spend and lateness without building your own pivot table.

Conditional formatting flags overdue rows and highlights Received rows in green, so a long procurement log is easy to scan for what needs attention.

Who this procurement tracker is for

Small businesses, contractors, and ops or office managers who place recurring purchase orders with a handful of vendors and need to know what's committed and what's late are the core fit. It's a step up from tracking purchases in email or a notebook, without the overhead of procurement software built for enterprise sourcing.

It also works well alongside a purchase order template: use the PO to formalize each order with the vendor, then log it here to track delivery status and committed spend across every vendor in one place.