PNC Quote Engine

End-to-end commercial insurance quoting — from quick indications to bound policies. 29 pages, 92 API endpoints, 19 services, 18 database tables.

10
Use Case Stories
29
Pages
92
API Endpoints
18
Database Tables

Use Case Stories

Use Case 1

New Business Quote Intake

Core Workflow Pages: /quotes, /quotes/new, /quotes/[id] Endpoints: create, addLine, getById, list, dashboard
SP
Sarah Palmer
Commercial Lines Agent — Palmer Insurance Agency

The Scenario

Sarah receives a call from Metro Construction Corp, a mid-size contractor looking for a Commercial General Liability policy. She needs to quickly enter the submission, run an appetite check, and generate a quote with proper coverages.

localhost:3001
Step 1 — Dashboard Overview
Quotes
Real-time quote pipeline overview
247
Total Quotes
34.2%
Conversion Rate
$45,800
Avg Premium
$2.4M
Pipeline Value
Status Breakdown
Draft 42 38 Rated 65 Referred 12 Bound 84 Declined 6
Quick Actions
localhost:3001/quotes/new
Step 2 — Quote Creation Wizard (4 Steps)
New Quote
1
Applicant
2
Business
3
Coverage
4
Review

Applicant Information


localhost:3001/quotes
Step 3 — Quote List with Search, Filters, Context Menu
Quotes
247 total quotes
Quote #ApplicantLine of BusinessStatusPremiumRiskAgentCreated
QT-2026-0248Metro Construction CorpGeneral LiabilityDraftSarah Palmer2026-03-07
QT-2026-0247Pacific Freight HoldingsCommercial AutoRated$89,50082Mike Chen2026-03-06
QT-2026-0246Summit Tech SolutionsCyber Liability$42,00065Sarah Palmer2026-03-05
QT-2026-0245Riverdale Medical CenterGeneral LiabilityBound$52,00091Jane Wilson2026-03-04
QT-2026-0244Coastal Resort GroupBOPReferred$46,50038Mike Chen2026-03-03
Page 1 of 13
Features Used: 4-step creation wizard with client-side validation, real-time tRPC mutation, auto-assigned quote number (QT-2026-XXXX), status badges, search across name + quote number, context-sensitive dropdown menu (⋮), CSV export with custom columns, custom attributes.

Use Case 2

Quick Quote — Indication & Appetite Check

Sales Pages: /appetite, /indications, /indications/new Endpoints: appetiteCheck, indicationCreate, indicationConvert
MC
Mike Chen
New Business Producer — West Region

The Scenario

Mike is at a networking event and a restaurant owner asks about Workers' Comp coverage. Mike pulls up the appetite checker on his tablet to instantly verify eligibility, then creates a quick indication with an estimated premium range — all within 60 seconds.

localhost:3001/appetite
Appetite Checker — Real-time Eligibility
Appetite Checker

Check Eligibility

✓ STANDARD
Eligible

Matched rule: WC Restaurant Standard

Restaurants in TX with class code 9082 are within standard appetite guidelines. No restrictions.

localhost:3001/indications
Indications List — Quick Quotes with Premium Estimates
Indications
Quick premium estimates for prospects
18
Active Indications
7
Converted to Quote
38.9%
Conversion Rate
Indication #ApplicantLOBStateEst. PremiumConfidenceStatus
IND-2026-0019Bella's BistroWorkers CompTX$8,200 – $12,40085%Active
IND-2026-0018Downtown Salon LLCBOPCA$3,100 – $5,80072%
Features Used: Real-time appetite rule matching (preferred/standard/referred/declined), premium estimation with confidence scoring, 30-day auto-expiration, indication-to-quote conversion tracking, appetite rule management with effective/expiration dates.

Use Case 3

Multi-Version Quoting & Comparison

Versioning Pages: /quotes/[id], /quotes/[id]/versions, /quotes/[id]/gaps Endpoints: versionCreate, versionSelect, compareQuotes, coverageGapAnalyze
JW
Jane Wilson
Senior Underwriter — Commercial Lines

The Scenario

A large manufacturing client needs a General Liability quote. Jane creates three coverage alternatives — Standard, Enhanced, and Premium — so the agent can present options. She also runs a coverage gap analysis to identify missing protections.

