Free template · Purchase

Request for Quotation (RFQ) Format: Free Excel Template with a Worked Example

A request for quotation (RFQ) format is the document you send vendors to ask for prices on the same items, units and terms. It lists the buyer, each item's specification, quantity, unit and required-by date, the delivery and payment terms, and the quote deadline. Because every vendor answers the same questions, you compare quotes on landed cost, not just unit rate.

Download the Excel template

What is a request for quotation?

A request for quotation is a short document a buyer sends to several vendors. It asks each vendor to price the same items on the same terms.

A factory sends one for a new item, a new vendor, a price revision or a large order.

The RFQ is what you send. The quotation is the vendor's reply. Here, the vendor fills the reply columns on your own sheet.

DocumentPurposeWhat you sendWhat comes back
RFI (request for information)Learn what vendors can supplyQuestions on capability and certificationsCompany details and capabilities
RFP (request for proposal)Get a solution for a loosely defined needThe problem and how you will judgeA proposal with approach and price
RFQ (request for quotation)Get prices for an exactly defined needItem, spec, quantity, unit and termsRates, GST, freight, delivery and validity

Raw material and bought-out parts with a fixed specification are RFQ buys.

What each part of the RFQ format means

You fill the header, the first six item columns and the terms. The vendor fills the rest.

Header block

FieldWhat to enterWhy it matters
RFQ number and dateA running number, such as RFQ/2026/014, and the send dateThe vendor quotes it back; your PO refers to it
Buyer name, address and GSTINYour registered detailsThe vendor needs it for the right GST
Delivery addressThe plant or store receiving the goodsFreight depends on it
ContactBuyer's name, phone and emailVendors ask questions before quoting
Vendor nameOne vendor per copy of the fileTies each reply to one vendor

Item table: columns you fill

ColumnWhat to enterWhy it matters
Sr. No.1, 2, 3…Quick reference to a line
ItemPlain name, such as MS sheetTells the material family
SpecificationGrade, standard, size, thickness; drawing no. and revision for made partsVendors quote the same thing only with an exact spec
QtyThe quantity you needRates change with quantity
UnitNos, kg, metre or litreStops quotes in different units
Required byDate material must reach your plantA cheap but late quote can stop production

Item table: columns the vendor fills

ColumnWhat the vendor entersWhy it matters
HSN codeThe item's HSN codeConfirms the GST rate
Unit rate (₹, excl. GST)Price per unitRates without GST compare cleanly
Amount (₹)Qty × unit rateLine total for landed cost
GST %The GST rate chargedShows a different rate at once
Delivery date offeredWhen they can deliverCheck against your required-by date
Vendor remarksMake, test certificate, minimum order, exceptionsExceptions often hide here

Footer

FieldWhat to enterWhy it matters
Price basisVendor states ex-works or deliveredEx-works leaves freight out
Freight and packing (₹)Vendor's figure, if not includedNeeded for the landed total
Payment termsYour terms, such as 30 days from receiptVendors price credit into the rate
Quote deadlineDate the quote must reach youLate replies don't hold up the PO
Quote validityHow long the price holds, such as 30 daysThe rate still holds at PO time
NotesTest certificates, packing, inspectionEvery vendor prices the same conditions

[[IMAGE {"type":"compare","title":"Comparing quotes: unit rate vs landed cost","columns":["By unit rate","By landed cost"],"rows":[["Freight and packing","Left out","Added to each total"],["GST","Mixed into some rates","Kept out of every rate"],["Delivery date","Not checked","Checked against required-by date"],["Ex-works quote","Looks cheapest","Shows its true cost"]]}]]

Where the RFQ sits in your purchase flow

An RFQ sits in a chain: MRP report → indent → RFQ → PO → GRN → payment.

What you ask quotes for comes from your orders and BOMs. Start with a clean bill of materials format.

Once you pick a vendor, raise a purchase order on the agreed rate and terms. Check arriving material against the PO with a goods received note.

Where TranZact fits (as of 18 Nov 2026)

TranZact is manufacturing AI software used by 10,000+ manufacturers. In TranZact, purchase runs as this same flow: MRP report → indent → RFQ → PO → GRN → payment.

The MRP engine runs through your orders and BOMs, then tells you what to buy and when.

Accounting stays in Tally. Operations run in TranZact, with a one-way sync and no double entry.

Choosing the vendor stays with your purchase team. Teams go live in 2–3 weeks. See the purchase management page, and plan contents on the pricing page.

Book a demo →

