Volume Volume Book Demo Contact Us

Case study

Automated Commission Reconciliation for a Broker Network

6,500 transaction lines a week, reconciled without the manual work

Tuto Money manages a network of 75 financial services brokers

It runs its commission cycle on Volume, from taking in each provider's statement in its own format to matching every deal, calculating broker commission, publishing broker statements and paying brokers. Before Volume, around 6,500 transaction lines a week were reconciled by hand.

Customer

Tuto Money, which manages a network of 75 financial services brokers

Industry

Financial Services

Outcome

6,500 transaction lines a week reconciled automatically, across a network of 75 brokers

The challenge

Growth would only mean more manual work

Tuto Money was manually processing around 6,500 transaction lines a week, across providers that each used different formats, payment structures and commission models. Scaling would have meant more people and more risk

Reconciling statements icon

Reconciling provider statements in different formats against internal deal records.

Interpreting statements icon

Interpreting statements by hand to work out what had been paid and why.

Commission icon

Calculating broker commission across providers with different fee structures.

Staged payments icon

Handling staged, partial or adjusted payments over the life of a deal.

Broker statements built, checked and sent by hand, broker by broker.

Reconciliation status icon

No real-time view of reconciliation status or outstanding balances.

What we built

One commission cycle, from statement to payment

Volume built the cycle from two Blueprints, Commission Reconciliation in two stages and then Payment Reconciliation, linked by Workflows, so every transaction can be traced from the provider statement to the broker's payment

1

Commission Reconciliation: Match

Every provider statement taken in, every deal matched.

Statements are taken in exactly as each provider issues them, and every line is matched to the deal it belongs to.

1

Statements uploaded

Each provider's statement is uploaded as issued, including workbooks with several tabs, with no reformatting.

2

Each provider's layout recognised

Import profiles map each provider's columns to the right fields, so every line is read the same way, whatever the format.

3

Matched to deal level

Every line is cross-referenced against Tuto's deal records and classified as matched, short-paid, over-paid or missing.

4

Variances visible straight away

Discrepancies show up immediately, filtered by broker, provider, status or amount, ready for the team to review.

2

Commission Reconciliation: Calculate & Distribute

Commission calculated in real time, and statements published to every broker.

Each broker's commission is calculated from the matched deals using a standard process for every provider, then turned into a statement and published.

1

Commission calculated

Each broker's formula and each provider's rate are applied to every matched deal, in real time.

2

Statements generated

A statement is generated for every broker from the same data, so the figures always agree.

3

Published to the broker portal

Each broker sees their statement in their own portal, and is told when it's ready.

4

A live view for the team

Totals, variances and outstanding balances across the network are always current.

3

Payment Reconciliation

Provider payments reconciled, and brokers paid accurately.

Money received from providers is matched to the commission expected, including staged, partial and adjusted payments, before brokers are paid.

1

Payment received

Each provider payment is tracked as it lands, against the commission expected for each deal.

2

Matched to what was expected

Payments are reconciled to deal level, with staged, partial and adjusted payments tracked over the life of each deal.

3

Shortfalls followed up

Anything short or missing stays visible as an outstanding balance until it's resolved.

4

Brokers paid

A network statement shows the fees retained, and payment instructions go to the accounts team, so brokers are paid accurately.

The results

Scaled across providers without adding headcount

Reconciling statements icon

Broker payments scaled without adding headcount.

Interpreting statements icon

No more manual interpretation of provider statements.

Commission icon

Accurate broker commission, with fewer disputes.

Broker statements generated and published from one dataset.

Full audit trail from reconciliation to settlement.

Reconciliation status icon

Real-time visibility of the financial position.

Staged payments icon

A scalable foundation for adding providers and volume.

6,500 statement lines a week reconciled automatically.

Speech bubble

“Before Volume, we were manually processing thousands of transactions every week across multiple providers, all in different formats. It was unsustainable and we knew scaling would only make it worse. Volume built us a reconciliation framework that just runs. Payments go out accurately, commissions are calculated in real time, and we finally have full visibility of where everything sits. It's taken a huge operational burden off the team.”

Kim Bascombe

Managing Director, Tuto Money

Explore further

See the Blueprints behind this story

Tuto Money's solution was built from two Blueprints