Free template · Excel

Order Confirmation Format: Free Excel + Filled Example

An order confirmation is the document a seller sends to confirm a buyer's purchase order is accepted and will be supplied on agreed terms. A good format shows the buyer's PO number, each item's quantity, unit, rate, GST and line total, and a committed delivery date. Payment terms, delivery terms and any change from the PO are written on it clearly.

Download the Excel template

Download the free Excel on this page. It has two sheets: a blank order confirmation format and a filled example with illustrative numbers.

What is an order confirmation?

An order confirmation is the seller's written yes to a buyer's purchase order. The sales or order desk sends it after checking stock, capacity and rates. It goes out before production starts or goods are dispatched.

To confirm an order, read the PO line by line and check you can supply it. Then reply in writing with what you will supply, at what price, by when and on what terms. Both sides use this document if a question comes up later.

Order confirmation vs purchase order vs quotation vs invoice

DocumentWho sends itWhenWhat it does
QuotationSellerBefore the orderOffers items, rates and terms
Purchase orderBuyerWhen the buyer decidesOrders items at stated rates and dates
Order confirmationSellerAfter checking the POAccepts the PO and commits delivery dates
Tax invoiceSellerAt dispatchBills the goods; the GST document for the sale

Order confirmation vs order acknowledgement

In most factories these are the same document under different names. Some call it an order acceptance or a sales order confirmation. Some sellers first send a short "PO received" note, then the full confirmation once stock and dates are checked.

Order confirmation format: every column explained

The format has three parts: a header, an item table and a terms footer.

Header

  • Your company name, address and GSTIN: the buyer checks these against their vendor records.
  • Order confirmation number and date: your own reference, the same as your sales order number.
  • Customer name, GSTIN, billing and shipping address: copy them from the PO.
  • Customer PO number and date: the most important field. The buyer matches every GRN and invoice to it.
  • Place of supply: the state where the goods are delivered. Same state as yours means CGST + SGST. A different state means IGST.
  • Contact person: who the buyer should call about this order.

Item table

ColumnWhat to writeWhy it matters
Item code / drawing revYour code, the buyer's code and the drawing revisionStops the wrong version being made
DescriptionShort name, material and sizeConfirms it is the right part
HSNHSN code of the itemDecides the GST rate
Qty and unitQuantity and unit as on the PO (Nos, kg, m)A unit mismatch causes short or excess supply
Rate (₹)Rate per unit, as agreed in your quotationShows any gap from the PO rate
Taxable value (₹)Qty × rateThe base for GST
GST % and GST amount (₹)Tax rate and amount for the lineThe buyer approves the full cost upfront
Line total (₹)Taxable value + GSTAdds up to the order value
Delivery dateCommitted date for this line; split into lots if neededLines often ship at different times
Deviation from POAny change in rate, qty, date or spec, or "None"Puts every change in writing

Below the table, show the taxable total, CGST and SGST (or IGST), and the grand total.

Terms footer

  • Payment terms: 30 days from invoice, or advance with balance before dispatch.
  • Delivery terms: Ex-works your factory, or delivered to the buyer's site.
  • Freight, packing and insurance: who pays for each.
  • Acceptance line: ask the buyer to confirm any deviation in writing by a date you name.
  • Signature: name and role of the person who can commit price and delivery.

How to fill an order confirmation, step by step

  1. Read the PO line by line: item, drawing revision, quantity, unit, rate and date.
  2. Check stock and capacity. Use the bill of materials to see what raw material each line needs.
  3. Match each PO rate to your quotation.
  4. Fill the header, starting with the customer's PO number and date.
  5. Fill one row per PO line, in the same order as the PO.
  6. Set a delivery date for each line, split into lots if needed.
  7. Write every change from the PO in the deviation column.
  8. Add payment, delivery and freight terms.
  9. Sign it, save it as a PDF and send it with a short email.
  10. Get the buyer's written OK on any deviation before you start production.

This is also how you confirm a purchase order.

Want to see these steps done in TranZact? Bring a recent customer PO to the demo and walk through it from quotation to dispatch.

Book a demo →

Worked example: order confirmation for an engineering components order

A Pune machine shop receives PO 4500-2231 from a customer in Nashik. Both are in Maharashtra, so GST splits into CGST 9% and SGST 9%. All numbers and codes below are illustrative.

