A practical manufacturing decision guide

ERP, SaaS, Excel, automation—or custom software?

The expensive mistake is not choosing the “wrong technology.” It is starting with a technology before understanding the workflow. A manufacturer may need ERP, a $50/month SaaS tool, a better spreadsheet, a small automation—or one focused custom layer.

Neutral by design: custom development is only one of the possible answers.

The useful question is not “ERP or custom?”

It is: Which parts of the operation are standard enough to buy, and which parts are specific enough to justify something different? Many good systems are combinations rather than one platform replacing everything.

Five legitimate answers

Each option has a job.
None is automatically superior.

The right choice depends on scope, risk, number of users, process uniqueness, integration needs, maintenance burden and how costly failure actually is.

Option 1

ERP

A broad system of record covering standardized business functions across the organization.

  • Finance and accounting
  • Purchasing and inventory
  • Orders and production
  • Master data and reporting
Best when: the requirement is broad, interconnected and reasonably standard.
Option 2

Focused SaaS

A purpose-built product for a common business problem that many companies share.

  • Maintenance / CMMS
  • Safety records
  • Scheduling
  • CRM, payroll, HR
Best when: a mature product already solves 80–95% of the workflow cheaply.
Option 3

Excel / Sheets

Still one of the best tools for small, flexible, low-risk workflows when complexity is honestly low.

  • Simple trackers
  • One-owner calculations
  • Temporary analysis
  • Low-frequency processes
Best when: one or two people can safely own it without hidden operational risk.
Option 4

Automation

A small layer that removes repetitive moving, checking, notifying or reconciling between systems.

  • Overdue alerts
  • Scheduled reports
  • Data synchronization
  • Exception monitoring
Best when: your existing systems are mostly right but the handoffs are manual.
Option 5

Custom software

A focused system designed around a valuable workflow that standard products do not handle well enough.

  • Unique estimating logic
  • Shop-specific workflows
  • Cross-system operating layer
  • Specialized intake / status tools
Best when: the workflow matters enough that forcing it into generic software creates recurring cost or failure.

Decision matrix

Match the tool to
the shape of the problem.

This is deliberately simplified, but it is a useful first filter before anyone starts shopping for platforms or writing a software scope.

Situation ERP SaaS Excel Automation Custom
Broad company-wide backbone Strong fitPartialWeakNot primarySometimes
Common workflow with mature products MaybeStrong fitMaybeAdd-onUsually unnecessary
Simple low-risk tracker Too heavyMaybeStrong fitUsually not neededUsually unnecessary
Repeated checking / copying between systems MaybeMaybeCreates more workStrong fitIf logic is complex
Unique high-value operating workflow May support itMay be closePrototype onlyPart of answerStrong fit
Need controlled users, history and alerts YesYesOften weakSupportsYes

The part many companies miss

Your ERP can be correct
and you can still have a software gap.

An ERP does not have to be a failure for a custom tool to make sense. The missing opportunity is often a narrow operating layer around the system of record.

ERP / core system

Orders, purchasing, accounting, inventory, production data, master records. The system of record remains intact.

Focused SaaS

Maintenance, safety, CRM, payroll, scheduling or another common function handled by a mature specialist product.

The operating gap

Whiteboards, spreadsheets, emailed files, WhatsApp, paper forms, repeated calls, copy-paste work, supervisor memory and “ask John where that is.”

Automation / custom layer

A small system that captures the missing workflow, connects existing tools, surfaces exceptions or gives operators a faster interface without replacing everything underneath.

Manufacturing examples

What the decision looks like
in actual operations.

The same company may correctly use all five approaches in different parts of the business. Architecture is often more useful than ideology.

Cabinet / millwork

Historical kitchens are already in spreadsheets

The owners want to find previous kitchens most similar to a new quote and inspect historical pricing. No drawing takeoff, no accounting replacement, no broad ERP requirement.

Likely answer: focused custom estimating assistant around the existing historical data.
Maintenance-heavy shop

Service work happens, but nobody records it consistently

The underlying need is simple machine history, QR access, quick logging and reminders. A full enterprise asset platform may create more onboarding than value.

Likely answer: focused CMMS/SaaS if a suitable lightweight product already fits.
Operations management

