Quoting takes too much time? Where your calculation gets stuck

Quoting takes too long because of outdated Excel formulas, prices that change per delivery date and quotes that differ per salesperson. Here is how to solve that.

In short

Making a quote usually takes too long because the calculation sits in an Excel file only one person understands, because prices change per delivery date and are looked up by hand, and because each salesperson builds their quote differently. A quote calculator fetches current prices itself, calculates with fixed rules and produces a quote in your house style, directly in your ERP or CRM. Replacing your ERP is rarely needed for that.

Making a quote usually takes too much time because the calculation is in the wrong place. It sits in an Excel file that one person understands, the prices are looked up by hand and each salesperson builds their quote differently. Faster quotes therefore start with the calculation, long before you think about the layout of the PDF.

What we often hear sounds like this: “We work in Excel with outdated quote formulas, but the person who set them up will soon no longer work for us.” Or: “Adjusting quotes takes a lot of time, because prices and earlier versions have to be checked.” The goal companies then mention is a regular quote in ten minutes instead of half a day.

Why does a quote take so long?

A quote takes long because the estimator has to look up and retype the same data in three places. Items are in the ERP, prices in a supplier’s list and the calculation in an Excel file. Every step is a chance for a mistake, and every mistake has to be checked again by someone.

Where it gets stuck What it costs What a quote calculator does differently
Formulas in an Excel file that one person understands Quotes wait when that person is not there The calculation rules are in the software, with parameters anyone can fill in
Prices that change per delivery date Quotes with a price that no longer applies, margin that disappears Fetches the price that applies for the delivery date
Each salesperson builds their quote differently Customers get different answers, follow-up is difficult One structure, one house style, the same questions for every request
Quoting tool does not talk to the ERP Everything is entered twice Puts the quote directly into your ERP as quote lines
Plans or drawings are converted by hand Hours of senior work per file Reads the components from the drawing and calculates them

What if the formulas are in one person’s head?

Then your quoting process is as strong as that one person. As long as they are there, it works, but a holiday, an illness or a departure brings quoting to a standstill. And nobody dares to change the formulas, so after a few years the file calculates with rules that are no longer correct.

The solution is to get the knowledge out of the file and into rules everyone can use. That starts with a conversation with that one person, and that conversation is often the most valuable part of the whole project. After that, a salesperson only adjusts parameters, such as dimensions, material or quantities, and the software calculates the rest.

How do you deal with prices that change per delivery date?

You let the calculator work with the price that applies at the time of delivery. In sectors with raw materials, steel, aluminium or energy, a price sometimes changes between the quote and the order, and an Excel file does not know that. Anyone calculating with last month’s price sometimes sees their margin disappear without noticing.

A few things that help:

  • Prices come in automatically, from your ERP or from your suppliers’ price lists, instead of being retyped.
  • Every quote gets a validity period, and the software warns you if an open quote relies on an outdated price.
  • Prices per period, so a delivery in March is calculated at the March price.

How do you get uniform quotes?

You get uniform quotes by fixing the questions, not just the layout. If every request goes through the same questions, no salesperson can forget a step, and every quote looks the same to the customer.

ASW and Alracon, specialists in windows and doors, worked as two companies each in their own way. Aziri built one shared application with a customer database, a quoting tool and project follow-up. Smart questionnaires ask for all the necessary details with every quote request, such as choice of material, profile type and new build or renovation. They save more than 20 hours a week of administration, and they replaced three or more packages with one system (ASW and Alracon case).

We saw the same at an installation company: quotes are now made and followed up in one uniform way, and managing the product catalogue became a lot simpler.

Do you need to replace your ERP for better quotes?

Almost never. Your ERP stays, and the quote calculator is linked to it. That is faster and cheaper than a new ERP, and your people keep working in the system they know.

Warsco builds modular units and draws them in ArchiCAD. That CAD package could not talk to their ERP SAP, so all drawn units were created by hand as quote lines. Aziri built an application that automatically converts the plans from ArchiCAD into quote lines in SAP, and checks the designs straight away. So Warsco now makes quotes in its ERP simply and automatically based on the drawings (Warsco case).

A second application followed. The transport calculation, which sat in an Excel sheet, was rewritten and extended with, among other things, automatic sending of emails. After a four-day training, Warsco now develops that application further itself.

Where do you start?

Start with the quote that is made most often, or with the calculation that produces the most mistakes. Bring the Excel file, and the person who understands it. From that one file and that one conversation we usually get enough to build a first version, and that is usually ready with us within 2 to 6 weeks.

What we build for quotes is explained under quote calculation software. How AI turns a request, plan or specification into a draft quote with your own items and prices is under quoting with AI. How we integrate with your ERP or CRM is under software integration, and what a project costs on what custom software costs.

Frequently asked questions

How long should making a quote take?

That depends on your product, but if a standard quote takes more than an hour, there is usually retyping or looking things up in it that a system can take over. Companies we talk to often aim for about ten minutes for a regular quote, so the estimator only spends time on the real exceptions.

Can a quote calculator connect to my ERP?

Yes, and that is usually the core of the work. The calculator fetches items and prices from your ERP and puts the quote back into it as quote lines, as at Warsco with SAP. We have already built integrations with SAP, Exact Online, Odoo, AFAS and Priority, among others.

What if my prices change every week?

Then the calculator fetches the price that applies for the delivery date, not the one for the day the quote was made. You can also set a validity period and get a notification if an open quote relies on a price that has since changed.

What does a custom quote calculator cost?

A first version for one process starts from €5,000. You add an integration with your ERP and more product groups step by step, each time for a fixed price upfront. Licence and hosting come separately, from €1,000 per year.

Maxim Daels

Maxim DaelsSales Manager, Aziri

Maxim Daels works at Aziri (Sales Manager).

Is this where you get stuck?

Tell us in a half-hour call how things run today. You get an honest assessment, even if the answer is that you do not need custom software.

We reply quickly.