Skip to content
All insights

General

Our ERP Says One Thing. The Spreadsheet Says Another.

By Shanshan "Sasha" Ma

When the system of record and the spreadsheet disagree, somebody has to decide which is true. That adjudication is a job nobody designed — and it is fixable.

"Our ERP says one thing. The spreadsheet says another."

The moment those two sentences are spoken, a human being becomes the arbiter. Not the ERP. Not the spreadsheet. A person, deciding which number to believe, usually under time pressure, usually without writing down the decision.

That is the real problem. Not that a spreadsheet exists — spreadsheets are how operations teams stay fast — but that truth has to be settled by a judgment call in the middle of a working day.

What people say when you ask

The people living this are remarkably consistent about it.

In r/manufacturing, the thread "The biggest threat to ERP isn't bugs — it's Excel" describes the mechanism exactly: one colleague maintained 40+ spreadsheets because the system around the work couldn't carry what the work actually needed. Shadow systems are not born from a preference for Excel. They are born from a gap.

In r/ERP, "ERP adoption turned out to be more important than ERP functionally" contains the line that explains every spreadsheet in your operation:

There is always something in their spreadsheets that an ERP system doesn't replicate.

And r/analytics has a thread with a title that is hard to argue with — "The biggest lie in data is the 'single source of truth'" — where the point is that "single source of truth" is not a place your data lives. It is a governance promise that most teams never got around to making.

The pattern across all of them: nobody decided to run a second system of record. It accumulated.

Why it keeps happening

Spreadsheets do something an ERP genuinely cannot: they model the work as it is today, including the parts that were never designed.

A spreadsheet can hold a grade swap, a rush order, a customer's special instruction, a colour of socks. It can be changed in ten seconds by the person who understands the exception. An ERP holds the transaction, and only the transaction — which is why the thread above about adoption ends with Excel winning the argument.

So the spreadsheet is not the enemy of the ERP. It is the exception handler. The problem is that it is an unmanaged exception handler: no ownership, no history, no reconciliation, and no way to tell who is right.

What it costs

  • Two versions of the truth, and a person required to choose between them.
  • Decisions that get reversed when the other system is checked.
  • No audit trail for the call that was made — so it gets made again next week.
  • Trust that erodes in both directions: the team stops trusting the ERP, and leadership stops trusting the spreadsheet.

What LevelOneAI does about it

We do not ask you to pick a winner, and we do not ask you to replace the ERP. Your system of record stays authoritative — that is the whole point.

LevelOneAI is the layer that holds the work: the order, the job, the shipment, and everything known about it, including the exception that only the spreadsheet knew. The engine gathers the state from the system of record, captures what arrived outside it, and shows the discrepancy as an exception with a name on it, rather than a decision to be made in someone's head.

Where write-back is set up, approved updates go to the system of record, so there is one truth again — and it is the ERP's. No third version of the answer.

The spreadsheet can go back to being what it is good at: quick analysis. Not the place where the business lives.

The test

Take the spreadsheet your team would be in trouble without. Ask what it knows that the ERP doesn't. That gap is not a data problem — it is undesigned work. It is the first thing we would put in the queue.