Replacing Excel: quotes and cost calculation without spreadsheets

At many manufacturing, printing, food and logistics companies, quotes and cost calculation live in one big Excel file. It works for years, then it starts to slow you down: the costing logic sits in one person's head and one spreadsheet, quote versions circulate by email, and nobody is sure which material price is current. This article covers the signs that it is time to replace Excel, the risks of running on spreadsheets, and what a custom internal tool does instead.

It is written mainly for managing directors and operations leaders at companies with 20 to 200 staff, where the speed and accuracy of quoting directly affect profit.

Why quoting and costing are where Excel hurts most

The quote is where a company makes or loses money. Price too low and the job eats the margin. Price too high and the order goes elsewhere. Meanwhile the calculation draws on many sources: material prices, machine hour rates, setup times, scrap rates, subcontractor costs, delivery. At a metalworking or machine building company a single quote can have dozens of line items. At a print shop, paper, ink and machine time together make the price.

Excel can carry this for a long time. The problem is not the arithmetic. It is that the spreadsheet is a price list, a calculation engine, a quote register and a knowledge base all at once, and it was built for none of them.

6 signs you have outgrown Excel

• Pricing depends on one person. If only one person really understands the costing sheet, their holiday or departure stops quoting.
• You are never sure which version is current. Quote_final_2_fixed.xlsx: if that looks familiar, your team already loses time searching.
• Updating material prices is manual work. When steel, paper or raw material prices change, someone has to go through the sheets, and outdated prices in old quotes stay invisible.
• You cannot see where quotes stand. Which went out, which got a reply, which won, which was lost, and why? Without a quick answer, improving your win rate is hard.
• You cannot compare planned and actual cost. If the calculated cost never meets real production data, you never learn which product group earns less than you think.
• Formulas break and nobody notices. A shifted cell reference or an overwritten formula quietly produces a wrong price until someone stumbles on it.

If two or more of these apply to you, replacing Excel deserves serious thought.

The risks of staying on spreadsheets

• Pricing errors: one wrong formula or outdated material price can send a whole series of quotes in the wrong direction.
• Lost knowledge: pricing logic built over years lives in a spreadsheet and one person's head, not in the company.
• Slow quoting: if a quote takes days, a faster competitor wins the order.
• Data security: spreadsheets travel by email and USB stick, and it is hard to control who sees purchase prices and margins.
• Blind spots in decisions: without aggregated quote data, decisions rest on gut feeling.

What a custom internal tool does instead

A custom quoting and cost calculation tool moves your existing logic into a shared system that runs in the browser. You do not have to adapt to the way an off-the-shelf product thinks.

• Master data in one place: materials, price lists, machine hour rates, setup times. When a price changes, you update it once, and every new calculation uses it.
• Locked calculation logic: formulas live in the system, cannot be overwritten by accident, and everyone on the team calculates the same way.
• Quotes in one click: the calculation produces a consistent, branded PDF quote with versions and dates.
• Quote tracking: you can see where each quote stands, who owns it, and why it was won or lost.
• Post-calculation: planned cost can be compared with actual material and time usage.
• Permissions: margins and purchase prices are visible only to those who need them.
• Integration: if you use invoicing, inventory or ERP software, the tool can exchange data with it.

For the bigger picture, our ERP system guide compares off-the-shelf and custom options, and ERP system cost covers pricing in detail.

ERP or a custom tool for quoting?

An ERP covers a lot, but quoting and costing are often exactly where companies differ most. If your costing is standard, an off-the-shelf module may be enough, and we will tell you so. If your own pricing logic is your edge, a focused custom tool is often built faster and fits better than reshaping a large system. It can grow later, for example with order tracking or production planning.

How replacing Excel works, step by step

We start with a free initial consultation. Based on it, we design the system at a fixed price, step by step, so from the very beginning you see on a live prototype how it will work. After that, in a separate offer, we give a fixed price for development that covers everything we recorded during design.

1. Free initial consultation

A free, one-hour online conversation. You show us how a quote is made today, what slows it down and what causes the most errors.

2. Fixed-price system design with a live prototype

For a small to mid-sized project this takes 1 to 4 weeks, depending on the size of the system and how much we need to discuss. We go through your spreadsheets and costing logic, then build a clickable prototype in the browser. You can walk through the whole quoting process before a line of code is written.

3. Separate fixed-price development offer

Based on the approved prototype, we give an itemised, fixed-price proposal. From then on you know exactly what you get and what it costs.

4. Development: typically 6‑10 weeks for a small or medium project

Based on industry experience, a small or medium internal system used to need a development team of typically 3-4 people, and comprehensive automated testing, which keeps the system stable and easy to extend for years, pushed that cost even higher. Today, with the right methods, every project is led end to end by one lead developer, supported by a complete AI team, for a fraction of the traditional cost, including a large suite of automated tests. We can give you the exact scope and price after the one-hour call and the discovery phase. For a small or medium project this typically means 6‑10 weeks of development, after 1-4 weeks of discovery. For larger projects we set the timeline after discovery, in the fixed-price proposal. You get weekly status updates throughout. Along the way we load your existing material data, price lists and important past quotes.

5. Switchover and training

It is worth running the spreadsheet and the new tool side by side for a short time and comparing results. Once they match, the team switches over. The source code and documentation belong to you.

The full process is described in our guide to custom software development for companies.

Which companies benefit?

Mostly companies with 20 to 200 staff that produce many individually priced quotes: metalworking, machine building, contract manufacturing, printing, food production and logistics. If you run a manufacturing company, see our custom software for manufacturers page too.

If you only make a few quotes a month and the spreadsheet works well, you do not need a system. Replacing Excel pays off when the spreadsheet costs more in time, errors and lost orders than it saves.