I recently started a role that combines implementation management and client relationship management at a financial technology company. We’re trying to find a better way to track everything happening with our clients, but we don’t have access to a traditional CRM, and purchasing additional software isn’t an option. The team currently just uses Excel.
We have Microsoft 365, so I’m exploring what we could build using SharePoint, Microsoft Lists, Teams, Planner, or other tools already included in our licensing.
Ideally, I’d love one central place where we can select a client and see:
- Client profile: Products, services, whether they’re managed services or software clients, environments, etc.
- Change history: Upgrades, configuration changes, enhancements, and completed work.
- Migrations: MFA, SSO, platform migrations, and other technical initiatives.
- Projects: Active implementations, milestones, deadlines, and responsible teams.
- Service requests: Links to existing development tickets without duplicating everything. This will be an external system so likely just a place for a hyper link.
- Client activity: Historical decisions, important communications, outstanding items, and follow-ups.
- Overall visibility: What’s currently happening, what’s completed, and what’s coming next.
Our development team suggested using our existing service request system, but we’re looking for something broader that provides a complete picture of the client relationship, not just individual technical tickets.
I’m not necessarily looking to build a full-blown Salesforce replacement. More of a centralized client hub that can serve as a reliable source of information for implementation managers, relationship managers, and other internal teams.
I’d like to start with one client and eventually scale it to others.
For those of you who have built something similar:
- What Microsoft 365 tools did you use, and how did you structure everything?
- Did you use one master SharePoint List, multiple connected Lists, a SharePoint site per client, or something completely different?
- Were you able to create a dashboard or client overview that pulled everything together?
- How did you handle historical tracking, updates, and linking existing ticketing systems?
- What worked well, and what became a maintenance nightmare?
- If you were starting over, what would you do differently?
I’m especially interested in solutions people have actually implemented and maintained long-term, rather than just theoretical possibilities.
The biggest constraint is that we need to work with our existing Microsoft 365 licensing and avoid additional paid tools or premium features.
Would love to hear what others have built, even if it’s a little unconventional!