Streamlining Client Intake and Reporting Using Microsoft 365
A counselling and psychotherapy practice came to me for support in making better sense of their systems and processes. At first, the brief was fairly broad: things felt heavier and more complex than they needed to be, and there was a sense that too many tools were involved.
After reviewing their setup, it became clear that the number of tools was not really the issue. The bigger problem was how client intake and reporting were being handled behind the scenes.
The practice already used a dedicated platform for invoicing and therapy-related information, but relied on an Excel spreadsheet to manage new enquiries, track service usage, and pull reports. Over time, that spreadsheet had become difficult to maintain. Data was not always entered consistently, formatting varied, and the structure made reporting more fragile than it needed to be.
The challenge
The intake process involved a mix of emails, phone calls, follow-up questions, and manual data entry into Excel. This created a few issues:
- information was captured in different ways
- manual handling increased the risk of mistakes
- reporting depended on data that was not always standardised
- the spreadsheet had become a central tool for too many different tasks
What initially looked like a tool problem was really a structure problem. The client did not necessarily need more software, they needed a clearer and more reliable way to use what they already had.
What I implemented
Because the client wanted to avoid introducing another platform, I focused on improving the system using their existing Microsoft 365 tools.
The first step was to rebuild the master client setup in Microsoft Lists. This made it possible to standardise the way key information was recorded, including dates, notes, and contract-related details.
Before that could happen, the existing Excel data needed to be cleaned and prepared. One of the main challenges in the project was that the spreadsheet data was not fully standardised, which made migration more time-consuming. I cleaned the data, adjusted formatting, and reviewed column types so it could be imported properly and used more reliably going forward.
To make the structure clearer, I also split the records into two separate Microsoft Lists:
- one for individuals
- one for organisations
This reduced noise in the system and made the data easier to manage and report on.
For intake, I created a Microsoft Form so that new enquiries could be captured in a more consistent way and fed directly into the system. This reduced the amount of manual re-entry required and helped create a smoother starting point for the client journey.
Excel was still retained for reporting, but in a much more structured way. Using the Microsoft Lists export link, I created linked Excel reporting files and built pivot tables around the information the client needed to report on. This meant the client could update information in Microsoft Lists and have it flow through into reporting more reliably.
To support the transition, I also provided written guidance and video tutorials so the team could understand the new setup and use it confidently.
The result
The client now has a clearer and more structured way to manage enquiries, maintain client records, and produce reports.
Instead of relying on a single spreadsheet for intake, tracking, and reporting, they now have a system that separates those functions more effectively while still working within tools they already use.
The improvements included:
- more consistent data capture
- less manual admin
- cleaner reporting inputs
- fewer formatting issues
- a setup that is easier to maintain over time
- better internal handover through written and video guidance
Overall, the project replaced a spreadsheet-heavy process with a more reliable Microsoft 365-based system, without adding unnecessary complexity.
Need support simplifying your systems behind the scenes? Get in touch.