Custom machine builders and automation companies live and die by their ability to deliver complex, one-of-a-kind solutions. In the early days for any Engineer-To-Order (ETO) manufacturer, the flexibility that wins contracts often comes from a familiar tool sitting on every engineer’s desktop: spreadsheet programs like Microsoft Excel, Google Sheets, and the like.

Excel is the go-to solution for managing data and it gets you in business, but it eventually becomes the enemy of profitable, scalable growth.

The Loyal Friend in the Startup Phase

When you’re a small team quoting the first few custom automation cells or specialty machinery projects, Excel feels like a superpower:

  • It’s a go-to quoting tool for quick data entry, calculations, etc.
  • Quick sketches turn into BOMs and are managed in Excel
  • Gantt charts live in the same workbook as pricing
  • Engineering changes get tracked with a few color-coded cells
  • “We’ll just add another column or tab” becomes the company motto

You win jobs because you’re fast and responsive. The founder is still close enough to every project to catch mistakes. Spreadsheets feel lightweight and perfectly tailored to your unique process.

This is the “friend” phase. 

When the Frenemy Emerges: The Hidden Cost of “Good Enough”

As order volume grows, project complexity increases, and more people touch the data, Excel imperceptibly becomes a challenge and only works when everyone does it the same way. What began as a nimble helper becomes a silent profit killer by heavily relying on tribal knowledge of how to properly manage the spreadsheet data, etc.

Here are a few scenarios that might sound familiar.

1. Version Chaos and Data Integrity Nightmares 

Multiple team members editing the same “master” quote file. Engineering updates never make it to purchasing. Sales promising options that weren’t priced correctly. Columns, rows or cells disappearing or losing formatting? Sound familiar? In ETO, a single misplaced decimal or outdated revision can be a costly mistake.

2. Endless Rework and Non-Billable Time 

How many hours per week does your team spend chasing down “the latest” BOM, material change, etc., and re-keying data between engineering, purchasing, and accounting systems? That time doesn’t go on any customer invoice—it simply erodes EBITDA.

3. Quoting Inaccuracy Decreases Profitability and Increases Risk

Excel-based quoting often relies on tribal knowledge and incomplete or incorrect costing that’s old. Material prices change. Labor rates fluctuate. Supply chain disruptions hit. Without real-time, accurate cost data, you’re either leaving money on the table or winning jobs you’ll regret. Then add long-lead-time items or various partial BOMs, and it’s difficult to even collect the data from project completed 6 months ago. 

4. Scalability Ceiling 

It’s difficult to hire fast enough because every new estimator or project manager needs weeks of training on “how we do it in Excel here.” Onboarding becomes tribal knowledge transfer instead of a repeatable process. Growth and training become bottlenecks.

5. Compliance and Risk Exposure 

ISO, AS9100, customer audits, or ITAR requirements? Good luck explaining your Excel-based change management and traceability process to an auditor. One major customer asking for full material traceability can trigger months of painful manual reconstruction.

6. The Real Financial Impact 

Industry studies and our own work with ETO companies consistently show that relying heavily on spreadsheets increases costs between 8–18% through inefficiencies, errors, and lost visibility. That’s the difference between a healthy business, and one that struggles to scale.

The Breaking Point Most ETO Leaders Recognize Too Late

The moment usually comes when:

  • There is a serious cost impact or late project delivery because of an easily avoidable mistake with an integrated ERP
  • Cash flow surprises you because project profitability was miscalculated
  • Your best people burn out from the constant manual grind and look for other jobs that are more rewarding and less paperwork-driven
  • The lack of real CAD integration results in multiple spreadsheets and manually calculating QTY’s, revisions, changes, etc. with the high chance of human error

At that point, Excel isn’t just inefficient. It’s actively preventing you from scaling and being that larger, more profitable company you know is possible.

From Frenemy to Freedom: Purpose-Built ERP for ETO

The good news? You don’t have to abandon what made you successful—you need to professionalize it.

COUNTERPART is an industry leading, modern ETO specific ERP built from the ground up to solve these (and other) challenges for the realities of custom machinery and automation:

  • True revision control that engineering, sales, and purchasing actually trust
  • Configurable cost tracking and calculation that captures your unique pricing logic and options
  • Real-time project costing and margin visibility
  • Seamless flow from proposal to engineering to procurement to build to service
  • Built-in compliance and traceability without the spreadsheet gymnastics

The companies that make this transition don’t lose their entrepreneurial edge. They amplify it. They quote faster with higher accuracy. They onboard new talent in days, not months. They see project profitability in real time and make course corrections before margins evaporate.

Ready to Make Excel a True Friend Again?

Keep using Excel for what it’s great at—ad-hoc analysis, one-off calculations, lightweight modeling. Just stop using it as your core business system.

The most successful custom machine and automation companies we work with have made the shift from “spreadsheet heroes” to ERP-enabled efficiencies. Their growth didn’t slow down—it accelerated. Their profits expanded. Their teams stopped dreading Monday mornings.