SME Sabotage: How to Spot the "Spreadsheet Gatekeepers" Killing Your ERP ROI

She's been with the company for 12 years. She's indispensable. She maintains the "master spreadsheet" that reconciles what the ERP can't. Without her, entire workflows grind to a halt.

She is a Spreadsheet Gatekeeper, and she is the single largest threat to your ERP ROI.

The Gatekeeper Pattern

Spreadsheet Gatekeepers emerge when ERP implementations leave gaps that employees fill with manual workarounds. Over time, these workarounds become essential — and the employee who maintains them becomes irreplaceable. Not because they're exceptionally talented, but because they're the only person who understands the logic embedded in their spreadsheets.

This creates a perverse incentive: the gatekeeper's job security depends on the shadow processes remaining undocumented and indispensable. Whether conscious or not, they resist systematization because it threatens their unique position.

How to Neutralize the Pattern

The solution isn't to fire gatekeepers — it's to extract and systematize their knowledge. A Deadweight Diagnostic identifies every shadow process, quantifies the risk exposure, and creates a plan to move that knowledge from people to systems. The gatekeeper becomes a trainer and subject matter expert rather than a single point of failure.

The key: this requires an external facilitator who can ask the uncomfortable questions that internal teams won't. That's where we come in.