Automation

How do we stop quotes taking all day to put together?

By Paul Meakin9 min read

Office desk with pricing formula document, laptop, and smartphone calculator
Photo: Leeloo The First on Pexels

Why does one quote take a whole day?

Often because very little of that day is quoting. Someone opens the last quote for a similar job, saves it under a new name and starts overwriting. The customer details come out of an email. The prices come from a spreadsheet, a supplier's PDF or the memory of whoever priced the last one. Line totals get worked out on a calculator and typed in. So does the VAT. Then someone checks the terms, because nobody is sure last year's version is still right, and a director reads the lot, because that is the only way anyone catches a mistake.

None of that is unreasonable. Each step is there for a reason. But the thinking, meaning what the job involves and what it is worth, is often the smaller part of the day. The rest is typing things the business already knows.

A customer kept waiting is free to ask someone else.

What does a quote actually have to say?

It depends who you are selling to. GOV.UK lists what an invoice must include, from a unique identification number to the total owed. Quotes have no single list like that. If you sell to consumers, though, the Consumer Contracts Regulations 2013 set out information you must give before they are bound, and for services section 50 of the Consumer Rights Act makes it part of the contract. That includes the total price with taxes, or how it will be worked out if it cannot be calculated in advance. For sales made away from your premises or at a distance, it also includes the conditions of any right to cancel. Whether your quotes fall under them is a question for your solicitor. A few other rules follow you too.

If you are a limited company, GOV.UK says you must include your company's name on all company documents, publicity and letters. Business letters, order forms and websites must also show the registered number, the registered office address and where the company is registered, and the fact that it is a limited company. GOV.UK does not mention quotes by name, so treat this as the safe default. Put all of it in the template footer once and nobody has to remember it.

What you write counts as well. For services sold to consumers, section 50 of the Consumer Rights Act 2015 treats anything said or written to the consumer about the trader or the service as a term of the contract, if they took it into account when deciding to go ahead, or when making a decision about the service afterwards. Anything you said at the same time to qualify it counts too, as does any change you both expressly agreed. A promise copied from an old quote, for something you stopped offering years ago, is not harmless filler.

Leaving the price of a service vague does not help. If a consumer has paid nothing yet, the contract neither fixes a price nor says how to fix one, and nothing you said or wrote that counts as part of it fixes one either, section 51 says the consumer pays a reasonable price, and no more. Between businesses in England, Wales and Northern Ireland, section 15 of the Supply of Goods and Services Act 1982 reaches a similar place for services: where the contract or your past dealings do not settle the price, the customer pays a reasonable charge. Both call what is reasonable a question of fact, which is a polite way of saying an argument. Goods fall under different rules, which this post does not cover.

Then there is getting paid. GOV.UK's guidance on late commercial payments says an agreed payment date must usually be within 60 days for business transactions, or 30 days for public authorities. With no agreed date, the payment is late 30 days after the customer gets the invoice, or after you deliver if that is later. The quote is the natural place to agree it.

Take all of that as a map, not legal advice. Your actual terms are a job for your solicitor.

Where do people get this wrong?

The root mistake is treating a quote as a document. It is data with a layout on top. Once the price lives only inside a Word file, every new quote is another chance for it to be wrong, and nobody can answer a simple question like how much is out there waiting for a yes.

Copying the last quote is how that shows up. The classic failure is the previous customer's name still sitting in paragraph three. If their address or job details came along too, you have just told one customer about another.

Then come the prices. A supplier puts a rate up, one person updates their copy of the spreadsheet, and the quotes going out next week depend on who writes them.

Some people buy quoting software at this point. If the pricing rules live in one person's head, the software gets set up around a guess. Write them down first.

The last one is silence. Without a record of what went out and when, the follow up happens if someone remembers.

Which fields should a template fill in by itself?

Nearly all of them. The test is whether the business already knows the answer before the person quoting sits down.

Field Where it comes from Who touches it
Customer name and address Your customer list or CRM Nobody, after the first entry
Quote number and date Generated when the quote is made Nobody
Line items and unit prices One price list Whoever owns the price list
Quantities The job The person quoting
Line totals, VAT and total Formulas Nobody
Scope wording Approved paragraphs, chosen from a list The person quoting, who edits them
Payment terms and how long the price holds Standard terms Whoever owns the terms
Company details The template footer Nobody

Say plainly whether prices include VAT, and check with your accountant how to show it to consumers and how VAT applies to what you sell. Hold the rate in one cell rather than typing it into each quote.

Quantities and scope are the judgement. Everything else can arrive filled in.

How do you build that with tools you already have?

If you run on Google Workspace, it comes down to three small pieces.

