Delivered — phase 2 ongoing · Funeral insurance — distribution

One self-service platform for 900+ agents — onboarding, comms, commission, payroll.

Replaced the spreadsheets and WhatsApp threads that ran a six-tier sales force with a single .NET 8 + React platform on Azure. Every agent has their own login. Onboarding, comms, commission and payroll all live on one audit trail.

The problem

The client recruits and manages a funeral insurance sales force across a six-level hierarchy — agents, distributors, managers, area managers, regional managers and a national manager — selling policies administered on a separate external system called POL360.

Before this engagement, the sales-force database lived in spreadsheets. Onboarding a new agent meant chasing documents by email, manually capturing details into a sheet, copying verification links into WhatsApps, and hoping nothing fell through.

Commission workings sat in separate workbooks. There was no single place to see which agents were dormant, which were awaiting a verified email, or which had never submitted a first policy.

The approach

We built a centralised sales-force platform in .NET 8 and React on Azure, modelling the six-level hierarchy directly in SQL Server so L1–L6 relationships, agent re-allocations, and partner-scoped permissions became data rather than spreadsheet conventions.

Every agent and distributor has their own login — cookie-based auth and five enforced access levels mean an L1 Agent sees their own commissions, status, documents and stats; an L6 National Manager sees everything across every partner; admin sees the operational control surface.

For communications we wrote a Hangfire-driven pipeline with per-message de-duplication, dispatched through BulkSMS for SMS and SMTP for email, with every send timestamped and stored under the recipient. The three-email onboarding sequence and status-change notifications fire automatically the moment an agent moves out of Under-Review.

On top of that we automated the money side: commission calculations run on the platform against ingested policy data, and payroll is prepared and managed from the same system — so every agent's journey from onboarding to earnings to payout lives on one audit trail.

Inside the platform

Sales operations dashboard showing active agents, policies today, MTD volume, new premium, pending approvals and outstanding documents, with charts for captured policies and inception-month breakdowns. — The operational control surface — active agents, policies today, MTD volume, pending approvals and outstanding documents on one screen, with captured-policy and inception-month breakdowns underneath.

Sales force roster table listing agents with role, M&C code, status, province, distributor, area manager and compliance percentage. — The six-tier hierarchy modelled in SQL — every agent's role, M&C code, distributor, area manager and compliance score in one filterable roster.

Add Member modal capturing personal information, ID, mobile, role and assessment mark, with tabs for documents, bank, address and notes. — Onboarding intake — every new agent captured digitally end-to-end. Submission triggers verification, welcome and policy-link emails automatically.

Commission cycle screen with exception flags (invalid email, compliance below 80%, duplicate M&C code) above a provisional ledger of per-agent and per-distributor earnings totalling R 162,575 across 1476 policies, with an Approve Cycle action. — A monthly commission cycle — exceptions surfaced before approval, then a provisional ledger of per-agent, distributor and area-manager earnings on the same audit trail as onboarding.

System administration audit log showing timestamped commission rule updates, cycle approvals, hierarchy modifications and compliance setting changes against named users. — Every config change, cycle approval and hierarchy edit timestamped against the user — the audit trail that used to be reconstructed from spreadsheets at year-end.

Client logo, real names, banking fields and partner identifiers redacted at the client's request. Sample data shown in place of live records.

What we delivered

Centralised .NET 8 + React platform on Azure (App Service, Azure SQL, Key Vault).
Six-tier sales hierarchy modelled in SQL with partner-scoped permissions.
Per-agent self-service login with five enforced access levels (L1 Agent through L6 National Manager + admin).
Hangfire-driven communications pipeline — three-email onboarding sequence + status-change notifications, BulkSMS for SMS, SMTP for email, every send timestamped.
Commission automation against ingested policy data.
Payroll preparation and management on the same audit trail.

The result

900+ active agents nationwide running on one platform, each with their own login.
Agents and distributors self-serve on status, commissions, documents and sales stats — no more phoning head office.
Onboarding is fully remote and digital end-to-end: capture, verification, status tracking and document storage all live in the platform.
What an agent sold, what they earned and what they were paid reconcile on one audit trail.
Spreadsheets and WhatsApp-based manual onboarding retired.

Ongoing — in build