Sales order template and a confirmation email you can reuse
Short answer: A sales order is the internal record of what a customer bought: who, what, how many, at what price, and when it ships. A good template has a header block (customer, PO number, terms, ship-to) and a line table (item, quantity, price, line total). Send the customer a short confirmation email with the same numbers the moment the order is entered. You can do all of this in Excel or Google Sheets, and a short Google Apps Script (Google's built-in scripting tool for Sheets) can send the confirmation for you.
You want one sales order sheet and one confirmation email your team can copy every time, instead of retyping orders from emails.
I'm Ranjit, and I run Blur Studio: 15+ years building software, 120 apps taken live, and clients who have gone on to raise $10M+. I build AI systems and processes that help businesses do a lot more with a lot less time. I also work differently from most of what else is out there, more on that further down this page. Say hello.
What is a sales order, and how is it different from a quote or an invoice?
A sales order is your own record that a customer has said yes. It sits between three other documents, and people mix them up. Related reading: a purchase order template.
- Quote: a price offer. The customer has not committed yet.
- Customer PO: the customer's purchase order, which is their own paper saying they will buy. A PO is a document the buyer creates. Your sales order is the one you create.
- Sales order: your internal copy of the deal, entered after the quote is accepted or the PO arrives. Your team picks, packs and ships from it.
- Invoice: the bill, sent when you ship or as the terms say.
Why keep a sales order at all? Because the customer's PO is rarely in your format. It may be a PDF, an email line or a phone call. The sales order turns that into one clean record that the warehouse, the shop floor and accounting can all read. My guide to quote generators covers the step before this one.
The sales order template, field by field
Build one sheet with two parts: a header block at the top and a table of lines below it. Here is what each part needs.
Header block (one per order)
| Field | Why it matters |
|---|---|
| Sales order number | A unique number, such as SO-1042. Every email, pick list and invoice refers back to it. |
| Order date and requested ship date | The date you got the order and the date the customer wants it. These two dates are how you measure lead time. |
| Customer name and account number | Ties the order to the customer record and their price list. |
| Customer PO number | Many customers will not pay an invoice that lacks their PO number. |
| Bill-to and ship-to address | These are often different. Check the ship-to every time. |
| Payment terms | For example Net 30, meaning payment is due 30 days after the invoice date. |
| Ship via and freight | Carrier, and whether freight is prepaid, collect or added to the invoice. |
| Contact email for confirmations | The address the confirmation goes to. This may not be the buyer's main address. |
| Status | Entered, Confirmed, Picked, Shipped, Invoiced. One word that tells everyone where the order is. |
Line table (one row per product)
| Column | Notes |
|---|---|
| Item number or SKU | A SKU is your code for one exact product. Use the same code as your price list. |
| Description | Pulled from the price list so it matches what you quoted. |
| Quantity ordered | Also check it against the minimum order quantity (MOQ), the smallest amount you will sell. |
| Unit of measure | Each, box, case or foot. A mismatch here causes expensive mistakes. |
| Unit price | The price for this customer, which may differ from list price. Add a note on where it came from. |
| Line total | Quantity times unit price. Use a formula, never a typed number. |
| Quantity backordered | What you cannot ship now. Add an expected date. |
Below the lines, add subtotal, freight, tax and total. If the customer holds a resale certificate, which lets them buy for resale without sales tax, note it in the header so tax is left off on purpose.
A filled-in example (made-up figures)
These names and numbers are invented to show the layout.
| Header | Value |
|---|---|
| Sales order | SO-1042, dated 12 Nov 2026, ship by 18 Nov 2026 |
| Customer | Harbor Plumbing Supply, account HPS-220, PO 77815 |
| Terms and shipping | Net 30, ground freight added to invoice |
| SKU | Description | Qty | Unit price | Line total |
|---|---|---|---|---|
| VLV-050 | Brass ball valve, 1/2 inch | 12 each | $18.50 | $222.00 |
| CPL-075 | Copper coupling, 3/4 inch | 40 each | $6.25 | $250.00 |
| GSK-100 | Flange gasket, 1 inch | 6 boxes | $41.00 | $246.00 |
Subtotal $718.00. Freight $35.00. Tax $0.00 (resale certificate on file). Total $753.00. If the gasket box had only four in stock, the line would show quantity 6, backordered 2, with the date the next shipment arrives.
The order confirmation email you can reuse
The confirmation proves you read the order the same way the customer meant it. Most disputes start with a mismatch that nobody saw until the truck arrived. Send it within the hour. Keep it short and put the numbers in the body, not only in an attachment.
Subject: Order confirmation: SO-1042 (your PO 77815)
Hello [first name],
Thank you for your order. Here is what we have entered.
Our order: SO-1042. Your PO: 77815.
Ship-to: [address].
Requested ship date: 18 Nov 2026.
Terms: Net 30.
Items: 12 brass ball valves 1/2 inch at $18.50, 40 copper couplings 3/4 inch at $6.25, 6 boxes flange gaskets 1 inch at $41.00.
Subtotal $718.00. Freight $35.00. Total $753.00.
Backorders: [none, or item, quantity and expected date].
Please reply within one business day if anything here is wrong. If we do not hear from you, we will ship as shown.
[Your name, phone]
That last line matters. It gives the customer a clear window to correct you, and it gives you a record that they had the chance. For the next step, the quote acceptance form and email wording uses the same idea earlier in the deal.
How to send the confirmation automatically from Google Sheets
If you keep orders in Google Sheets, you can have the sheet send the confirmation when you mark an order Entered. Google Apps Script is a free scripting tool built into Sheets. Its mail service has a sendEmail method that takes a recipient, subject and body. Here are the steps.
- Set up one row per order with these columns: A order number, B customer, C contact email, D PO number, E total, F status, G confirmed on.
- Open Extensions, then Apps Script in the sheet and paste the script below.
- Run it once by hand and approve the permission to send email.
- Test with your own email in column C before using a customer address.
- Add a time-based trigger in the Triggers panel so it runs every 10 minutes or every hour.
function sendConfirmations() {
var sheet = SpreadsheetApp.getActiveSheet();
var rows = sheet.getDataRange().getValues();
for (var i = 1; i < rows.length; i++) {
var r = rows[i];
if (r[5] === 'Entered' && r[6] === '') {
var body = 'Thank you for your order.\n' +
'Our order: ' + r[0] + '. Your PO: ' + r[3] + '.\n' +
'Total: $' + r[4] + '.\n' +
'Please reply within one business day if anything is wrong.';
MailApp.sendEmail(r[2], 'Order confirmation: ' + r[0], body);
sheet.getRange(i + 1, 7).setValue(new Date());
}
}
}
Column G stops the same order being confirmed twice. For a full item list in the email, build the text from your line rows the same way.
Know the limit. Google caps how many recipients a script can email each day. As of November 2026 the Apps Script quota page lists 100 a day for a free Gmail account and 1,500 a day for a Google Workspace account. That is plenty for most small distributors, but it is a ceiling you should know about.
Where a spreadsheet sales order stops working
This works well up to a point. I would move off it when you see these signs:
- Two people edit the same sheet and one overwrites the other.
- Prices are typed, not looked up, so the same item gets different prices on different orders.
- Stock is not checked before you confirm, so you promise what you do not have.
- Orders arrive by email and someone retypes them. That retyping is the real cost. My guide to using AI on email orders covers it, and the same fix applies to a template like this.
The ready-made options are real. Zoho Books, an accounting tool, includes sales order tracking and price lists from its Professional plan, listed at $20 a month billed yearly as of November 2026. Fishbowl, inventory software that links sales orders to stock, lists plans from $229 a month with 2 users, billed yearly, as of November 2026. JobBOSS, from ECI, is a shop management system for manufacturers with sales order processing built in. Check each vendor's page for current prices.
If the sheet is the part you like and the problem is that it is fragile, my guide to turning an Excel sheet into a web app explains the middle path: same columns, but with logins, price lookups and automatic emails.
How I'd approach this
Start with the sheet and the email above for two weeks. Do not buy software yet. Count how many orders you enter, how many minutes each takes, and how many corrections come back after you send a confirmation. Those three numbers tell you what an automatic system is worth to you.
Then fix the biggest leak first. If prices are wrong, add a price lookup. If stock is the problem, link orders to inventory. If retyping is the problem, read orders straight from email. A sales order template is a good first step, but I would never leave it as the final one. Learn the process on paper, then let software do the repeating. See my guide to business process automation for how to pick the order of fixes.
Questions people ask
What should a sales order include?
At minimum: an order number, date, customer name, customer PO number, ship-to address, payment terms, and a line for each item with quantity, unit price and line total. Add requested ship date, freight, tax and a status column so everyone knows where the order stands.
Is a sales order the same as an invoice?
No. A sales order records what the customer agreed to buy, before shipping. An invoice is the bill you send after you ship or as your payment terms say. The invoice should reuse the numbers from the sales order.
Should I send an order confirmation for every order?
Yes, especially for orders that came by phone or a PDF purchase order. The confirmation catches wrong quantities, wrong ship-to addresses and wrong prices before the shipment leaves, which is far cheaper than fixing them afterward.
Can Google Sheets send the confirmation email for me?
Yes. A short Google Apps Script can read each new order row and email the customer. As of November 2026 Google lists a limit of 100 email recipients a day on free Gmail accounts and 1,500 on Google Workspace accounts. See how to turn a spreadsheet into a web app if you outgrow it.
When should I stop using a spreadsheet for sales orders?
When more than one person edits it, when prices are typed by hand, or when you need to check stock before confirming. Those are the points where mistakes start costing money, and where a tool built around your price lists pays off.
More in this topic: B2B: order entry and purchase orders (9 guides) →