System Overhaul for a CPA Firm

What Wasn’t Working

This CPA firm had hundreds of clients and no real way to track where each one was in the process. The inbox was flooded (95k+ emails), the team was constantly in catch-up mode, and the owner was working long hours every day (including weekends) just to keep up. There was no central source of truth, so figuring out who still needed what or where to focus each day took hours of meetings and manual digging. Everyone was overwhelmed.

What We Built

I designed a custom system in Google Sheets that gave the team (and especially the owner) total visibility without the mental chaos. The setup included:

• a single sheet to track all clients and their required documents

• smart checkboxes that updated client status automatically

• personal dashboards that told each team member what to work on next

• visual cues for overdue tasks or follow-ups

• light automation to trigger client emails and reduce manual admin

• a built-in workflow for extensions so nothing had to be rebuilt for October

• simple delegation tracking so prep could be split between the owner and team easily

Everything flowed through one place, and the system told everyone what to do next—no memory or micromanaging required.

The Outcome

The owner was able to take a two-week vacation abroad in March and barely needed to check in. The next year, he was working fewer hours, taking mornings off with his wife, and handling tax season without the usual panic. He told me the system gave him a way to wake up and know exactly what needed to happen that day. It also made it easier for the whole team to work together without constant check-ins.

This setup didn’t just streamline the process, it reduced the massive mental load, the anxiety, confusion, and the decision fatigue that came with managing hundreds of clients.