Everything you need to trust the number.
Check carrier payments against supplied rates, investigate the exceptions, and keep a record of what came back. For independent P&C, Medicare, health, and life agencies.
Reads the format you actually got
Carriers send CSV, Excel, and PDF, each with different column names, merged header rows, negative chargebacks, and odd date formats. Pineapple Split extracts commission data from supported layouts. New layouts need mapping review; scanned PDFs and some formats need additional work. Upload the file or forward it to your private address.
- PDF tables and text layouts
- Excel banner and total rows
- Private email-in address
- Currency and dates normalized
A dozen checks, every line
Each commission line is reconciled against your expected rates and prior periods. Findings come back ranked by severity with the expected value, the actual value, and a plain-English reason.
- Underpaid vs contract rate
- One policy, two different rates
- Rate differs from similar lines
- Duplicate and phantom chargebacks
- Missing and aging commissions
- Statement totals that do not add up
- New / renewal miscode
- CMS cap exceeded
Your contract rates and the CMS tables
P&C carriers pay a percentage of premium set by your contract, so each auto, home, umbrella, commercial, or workers comp line checks against the commission schedule you keep per carrier and line of business. Lines that show up on a statement with no rate on file are surfaced so you can add the missing rates. Medicare Advantage and PDP have reference checks by year and state, but the current CMS seed is unverified. Verify it against current CMS documentation before relying on it. Med Supp, health, and life use per-carrier rates.
- Per-carrier, per-line commission schedule
- Gaps surfaced from real statements
- MA and PDP FMV by year and state
- Renewal handled correctly
From finding to recovered dollars
Review a potential shortfall against your carrier records and contract, then create a recovery case. Track carrier follow-up and link incremental receipts your agency confirms it received. Confirmed recoveries are net of reversals; Pineapple does not verify bank deposits or contact carriers for you.
- Reviewed recovery cases
- Agency-confirmed receipt allocations
- Write-offs with a reason
- Retained evidence and decision history
Pay the whole hierarchy right
If commissions flow through you to producers or downline agencies, walk each one up the chain, apply split percentages or flat overrides at every level, subtract chargebacks from the responsible agent, and export a per-agent payout statement for your accounting review.
- Arbitrary-depth hierarchies
- Splits or flat overrides
- Chargebacks to the right agent
- Per-agent payout export
Exports you can hand to anyone
Finding reports and payout statements export to CSV and a clean PDF. Every figure traces to the original row, so a dispute with a carrier or a conversation with an agent is backed by source data.
- CSV + PDF exports
- Full provenance on every line
- Files you upload only
- No carrier credentials stored