Skip to content
Efidis
Efidis

Customers and salesUpdated 10 min read

Quote template with AI: from one day to 15 minutes

3D illustration of a quote with a lilac header, a stopwatch and a lilac paper plane.
In this article

An illustrative example. A customer writes on Tuesday at 10 a.m.: "Can you quote me 40 cases of the large size and 12 of the medium, delivered Friday?" The quote goes out Wednesday afternoon. Nobody spent a full day writing it. It took 40 minutes of actual work, spread across looking up prices, asking the warehouse whether there was stock, getting a discount approved and waiting for someone to open the right file.

Why speed matters more than formatting

The most cited study on response times was published in Harvard Business Review. The authors sent a test inquiry through the websites of 2,241 U.S. companies: 37% responded within an hour, 24% took more than 24 hours and 23% never responded at all. Among those that did respond within 30 days, the average was 42 hours (Oldroyd, McElheran and Elkington, 2011).

In a second part, they analyzed 1.25 million leads from 42 companies. Firms that tried to reach the customer within the first hour were nearly 7 times as likely to qualify the lead as those that waited one more hour, and more than 60 times as likely as those that waited 24 hours or longer (Oldroyd, McElheran and Elkington, 2011).

Read it carefully: the data predates 2011, it covers web inquiries, and "qualify" means getting a conversation, not closing a sale. Even so, the direction is clear: a customer's interest cools by the hour, not by the week.

There's a second reason. In 6sense's study of more than 4,000 business buyers, 94% of buying groups had already ranked their preferred vendors before first contact, and they ended up buying from that favorite 77% of the time (6sense, 2025). If you're not the favorite, your quote is your chance to change the ranking. If it shows up late, it just confirms what the customer already thought.

The rule: AI writes, the list sets the price

Quoting has two slow parts. The first is finding data: prices, stock, lead times, the discount cap. The second is writing: figuring out what the customer asked for and sending back a clear answer. The template handles the first and AI handles the second. What can't happen is the two getting mixed up.

A language model writes well and confidently, even when it's wrong. In 2024, a Canadian tribunal ordered Air Canada to pay a customer because the chatbot on its website promised a discount the airline didn't offer: the company is responsible for what its chatbot says (Moffatt v. Air Canada, 2024). A quote works the same way. If the AI writes a price, that price is yours.

The rule in one line: AI writes, the list sets the price. No number on the quote comes from the model's memory or a salesperson's. It comes from the price sheet, and the sheet does the math.

People who use AI every day already work this way: 86% treat what it produces as a starting point, not a final answer (Microsoft, 2026). The template turns that habit into a method.

The template: three sheets, columns and fields

Build one file with three sheets: Prices, Quote and Log. One person keeps the first one up to date; salespeople fill in the second; the third tells you what's happening with everything you've quoted.

Sheet 1: Prices

ColumnWhat goes inIllustrative example
SKUUnique, no spaces or special charactersBOX-040
Product or serviceThe name as the customer should read itCorrugated box, 16 × 12 in
UnitEach, case, hour, foot, visitCase
List priceBefore tax12.50
Max discountWhat a salesperson can give without approval8%
TaxThe rate that applies where you sellDepends on the item
Lead timeUsual business days3
UpdatedDate of the last price change2026-10-01

Sheet 2: Quote, the header

FieldWhat it's for
Quote numberSo you can find it later and know how many you send a month. Never repeat one: take it from the Log sheet
Date and expirationAn expiration date (say, 15 days) protects you if prices change
Customer and contactCompany, person, phone or email
SalespersonWho owns the quote
Delivery dateThe one the customer asked for, or the one you can meet, written as a date, not "soon"
Payment termsDue on receipt, Net 30, 50% deposit
Next stepWhat the customer has to do to accept: reply, sign, pay the deposit

If you only need the document to send, without the spreadsheet, use the PDF and Word quote template.

Sheet 2: Quote, the line items

ColumnWho fills it inHow
SKUSalespersonDropdown with the SKUs from Prices
ProductThe sheetFormula that looks up the SKU in Prices
QuantitySalespersonA number greater than zero
Unit priceThe sheetFormula; the cell is locked
Discount %SalespersonValidated: can't exceed the max discount
SubtotalThe sheetQuantity × price × (1 − discount)
TaxThe sheetSubtotal × the item's tax rate
TotalThe sheetSubtotal + tax

The key formula is the one that pulls the price. In Excel 365, 2021 and 2024, and in Google Sheets: =XLOOKUP(A12,Prices!A:A,Prices!D:D,"Not on the list"). It looks up the SKU in cell A12 on the Prices sheet and returns its price; if the SKU doesn't exist, it says so instead of leaving a blank. Excel 2016 and 2019 don't have XLOOKUP, so use VLOOKUP there.

For the cap, add data validation to the Discount column so it won't accept anything above that SKU's max discount. If the customer asks for more, the salesperson knows they need approval; if not, they don't ask.

Sheet 3: Log

One row per quote: number, date, customer, salesperson, total, time the request came in, time the quote went out, status (sent, won, lost) and reason lost. The two timestamps give you your real response time. After 30 quotes, the reason-lost column tells you whether you're losing on price, on delivery or on being late. The same sheet gives you the close rate the Monday dashboard asks for.

Where the day goes, and where you get it back

Here's the breakdown for the opening example. The numbers are illustrative: track your own for a week before you change anything.

