Ledger to Dashboard

A Case Study on a client’s Digital Journey……

The Background

When the Consultant team from Gateways Global that I was leading, first walked into the client’s textile factory premises, it felt like stepping back two decades. This was a successful manufacturing company. Orders were steady. Customers were largely satisfied. Profitability, though small, existed. And yet, everything ran on paper.

Tall steel cupboards lined the walls, their shelves bowed under the weight of handwritten registers. Production records, purchase ledgers, inventory logs, dispatch notes—all meticulously written in ink, all fiercely guarded by accountants and staff who had built their careers on knowing exactly which book sat on which shelf. The faint smell of paper, oil, and time hung heavily in the air.

There were no real-time dashboards. There was no consolidated view of production. No predictive insights. No single source of truth. The Management sensed something was wrong but could not articulate it. They knew they were working harder every year just to stay in the same place.

Diagnosing the Problem

Our first instinct was not technology, it was listening. We spent weeks on the shop floor, in the administration/accounts office, and inside review meetings. We listened to supervisors defend notebooks/registers and accountants justify manual reconciliations. The problem was not only inefficiency, but it was also invisibility. Without real-time data, decisions were always retrospective. Problems were discovered much after the damage was done. After multiple rounds of discussion, the leadership accepted a critical truth- that modern business cannot survive on yesterday’s tools.

We Met Them Where They Stood

As Consultants, The Gateways Global Team did not impose solutions from an ivory tower. Rather, our approach was grounded in reality. Instead of forcing advanced systems on an unprepared organisation, we aligned with their current state and designed a transformation roadmap that respected their place while steadily prodding them forward. We demonstrated that true Consulting starts from where the client presently stands.

Rather than forcing an ERP that would overwhelm them, we suggested and started with Google Sheets. Simple trackers were introduced for Production, Quality Control, Stores, Dispatches, Inventory, Accounts & Human Resources. We positioned it not as transformation, but as ease of work. It came as a gentle and non-threatening first step. We knew that digital transformation is behavioral before it is technical.

The Human Side of Change

As gentle as we tried to keep it, resistance came swiftly. Senior employees, mainly in their 50s and 60s expressed fear, skepticism, and anxiety. Registers were identity, not just tools. It was evidence of their hard work over the last few decades. They were not ready for any conversation related to replacing them. We addressed this through patience and empathy. Multiple training sessions were conducted both in groups and one-on-one. Parallel manual and digital systems were allowed. Confidence began to build slowly but steadily. Most team members adopted willingly. Some resisted endlessly.

The Tough Decision

Resistance was addressed with empathy rather than authority. We invested significant time in dialogue, discussions and handholding to bring the skeptics on board. Targeted training was given to help hesitant employees adapt to change. Yet, when sustained resistance began to hinder organisational momentum, we supported the Management in taking the tough call-to choose progress over comfort. A few persistent resisters were exited. It was painful but necessary. A signal was sent- change was non-negotiable.

Reaching Saturation with Google Sheets

As adoption increased and data volumes grew, Google Sheets gradually reached its practical limits. Multiple users updating data simultaneously led to version control challenges, manual errors, and governance gaps, while the absence of structured workflows made cross-functional integration increasingly complex. What successfully jump-started the digital journey could not support the organization’s growing need for scalability, and predictive decision-making.

Migrating to Tally ERP

Convinced of the limitations of Google Sheets, we made the migration to Tally ERP. It delivered visibility of data, but very soon limitations emerged—data volume, control issues, lack of deeper insight. By this time, the Management now wanted foresight, not hindsight Tally introduced structure, compliance, and better integration. Yet, advanced analytics and scalability remained challenges. Also, collaboration and co-working tools were absent compared to a full-

fledged ERP for a multifunctional organisation. After a year of navigating through Tally ERP,  they were convinced of the need to move to a full-fledged ERP if they wanted to be efficient & competitive.

Recognising the Need for a Robust ERP

Having matured digitally, management now sought real-time dashboards, predictive planning, and integrated operations. Together, we decided that time had come for a full-fledged solution.

The ERP Selection Journey

The process of vendor selection for the right ERP was as painful as it was time consuming. Ambiguity in business requirements due to process silos, stakeholder misalignment arising from conflicting priorities across functions such as finance, production, inventory, overwhelming vendor landscape, challenges in customisation, costing challenges – annual recurring costs, implementation costs, training costs,  and maintenance costs, poor data readiness impacting feasibility assessments and migration planning, limited internal expertise in ERP evaluation, leading to over-reliance on vendor-driven narratives, evaluation cycles that were never ending, and fear of high-stakes commitment form the Management side, were some of the pain points that made the process borderline traumatic for a Consultant like us.

In all, eleven vendors were evaluated. Use cases were demonstrated, cost-benefit analyses were done, workflows were explained by each of the vendors, each one wanting to push his product as the best and the one that was best suited for our requirements. Multiple negotiation rounds followed. We spoke to other organisations in the same industry to understand their experience.

Adoption Over Installation

Finally, the Management zeroed in on an ERP that was cost effective and fulfilled most of their requirements. Implementation was treated as a people project. Processes were redesigned, KPIs aligned, and real time dashboards were built.  This aligned with both their current needs and future growth ambitions. Over time, the workforce not only adapted to the new system but began to actively own and leverage it. This showed a critical shift in mindset from compliance to commitment.  Resistance was now minimal; understanding had replaced fear.

Today, the organization operates with integrated systems, data-driven decisions, and a progressive mindset. The transition from a predominantly manual operating model to a digitally enabled, automation-driven environment represents an evolution into a more agile, resilient, and digitally mature enterprise, rather than a mere technology upgrade.  

Key Learnings for Similar Organizations

Transformation is incremental and often painful. People must evolve before systems. Tools must match maturity. Progress demands courage.

Our Consulting Philosophy in Action

True to our Consulting Philosophy, I-C-I  -Inclusive-Consensus-Implementation, Gateways Global did not force systems, processes or technology on the client. Rather, we enabled the transition. We encouraged broad-based participation, involving all stakeholders in the journey. We listened to diverse perspectives and built consensus at each stage; we remained engaged beyond giving recommendations and stayed invested throughout the execution. We walked with them and handheld them through uncertainty. We did not just build a system, we built capability.

This is not just their story. It could be yours…….

Sheela Warrier

Senior Consultant