Commission tracking software that reconciles every payment

CommissionsIQ brings every upfront and trail commission payment into one view and reconciles it against what your aggregator statements say you were due.

The problem with commission statements

Commission arrives as aggregated statements, not verifiable calculations. A broker with a few hundred loans receives thousands of line items a year, across lenders that calculate differently and statements that arrive in different shapes.

Rates are broadly standardised; calculation methods aren't — and the gap between the two is where money goes missing. A payment that's a few per cent light looks exactly like a correct one, and a payment that stops leaves nothing behind to check.

CommissionsIQ · Total CommissionSample data
⌂ Management View$ Broker View
◔ Portfolio
% Total Commission
△ Variance
✦ Brokers Performance

Total Commission

Monitor upfront and trail commissions with AI-powered projections

Commission Income (YTD)
$1.37M
↗ +8.4% growth
Upfront Commission YTD
$1,023,427
↗ +6.1% YTD
Avg Monthly Trail
$28,489
↗ +2.3% growth
GrowingAnnualized Commission
$963.97K
↗ Projected

Upfront vs Trail Commission

Monthly, current financial year

$160K$120K$80K$40K$0
Upfront CommissionTrail Commission
The Total Commission view: upfront and trail side by side, with AI-powered annualised projections.

How it helps

Every payment in one place

Upfront and trail, across your lenders, consolidated from the statements you upload — one view instead of a folder of files.

Reconciled against your statements

Each payment is automatically compared against what your aggregator statements say you were due, per loan, so differences stand out instead of hiding in the noise.

Absences flagged, not just errors

Missing and stopped payments are detected automatically — as are stepped-trail increases that never applied. The errors that leave no row behind are the ones this catches.

A record you can retrieve

A reconciled commission history: what your statements showed, what arrived, and what differed — retrievable when you need to query a payment.

Why this is unreasonable to do by hand

Reconciling one statement is easy. Reconciling every statement, across lenders, against last month and the month before — while noticing what didn't arrive — is a volume problem, and volume problems don't care how careful you are. A missing $80 trail payment is invisible inside a deposit that varies anyway, and it stays invisible every month after.

Detection is the hard part, and it's what software is for. Investigation is yours — you know the client, the deal and the lender relationship.

Related reading

Common questions

How does CommissionsIQ know what I was due?
The expected figure comes from your own aggregator statements. CommissionsIQ doesn't hold lender rate cards — it reconciles what your statements say you were due against what was actually paid, per loan. That keeps the comparison grounded in documents you can verify yourself.
Does it work with my aggregator's statements?
Yes. You upload the commission statements you already receive as Excel or CSV files. The first import of a new format is mapped once and the mapping is saved, so repeat imports of the same format are straightforward. See data imports for the detail.
Does it tell me why a payment is different?
No — and that's deliberate. CommissionsIQ detects and notifies; it doesn't guess at the reason. You get the context to investigate — which loan, which lender, what changed, and when — and you're better placed than any algorithm to work out why, because you know the client and the deal. That follow-up is often a client re-engagement opportunity in itself.
What if a payment stops entirely?
Stopped payments are the hardest error to spot by hand, because an absence leaves no row to check. CommissionsIQ flags missing and stopped payments, and missed stepped-trail increases, automatically.
How is this different from what my aggregator already sends me?
Your statements tell you what happened in one period, one document at a time. CommissionsIQ brings every statement into one place, reconciles each payment against what the statements say you were due, and keeps watching across periods — which is how gaps, stops and variances become visible.

See it on your own book

14-day free trial. No credit card required.