How to fill the RFQ format, step by step

  1. Give it a number and date. Use a running series.
  2. Copy items and quantities from your indent or shortage list. Don't retype from memory.
  3. Write the full specification. Add the drawing number and revision for made parts.
  4. Use one unit per item, the same for every vendor.
  5. Ask for the price basis and GST separately. Freight and packing come as their own figure.
  6. Set a required-by date and a separate quote deadline. One is for the material, the other for the reply.
  7. Send the same file to 3–6 vendors. Change only the vendor name.
  8. Put the replies side by side. Add freight and packing to each total, then check delivery dates.

Sample email to send with the RFQ

Subject: RFQ/2026/014: MS sheet, square tube and round bar

Dear Sir/Madam,

Please quote for the items in the attached RFQ (Excel). Fill the vendor columns, and state ex-works or delivered, freight, GST % and quote validity.

We need delivery at our plant by 15 Dec 2026. Please send your quote by 28 Nov 2026.

Regards,
[Name], Purchase, [Company], [Phone]

Worked example: steel for an order of 50 trolleys (illustrative)

ABC Engineering (an example company) needs sheet, tube and bar for 50 material-handling trolleys. All numbers are illustrative.

Table 1 (Example): the header

FieldExample entry
RFQ number and dateRFQ/2026/014, 24 Nov 2026
Price basisVendor to state ex-works or delivered
Payment terms30 days from receipt
Quote deadline and validity28 Nov 2026, valid 30 days
NotesMill test certificate with each lot

Table 2 (Example): the items as sent

Sr.Item and specificationQty and unitRequired by
1MS sheet, IS 2062 E250, 2 mm, 1250 × 2500 mm40 Nos15 Dec 2026
2MS square tube, IS 4923, 25 × 25 × 2 mm, 6 m length120 Nos15 Dec 2026
3MS round bar for axles, IS 2062 E250, 20 mm dia150 kg15 Dec 2026

Table 3 (Example): three replies compared on landed cost

VendorMaterial + freight and packingLanded total (excl. GST)Delivery offered
Vendor A (delivered)₹2,03,000 + ₹0₹2,03,00012 Dec: on time
Vendor B (ex-works)₹1,96,300 + ₹11,000₹2,07,30022 Dec: late
Vendor C (delivered)₹2,06,500 + ₹0₹2,06,50015 Dec: on time

Vendor B has the lowest unit rate on every line: ₹2,800, ₹620 and ₹66, against A's ₹2,900, ₹640 and ₹68. But B quotes ex-works, and freight and packing add ₹11,000.

That makes B's landed total the highest, and its 22 Dec date misses the 15 Dec need. Vendor A is cheapest landed and on time, so A wins.

All three charge 18% GST, so leaving GST out keeps the comparison fair.

Common RFQ mistakes

  • Quantity with no unit. One vendor quotes per kg, another per sheet.
  • Vague specification. "MS sheet" with no grade or thickness brings quotes for different materials.
  • No drawing revision. The vendor quotes an old drawing.
  • Not asking ex-works or delivered. Freight stays hidden until the invoice.
  • Not asking if GST is included. The cheaper rate can look dearer.
  • No quote deadline, or mixing it with the delivery date. The PO waits.
  • Different details to different vendors. The replies don't line up.
  • Comparing unit rates, not landed totals. The example above shows where that leads.
  • No quote validity. The vendor revises the price at PO time.

Run the whole purchase flow on one system

See how purchase runs as one flow in TranZact, from the MRP report to payment.

Don't be the bottleneck. Become the AI-Run Factory.

Book a demo →

Frequently asked questions

Should the RFQ include our target price?

Usually not in the first round. Ask for the vendor's best price on a clear specification, then negotiate with the shortlisted two or three.

How many vendors should get the same RFQ?

Three to six capable vendors is a practical range. Send every vendor the same file so the replies line up side by side.

Is an RFQ legally binding?

No. An RFQ only asks for prices. The order is placed when you issue a purchase order and the vendor accepts it.

How long should a quote stay valid?

Ask for a validity period in the RFQ (the example uses 30 days) so the price still holds when you raise the PO.

Can I use this format for job work or bought-out parts?

Yes. Put the drawing number and revision in the item row and note any material you will supply in Remarks.

What happens after I choose a vendor?

Raise a purchase order on the agreed rate and terms, then check the goods against the PO with a goods received note when they arrive.

Don’t be the bottleneck.
Become the AI-Run Factory.

Book a demo

Born in India. Building for the world.