Managers keep checking dates and chasing exceptions

The data already exists, but attention depends on someone remembering to open a dashboard and notice that something slipped.

Likely answer: automation / exception monitoring before building another full system.
Growing manufacturer

Finance, inventory and purchasing are fragmented

The requirement spans core functions, needs consistent master data and affects the whole company.

Likely answer: evaluate ERP first. Custom software should not casually replace standard business infrastructure.
Small team

One estimator maintains a straightforward calculator

The logic is stable, the file is controlled, the risk is low and there is no need for roles, workflow, audit history or integrations.

Likely answer: keep Excel. There may be nothing to fix.
Warehouse / production

ERP knows the order. The floor still uses a whiteboard.

The missing need is fast local status, exceptions and a simple interface for people who should not navigate the whole ERP.

Likely answer: small operating layer connected to existing records.

Signals worth noticing

When to buy.
When to investigate custom.

Neither list is absolute. They are useful indicators that tell you where to spend discovery effort before committing budget.

Strong signals to buy existing software

The process is common across thousands of businessesAccounting, payroll, CRM and many standard maintenance workflows are obvious examples.
Regulatory or accounting complexity is the core valueEstablished vendors can spread that maintenance burden across a large customer base.
A mature product already solves nearly everythingDo not rebuild a commodity capability simply to own the code.
Your team can adopt the standard process without meaningful lossConfiguration is often cheaper than custom development.

Strong signals to investigate custom

The workaround has become an unofficial systemMultiple spreadsheets, whiteboards, messages and repeated explanations keep the workflow alive.
The workflow is specific and commercially importantIt is part of how your company estimates, produces, services or differentiates itself.
People repeatedly re-enter or reconcile the same informationThe gap may be integration or automation rather than a whole new platform.
Generic platforms require too much ceremony for a narrow taskThe operational cost of using the software becomes part of the problem.

Before you buy or build

Answer these seven questions
before choosing the category.

If these answers are unclear, comparing vendors or requesting custom-development quotes is premature. The workflow still needs to be understood.

The 20-minute decision screen

You do not need a formal consulting engagement to perform the first pass. Sit with the people doing the work and answer these plainly.

1. What specifically gets missed, delayed, copied, chased or re-entered today?
2. How often does it happen, and what does failure actually cost?
3. Which existing system already owns the underlying data?
4. Is this workflow genuinely unique, or is it common enough that a good product should already exist?
5. How many people need access, and do you need roles, history, approvals or auditability?
6. Could one process change or automation remove the problem without another application?
7. If custom software is built, what measurable operating result would justify owning and maintaining it?

Frequently asked

Common questions manufacturers
ask before deciding.

The goal is not to push every company toward custom development. It is to narrow the decision until the right category becomes obvious enough to investigate properly.

Should a small manufacturer buy ERP or build custom software?

If the need spans standardized functions such as accounting, purchasing, inventory and company-wide records, evaluate ERP first. Custom software is more defensible when a narrower, high-value workflow remains poorly served after suitable platforms and SaaS products are considered.

Is Excel always a bad manufacturing system?

No. Excel is excellent for flexible analysis and can be perfectly adequate for simple, low-risk workflows owned by a small number of people. The warning signs appear when you need controlled multi-user access, reliable history, validation, integrations, alerts or one shared operational truth.

Can custom software work with an existing ERP?

Yes. Often that is the better architecture. The ERP remains the system of record while a focused tool handles local data capture, a specialized workflow, operator-facing status, exception handling or integration between systems.

When is workflow automation enough without a custom app?

When the existing systems already contain the right data and the main waste is manual checking, copying, notifying or reconciling. A small scheduled service or integration may solve the problem with less cost and maintenance than a new application.

What makes custom software worth maintaining?

Usually one of three things: the workflow is commercially important and genuinely specific; the repeated operating cost of the workaround is material; or the custom layer creates a meaningful advantage that generic software cannot provide without excessive compromise.

Still unclear?

Bring the workflow, not a software shopping list.

Rainmaker can look at the current process and tell you whether the next investigation should be ERP, existing SaaS, a process change, automation or a focused custom build. The useful answer may be that you should not hire Rainmaker at all.