Procurement Log Template (Excel + Google Sheets, Free)
What's inside the procurement log template
The workbook has one Procurement Log sheet, up to 150 rows. Each row is one purchase order: PO number, supplier, order date, delivery date, status (Ordered, Partially delivered, Delivered, Cancelled), committed amount and delivered amount.
Lead time in days calculates automatically once you've entered both an order date and a delivery date - it stays blank, not an error, on any order still pending delivery.
Unlike the construction-management SaaS tools that offer a procurement log as a free lead-in to their paid app - and the one bare, unstyled 2013 .xls file found in search results - this is a single, ready-to-use, formula-driven workbook.
Committed vs. delivered, and vendor lead time
Every order tracks two dollar amounts separately - what you committed to spend when you placed the PO, and what's actually been delivered - so the summary's outstanding-balance total always reflects real exposure, not just what's been ordered.
The average lead time figure, and the count of orders marked Delivered, roll up automatically from every logged order, giving you a running view of how fast your suppliers actually deliver versus how fast they promise.
Status tracking and cancelled orders
Status is a dropdown - Ordered, Partially delivered, Delivered, Cancelled - so every row rolls up consistently instead of relying on free-text notes that don't total cleanly.
Cancelled orders are flagged directly in the table with conditional formatting, so a cancelled PO doesn't get missed when you're scanning the log for what's still outstanding.
Who this template is for
Construction project managers, procurement coordinators and small contractors who need one straightforward file to track material and equipment purchase orders from submittal through delivery - without a paid procurement SaaS subscription.
It's a log-and-track tool - it doesn't connect to your accounting system's cost codes automatically. Use it alongside your project budget for a fuller picture of committed vs. spent.
How to use it
- Log every PO: number, supplier, order date, delivery date, status, committed and delivered amounts.
- Lead time in days calculates automatically once a delivery date is entered.
- Check the summary below the table for total committed, total delivered, outstanding balance and average lead time.
Download the free Procurement Log Template (Excel + Google Sheets, Free)
No spam — template updates and new free templates only. Unsubscribe anytime.
Frequently asked questions
How is lead time calculated?
Delivery date minus order date, in days. It stays blank until you enter a delivery date - it's not an error, just not yet applicable.
What's the difference between committed and delivered amounts?
Committed is what you agreed to pay when you placed the PO; delivered is what's actually been received. The summary's outstanding balance is the difference between the two totals.
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. The lead time and summary formulas keep working.
How many purchase orders can I log?
Up to 150 rows on the Procurement Log sheet.
Does this link to my project budget or cost codes automatically?
No. It's a standalone procurement log - use it alongside your project budget sheet to compare committed spend against your overall cost codes.
What's the usage license?
Personal use or use within one business. It's not meant to be resold or redistributed as a template product.