RFQ, BOQ & Evaluation

How to Build an RFQ Tracking Log for Construction Procurement

Once an RFQ has been sent to several suppliers, the next problem is no longer preparing the request.

It is tracking what happens next.

Which suppliers confirmed receipt? Who has not replied? Which quotation is overdue? Which supplier submitted a revised quote? Which quotation still has open clarifications, and which one is ready for comparison?

For a construction procurement team managing multiple suppliers or material packages, email alone is usually not enough.

A practical RFQ tracking log should show three things clearly:

• the current status of every supplier response;
• what action needs to happen next;
• whether the quotation is ready to move into comparison and evaluation.

The goal is not to create another complicated procurement spreadsheet.

It is to make sure no RFQ, supplier response, deadline, or clarification is lost during the sourcing process.

---

When Do You Need an RFQ Tracking Log?

For a very small purchase with one or two suppliers, your email inbox may be enough.

Tracking starts only after viable suppliers have passed the Supplier Qualification Checklist Before RFQ and the buyer has issued a structured Construction Material RFQ.

An RFQ tracker becomes useful when:

• several RFQs are running at the same time;
• one RFQ is sent to multiple suppliers;
• suppliers respond on different dates;
• quotations require follow-up;
• suppliers submit several quotation revisions;
• different buyers manage different procurement packages;
• technical clarifications continue after quotation receipt;
• delivery or commercial requirements change during the process.

A simple warning sign is when your team regularly asks:

“Did this supplier already send the quotation?”

or:

“Which suppliers are we still waiting for?”

If the answer requires searching through emails, the process should probably be tracked separately.

A typical workflow is:

RFQ Issued → Supplier Response → Follow-Up → Quote Received → Clarification → Ready for Comparison

---

Decide What One Row in the RFQ Tracker Represents

Before building the spreadsheet, decide what each row means.

For most construction procurement teams, a useful structure is:

One row = One RFQ Package × One Supplier

For example:

• RFQ-024 — Shower Enclosure Package — Supplier A
• RFQ-024 — Shower Enclosure Package — Supplier B
• RFQ-024 — Shower Enclosure Package — Supplier C

This is usually more useful than keeping only one row for RFQ-024.

Why?

Because each supplier may have:

• a different response status;
• a different quotation due date;
• a different follow-up date;
• a different quotation revision;
• different technical clarifications;
• a different final outcome.

The RFQ may be the same, but each supplier response follows its own path.

---

Fields to Include in an RFQ Tracking Log

A useful tracker does not need dozens of columns.

It needs enough information to answer:

Where is this supplier in the RFQ process, and what do I need to do next?

1. RFQ Identification

Include:

• RFQ number;
• project name;
• procurement package;
• material or category;
• buyer or owner;
• RFQ issue date.

Using an RFQ number is important.

Supplier names alone are not enough when the same supplier is quoting for several packages or projects.

---

2. Supplier Information

Include only the information needed for the RFQ process:

• supplier name;
• contact person;
• email;
• country or location, if useful.

Do not turn the RFQ tracker into a complete supplier database.

Company registration, certification records, factory information, and full contact details can remain in the supplier master record.

---

3. Deadline and Follow-Up Dates

Useful date fields include:

• RFQ issue date;
• quotation due date;
• receipt confirmation date;
• first follow-up date;
• final follow-up date;
• quotation received date;
• next action date.

These fields allow you to identify overdue RFQs without repeatedly checking email history.

---

4. Standardize the RFQ Status

Avoid allowing every buyer to type their own status.

If one person writes:

• Pending

another writes:

• Waiting

and another writes:

• Follow up supplier

the tracker becomes difficult to filter and manage.

Use a fixed set of statuses.

A practical RFQ status framework is:

Draft

RFQ is being prepared but has not been issued.

Issued

RFQ has been sent.

Receipt Confirmed

Supplier has confirmed receiving the request.

Awaiting Quote

Supplier is preparing the quotation.

Follow-Up Due

Supplier response or quotation requires follow-up.

Quote Received

Quotation has arrived but has not yet been fully reviewed.

Clarification Required

Important information is missing or unclear.

Revised Quote Requested

Supplier needs to submit an updated quotation.

Ready for Comparison

Quotation is sufficiently complete for bid evaluation.

Declined

Supplier has confirmed it will not quote.

No Response

Supplier did not respond after the defined follow-up process.

Closed

That supplier's RFQ process is complete.

---

Add a “Next Action” Field

Status tells you where the RFQ currently stands.

The Next Action tells you what procurement needs to do.

Typical actions include:

