Reconciles

Commission reconciliation software for agencies and brokers

Reconciles is commission reconciliation software for agencies, brokers and resellers that get paid by statement. You export the commission statement from a carrier, supplier or partner, upload it with your bank statement, and Reconciles matches each deposit to the statement lines it paid, then lists every line that was paid short, paid twice or never paid. Plans are published from $888 a year, and you see matched pairs from your own files before you create an account.

Why commission statements never agree with the bank

An insurance agency, a travel seller or a telecom retailer rarely gets one clean payment per sale. A carrier sends a statement listing hundreds of policies, then wires a single amount that already has chargebacks, adjustments and prior month corrections netted into it. The statement, the agency system and the bank each tell a slightly different story.

  • One deposit covers many policies, and sometimes many statements.
  • Chargebacks and cancellations are netted against new business, so the total hides the loss.
  • Carriers pay late, split a statement over two deposits or pay a month behind.
  • Commission rates on the statement differ from the rate you expected, and nobody notices.
  • Some statements arrive and the money never does, or the money arrives with no statement.

Checking this by hand means a spreadsheet per carrier per month. Most agencies sample a few lines, which is where unpaid commission goes unclaimed.

How to reconcile commission statements with Reconciles, step by step

  1. 01 Export the commission statement

    Download the statement from the carrier portal or your agency management system as CSV or XLSX. Any file that shows a policy or reference number, the commission amount and the statement date works. Download the bank statement for the same period in CSV, OFX, QFX, MT940 or CAMT.053.

  2. 02 Upload both files

    Drop the bank statement in the first slot and the commission statement in the second. Reconciles reads columns by content, so you do not map a template.

  3. 03 Review matches and exceptions

    Each deposit is matched to the statement lines it paid, including one deposit to many lines. Missing deposits, short pays and duplicate payments go to the exceptions queue with the exact difference shown.

  4. 04 Check against what you expected

    Upload your expected commission as the second file instead, from your agency system or a spreadsheet, and Reconciles matches by reference and amount and lists the lines where the carrier paid less than you earned.

  5. 05 Export the report

    Download the reconciliation as XLSX or PDF to attach to the month end close, or send the short pay list to the carrier.

Who uses commission reconciliation software

  • Independent insurance agencies reconciling carrier commission statements to deposits and to policies written.
  • Travel sellers and tour operators matching supplier and agent commissions to payments.
  • Telecom and mobile retailers matching carrier commission and chargeback statements.
  • Software and hardware resellers paid referral or channel commissions by several vendors.
  • Accounting firms that run the commission books for these clients and need one repeatable close step.

What the matching catches

  • Short pays, where the paid commission is lower than the statement or lower than your expected amount.
  • Missing payments, where a statement line has no deposit behind it.
  • Unexplained deposits, where money arrived with no matching statement.
  • Duplicate payments and double counted lines.
  • Timing differences, where a statement is paid the following month.

Every match shows its reason and a confidence score, so a reviewer can accept it in a click or open the exception.

Reconciles compared with commission tracking tools

Sales compensation platforms such as CaptivateIQ and Performio calculate what you owe your own sales reps. Agency management systems record policies and expected commission. Neither is built to prove that the cash that reached your bank equals what a carrier statement says. Reconciles does that one job, and it sits next to your agency system rather than replacing it.

NeedAgency management systemSales commission platformReconciles
Record policies and expected commission Yes Partly No
Pay your own reps or producers Some Yes No
Match carrier statements to bank deposits Limited No Yes
Flag short pays and missing payments Limited No Yes
Published price Varies Usually quote $888 to $5,988 a year

If you need to calculate producer splits, keep your commission platform. If you need to prove the money arrived, add Reconciles.

A carrier deposit, line by line

Say $18,420 lands in the agency bank account on the 12th. The carrier statement lists 61 policies. Their gross commission is $19,160, with $740 of chargebacks netted against it. Reconciles adds the lines, confirms they equal the deposit and marks the match as one deposit to many lines. If your expected commission file says you earned $19,600, the $440 gap appears as a short pay on the specific policies where the carrier used a lower rate.

Plans for agencies of every size

Starter is $888 a year billed yearly for 3,000 matched transactions a month, enough for most single agencies. Growth is $2,388 a year for 20,000 a month across 5 entities, for agency groups and accounting firms. Scale is $5,988 a year for 100,000 a month across 25 entities. See the pricing page, and if the underlying job is matching a bank file to a ledger, read about bank reconciliation software and payment reconciliation software.

Commission reconciliation questions

Check last month's commission against the bank

Upload a bank statement and a commission statement. You will see which deposits matched and which lines were paid short before you create an account.