Engineering Blog · Post #42

The 5-Day BOR Countdown: Visual Grace Period Tracking with Urgency-Coded Progress Bars

How InsightUW transforms the mandatory 5-day Broker of Record waiting period into a visual countdown with color-coded urgency levels — so no grace period expires unnoticed.

The Problem

When a Broker of Record letter is filed, most states mandate a 5-day grace period before the broker change takes effect. During this window, the incumbent broker can contest the change, and the carrier must not issue quotes to the new broker. The problem is tracking it. Underwriters scribble dates on sticky notes, operations teams maintain spreadsheets with manual date arithmetic, and when a grace period expires at 5:00 PM on a Friday, nobody notices until Monday morning — three days late.

Missed expirations mean delayed broker transitions, frustrated brokers, and potential compliance violations. When a carrier handles dozens of BOR changes monthly, the manual tracking approach collapses.

The InsightUW Approach

InsightUW provides a dedicated countdown system for every active BOR grace period. Each BOR displays a visual countdown card with days and hours remaining, a color-coded progress bar showing consumption percentage, and urgency levels that escalate automatically as the deadline approaches. The Countdown tab is the default view on the BOR dashboard, ensuring underwriters see active grace periods the moment they open the page.

graph TD subgraph Start["Grace Period Initiated"] A["BOR Created status: pending"] B["grace period start set e.g., Apr 22 9:00 AM"] C["grace period end calculated start + 5 calendar days"] end subgraph Active["Countdown Active"] D["Days Remaining > 3 Green progress bar"] E["Days Remaining 1-3 Amber progress bar"] F["Days Remaining < 1 RED progress bar"] end subgraph Expiry["Grace Period Expiry"] G["Countdown reaches 0 Pulsing RED indicator"] H["check expired bors batch operation runs"] I["Status: pending → expired"] end subgraph Resolution["Post-Expiry"] J["UW Approves Finalize Broker Change"] K["Status: expired → completed"] L["Notifications Sent to All Parties"] end A --> B B --> C C --> D D --> E E --> F F --> G G --> H H --> I I --> J J --> K K --> L

Grace Period Data Model

The countdown is driven by three fields on the Bor model:

Field	Type	Description	Example
grace period start	DateTime	Timestamp when the 5-day clock begins	2026-04-22 09:00:00
grace period end	DateTime	Start + 5 calendar days	2026-04-27 09:00:00
`status`	String	Current BOR status	pending / active / expired

The remaining time is calculated in real-time: grace_period_end - now(). No stored countdown field — always live.

Visual Countdown Cards

Each active BOR renders as a countdown card in the dashboard's Countdown tab. The card displays:

Element	Description
Large Day Display	Bold number showing days remaining (e.g., "2.3 days")
Hours/Minutes	Precise time remaining below the day count
Progress Bar	Horizontal bar showing percentage of grace period consumed
Urgency Badge	Color-coded label: Normal, Warning, Critical, Expired
Broker Transition	Incumbent (red) arrow to New Broker (green)
Insured Name	Prominent display of the insured and LOB

Urgency Color Coding

The system assigns urgency levels automatically based on remaining time:

Urgency Level	Remaining Time	Progress Bar Color	Badge	Behavior
Normal	> 3 days	Green (`#4caf50`)	"On Track"	Standard display
Warning	1 - 3 days	Amber (`#ff9800`)	"Approaching"	Amber highlight on card border
Critical	< 1 day	Red (`#f44336`)	"Urgent"	Red border, card elevated to top
Expired	0 or negative	Pulsing Red (`#d32f2f`)	"Expired"	Pulsing animation, requires action

Progress Bar Calculation

The progress bar represents how much of the 5-day window has been consumed:

Elapsed	Consumption	Bar Fill	Color
0 days	0%	Empty	Green
1.5 days	30%	30% filled	Green
2.7 days	54%	54% filled	Amber
4.2 days	84%	84% filled	Red
5.0 days	100%	Full	Pulsing Red

Batch Expiration Check

The check expired bors operation runs as a scheduled batch process and can also be triggered manually from the BOR dashboard via the "Check Expired" button. It:

Queries all BOR records where status = 'pending' and grace_period_end < now()
Updates each matching record to status = 'expired'
Sends expiry notifications to the assigned UW and operations team
Logs an audit trail entry for each status change

Countdown Tab as Default View

The BOR dashboard opens to the Countdown tab by default, showing all active grace periods as a card grid sorted by urgency (most urgent first). This ensures underwriters see the most time-sensitive BOR changes immediately, without navigating to a sub-view.

The card grid is responsive: 3 cards per row on desktop, 2 on tablet, 1 on mobile.

GL Submission: Bluefin Dining Group

Scenario: Marsh & McLennan files a BOR letter for the General Liability account of Bluefin Dining Group, currently brokered by Willis Towers Watson. The grace period started April 22, 2026 at 9:00 AM.

Field	Value
Insured	Bluefin Dining Group
LOB	General Liability
Incumbent Broker	Willis Towers Watson (David Park, d.park@wtwco.com)
New Broker	Marsh & McLennan (Lisa Nguyen, l.nguyen@marsh.com)
Grace Period Start	April 22, 2026, 9:00 AM
Grace Period End	April 27, 2026, 9:00 AM
Assigned UW	Michael Torres

What Michael sees on April 24 at 3:30 PM (2.3 days remaining):

Large day display: "2.3 days"
Precise time: "2 days, 17 hours, 30 minutes remaining"
Progress bar: 54% consumed, amber color
Urgency badge: "Approaching" (amber)
Card border: Amber highlight
Broker line: Willis Towers Watson (red) --> Marsh & McLennan (green)

Michael knows at a glance that this BOR is past the halfway mark but still within the grace window. He cannot issue quotes to Marsh for this account until the countdown reaches zero and the grace period expires.

What changes on April 26 at 10:00 AM (< 1 day remaining):

Large day display: "0.96 days"
Progress bar: 81% consumed, red color
Urgency badge: "Urgent" (red)
Card border: Red highlight, card moves to top of grid
Bell notification: "BOR Critical — Bluefin Dining Group grace period expires in under 24 hours"

What This Means for Underwriters

Visual urgency at a glance — the countdown card grid shows every active grace period with color-coded progress bars, so underwriters instantly know which BOR changes are approaching expiry without checking dates manually.
No missed expirations — the check expired bors batch operation and pulsing expired indicators ensure that no grace period passes without the team being alerted, even over weekends.
Compliance confidence — the countdown enforces the "no quoting during grace period" rule visually, giving underwriters a clear signal of when they can and cannot engage the new broker.
Automatic escalation — urgency levels escalate from green to amber to red to pulsing without any manual intervention, ensuring critical BOR changes surface to the top of the dashboard.
Default view prioritization — opening the BOR dashboard lands on the Countdown tab, so the most time-sensitive information is always front and center rather than buried behind clicks.

What's Next

In the next post, we will explore BOR notifications and alerts — the five automated notification events that keep underwriters and operations teams informed from BOR creation through grace period expiry.

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