Two years ago, a mid-market advisory firm was running their entire operation from Google Sheets. Everything: client records, deal pipeline, document management, compliance checklists, audit trails.
It worked, sort of. Until it didn’t.
The Spreadsheet Stage
The firm had eleven advisors, three operations staff, and a managing director. Here’s what they were doing:
Client data lived in one spreadsheet. Deal tracking in another. Documents were filed in Google Drive folders, but which folder? That was a guess. Compliance checklists were printed, filled in by hand, scanned, then maybe transcribed back into a sheet. Or maybe not. Audit trails didn’t exist—if something was wrong, nobody knew who changed it or when.
When a new advisor joined, they’d ask where something was and get a dozen different answers from different people. Every spreadsheet had subtle variations in how things were recorded. An date might be DD/MM/YYYY in one sheet and M/D/YY in another. A deal stage might be called “Proposal Sent” in one place and “Proposal” somewhere else.
So managers spent hours reconciling data. Calculations would break because someone accidentally deleted a formula. Column widths would shift and numbers would become unreadable. Files were emailed around, and nobody knew if you had the latest version.
Business was growing, but the spreadsheet infrastructure was cracking.
The Moment They Knew
The breaking point came when a compliance audit happened. Regulators needed an audit trail—a complete record of every action on every client file. The firm had to manually reconstruct six months of changes from version history, spreadsheet tabs, and emails. It took two weeks.
Then they lost a client because a spreadsheet formula broke on the last day of the quarter, missing a deadline renewal date. Nobody caught it until after hours.
That’s when they reached out.
What We Built
Not an off-the-shelf CRM (which wouldn’t handle their workflow). Not a custom monster requiring a full-time admin to maintain. A focused, purpose-built system.
All advisors log in and see a dashboard: their active clients, pending tasks, upcoming milestones, this quarter’s revenue.
Click on a client, and their full record appears: contact history, all deals, document library, compliance status, communication log. Everything they need is in one place.
Deals move through stages: Pipeline, Proposed, Accepted, In Progress, Complete. When a deal moves to a new stage, the system:
• Generates the next required document automatically (proposal, contract, checklist).
• Creates a calendar reminder for the advisor.
• Updates the compliance record.
• Logs the timestamp and user who moved it (audit trail).
No manual updates. No version confusion. Roles are granular: advisors see their own clients and those they’re collaborating on. Operations staff see reports and can edit compliance status. The managing director sees everything. A bookkeeper can see only financial records.
Integrations That Matter
Their Stripe account syncs automatically. Payments create invoice records. Invoices sync to their accounting software. Email archive links conversations to client records. Calendar meetings appear in the timeline.
Google Drive is still used for long-form documents, but the system knows what’s stored where. You can attach a document from Drive and the system indexes it, making it searchable.
The Human Impact
After six weeks of migration and training, here’s what changed:
Time: Operations staff used to spend 6-8 hours a week reconciling spreadsheets and managing versions. That’s gone. They now spend an hour a week reviewing reports.
Accuracy: Zero spreadsheet formula breaks in the last year. Data entry mistakes decreased because the system validates information as it’s entered (a date field won’t accept text, a dropdown prevents misspelling a stage name).
Compliance: Every action is logged with timestamp and user. An audit now takes one afternoon instead of two weeks.
Onboarding: New advisors can use the system productively on day one. Before, it took three days of asking where things were.
Confidence: Nobody’s panicking about where a critical file is or whether they’re looking at current data. The system is the source of truth.
The Cost Comparison
Build cost: £18,000. Ongoing support and maintenance: £1,500 per month.
They’d previously tried Salesforce and abandoned it after three months (too complicated, too expensive at £50 per seat, required a full-time admin). HubSpot worked partially but didn’t handle their specific workflows. Smaller tools lacked the integration and automation they needed.
Build once, own forever. After 12 months, the payback was clear: they’d saved more in staff time and eliminated errors than the system cost.
The Transition
Migration was gradual. For four weeks, both systems ran in parallel. Advisors used the new system for active work, Google Sheets for reference. Once they were confident, Sheets became read-only historical record. After two months, nobody missed it.
No catastrophic cutover. No data loss. No days of downtime.
What’s Different Now
The firm added two new advisors last year. Onboarding them took a fraction of the time it used to. They added a new automated workflow (document approval process) in two weeks. They integrated with a new compliance software without any integration headaches.
Would they have achieved this growth stuck managing spreadsheets? Unlikely.
This is what the jump from Stage Two (spreadsheets) to Stage Three (custom application) looks like. Not glamorous. Not enterprise. Just work that actually gets easier as you grow.
If this sounds familiar—if you’re managing client data in spreadsheets, losing hours to manual work, or worried about compliance and audit trails—your situation isn’t unique. And like this firm, the answer might be simpler than you think.
Want to explore what a custom system could do for your business? Head to our app development page to discuss your situation. We’ll walk you through options and timelines.
Frequently Asked Questions
Q: Do we have to export all our Google Sheets data?
Not if you don’t want to. Historical data can stay in Sheets. We import current, active data and make the new system your operational home. Old sheets become reference-only archive.
Q: What if we still want to use Sheets for ad-hoc analysis?
You can export reports from the system into Sheets anytime. The system is your operational source of truth, but Sheets can still be a tool for analysis and what-if scenarios.
Q: Will our team push back on learning new software?
If the new software is easier and saves them time, resistance dissolves fast. The firm we described here had 100% adoption within two weeks. People like systems that make their work simpler.
Q: What if we’re not ready to build yet?
That’s fine. Read our post on when to replace your SaaS stack. It outlines the signals. Some organisations need to try SaaS first. Some are ready immediately.
Q: How much does migration cost?
Data migration is part of the build project, not an extra cost. We include it: cleaning your data, validating it, importing it, running both systems in parallel, and training your team to use the new system.
Q: Do we need IT staff to manage it?
No. We build systems that operate independently. You have a support contact for maintenance and updates, but no day-to-day IT overhead. Your operations staff manages it the same way they would manage Salesforce.