localhost:3001/quotes/abc-123/versions
Version Management — Side-by-Side Alternatives
Quote Versions — Apex Manufacturing LLC
Version 1 — Standard
v1
$38,500
3 coverages • Risk Score: 78
✓ General Liability — $1M/$2M
✓ Products/Completed Ops
✓ Personal & Advertising
Version 2 — Enhanced
★ Recommended
$52,200
5 coverages • Risk Score: 85
✓ General Liability — $2M/$4M
✓ Products/Completed Ops
✓ Personal & Advertising
✓ Hired & Non-Owned Auto
✓ Employee Benefits Liability
Version 3 — Premium
v3
$78,900
7 coverages • Risk Score: 92
✓ General Liability — $5M/$10M
✓ Products/Completed Ops
✓ Personal & Advertising
✓ Hired & Non-Owned Auto
✓ Employee Benefits Liability
✓ Umbrella — $5M
✓ Cyber Liability — $1M
localhost:3001/quotes/abc-123/gaps
Coverage Gap Analysis — AI-Powered Recommendations
Coverage Gap Analysis
Critical+$8,200/yr est. impact
Missing: Cyber Liability Coverage

Manufacturing companies with 50+ employees and annual revenue above $5M should carry at minimum $1M cyber liability. Industry adoption rate: 72%.

Recommended+$3,400/yr est. impact
Inadequate Limit: General Liability

Current limit of $1M/$2M is below the industry median of $2M/$4M for manufacturers in this revenue class.

Informational
Industry Standard: Employment Practices Liability

48% of similar manufacturers carry EPLI. Consider if the client has 100+ employees.


Use Case 4

Underwriter Review, Referral & Collaboration

Underwriting Pages: /quotes/[id], /quotes/[id]/requirements, /quotes/[id]/comments, /clearance Endpoints: updateStatus, subjectivityCreate, commentCreate, clearanceCheck, scoreQuote
JW
Jane Wilson
Senior Underwriter — Commercial Lines

The Scenario

A high-value commercial property quote ($135K premium) from Metro Construction triggers a clearance alert — duplicate detection found a similar submission from last month. Jane reviews the clearance, checks subjectivities, scores the quote, and leaves comments for the agent before marking it as "referred" for management review.

localhost:3001/clearance
Clearance / Duplicate Detection
Clearance Queue
4
Flagged
12
Cleared
1
Blocked
QuoteConflicts WithMatch TypeConfidenceStatus
QT-2026-0248
Metro Construction Corp
QT-2026-0201
Metro Construction Co.
fuzzy_name 87% Flagged
localhost:3001/quotes/abc-123/requirements
Subjectivities / Binding Requirements Tracker
Binding Requirements
Pre-Bind (4)
Post-Bind (2)
Post-Issue (1)
✓ Satisfied Certificate of Insurance
Document • Required
In Progress Loss Runs (5 years)
Document • Required • Due: Mar 15
Open Site Inspection Report
Inspection • Required • Due: Mar 20
Waived Financial Statements
Financial • Recommended
⚠ Binding Gate: 2 of 3 required pre-bind subjectivities outstanding. Quote cannot be bound until resolved.
localhost:3001/quotes/abc-123/comments
Collaboration — Threaded Comments
Comments & Notes
Internal (3)
External (1)
JW
Jane Wilson underwriter 2 hours ago
Flagging this for senior review. Loss runs show 3 claims in the past 2 years — above our threshold for auto-bind. Recommending referral to management. @DavidKim please review.
DK
David Kim underwriter 30 min ago
Reviewed. Claims are all small property damage — no bodily injury. I'd approve at enhanced coverage level with a 10% rate load. Let the agent know.
SP
Sarah Palmer agent 15 min ago
Thanks for the quick turnaround! Client is aware of the rate load and still wants to proceed. I'll update the quote.

Use Case 5

Quote-to-Bind Orchestration

Critical Flow Pages: /quotes/[id]/bind, /quotes/[id]/financing Endpoints: bindQuote, financingGenerate, financingSelect
SP
Sarah Palmer
Commercial Lines Agent

The Scenario

Metro Construction accepts the Enhanced quote version ($52,200). Sarah selects quarterly payment and clicks "Bind." The system atomically creates a policy, billing account, billing cycles, the first invoice, and double-entry subledger entries — all in a single database transaction.

