anik ghosh
← Work

Moving client onboarding off Excel and into the product

Onboarding new clients ran on Excel sheets that people updated by hand. Now it runs on a board in the product whose stages come straight from our own data.

Jul – Oct 2026When
PM, design, frontendMy role
Onboarding and placement teamsUsed by
Illustration of the old Excel onboarding tracker Client onboarding board in the product Before: ExcelAfter: in the product

Drag to compare. Left: an illustration of the Excel tracker onboarding used to run on. Right: the board in the product. Company names are made up.

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.

  1. Before JunExcelUpdated by hand, with copies drifting apart
  2. JunGoogle Sheet report62 columns, rebuilt by a sync button that timed out past 300 deals
  3. ThenZoho Desk boardA board to work from, but the data still lived outside Pazcare
  4. 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.

  1. Docs pendingWaiting on the three to five policy documents this type of policy needsMoves on when the last one is filed
  2. Onboarding tasksThree platform tasks. Two are detected from the data; only health-card mapping is ticked by handMoves on when all three are done
  3. Verify and assign SPOCCheck the insurer's member list against ours, then name a point of contactMoves on at sign-off
  4. CompletedHanded over to account management 

Each card also shows how long it has waited: 0–3, 4–7, 8–14 or 15+ days.

Decisions

Stages come from data, not a dropdown.

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 drawer opens on what the card is waiting for.

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.

Reconciliation runs inside the board.

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.

300+companies onboarded
20%faster onboarding TAT