Everything you need to trust the number.
Pineapple Split is not a spreadsheet with a coat of paint. It is a reconciliation engine that understands how commissions actually work.
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 every line and the document totals without a template.
- PDF table extraction
- Excel banner and total rows
- CSV with comments
- Currency and dates normalized
Ten checks, every line
Each commission line is reconciled against expected rates and prior periods. Findings come back ranked by severity with the expected value, the actual value, and a plain-English reason.
- Underpaid and rate mismatches
- FMV cap exceeded
- New / renewal miscode
- Duplicate and phantom chargebacks
- Missing commissions across periods
- Header total mismatches
Medicare math, built in
Medicare Advantage and PDP fair-market-value amounts are seeded by plan year and state, including the cap. Percentage-of-premium products like Med Supp and life are checked against per-carrier rates set up for your account.
- MA and PDP FMV by year and state
- Renewal handled correctly
- Per-carrier rate overrides
- Verify-before-production values
Pay the whole hierarchy right
Walk each commission 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 ready for 1099 prep.
- Arbitrary-depth hierarchies
- Splits or flat overrides
- Chargebacks to the right agent
- 1099-ready payout export
Exports you can hand to anyone
Exception 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 credentials stored, ever