The Shadow System Reality: Why Excel Still Runs Parallel to Your ERP

If you asked many businesses what their most critical system is, you’d expect the answer to be their ERP.

Surprisingly, for many organisations, even large, mature ones, the honest answer would be Excel.

Despite significant investment in ERP platforms like SYSPRO, Excel continues to run in parallel, quietly powering critical business processes. This phenomenon is often referred to as the “shadow system reality.”

And it’s far more common and risky than most organisations realise.

Why Do Businesses Still Use Excel When They Have an ERP?

This is one of the most common questions we hear at Lancea Konsult.

After working with manufacturers and distributors for years, a few patterns consistently emerge.

1. ERP Systems Follow Standard Flows, Businesses Don’t

ERP systems are built around standardised business processes. But real businesses are full of exceptions, nuances, and differentiators.

Those differences, the things that make a company unique, often don’t fit neatly into standard ERP workflows.

Excel fills that gap.

It’s flexible. It’s fast. And it bends to the business, not the other way around.

2. Reports That Need Action Become Excel

A classic example is age analysis or debtors management.

The ERP provides the report, but then the real work starts:

• Adding comments
• Tracking follow-ups
• Assigning responsibility
• Recording outcomes

The moment a report needs to become a working document, it almost always ends up in Excel.

Excel becomes the place where:

• Decisions are made
• Context is added
• Actions are tracked

In other words, the real business logic moves out of the ERP.

3. Planning Lives Where Feedback Is Easiest

Production planning, inventory planning, and scheduling are some of the biggest Excel offenders.

Why? Because these processes require:

• Visibility
• Collaboration
• Ongoing feedback
• Continuous adjustment

Excel offers shared grids, comments, and editable logic, even if it’s unstable.

ERP systems historically struggled to offer that same actionable, collaborative experience.

What’s the Real Problem With Excel Shadow Systems?

Excel isn’t the enemy. The risk lies in how it’s used.

Key risks of Excel running parallel to ERP:

• Multiple versions of the same truth
• Delayed, non-real-time data
• Corrupted or broken files
• No audit trail or security controls
• Business IP trapped in spreadsheets
• Dependency on one “Excel expert”

In many organisations, if that one person is unavailable the business waits.

That’s not a system. That’s a single point of failure.

Why Excel Became the Default (And Why It Stayed)

Historically, ERP customisation was:

• Expensive
• Slow
• High-risk

So when businesses needed a quick win, Excel was the obvious choice.

It was easy to adopt. It didn’t require IT. And it worked, at least initially.

But over time, those “quick wins” became critical systems, without the structure, governance, or security of ERP.

The Question Businesses Are Asking Now

“Is there a way to get the Excel experience, without leaving the ERP?”

This is where things have changed.

The Shift: Bringing Excel-Like Experiences Back Into ERP

At Lancea Konsult, we’ve spent the last few years doing exactly this: replacing Excel shadow systems with ERP-native, actionable solutions inside SYSPRO.

Not by forcing businesses into rigid processes, but by bringing the flexibility of Excel into the ERP framework.

What does that mean in practice?

• Grid-based, editable views
• Real-time data
• Actionable reports
• Comments and feedback stored securely
• Business logic formalised inside ERP
• Full security, audit trails, and permissions

It looks familiar, but it lives where it belongs: inside SYSPRO.

Why This Matters More Than Ever

Running critical processes on Excel in today’s environment is no longer just inefficient, it’s risky.

Modern businesses need:

• Real-time visibility
• Secure collaboration
• Formalised business IP
• Systems that scale without breaking

ERP systems must evolve from record-keeping tools into actionable operational platforms.

Why This Is Where Lancea Excels

The reality is: ERP vendors can’t solve every business nuance out of the box.

That’s where partners matter.

Lancea’s strength lies in:

• Understanding unique business processes
• Translating Excel logic into ERP workflows
• Building tailored solutions inside SYSPRO
• Preserving what works, while removing risk

This is what allows businesses to move away from shadow systems without losing flexibility.

So… Should Excel Still Run Your Business?

Excel will always have a place.

But when it becomes:

• The system of record
• The planning engine
• The decision-making platform

…it’s time to rethink the architecture.

ERP systems like SYSPRO were designed to be the backbone of your operations, not a passive data source feeding spreadsheets.

The Way Forward

If your ERP reports are being:

• Exported to Excel
• Modified
• Shared
• Used to make decisions
• And never written back properly

You’re living in the shadow system reality.

The good news? It’s no longer the only option.