When a spreadsheet becomes a liability
The five signals that a spreadsheet is now critical infrastructure.
BUSINESS SYSTEMS
Business systems guides for owners who want their week back
These guides cover the operating layer of a business: when to replace spreadsheets, how to choose or build a CRM, which dashboards actually drive decisions, and how to keep data clean enough to trust.
A business system is whatever the team relies on to get work out of the door. Most are accidental, built from spreadsheets and habits.
These guides help you decide what to buy, what to build and what to delete.
Guides in this category
Published progressively in the journal. Ask for any of these and it moves up the queue.
Choosing between an off-the-shelf CRM and a custom one
Fit, cost per seat, workflow depth and migration risk.
Dashboards people actually use
Picking the six numbers that drive decisions and ignoring the rest.
Data hygiene for small teams
Single source of truth, validation rules and deduplication that stick.
Building an internal tool in four weeks
Scoping, delivery and adoption for tools your own team depends on.
Documenting processes so software can carry them
A practical template for turning tribal knowledge into a workflow.
Checklists
Internal tool scoping checklist
- The daily users were interviewed, not just managers
- Current workarounds are documented
- Required reports are listed before the build
- Permissions per role are defined
- Data migration source and quality are known
- Launch includes training and a fallback plan
Operations health checklist
- Every core process has a named owner
- Key numbers are visible without asking anyone
- No critical process depends on one person's memory
- Customer data lives in one system of record
- Manual re-keying between tools has been eliminated
Comparisons
- Custom CRM vs HubSpot or Pipedrive (planned)
- Notion or Airtable vs a purpose-built internal tool (planned)
- One integrated platform vs best-of-breed tools (planned)
Business Systems FAQs
How do I know we have outgrown spreadsheets?
+
When more than one person edits the same file, when errors have caused real cost, when the file drives customer-facing decisions, or when nobody fully understands the formulas any more.
Should we buy a CRM or build one?
+
Buy if your sales process is standard. Build when the pipeline reflects something specific to your business, when per-seat costs are high, or when the CRM must sit inside a wider operational system.
How much does an internal tool cost?
+
Focused internal tools typically run $3,000 - $10,000 and ship in 2 - 8 weeks. Larger operational platforms start around $15,000.
How do we get the team to actually use a new system?
+
Involve the daily users during scoping, replace rather than add to their workload, migrate real data before launch, and keep the first version small enough to learn in one session.