localhost:3001/quotes/abc-123/financing
Premium Financing Options
Payment Options — $52,200 Premium
Pay in Full
$52,200
1 payment • 0% interest
Save $1,566
Quarterly
Popular
$13,440/qtr
4 payments • 2.5% fee
Total: $53,760
IPFS 10-Month
$5,620/mo
25% down + 10 payments • 5.9% APR
Total: $56,200
localhost:3001/quotes/abc-123/bind
Bind Result — Cross-Module Orchestration

Quote Successfully Bound!

All resources created in a single atomic transaction

Quote
QT-2026-0248
Bound
Policy Created
POL-2026-0189
Effective today
Billing Account
BA-2026-0189
Quarterly billing
First Invoice
INV-2026-0412
$13,440 due
4 billing cycles created • Subledger entries posted (DR A/R, CR Unearned Premium)
Transactional Guarantee: The bind operation wraps Policy creation + Quote status update + Billing Account + Billing Cycles + Invoice generation + Subledger entries in a single PostgreSQL transaction. If any step fails, everything rolls back — no orphaned records.

Use Case 6

Renewal Quoting Workflow

Renewals Pages: /renewals, /quotes/[id]/market Endpoints: renewalCreate, renewalList, marketComparisonAdd, marketComparisonStats
LR
Lisa Rodriguez
Retention Specialist — Account Management

The Scenario

Lisa reviews the renewal queue 60 days before policy expirations. She identifies 2 high retention-risk accounts where premiums increased by 15%+, gathers market comparison quotes from competitors, and prepares renewal proposals with competitive positioning data.

localhost:3001/renewals
Renewal Queue with Retention Risk
Renewal Queue
8
Pending Renewals
2
High Retention Risk
+8.4%
Avg Premium Change
Policy #InsuredLOBPriorNewChangeRetention RiskEffective
POL-2025-0388Metro Construction CorpCommercial Property$118,000$135,700↗ +15.0%high2026-04-15
POL-2025-0390Summit Tech SolutionsCyber Liability$35,000$42,000↗ +20.0%high2026-04-15
POL-2025-0412Pacific Freight HoldingsCommercial Auto$82,000$89,500↗ +9.1%low2026-04-01
POL-2025-0401Apex Manufacturing LLCWorkers Comp$58,000$55,100↘ -5.0%low2026-04-01
POL-2025-0415Riverdale Medical CenterGeneral Liability$52,000$52,000— 0.0%low2026-05-01
localhost:3001/quotes/abc-123/market
Market Comparison — Competitive Positioning
Market Comparison — Metro Construction
CarrierPremiumvs. OursPositionSource
PNC (Our Quote)$135,700baseline
Hartford$142,500+5.0%lowerManual
Travelers$131,200-3.3%higherComparative Rater
CNA$138,900+2.4%competitiveManual

Use Case 7

Proposal Delivery & Follow-up Tracking

Sales Pages: /proposals, /followups Endpoints: proposalCreate, proposalSend, proposalRecordView, followupCreateSequence
SP
Sarah Palmer
Commercial Lines Agent

The Scenario

Sarah generates a branded proposal PDF with coverage summary, premium breakdown, and a personalized cover letter. She sends it via a trackable share link, sets up an automated follow-up sequence, and monitors when the client views/accepts the proposal.

localhost:3001/proposals
Proposal Tracking Dashboard
Proposals
12
Total Sent
8
Viewed
5
Accepted
41.7%
Accept Rate
ProposalRecipientQuoteStatusViewsSentExpires
GL Coverage — Metro ConstructionTom Metro
tom@metroconstruction.com
QT-2026-0248Viewed3Mar 5Apr 4
Cyber Policy — Summit TechAnna Lee
anna@summittech.com
QT-2026-0246Accepted5Mar 2Apr 1
localhost:3001/followups
Automated Follow-up Sequences
Follow-up Sequences
14
Pending
38
Sent
6
Cancelled
QT-2026-0248 — Metro Construction
3-step sequence
Day 3
Email sent
2
Day 7
Pending (tomorrow)
3
Day 14
Scheduled

Use Case 8

Embedded Partner Quoting SDK

Distribution Pages: /embedded Endpoints: embeddedConfigCreate, embeddedSessionCreate, embeddedPartnerStats
AT
Alex Torres
Distribution Manager — Partnerships

The Scenario

