Skip to content
Policy-bank intake cleaning

Dirty intake in.
Bank-clean records out.

Unifyr watches every carrier file dropped into Drive, cleans it against a million-policy bank, matches agents to NPNs, and hands reviewers a ready-to-approve queue.

~1M policy bank20,000+ rows / importLive pipeline status
unifyr.app/dashboard/files
Live

March intake

Watched Drive folder · 4 files

Watching
New file detected · queuing for intake cleaning

Prudential_Mar2026.xlsx

4,218 rows

2m ago

Lincoln_Intake.csv

12,840 rows

5m ago

Nationwide_Weekly.xlsx

892 rows

11m ago

Allianz_QTD.xlsx

3,109 rows

1h ago

Product walkthrough

Four phases, one durable workflow

01 — Intake

Drive is the front door

Per-section watched folders are polled on a schedule. New carrier files land as discovered — start processing when you are ready.

unifyr.app/dashboard/files
Live

March intake

Watched Drive folder · 4 files

Watching
New file detected · queuing for intake cleaning

Prudential_Mar2026.xlsx

4,218 rows

2m ago

Lincoln_Intake.csv

12,840 rows

5m ago

Nationwide_Weekly.xlsx

892 rows

11m ago

Allianz_QTD.xlsx

3,109 rows

1h ago

02 — Clean & match

Cleaned against the policy bank

Within-file dupes collapse, the intake date gate trims out-of-range rows, and every agent matches to an NPN through the writing index and fuzzy passes.

unifyr.app/dashboard/files
Live

Lincoln_Commissions.csv

12,840 rows · dedupe vs policy bank

Processing

Parse

12s

Clean

8s

NPN

31s

Dedupe

running

Review

NPN assigned · 12,712 of 12,840 (99.0%)

Checking against 974,221 policies in the bank…

03 — Review

Approve with confidence

Cross-import and policy-bank duplicate flags surface before commit. Bulk-approve clean rows the moment conflicts clear. Every decision is logged.

unifyr.app/dashboard/files
Live

Pending review

4,218 rows · 2 flagged

AgentPolicyPremiumFlag
A-10482PL-992014$1,240.00
A-88201PL-441902$890.50dup
A-33109PL-771023$2,100.00
A-50442PL-118821$3,470.25hold

What's in the box

Built around the policy bank

Policy bank backbone

Every intake row is checked against a versioned snapshot of your full policy bank — agent + policy + premium matches, with smart product-type rules.

Active snapshot974,221

3-key

remove

2-key

$0.01

1-key

missing #

Live pipeline status

Clean, NPN, and dedupe stages stream to the dashboard in real time. No refresh.

parsecleanNPNdedupereview

Drive-first intake

Watch a Drive folder per section. Poll discovers new carrier files — they stay discovered until you start processing.

March intake
4
Q1 statements
12
Renewals
7

NPN matching

Writing index, reference table, fuzzy name passes — unmatched agents flagged for review instead of silently dropped.

Review queues + audit trail

Review queues with role-based access. Every approval and duplicate decision is logged.

Smart dedupe

Within-file, policy-bank, and cross-import flags — three passes, every commit.

PL-992014$1,240
PL-441902$890.50dup
PL-771023$2,100

Workflow

One pipeline, end to end

Every file follows the same durable workflow — from first parse to final approval against your policy bank, with live status the entire way.

  1. 01

    Intake

    Drive poll discovers new carrier files by section — start processing when ready.

  2. 02

    Parse

    Multi-carrier spreadsheets queue on the default parser. Column layout normalized per row.

  3. 03

    Clean

    Intake date gate trims out-of-range rows; within-file duplicates collapse.

  4. 04

    NPN

    Agents matched to NPNs via writing index, reference, and fuzzy passes.

  5. 05

    Dedupe

    Rows checked against the policy bank and prior imports — conflicts flagged.

  6. 06

    Review

    Reviewers approve clean rows; approved policies land in the policy bank.

Stop hand-cleaning carrier intake

Connect your Drive folders, configure intake sections, and let Unifyr clean every carrier file against your policy bank.