Skip to content
CommissionSight Docs

Email statement ingestion

Email ingestion lets a carrier (or your team) email a statement to a unique address and have it ingested automatically — no logging in, no manual upload. Unlike a shared drop folder, the address itself identifies the carrier, so there’s no filename guessing about who a file is from.

Available on request (gated by the Email statement ingestion entitlement). Set it up in the app on the Files page, under Email ingestion.

How it works

  1. Add an address per carrier. On the Files page, pick a carrier and we mint a unique inbound address like stmt-a1b2c3@inbound.commissionsight.com.
  2. Send statements there. Forward the carrier’s statement email to that address, or ask the carrier to send it there directly. Only .csv, .xlsx, and .xls attachments are ingested.
  3. We ingest it automatically. The attachment is landed and scored exactly like an upload — same mapping, member scoring, deltas, and owed. A statement is never ingested twice (deduped by message and content).

Getting the period right

The address identifies the carrier; the statement period is read from the attachment filename when you give the address a rule — a regex with named year/month groups (the same mechanism SFTP uses), e.g. (?<year>\d{4})-(?<month>\d{2}). If the period can’t be determined it’s held for review rather than guessed — you set the period and ingest it in one step, like a manual upload.

Keeping it secure

  • Only signed webhooks are processed. Inbound mail arrives via Resend’s signed webhook; an unsigned or tampered request is rejected.
  • Sender allowlist (optional). Restrict an address to accept mail only from the carrier’s domain (e.g. carrier.com) to shut out spoofed senders.
  • Opaque addresses. The address is a random token — it reveals nothing and can be rotated (remove it and add a new one) at any time.

Managing addresses

Each address can be paused (stop accepting mail without deleting it) or removed. Recent inbound emails — sender, subject, attachment, and status (ingested / held / rejected) — show next to the address so you can confirm delivery. Your operator can also set these up for you.