Ingestion and book of business
The flagship is real carrier SFTP integration. Connect a carrier’s SFTP credentials once, and a scheduled worker downloads each book-of-business and commission file, normalizes the columns, matches every row to an agent by NPN, and loads the result into live book of business reporting.
New or changed carrier layouts are handled with AI-assisted column mapping, and every load is deduped so re-runs never double-count. The book stays current on schedule, without anyone pasting a spreadsheet.
- ✓ Scheduled SFTP pulls per carrier, mapped and normalized
- ✓ Rows matched to the writing agent by NPN
- ✓ Deduped loads so re-running a file is always safe
Hierarchy, reporting, and rollups
AgencyGrid’s insurance agency hierarchy software models your downline as a living structure. Every policy, premium, and commission rolls up each level of the hierarchy automatically, so a writing agent sees their own book, a manager sees their team, and the agency sees everything.
Because reporting runs off the same ingested data as everything else, the numbers agree across every view, with no reconciling one report against another by hand.
Commissions, overrides, and reconciliation
On top of the book, AgencyGrid’s commission tracking software computes expected pay for every policy from your comp grid, reconciles it against what the carrier actually paid, and flags underpaid, missing, and charged-back lines. Differential overrides are computed per level and cascaded up the hierarchy, and both 1099 and LOA agents settle into exportable payout sheets.
- ✓ Expected-vs-actual reconciliation on the full book
- ✓ Differential overrides cascaded up every level
- ✓ 1099 and LOA settlement into exportable payout sheets
Contracting, licensing, and compliance
Beyond the money, AgencyGrid tracks the operational side of running an agency: carrier contracting and licensing status, NPN matching, and a ticketing surface for compliance work. Impersonation and PHI access are recorded in an append-only audit log, so who saw what is never in question.