Constrange

Every organisation has a shadow system

The unofficial spreadsheets, emails, workarounds and human processes keeping the "official" system alive.

Official systems have logos, login screens, and audit trails. Shadow systems have tabs, inboxes, and memory. They are not always rogue. Often they are how the organisation actually ships the quarter: the forecast model finance trusts, the tracker operations updates hourly, the email thread where approvals really happen.

Leadership talks about the ERP, the CRM, the data platform. Operations talks about 'the sheet' and 'the way we do it when the system is down'. Both conversations are true. Constrange treats shadow systems as diagnostic, not shameful. They show where official design does not match reality.

Ignoring them produces replatforming surprises. Demonising them produces hiding. The mature move is to read them, decide what they protect, and choose: formalise, replace, or remove the pressure that created them.

What counts as a shadow system

Spreadsheets with write access shared across teams. Email as workflow. Chat channels as queues. Personal databases. Printed forms. Verbal handoffs. Side integrations built by an analyst years ago. Each carries load the official stack does not.

Official system above a dashed shadow layer of spreadsheets and inboxes
The shadow layer often carries the work the official system was supposed to own.
  • Higher change velocity than IT can match
  • Exceptions the official tool cannot model
  • Definitions the enterprise never agreed
  • Political safety — shadow avoids visible failure in the system of record
  • Skill concentration — one expert maintains the real logic

Why shadow systems are rational

They emerge when official tools are slow, rigid, or misaligned with incentives. They reward local speed. They absorb variance. They are maintained because removing them without replacing function would stop revenue or breach trust.

Official vs shadow
Official systemShadow system
AuditableFast
StandardisedLocally optimised
Funded centrallyMaintained by heroes
Upgrade on IT calendarChange before lunch
Designed for complianceDesigned for Tuesday

The table explains persistence, not virtue. Shadow is a signal, not a strategy.

Risks of leaving shadow unnamed

Continuity risk when the maintainer leaves. Quality risk from untested formulas. Compliance risk when auditors find the real path. Security risk from unmanaged access. Programme risk when migration cuts the shadow without replacing its function.

Three responses to shadow

Formalise

Bring the shadow into governance: owner, access control, change log, defined retirement of duplicates. Appropriate when the shadow is load-bearing and honest.

Replace

Fix the official path until it is faster or simpler than the shadow. Requires definition work and political will. Not a vendor checkbox.

Remove pressure

Stop measuring conflicting outcomes. Collapse approval layers. Agree one definition. Sometimes shadow exists because the organisation asks for impossible speed and perfect audit simultaneously.

Choosing a response
If shadow…Consider
Encodes unique judgementFormalise with controls
Duplicates official dataReplace official path or retire shadow
Exists only for speedFix incentives or simplify policy
Maintained by one expertDocument and duplicate skill urgently
Grows after every go-liveOfficial tool misfit — adapt or replace

Discovery without a witch hunt

  1. Ask teams what they check before they trust the official number.
  2. Follow one high-volume object for a week.
  3. Inventory exports that leave systems of record.
  4. Review incident stories for recurring manual bridges.
  5. Treat findings as design input, not compliance violations on day one.
“The shadow system is not the enemy of the official system. It is the proof of where the official system failed to carry the work.”Constrange

Shadow and transformation programmes

Programmes that mandate 'no spreadsheets' without replacing function fail quietly. Programmes that map shadow early can sequence: formalise the load-bearing sheet while fixing the join, then narrow scope of the official tool until shadow naturally shrinks.

Constrange starts many readings in the shadow layer because that is where truth lives. Every organisation has a shadow system. The question is whether leadership sees it, names it, and chooses what to do — before a migration deletes infrastructure nobody knew was infrastructure.

Patterns we see across sectors

In regulated environments, shadow often carries judgement the official tool cannot encode: exceptions, overrides, client-specific terms. In high-growth firms, shadow carries speed: a tracker updated before the CRM field exists. In cost-focused programmes, shadow carries reconciliation between systems that were never integrated honestly.

The pattern is stable even when the tools differ. Official promises control. Shadow carries the gap between policy and Tuesday. Naming that gap is the beginning of design.

Sector language changes. The structural move does not: read shadow as requirements written in behaviour, not in a backlog.

A twelve-month shadow programme

  1. Quarter one: map top five load-bearing unofficial paths without blame.
  2. Quarter two: formalise or replace the highest-risk path; name owner.
  3. Quarter three: fix one official join that made shadow rational.
  4. Quarter four: retire one duplicate; measure reconciliation time saved.

Twelve months is enough to show whether leadership will enforce change without a new logo. If shadow grows during the programme, the official path is still losing.

Questions for your next steering meeting

  • Which number do we act on when systems disagree?
  • Who maintains the spreadsheet finance trusts?
  • What breaks if that person is unavailable for two weeks?
  • Which approval happens only in email?
  • What did the last migration assume would stop that did not?

If the room cannot answer, shadow is running the steering meeting — not because people are disobedient, but because the official story is incomplete.

Frequently asked questions

Should we ban spreadsheets?

Banning without replacing function drives hiding. Govern or eliminate need instead.

Is shadow IT always bad?

It is always signal. Sometimes it is also risk. Read which.

How do we formalise without slowing teams?

Start with owner, access, and change control on the one sheet that matters most.

Will a new platform remove shadow work?

Only if it removes the pressure that created shadow. Otherwise shadow mutates.

Share

LinkedInXWhatsAppFacebookRedditBlueskyEmail
Keep reading

Related posts