INSURANCE · PARTNER DATA INTAKE AGENT

Partner files in any shape. One clean model.

The agent reads every partner's bordereaux, however it arrives, maps it to your canonical model and lands it in your warehouse. People confirm anything it isn't sure of.

Run the agentAbout 90 seconds · simulated on sample data
Any partner file → one canonical model
THE BUSINESS PROBLEM

Sound familiar? Watch the agent take a real-looking partner file from mess to warehouse.

The Partner Data Intake agent reads insurance bordereaux from any partner, maps each column to your canonical model with a confidence score, sends uncertain fields to a reviewer, remembers every approved mapping, and loads clean data into your warehouse.

Every month, a dozen partners send the same data a dozen ways. Your analysts re-key it by hand.

Delegated partners report premium and claims on the business they write for you. Each one uses its own spreadsheet. Before anyone can analyse it, someone has to find the right rows, match every column to your model, and check nothing moved since last month. It takes days, and the data rarely leaves Excel.

Why it's hard
  1. No two partners alike

    Different headers, tab layouts and formats for the same fields. Header rows sit anywhere.

  2. It drifts every month

    Columns get renamed, added or dropped without notice, and nobody tells you which.

  3. Lines of business mixed

    Several lines in one workbook, sometimes on one tab, each needing its own mapping.

  4. Every number is audited

    Finance, regulators and reinsurers need to trace each figure back to the partner's file.

TRY IT

Be the analyst for 90 seconds.

Hand the agent a messy partner file, map the three columns it won’t guess at, then watch next month’s renamed file go straight through.

HOW IT WORKS

Complex documents, read the way an expert would. People decide what matters.

  • Document understandingFinds header rows, tabs and lines of business in any workbook layout, including merged cells and stray notes.
  • Partner memoryLearns each partner's mappings once and reuses them, so repeat files are mostly automatic.
  • Drift detectionCompares every file with the partner's history and flags renamed, new and missing columns.
  • Human in the loopAnything uncertain goes to a reviewer. Nothing commits until a person confirms it.
  • Quality gate and audit trailRules run before the warehouse, and every value traces back to its cell in the original file.
Built onMicrosoft GraphAzure Blob StorageAzure SQLMicrosoft FabricEntra IDClaude

See it on your partners' files.

BOOK A LIVE DEMO
UNDER THE HOOD

Built on a contract, not a one-off script.

This agent is registered like every agent we build: a name, an owner, the knowledge it reasons from and the modes it runs in. That is what lets the next agent work with it instead of becoming another silo.

See its registry entry →
id:partner-intake-agentmodes:scheduled · interactiveknowledge:bordereaux_schema · dq_rules · partner_profiles