Moving Client Management Off Spreadsheets and Email
The spreadsheet is not the problem. The problem is that it is the only place three facts exist and nobody knows which three.
Almost every professional services firm runs client delivery on a shared mailbox, a workbook and a folder structure, and it works far longer than anybody expects. It stops working at a specific and recognisable point: when the number of people who need to know something exceeds the number who happen to be on the thread.
The migration away from it is usually attempted as a technology project and usually fails as a change project. What follows is a sequence that treats it as the latter.
Recognising the point at which it has stopped working
The symptoms are behavioural rather than technical, and they are worth naming because firms tend to normalise them.
- Somebody has to search their own mailbox to answer a factual question about a client commitment.
- Two people give a client different answers about the same deadline in the same week.
- A person going on leave requires a handover document that takes half a day to write.
- A client asks what was agreed in a meeting three months ago and the answer requires an archaeology exercise.
- The workbook has a column somebody is afraid to change because they do not know what depends on it.
- Onboarding a new joiner takes longer than a month before they can answer a client question unaided.
What to migrate, and what to leave behind
The instinct is to move everything, and it is wrong. A migration that carries fifteen years of history into a new system reproduces the mess in a more expensive place, and it makes the new system feel like the old one on day one, which is fatal to adoption.
Move what is live and what is legally required. Leave the rest where it is, archived and searchable, and let it age out.
- Move: live engagements, current commitments, open risks and issues, the client contact list, and contractual documents still in force.
- Move: anything with a retention obligation, which usually means signed agreements, approvals and formal correspondence.
- Leave: closed engagements older than your retention floor, superseded document versions, and the entire mailbox.
- Leave: the workbook itself, read-only, for a defined period. People will check it, and telling them not to does not stop them; making it read-only does.
The sequence that works
Run it engagement by engagement rather than all at once. A big-bang cutover in a services firm means every client relationship changes on the same day, and any problem affects all of them simultaneously.
- Pick one engagement with a tolerant client and a willing lead. Not the largest, and not the most difficult.
- Move that engagement completely. Half-migration is worse than none, because it creates two places to look, which is the original problem.
- Run it for one full reporting cycle, so the monthly report, the billing run and at least one governance meeting all happen in the new place.
- Write down what broke. Fix the process, not just the instance.
- Then move engagements in batches, oldest and simplest first, with a fixed date after which the old place is read-only for each batch.
- Set a firm-wide date for the shared mailbox to become read-only, announce it well in advance, and hold it. A migration with no end date does not end.
The part everybody underestimates: telling the clients
A migration changes how clients interact with you, and a client who learns about it from a system-generated invitation email will treat it as spam. This is the single most common cause of a portal rollout stalling at low adoption, and it is entirely preventable.
Tell each client individually, from a person they know, before any automated message arrives. Say what changes for them, what does not, and what problem it solves for them specifically rather than for you. A message saying it will improve our internal efficiency invites the reasonable response that this is not their concern.
Give them a way back. A client who cannot get an answer because they cannot log in will email, and if the email goes unanswered you have made their life worse in exchange for making yours better, which is how goodwill is spent.
Keeping the history without carrying the mess
History matters in professional services because a question about what was agreed can arrive years later, and the answer has commercial consequences. But history does not need to be in the working system to be findable.
The workable arrangement is a frozen archive with a documented index: where the old material lives, who can reach it, how far back it goes, and when it will be deleted under the retention policy. One page, written once, kept with the client records. It costs an afternoon and it is the difference between an archive and a pile.
Measuring whether it worked
Decide the measurements before the migration starts, because afterwards everybody will have an opinion and no baseline. Three are usually sufficient.
Time to answer a factual client question, sampled the same way before and after. The number of client-facing commitments with a named owner and a date, which should rise sharply because the old system had no way to enforce it. And the proportion of client interactions happening in the new place rather than by email, which is the honest adoption number and the one most firms avoid looking at.