Engineering Blog · Post #45

The BOR Dashboard: How Underwriters Track Every Broker Change Across Their Book

How InsightUW gives underwriters a single page to monitor active countdowns, filter BOR history by status, search account-level records, and manage broker transitions — with summary cards that never scroll out of view.

The Problem

An underwriter managing a book of 150+ accounts may have five or six active BOR changes at any given time, each at a different stage: one pending, two counting down, one contested, two recently completed. Without a centralized view, the underwriter checks a spreadsheet for active BORs, opens an email folder for contest updates, and asks the ops team about completed changes. When a broker calls asking about the status of their BOR filing, the underwriter needs 10 minutes and three systems to answer a 10-second question.

The lack of a unified dashboard also means that portfolio-level patterns are invisible. Is one broker consistently filing BOR letters against another? Are BOR contests concentrated in a specific LOB? These questions cannot be answered when BOR data lives in disconnected systems.

The InsightUW Approach

InsightUW provides a dedicated BOR dashboard at /uw/bor with three tabs — Countdown, All BORs, and Account History — plus always-visible summary cards. Underwriters access their assigned BORs via GET /uw/{uw_name}, and every BOR record is accessible through a detail modal with full information, letter preview, PDF download, and action buttons for approve, deny, and contest.

graph TD subgraph Header["Summary Cards — Always Visible"] A["Active Countdowns Card Count Badge"] B["Total BORs All-Time Count"] C["Completed Finalized Count"] D["Expired Awaiting Action"] end subgraph Tab1["Tab 1: Countdown"] E["Card Grid Layout"] F["Urgency-Sorted Most Urgent First"] G["Countdown Cards Days / Progress Bar"] H["Broker Transition Incumbent → New"] end subgraph Tab2["Tab 2: All BORs"] I["Filterable Table"] J["Status Filter Active / Expired / Completed / Contested"] K["Sort by Date Insured / LOB / Status"] L["Click Row → Detail Modal"] end subgraph Tab3["Tab 3: Account History"] M["Search by Insured Name"] N["Chronological Entries"] O["Action Badges Created / Contested / Approved / Denied"] P["Expandable Details"] end A --> E A --> I A --> M B --> I C --> I D --> E E --> F F --> G G --> H I --> J J --> K K --> L M --> N N --> O O --> P

Summary Cards: Always Visible

Four summary cards are pinned above the tab content and remain visible regardless of which tab is selected. They provide an at-a-glance portfolio summary:

Card	Value	Color	Description
Active Countdowns	Count of BORs with status `active`	Blue	Number of grace periods currently running
Total BORs	Count of all BOR records assigned to the UW	Gray	Lifetime BOR volume
Completed	Count of BORs with status `completed`	Green	Successfully finalized broker changes
Expired	Count of BORs with status `expired`	Amber	Grace periods that have passed but not yet finalized

Cards update in real-time as BOR statuses change. The Active Countdowns card pulses when any countdown is in the critical (< 1 day) urgency level.

Tab 1: Countdown (Default View)

The Countdown tab displays all active grace periods as a card grid, sorted by urgency (most urgent first). This is the default tab when the dashboard loads.

Each countdown card contains:

Element	Description
Insured Name	Bold header with LOB badge
Day Counter	Large numeric display (e.g., "3.2 days")
Progress Bar	Color-coded consumption bar (green/amber/red)
Urgency Badge	On Track / Approaching / Urgent / Expired
Broker Transition	Incumbent broker name in red, arrow, new broker name in green
Assigned UW	Shown only in team views
Quick Actions	View Details, Generate Letter, Contest

The broker transition line uses color to make the direction of change immediately clear:

Red for the incumbent being replaced, green for the new broker taking over.

Tab 2: All BORs (Filterable Table)

The All BORs tab displays every BOR record assigned to the underwriter in a sortable, filterable table:

Column	Sortable	Filterable	Description
Insured Name	Yes	Yes (text search)	Account name
LOB	Yes	Yes (dropdown)	Line of business
Incumbent Broker	Yes	Yes (text search)	Broker being replaced
New Broker	Yes	Yes (text search)	Broker taking over
Status	Yes	Yes (multi-select)	active / expired / completed / contested / denied / withdrawn
Grace Period End	Yes	Yes (date range)	When the countdown expires
Created Date	Yes	Yes (date range)	When the BOR was filed

Status filter options: Active, Expired, Completed, Contested, Denied, Withdrawn. Multiple statuses can be selected simultaneously.

Clicking any table row opens the detail modal for that BOR.