Alex onboards a new fintech partner (LoanPro) that wants to offer insurance quotes within their lending platform. Alex configures allowed domains, products, branding, and API rate limits. LoanPro embeds the quoting widget — every session is tracked with referrer URL, completion status, and revenue attribution.

localhost:3001/embedded
Embedded SDK Partner Management
Embedded Quoting Partners
LoanPro Financial
Active
Partner ID: loanpro-financial
142
Quotes Generated
23
Quotes Bound
$284K
Revenue
Domains: loanpro.com, app.loanpro.com • Rate limit: 60/min
RealEstate Hub
Active
Partner ID: realestate-hub
87
Quotes Generated
12
Quotes Bound
$156K
Revenue
Domains: realestatehub.io • Rate limit: 30/min

Use Case 9

Bulk Schedule Import (SOV / Fleet)

Data Import Pages: /quotes/[id]/import, /quotes/[id]/acord Endpoints: importCreate, bulkCreateItems, acordFormCreate, acordFormExtract
KM
Karen Mitchell
Account Manager — Large Commercial

The Scenario

Karen is quoting a commercial property policy for a 50-location retail chain. Instead of entering each location manually, she uploads a CSV Statement of Values (SOV) with all property details. The system validates each row, maps columns, and creates schedule items. She also uploads an inbound ACORD 140 Property form for data extraction.

localhost:3001/quotes/abc-123/import
Bulk Import — SOV Upload & Validation
Schedule of Values Import
📂
retail-chain-locations-2026.csv
50 rows • 12 columns • 24 KB
✓ 47 valid ⚠ 2 warnings ✗ 1 error
#AddressCityStateTIVPremiumStatus
11200 Main StDallasTX$2,400,000$4,800Valid
2450 Oak AveHoustonTX$1,800,000$3,600Valid
3789 Beach RdGalvestonTX$3,200,000$8,400Warning Flood zone
4AustinTXError Missing address, TIV
Total TIV: $84,600,000 • Est. Premium: $169,200
localhost:3001/quotes/abc-123/acord
ACORD Form Management — 9 Supported Forms
ACORD Forms
Inbound (2)
Outbound (1)
ACORD 140 — Property Application Extracted
Confidence: 92%
Uploaded Mar 5, 2026 • 18 fields extracted • 1 validation warning
ACORD 125 — Commercial Application Generated
Sent to Hartford
Generated Mar 6, 2026 • Sent Mar 6 • 24 fields populated

Use Case 10

Producer Performance & Pipeline Analytics

Analytics Pages: /producers, /pipeline, /commissions Endpoints: producerLeaderboard, producerMetricsHistory, analytics, priorityQueue
RD
Robert Davis
VP of Commercial Lines

The Scenario

Robert reviews the monthly producer leaderboard to identify top performers and those needing coaching. He examines the pipeline Kanban board to spot bottlenecks, checks conversion analytics by line of business, and uses AI scoring to prioritize hot leads.

localhost:3001/producers
Producer Leaderboard
Producer Performance — March 2026
RankProducerQuotesBoundClose RatioTotal PremiumAvg PremiumAvg Days to Bind
🥇 Sarah Palmer 4218 42.9% $824,000$45,778 12.3
🥈 Mike Chen 3814 36.8% $672,000$48,000 14.7
🥉 Jane Wilson 2811 39.3% $583,000$53,000 9.8
4 Lisa Rodriguez 226 27.3% $318,000$53,000 18.2
localhost:3001/pipeline
Pipeline Kanban Board
Quote Pipeline

Draft (12)

Metro Construction
GL • Est. $52K
Oak Valley Farms
BOP • Est. $18K
Blue Ocean Tech
Cyber • Est. $35K

Submitted (8)

Summit Tech
Cyber • $42K
Harbor Marine
Property • $78K

Rated (15)

Pacific Freight
Auto • $89.5K
Greenfield Academy
WC • $24.7K
Apex Mfg
GL • $55K

Referred (3)

Coastal Resort
BOP • $46.5K

Bound (24)

Riverdale Medical
GL • $52K
Atlas Logistics
Auto • $67K
AI Scoring: Every active quote receives a composite score based on 5 dimensions — Bindability (coverage completeness, pricing competitiveness), Urgency (days until expiration, follow-up activity), Value (premium amount, LOB profitability), Fit (appetite match, class code risk), and Engagement (proposal views, comment activity). Hot/Warm/Cold categorization drives the priority queue.