First, a sheet with a customer tab, a price list tab and a quote tab. Google's dropdown lists give each line a fixed set of options, and anything typed that does not match is rejected by default. XLOOKUP then returns the value from a result range based on where a match was found, so choosing a line pulls the current price from the list.

Second, a Google Doc that holds your layout, with placeholders such as CUSTOMER_NAME where the details go. A short Apps Script does the rest. makeCopy creates a copy of the file in the folder you choose, replaceText swaps every occurrence of each placeholder for the real value, and getAs turns the result into a PDF. Two details from Google's reference are worth knowing first. The search pattern is treated as a regular expression, so keep placeholders to plain letters and underscores. It also matches each text block separately, so a placeholder must not be split across two blocks. replaceText only swaps text, so it will not add table rows for a quote with a varying number of lines. That needs a little more script, using the table's appendTableRow method.

Third, a log. The script adds a row for each quote: number, customer, value, date and status. Time driven triggers can then run on a recurring interval and tell a named person which quotes have gone unanswered. Build it on an account the business controls, because installable triggers always run under the account of the person who created them.

The log tells you what is out there, and when a quote is accepted, the line items are already in a record, so nobody types them again for the invoice.

Word's mail merge works on the same idea: the data lives in a list and the document is only a layout. And check your accounting package, because it may have a quoting feature nobody ever switched on.

AI has a narrow job here. It can turn site notes into a first draft of the scope, with a person reading it before it goes. It should not set the price. There is more on that in where to start with AI.

We build the sheet and script version in our Apps Script service, and a proper web application when several people quote at once and approvals need a record.

When is this not the answer?

When the day really is the estimating. If the time goes on site visits, measuring up and working out how a job will be done, a template saves the typing at the end and nothing else. That is still worth having.

A few quotes a month does not need any of this. A tidy template and one maintained price list will do.

When nobody agrees how pricing works. Automating that produces wrong quotes faster. Sort out the rules first, which is the work we do as business analysis and solution design.

And when the question is what your terms should say. That is for your solicitor. We can put approved wording into a template. We do not write it.

Where do you start?

Take the last few quotes you sent and go through each one with two pens. Mark every line in one colour if it was copied from something the business already held, and in another if someone had to decide it. The first colour is what a template can take over. The second is where you want a person spending their time.

If the first colour covers most of the page, tell us what's stuck and we'll map the quickest fix. We will tell you straight whether it needs a better template, a short script or a feature you already pay for. Time to talk yet?

Common questions

Do we have to stop using Word for quotes?

No. Word's mail merge can read from a list, so the layout can stay. What has to change is where the prices and customer details live, which is one list rather than the last quote.

Does a quote need a unique number?

GOV.UK says an invoice must have a unique identification number, and we have not found the same rule for quotes. Give each one a number anyway, because it is how you find it when the customer rings back.

What if the quote says nothing about when we get paid?

For a business customer, GOV.UK says that with no agreed payment date, the payment is late 30 days after the customer gets the invoice, or after you deliver the goods or service if that is later. Stating your terms on the quote is clearer.

Can AI write our quotes?

It can draft the scope wording from your notes, with a person reading it before it goes. Prices should come from your price list and your judgement, not from a model.

Sources

  1. Invoices: what they must include, GOV.UK
  2. Running a limited company: signs, stationery and promotional material, GOV.UK
  3. Late commercial payments: charging interest and debt recovery, GOV.UK
  4. Consumer Rights Act 2015, section 50, legislation.gov.uk
  5. Consumer Rights Act 2015, section 51, legislation.gov.uk
  6. Supply of Goods and Services Act 1982, section 15, legislation.gov.uk
  7. Create an in-cell drop-down list, Google Docs Editors Help
  8. XLOOKUP function, Google Docs Editors Help
  9. Class File, Apps Script, Google for Developers
  10. Class Body, Apps Script, Google for Developers
  11. Installable triggers, Apps Script, Google for Developers
  12. Class Table, Apps Script, Google for Developers
  13. Consumer Contracts (Information, Cancellation and Additional Charges) Regulations 2013, regulation 9, legislation.gov.uk
  14. Consumer Contracts Regulations 2013, Schedule 1, legislation.gov.uk
  15. Consumer Contracts Regulations 2013, Schedule 2, legislation.gov.uk

Paul Meakin, Founder

Twenty years of fixing businesses from the inside, eighteen of them in recruitment from consultant to national operations, before building the automation, web applications and compliance systems Staxxd runs today.

More about Paul

Time to talk yet?

Tell us what's stuck and we'll map the quickest fix. Fifteen minutes, no obligation.

Time to talk yet?