Validates insurance quotes against state DOI rate filings for base rates, discounts, and surcharges. Flags regulatory violations with approval references and validation details.

How it works 22 steps

Inspect the data fetches, transforms, gates, and output this recipe runs.

Data fetch

▼ deal ?

▼

Process (21 steps)

⚠ guard_missing_deal guard

Stop if deal result properties is missing

■ extract_quote_data pick

Keep only specific fields from

■ normalized_applied_discounts coalesce

Use the first available value from: extract quote data applied discounts,

■ normalized_applied_surcharges coalesce

Use the first available value from: extract quote data applied surcharges,

■ total_premium_invalid any

Check if any of the conditions are true

■ skip_expected_total_premium any

Check if any of the conditions are true

■ expected_total_premium math

Calculate: {{step.extract_quote_data.base_rate}} - {{step.extract_quote_data.discount_total}} + {{step.extract_quote_data.surcharge_total}}

skip: step.skip_expected_total_premium equal true

■ skip_total_premium_variance_abs any

Check if any of the conditions are true

■ total_premium_variance_abs math

Calculate: abs({{step.extract_quote_data.total_premium}} - {{step.expected_total_premium}})

skip: step.skip_total_premium_variance_abs equal true

■ skip_total_premium_variance_pct any

Check if any of the conditions are true

■ total_premium_variance_pct math

Calculate: ({{step.total_premium_variance_abs}} / {{step.expected_total_premium}}) * 100

skip: step.skip_total_premium_variance_pct equal true

■ state_or_policy_missing any

Check if any of the conditions are true

■ lookup_rate_filing pick

Keep only specific fields from

skip: step.state_or_policy_missing equal true

■ approved_discount_names pluck

Extract name from each item

skip: step.lookup_rate_filing is_null

■ approved_surcharge_names pluck

Extract name from each item

skip: step.lookup_rate_filing is_null

■ base_rate_variance_pct math

Calculate: (abs({{step.extract_quote_data.base_rate}} - {{step.lookup_rate_filing.base_rate}}) / {{step.lookup_rate_filing.base_rate}}) * 100

skip: step.lookup_rate_filing is_null

■ unapproved_discounts filter

Filter by condition

skip: step.lookup_rate_filing is_null

■ unapproved_surcharges filter

Filter by condition

skip: step.lookup_rate_filing is_null

■ unapproved_discounts_list join

Join items with ", "

skip: step.unapproved_discounts is_empty

■ unapproved_surcharges_list join

Join items with ", "

skip: step.unapproved_surcharges is_empty

■ compliance_checklist to_checklist

Format results as an actionable checklist

Settings 3 configurable

Configurable at install. Defaults shown — change them anytime in Recued.

hubspot setting =

tolerance pct number = 0.01

state rate filings text = [object Object]