From Excel Chaos to ERP Control: Digitising Traditional Businesses

2026-04-29

By a finance-led operator who builds systems that turn disorder into measurable performance.

For many traditional businesses, Excel becomes the default operating system. It starts innocently enough. A few spreadsheets for stock. A workbook for sales. Another for purchasing. A few files sent back and forth on email or messaging apps. Some handwritten notes. Some numbers remembered only by certain staff members. Then one day, the business grows, and the spreadsheets do not.

I’ve seen this happen across multiple industries. I’ve helped transform a timber manufacturing business running on Excel into a live database-driven operation. I’ve worked on systems for monitoring illegal timber trade. I’ve also built systems for tracking plantation health across Myanmar. The pattern is always the same: the business becomes larger than the tools managing it.

When Excel Stops Being Enough

Excel is not the enemy. It is one of the most useful business tools ever created. But Excel was never meant to become the nervous system of a complex operation. When I first step into many businesses, I usually find:

  • Dozens of disconnected spreadsheets
  • Physical documents stacked in folders
  • Files passed between staff with no version control
  • Duplicate entries
  • Missing records
  • No real-time visibility
  • No trustworthy reporting

Most importantly, management cannot answer simple but critical questions quickly. What is our actual stock position? Which supplier gives the best yield? Where are losses happening? Which branch is underperforming? What products are truly profitable?

When data is fragmented, decision-making becomes guesswork.

Why Businesses Delay Change

Many owners already know their systems are weak. But change feels expensive, disruptive, and non-urgent. If revenue is still coming in, replacing the old process gets pushed aside. The move usually happens only when something breaks:

  • Customer losses
  • Internal theft
  • Inventory discrepancies
  • Cash flow pressure
  • Reporting failures
  • Scaling problems

By that stage, the cost of doing nothing has already become high.

My Approach: Fix What Matters First

I usually enter these situations through a finance or advisory role, not purely as a software developer. That matters because digitisation is not really a technology problem. It is a control problem, a reporting problem, and a decision-making problem. The first thing I examine is not software. I look at:

  • What data is being captured
  • What assumptions management believes
  • Which numbers drive profit
  • Where leakages can occur
  • Which process is mission-critical

Then I digitise the highest-value part first.

Real Example: Timber Yield Tracking

In one timber business, the lifeblood of the company was not sales invoices or warehouse reports. It was yield. Raw logs came in and were transformed into furniture, flooring, and planks for domestic and export markets. The real profit driver was how much usable output came from each batch of logs.

Without reliable yield tracking, management could not clearly identify:

  • Good vs poor suppliers
  • Production efficiency
  • Hidden losses
  • Material wastage
  • True margins

So I built a system called Tallify focused on real-time material output tracking. That one operational layer changed visibility dramatically. Suddenly the company could track which suppliers were underperforming, which batches were weak, and where margins were being lost.

That is how transformation should work: start with the heartbeat of the business.

Technology Must Feel Invisible

Many system projects fail because they force users to think like software. I prefer the opposite. Technology should adapt to the worker. If a timber inspector’s real job is grading timber quality, then the system should let him do exactly that, simply, quickly, and naturally. He should not be burdened with accounting logic, workflow complexity, or irrelevant fields.

Good systems reduce friction. They do not create it.

ERP Is Not Magic

Some businesses think buying ERP software automatically solves problems. It does not. A badly implemented ERP can create just as much chaos as spreadsheets. In fact, I’ve seen excellent businesses run on paper, and terrible businesses run on expensive ERP systems.

The real value comes from aligning systems with operational reality. A properly implemented ERP should expose business weaknesses within two quarters:

  • Margin leaks
  • Inventory errors
  • Poor purchasing discipline
  • Weak approvals
  • Unprofitable products
  • Inefficient teams

If the system hides problems, it is failing.

Why Finance Knowledge Matters

This is where many technical projects go wrong. If you do not understand accounting, management reporting, controls, or how owners think, you risk building software that looks impressive but solves little.

Because I come from a finance background, I understand what decision-makers actually need:

  • Cash flow visibility
  • Profitability by product or unit
  • Budget vs actual performance
  • Cost controls
  • Creditor exposure
  • Operational KPIs that matter

That makes system design far sharper.

My Advice to Businesses Still Running on Excel

Excel is excellent. But management should not be spending time controlling clunky files, reconciling duplicate data, and chasing documents. Use systems tailored to your operation. When data is captured properly, every number begins to generate unexpected value:

  • Better decisions
  • Faster reporting
  • Reduced losses
  • Stronger accountability
  • Higher margins
  • Easier growth

The goal is not to replace Excel. The goal is to replace chaos.

Final Thought

Digitising traditional businesses is not about software trends. It is about turning hidden operational reality into visible truth. And once a business can clearly see itself, it can improve itself.