StepBeforeWith template and AI
Read the message and figure out what they want5 minutes1 minute: AI pulls out products and quantities
Look up prices15 minutes across files and emails0: the formula pulls them
Confirm stockAbout 3 hours waiting on the warehouse3 minutes, if inventory lives in an up-to-date sheet or system
Approve the discountHalf a day waiting on the manager0 if it's within the cap
Write and send20 minutes3 minutes of AI and 8 of review
Total40 minutes of work and more than a day of waitingAbout 15 minutes

The work was never a full day; the waiting was. The list removes the lookup, the cap removes the approval and AI removes the writing. Stock is the one piece the template can't fix: if inventory lives in one person's head, that person is still the bottleneck.

The prompt: how to have AI draft the quote

  1. Use a business accountOpen the AI tool on the business plan your company approved. OpenAI, for example, says that on its business plans it doesn't train its models on company data by default (OpenAI, 2026). Check that condition with your provider and put the rules in an AI use policy.
  2. Give it the product listAttach the exported Prices sheet or paste it in full. SKUs, names, units and lead times only: it doesn't need prices to write.
  3. Paste the customer's messageExactly as it came in, typos and all. If it was a voice message, paste the transcript.
  4. Use the prompt belowSave it as a template in the tool so you don't retype it every time.
  5. Move the lines to the sheet and reviewCopy SKU and quantity into the template, let the sheet do the math and check three things: that each product is what the customer asked for, the delivery date and whatever landed under "To confirm."

The prompt, to copy and adjust for your business:

  • You are a sales assistant at [Company]. Below are our product list and a message from a customer.
  • Pull out every product the customer asks for, with quantity and unit, and find its SKU on the list.
  • If a product isn't on the list or the quantity isn't clear, don't quote it: put it under a "To confirm" section with the question we'd ask the customer.
  • Don't write prices, discounts or taxes. Our spreadsheet calculates them.
  • Return a table with SKU, product and quantity, and a two-paragraph email that confirms the delivery date the customer asked for and states the next step to accept.

Look at the third and fourth lines. They ask the AI to say "I don't know" instead of guessing, and they take the numbers away from it. That's the rule in practice: AI writes, the list sets the price. Then you copy the total into the email from the sheet, not from the AI's text.

Checklist: eight things a quote that closes has

Before you send, check the quote against this list. If something is missing, the customer will have to ask, and every question costs another day.

  • It has a quote number and a date, and it's in the Log.
  • It says how long the prices are good for.
  • Every line has a SKU, quantity and unit, and matches what the customer asked for.
  • Prices come from the current list, and no discount goes over the cap without approval.
  • Subtotal, tax and total are shown separately.
  • It gives a specific delivery date you can actually meet.
  • It states the payment terms: due on receipt, net terms or deposit.
  • It ends with a clear next step: what the customer does to accept and who to reply to.

When this method isn't worth it

  • You send fewer than ten quotes a month. At that volume, a good template is enough and AI saves only a few minutes.
  • Every quote is a project: a build, a custom job, consulting work that needs a site visit or discovery. The template still helps with fixed-price line items, but the value is in the assessment, and AI doesn't write that. If you quote construction jobs, what comes after acceptance is construction cost control.
  • Your prices change daily and nobody updates the list. The AI and the formula will confidently read a stale list. Sort out who updates prices, and when, first.
  • The customer requires their own format, as in a formal bid. Use the sheet to calculate and fill in their form by hand.
  • You only have free AI accounts and the quote includes customer data. Use the template without AI until you have a business account.

The template can be wrong too. In audits of real-world spreadsheets, 94% of the 88 spreadsheets reviewed across seven studies contained errors (Panko, 2005). Lock the formula cells, let only one person edit the Prices sheet and save a copy before every price change.

When the spreadsheet stops being enough

The template starts to break when every salesperson keeps their own copy, stock gets checked over text messages and the Log is filled in from memory on Friday. At that point the problem isn't writing fast anymore: it's that the data behind the quote lives in different places.

The next step is having prices, inventory and customers in one system, so the quote is built from current data and gets recorded without anyone copying it. With the data in one place, connecting an AI to draft quotes is also safer: it reads the current list instead of a file exported last week. That's what we build as custom software, for example for distributors.

Sources

  1. James B. Oldroyd, Kristina McElheran and David Elkington, "The Short Life of Online Sales Leads," Harvard Business Review, 2011 (opens in a new tab)
  2. 6sense, "The Timeline for Influencing B2B Buyers Is Shrinking: Insights From 6sense's 2025 Buyer Experience Report," 2025 (opens in a new tab)
  3. American Bar Association, "BC Tribunal Confirms Companies Remain Liable for Information Provided by AI Chatbot" (Moffatt v. Air Canada), 2024 (opens in a new tab)
  4. Microsoft, "2026 Work Trend Index," 2026 (opens in a new tab)
  5. OpenAI, "Enterprise privacy at OpenAI," 2026 (opens in a new tab)
  6. Microsoft, "XLOOKUP function," Office support (opens in a new tab)
  7. Raymond R. Panko, "What We Know About Spreadsheet Errors," revised 2005 version (opens in a new tab)
See how we work in route-based distribution

Frequently asked questions

Send quotes the same day

Efidis builds your company's app so every quote goes out with current prices and stock. On the call we'll look at how your team quotes today and where the time goes.