Tab 3: Account History (Search)

The Account History tab provides a searchable view of all BORHistory entries:

Search bar — type-ahead search by insured name, filters results as you type
Chronological list — entries displayed newest first
Action badges — color-coded badges for each action type: Created (blue), Contested (red), Approved (green), Denied (red), Withdrawn (gray)
Expandable rows — click to expand and see full details including broker names, contest reasons, and resolution notes
Export button — download filtered history as CSV

This tab is invaluable when an underwriter needs to answer: "What is the BOR history for this account?" — a question that previously required searching through email archives and spreadsheets.

Detail Modal

Clicking any BOR record (from the Countdown card or the All BORs table) opens a comprehensive detail modal:

Section	Content
Header	Insured name, LOB, status badge
Broker Information	Incumbent and new broker names, contacts, emails
Grace Period	Start date, end date, days remaining (if active), progress bar
Documents	BOR letter preview (HTML), 5-day notice preview, PDF download buttons
Contest Info	Shown only if status is `contested`: contested by, reason, date
Actions	Approve & Finalize, Deny, Contest, Generate Letter (context-dependent)
Audit Trail	Chronological log of all actions on this BOR

The document section includes both an HTML preview (rendered in the modal body) and a PDF download button, using the same Document Template and ReportLab infrastructure described in Blog 41.

API: Underwriter BOR Endpoint

Underwriters access their BOR records through:

Broker List in Countdown Cards

Each countdown card displays the broker transition with color coding to make the direction of change unambiguous:

Element	Style	Example
Incumbent broker name	Red text (`#f44336`)	Willis Towers Watson
Arrow indicator	Gray (`#9e9e9e`)	-->
New broker name	Green text (`#4caf50`)	Marsh & McLennan

When multiple BOR records are visible in the countdown grid, the color-coded broker lines create an instantly scannable view of all active transitions.

Sarah Chen's BOR Dashboard

Scenario: Sarah Chen, a senior D&O and Cyber underwriter, opens her BOR dashboard on the morning of April 22, 2026.

Summary Cards:

Card	Value
Active Countdowns	2
Total BORs	14
Completed	9
Expired	3

Countdown Tab (default view) — 2 active cards:

Card	Insured	LOB	Days Left	Urgency	Broker Transition
1	NovaPay Technologies	Cyber	1.1 days	Critical (red)	Gallagher (red) --> Aon (green)
2	Apex Medical Partners	D&O	3.2 days	Warning (amber)	Willis (red) --> Marsh (green)

NovaPay is sorted first because it is more urgent. The card has a red border and the "Urgent" badge.

Sarah's workflow:

She sees NovaPay is critical — 1.1 days left. She clicks the card to open the detail modal, reviews the BOR details, and confirms no contest has been filed. She knows she cannot quote Aon on this account until tomorrow afternoon.
She clicks the "All BORs" tab and filters by status: "completed". The table shows her 9 finalized BOR changes from the past 6 months. She clicks the most recent one to review the resolution notes.
She switches to "Account History" and searches for "Apex Medical" to see prior BOR activity. The history shows this is the second BOR change for Apex Medical in 18 months — last year Willis replaced Lockton, and now Marsh is replacing Willis.
She returns to the Countdown tab. The summary cards at the top still show 2 active countdowns, confirming nothing has changed while she was reviewing history.

What This Means for Underwriters

One page for everything — the three-tab dashboard with always-visible summary cards gives underwriters a complete view of their BOR portfolio without switching between systems, spreadsheets, or email folders.
Urgency-first prioritization — the Countdown tab as the default view, sorted by urgency, ensures that the most time-sensitive BOR changes are always the first thing an underwriter sees.
Instant status answers — when a broker calls asking about their BOR filing, the underwriter can search by insured name in the All BORs tab or Account History tab and answer in seconds, not minutes.
Visual broker direction — the red (incumbent) to green (new broker) color coding on countdown cards makes the direction of every broker change immediately scannable, even across a grid of multiple active BORs.
Full detail without navigation — the detail modal provides broker information, grace period status, document preview, PDF download, and action buttons in a single overlay, so underwriters never leave the dashboard to manage a BOR.

What's Next

This concludes the BOR feature series. In upcoming posts, we will explore InsightUW's reporting and analytics capabilities — how carriers extract portfolio insights, track underwriting performance metrics, and generate regulatory reports from the data captured across submissions, quotes, policies, and BOR changes.

InsightUW is an AI-powered underwriting workstation for P&C carriers. Request a demo to see the BOR dashboard in action.