ItemQty × rate (₹)GST 18% (₹)Line total (₹)
FL-220 Rev B machined flange500 Nos × 185.0016,6501,09,150
SH-118 Rev C drive shaft200 Nos × 640.0023,0401,51,040
BK-045 Rev A mounting bracket1,000 Nos × 42.507,65050,150
HB-310 hex bolt M12 × 502,000 Nos × 9.803,52823,128
TotalTaxable value 2,82,60050,8683,33,468

CGST and SGST are ₹25,434 each.

Two lines carry deviations. The shaft ships in two lots of 100, on 10 Dec and 24 Dec, while the PO asked for all on 10 Dec. The bracket is at the quoted rate of ₹42.50, while the PO shows ₹40.00. Both are written on the confirmation and need the buyer's OK.

[[IMAGE {"type":"checklist","title":"Check before you send it","items":["Customer PO number and date","Drawing revision on every line","Same unit as the PO","Right GST: CGST + SGST or IGST","A delivery date per line","Every deviation written down"]}]]

Covering email to send with it

Put the customer's PO number in the subject so it is easy to find.

Subject: Order confirmation OC-1187 against your PO 4500-2231

Dear [Buyer name],

Thank you for your PO 4500-2231 dated [date]. Please find our order confirmation OC-1187 attached.

We confirm supply of all 4 lines, with deliveries from 10 Dec 2026.

Line 2 ships in two lots and line 3 is at our quoted rate. Please confirm both in writing.

Regards, [Name], [Role], [Phone]

Acknowledgement only? Use one line:

"We acknowledge receipt of your PO 4500-2231 dated [date]. Our order confirmation will follow by [date]."

8 common mistakes in order confirmations

  1. No customer PO number. The buyer cannot match your GRN or invoice, so payment gets held.
  2. Copying the PO rate without checking the quotation. A lower PO rate becomes the agreed rate once you confirm it.
  3. One delivery date for the whole order. One late line makes the whole order late.
  4. Changes left in an email or call. If it is not on the confirmation, it gets disputed.
  5. Wrong GST type. CGST + SGST on an inter-state order, or IGST on a local one, means a corrected invoice later.
  6. Missing drawing revision. The shop floor makes the old version and the lot gets rejected.
  7. Unit mismatch. The PO says kg, you confirm Nos, and the quantity is wrong.
  8. Terms left as "as discussed". Freight, packing and payment then become a fight at dispatch.

Where TranZact fills this for you

In Excel, every order confirmation is retyped from the PO and the quotation. Rates and dates then drift across files, emails and WhatsApp. The fault is the patchwork, not the person filling it.

TranZact is manufacturing AI software used by 10,000+ manufacturers. Its sales module covers enquiry, quotation, order timeline, dispatch, e-invoicing and payment, on one system.

  • The MRP engine runs through your orders and BOMs, then tells you what to buy and when. See purchase management.
  • Delivery and payment reminders and Gmail integration are in the Grow plan.
  • At dispatch, TranZact generates the e-way bill from the GST invoice, with e-invoice (IRN) in the same flow, on all plans.
  • Accounting stays in Tally. Operations run in TranZact, with one-way sync and no double entry.
  • Want your own document layout? Custom document formats are on the Dominate plan. Plan details are on the pricing page.

TranZact goes live in 2–3 weeks.

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

Use the free format today. When retyping orders starts holding you back, see how 10,000+ manufacturers run on TranZact.

Book a demo →

Frequently asked questions

Is an order confirmation the same as a sales order?

In most factories, yes in practice. The sales order is the seller's internal record and the order confirmation is the copy sent to the buyer. Both should carry the same order number and the customer's PO number.

Should GST be shown on an order confirmation?

Showing the GST rate and amount per line lets the buyer approve the full cost before dispatch. The tax invoice raised at dispatch is still the GST document.

What if I can't meet the PO delivery date?

Write the date you can meet against that line and mark it as a deviation. Get the buyer's written OK before starting production.

Can I send the order confirmation by email or WhatsApp?

Yes. Send it as a PDF with the customer's PO number in the subject, and keep the buyer's reply with the order.

Who should sign the order confirmation?

Someone authorised to commit price and delivery, usually the owner, sales head or a named signatory. Leave space for the buyer to sign if there are deviations.

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

Book a demo

Born in India. Building for the world.