• Confirm receipt of RFQ
• Follow up with supplier
• Request missing freight cost
• Clarify specification deviation
• Request revised quotation
• Confirm quotation validity
• Send quotation for technical review
• Move quotation to comparison
• Close supplier response

Add another field:

Next Action Date

Now the tracker becomes an operational tool rather than just a historical record.

For example:

A buyer can open the tracker and immediately see today's work.

---

How to Track Supplier Follow-Ups

The follow-up process should use simple rules.

Rule 1: Receipt Not Confirmed

If:

RFQ issued + supplier has not confirmed receipt

then:

Follow up

This prevents RFQs from disappearing because an email was missed or sent to the wrong contact.

---

Rule 2: Quote Due Date Is Approaching

If the quotation deadline is close and the supplier has not responded, a reminder may be appropriate.

You do not need excessive reminders.

The purpose is simply to identify suppliers that still intend to participate and reduce last-minute surprises.

---

Rule 3: Quote Is Overdue

If:

Current Date > Quote Due Date

and:

Quote Received Date is blank

then:

Status = Follow-Up Due / Overdue

The buyer should then decide whether to:

• extend the deadline;
• make a final follow-up;
• close the supplier as No Response.

---

Rule 4: Supplier Declines to Quote

Do not delete the supplier from the tracker.

Record:

Status = Declined

If useful, record the reason:

• no capacity;
• product not available;
• project too small;
• MOQ issue;
• certification unavailable;
• lead time too short;
• project outside supplier capability.

Over time, this information can improve supplier shortlisting.

---

Track Quotation Revisions Properly

Construction quotations often change several times.

For example:

V1 — Original quotation

V2 — Quantity corrected

V3 — Specification updated

V4 — Freight added

Do not simply overwrite the previous quotation.

Track:

• initial quote date;
• current revision number;
• latest revision date;
• reason for revision;
• latest quotation reference or file link.

This creates an audit trail and reduces the risk of someone comparing the wrong version.

For example:

The tracker itself does not need to contain every previous price.

It only needs to show which quotation version is currently valid.

---

“Quote Received” Is Not the Same as “Ready for Comparison”

This is one of the most important distinctions in RFQ tracking.

Once the quote is complete enough to leave the tracker, hand it into Construction Material Quotation Comparison or Construction Bid Leveling rather than mixing evaluation logic into the RFQ tracking sheet.

A supplier sends you a PDF quotation.

That does not automatically mean the bid is ready for evaluation.

Before changing the status to Ready for Comparison, check whether the quotation contains the information required for a fair comparison.

Depending on the RFQ, this may include:

• correct quantities;
• requested specification;
• unit prices;
• total price;
• freight where required;
• Incoterm;
• production lead time;
• payment terms;
• quotation validity;
• required options;
• technical deviations;
• packaging assumptions.

If important information is missing:

Status = Clarification Required

For example:

Supplier A quoted the correct product and quantity but did not state whether freight is included.

That quotation has been received, but it is not yet commercially comparable.

Only when critical missing information is resolved should the status become:

Ready for Comparison

This creates a clean handoff into bid leveling or quotation comparison.

---

Example RFQ Tracking Log

A simple RFQ tracker might look like this:

This gives the procurement team a quick view of:

• open RFQs;
• missing quotations;
• pending clarifications;
• follow-ups;
• quotations ready for evaluation.

---

Use Simple Overdue and Action Rules

An Excel or Google Sheets tracker can become much more useful with a few basic rules.

Overdue Quote

If:

Quote Due Date < Today

and:

Quote Received Date is blank

then flag:

Overdue

---

Follow-Up Due

If:

Next Action Date ≤ Today

and:

Status is still open

then flag:

Follow-Up Due

---

Ready for Comparison

If:

• quotation received;
• mandatory quotation fields are complete;
• no critical clarification remains;

then:

Status = Ready for Comparison

These rules can later be automated with formulas, conditional formatting, or procurement software.

The important part is defining the logic first.

---

What Should You Not Put in the RFQ Tracker?

A common mistake is trying to make one spreadsheet contain the entire procurement process.

Avoid putting all of the following directly into the RFQ tracker:

• full technical specifications;
• complete email conversations;
• every line of quotation pricing;
• full supplier master data;
• complete contract documentation;
• detailed inspection reports.

Instead, add a file reference or link to:

• RFQ document;
• supplier folder;
• quotation;
• technical clarification;
• bid comparison sheet.

A good principle is:

The tracker should show status, ownership, deadlines, and next action. It should not replace every procurement document.

---

Excel vs Google Sheets vs Procurement Software

