Insurance Brokerage, Bancassurance & Underwriting Agency ERP: IRA Commission Splits, IPF Premium Financing, and Claims Bordereaux Automation

Insurance brokers, bancassurance intermediaries, and general/medical underwriting agencies in Kenya operate under strict Insurance Regulatory Authority (IRA) cash-and-carry premium rules, multi-tier underwriter commission schedules, and complex Insurance Premium Financing (IPF) arrangements with commercial banks. Yet many mid-to-large brokerages still track policy renewals, risk notes, M-Pesa Paybill collections, and underwriter remittances on disconnected spreadsheets—leading to uncollected renewal policies, sub-agent commission overpayments on cancelled policies, and prolonged IRA audit reconciliations.

At devManue, we architect custom Insurance Brokerage, Bancassurance & Underwriting Agency ERP platforms that unify multi-underwriter quote comparisons, instant risk-note generation, tripartite IPF loan tracking, automated AKI DMVIC motor certificate issuance, and real-time commission split ledgers.

1. Why Generic Accounting Software Fails Insurance Intermediaries

Unlike standard retail invoicing where 100% of a sale is recognized as company revenue, an insurance broker collects gross premiums in trust, deducts class-specific brokerage commission (e.g., 10% on Motor Private, 15% on Fire Industrial, 12.5% on Medical), withholds Withholding Tax (WHT), splits a portion with tied sub-agents or relationship managers, and remits the net premium to the underwriter:

• Tripartite IPF Default & Policy Cancellation Windows: When a corporate fleet client finances a KES 14M annual premium via a 10-month Bank IPF facility, the bank disburses the gross premium up front. If the client defaults on Month 4, the bank exercises its right to instruct policy cancellation and demands a pro-rata unearned premium refund—requiring immediate reversal of unearned brokerage and sub-agent commissions.
• AKI DMVIC & Medical Card API Bottlenecks: Manually logging into external portals to issue digital motor certificates after an M-Pesa payment delays policy delivery and frustrates retail motorists at police checkpoints.
• Claims Notification & Assessor SLA Blind Spots: Without a structured claims bordereaux tracker linking the First Notice of Loss (FNOL), external loss adjuster appointments, discharge vouchers, and DV settlement timelines, corporate clients defect at renewal.

2. Statutory Levy Calculation & Clawback-Safe Commission Ledger

Every Kenyan risk note must accurately compute the base premium across the sum insured or tariff rate, add the Insurance Training Levy (ITL), the Policyholders Compensation Fund (PHCF) levy, and statutory Stamp Duty, while ensuring brokerage commission is calculated strictly on the basic net premium (excluding statutory levies):

# Python / Django: Kenyan Insurance Risk Note & Commission Split Engine
from decimal import Decimal, ROUND_HALF_UP

class KenyanRiskNoteCalculator:
    ITL_RATE = Decimal("0.0020")   # 0.20% Insurance Training Levy
    PHCF_RATE = Decimal("0.0025")  # 0.25% Policyholders Compensation Fund
    WHT_COMMISSION_RATE = Decimal("0.05")  # 5% Withholding Tax on Brokerage

    @classmethod
    def compute_debit_note_and_commission(
        cls,
        basic_premium: Decimal,
        brokerage_rate: Decimal,
        stamp_duty: Decimal = Decimal("40.00"),
        sub_agent_share_rate: Decimal = Decimal("0.30"),
    ) -> dict[str, Decimal]:
        itl = (basic_premium * cls.ITL_RATE).quantize(Decimal("0.01"), rounding=ROUND_HALF_UP)
        phcf = (basic_premium * cls.PHCF_RATE).quantize(Decimal("0.01"), rounding=ROUND_HALF_UP)
        gross_payable = basic_premium + itl + phcf + stamp_duty

        # Commission applies strictly to basic premium, never statutory levies
        gross_commission = (basic_premium * brokerage_rate).quantize(Decimal("0.01"), rounding=ROUND_HALF_UP)
        wht_deduction = (gross_commission * cls.WHT_COMMISSION_RATE).quantize(Decimal("0.01"), rounding=ROUND_HALF_UP)
        net_broker_commission = gross_commission - wht_deduction
        sub_agent_payout = (net_broker_commission * sub_agent_share_rate).quantize(Decimal("0.01"), rounding=ROUND_HALF_UP)

        net_remittance_to_underwriter = gross_payable - gross_commission
        return {
            "basic_premium": basic_premium,
            "itl_levy": itl,
            "phcf_levy": phcf,
            "stamp_duty": stamp_duty,
            "gross_client_debit": gross_payable,
            "gross_brokerage": gross_commission,
            "wht_tax": wht_deduction,
            "sub_agent_commission": sub_agent_payout,
            "net_underwriter_payable": net_remittance_to_underwriter,
        }