The problem
When a client signs, operations collects the policy documents, maps health cards, sets up the deposit ledger and hands the account over to account management. All of that was tracked in Excel.
Each row's status was typed in by whoever last touched it, so the sheet said one thing while the records in Pazcare said another. Nobody could say how long onboarding took, or which clients were stuck.
How it got here
The board wasn't the first fix. Each step solved part of the problem and showed what the next one needed.
- Before JunExcelUpdated by hand, with copies drifting apart
- JunGoogle Sheet report62 columns, rebuilt by a sync button that timed out past 300 deals
- ThenZoho Desk boardA board to work from, but the data still lived outside Pazcare
- Aug – SepBoard in the productEvery input already comes from Pazcare, so the board reads it directly
How the board works
Nobody sets a card's stage. It's worked out again every time something changes, from records that already exist.
- Docs pendingWaiting on the three to five policy documents this type of policy needsMoves on when the last one is filed
- Onboarding tasksThree platform tasks. Two are detected from the data; only health-card mapping is ticked by handMoves on when all three are done
- Verify and assign SPOCCheck the insurer's member list against ours, then name a point of contactMoves on at sign-off
- CompletedHanded over to account management
Each card also shows how long it has waited: 0–3, 4–7, 8–14 or 15+ days.
Decisions
A status that people have to remember to update is what made Excel drift. If the stage can be worked out from what's already in Pazcare, the board can't disagree with the records.
The first version showed all four sections on every card, and three of them usually weren't actionable. Now the drawer changes with the stage and leads with the one thing that's holding the client up.
Before sign-off, ops checked the insurer's member list against ours line by line in Excel, and any gap turned up later as a missing health card or a rejected claim. One button now runs the comparison and lists only the people who need action.
Who did what
Me
The product and design of the board, its stage rules and the drawer, and much of the frontend.
The team
Engineering on the backend models and the lives-matching engine behind reconciliation, and feedback from ops on every version.
Result
The Excel tracker is gone. The onboarding and placement teams work from one board, and its stages match the records because they come from them.