You do not necessarily need specialist software to track RFQs.

Excel

Useful when:

• one buyer or a small team manages the process;
• RFQ volume is moderate;
• files are managed internally;
• advanced collaboration is not required.

Google Sheets

Useful when:

• several team members need live access;
• status updates need to be shared;
• simple collaboration is important.

Smartsheet or Procurement Platforms

Useful when:

• many RFQs run simultaneously;
• multiple buyers or projects are involved;
• automated reminders are useful;
• approvals are required;
• a centralized audit trail is important.

The correct system is not necessarily the most sophisticated one.

Start with the simplest tool that reliably shows owner, status, deadline, and next action.

---

Common RFQ Tracking Mistakes

Managing Everything in Email

Email records communication.

It does not clearly show the overall procurement status.

---

Using Too Many Free-Text Statuses

Standardize status options so the tracker can be filtered and reviewed consistently.

---

Tracking Quote Receipt but Not Next Action

A received quotation may still need technical or commercial clarification.

Always record what happens next.

---

Overwriting Previous Quotations

Keep revision history so the team knows which quotation is current.

---

Mixing RFQ Tracking With Quote Comparison

These are different tasks.

RFQ tracking answers:

Where is each supplier in the process?

Quotation comparison answers:

Which supplier has the best evaluated bid?

Keeping them separate makes both tools easier to manage.

---

RFQ Tracking Checklist

Before considering an RFQ record properly controlled, check that:

• RFQ number is assigned
• Supplier is entered
• RFQ issue date is recorded
• Quote due date is recorded
• Receipt confirmation is tracked
• Current status is selected
• Follow-up date is recorded
• Quote receipt date is recorded
• Current quote revision is identified
• Open clarifications are tracked
• Next action is defined
• Action owner is clear
• Next action date is recorded
• Quote is marked Ready for Comparison only when sufficiently complete

---

Tools and Resources for RFQ Tracking

Buyers can manage RFQ tracking using different types of tools, including:

• RFQ tracking spreadsheet templates;
• Excel templates;
• Google Sheets;
• Smartsheet RFQ trackers;
• procurement management platforms;
• RFQ templates;
• quotation comparison tools;
• vendor evaluation tools.

The challenge is often not finding another spreadsheet.

It is knowing which tool belongs at each stage of the procurement workflow.

Build Procurement Hub organizes RFQ templates, tracking resources, quotation comparison tools, and supplier evaluation resources around actual procurement tasks so buyers can move from issuing an RFQ to evaluating bids without searching across multiple unrelated websites.

---

What Comes After RFQ Tracking?

The RFQ tracker should eventually move every supplier toward a clear next step.

After comparable quotations are frozen, the final selection process can feed into a broader Construction Supplier Evaluation Scorecard alongside technical, commercial, capability and performance evidence.

If the quotation is incomplete:

Clarification → Revised Quote → Update Tracker

If the quotation is complete:

Ready for Comparison → Bid Leveling / Quote Comparison

If the supplier does not respond:

Final Follow-Up → No Response → Close

The broader workflow is:

Prepare RFQ

↓

Issue RFQ

↓

Track Supplier Responses

↓

Resolve Clarifications

↓

Freeze Comparable Quotations

↓

Technical and Commercial Evaluation

↓

Supplier Selection

The purpose of RFQ tracking is simple:

At any moment, the procurement team should know which suppliers are still active, what is missing, what needs action, and which quotations are ready for evaluation.

---

Keep Every Supplier Response Moving Toward a Clear RFQ Outcome

Use RFQ, BOQ & Evaluation resources for RFQ templates, tracking logs, quotation comparison and vendor evaluation. Keep the tracker focused on status, ownership, deadlines, revisions and next action — then hand complete quotations into bid evaluation.

Explore RFQ, BOQ & Evaluation Tools Browse Common Procurement Tools

FAQ

What is an RFQ tracking log?

An RFQ tracking log is a procurement record used to track RFQs sent to suppliers, quotation deadlines, response status, follow-ups, quotation revisions, clarifications, and next actions.

What should an RFQ tracker include?

At minimum, include the RFQ number, supplier, issue date, quote due date, current status, follow-up date, quotation receipt date, latest revision, next action, and next action date.

Can I track RFQs in Excel?

Yes. Excel or Google Sheets can work well for small and medium RFQ workloads if the team uses standardized status values, deadlines, and follow-up rules.

What is the difference between RFQ tracking and quotation comparison?

RFQ tracking manages the process of receiving and completing supplier quotations. Quotation comparison evaluates the technical and commercial content of those quotations once they are ready for comparison.