Construction procurement log
Track the dates behind each long-lead item. Work backward from its required-on-site date, record who owns the next action, and keep procurement status separate from submittal review status.
The starting row is fictional. Edit it or remove it and add your own records. Inputs stay in this browser session and are not automatically saved or transmitted. Export the reviewed CSV to keep a copy.
What does a construction procurement log track?
A procurement log records the item, responsible owner, required-on-site date, lead-time assumptions, actual order date and next action. It connects design review to purchasing and delivery while keeping procurement status separate from submittal review status.
How to use the worksheet
- Set the required-on-site date from the project schedule.
- Enter supplier-confirmed fabrication/transit durations and the review allowance.
- Compare the planned release dates with actual order and review status.
- Assign the next action; update dates when a supplier or design decision changes.
Latest order date = required-on-site date − fabrication days − transit days. Latest submittal start = latest order date − review days. All durations are calendar days, not working days. Dates are planning assumptions, not supplier commitments.
A worked example
A fictional item is required on site March 15, 2027. With 60 fabrication days, 7 transit days and 14 review days, the planning dates are January 7 for the order and December 24 for starting the submittal review. Confirm the assumptions with the actual supplier and project team.
What to check before using the output
The planning dates use calendar days. They do not account for weekends, holidays, manufacturing calendars or supplier commitments. Confirm lead times and update the log when scope or delivery assumptions change.
Work back from the installation need
Start with the date the item must be available on site. Confirm whether that date needs to allow for receiving, inspection, storage or other preparation before installation. Enter fabrication and transit durations on a consistent calendar-day basis. Keep a record of who supplied each lead-time estimate and when it was checked.
A reviewed submittal is not an order
Keep submittal status and procurement status separate. An item can have an approved submittal without an order, or an order with unresolved design conditions. Compare the calculated latest dates with the actual order date and assign the next action to a named owner. Recheck the plan when a selection, review cycle or supplier commitment changes.
Interpret the dates as planning targets
The example's January 7 order target and December 24 submittal-start target follow directly from the entered calendar-day allowances. They are not supplier promises. If the item is already late against those targets, confirm the achievable delivery and assess the schedule effect with the project team. Do not shorten the entered lead time just to make the dates fit.