Lender Remittance Processing: A Guide for Mortgage Brokerages
by Sandlabs Team, Founder, Sandlabs
How Commission Money Flows in the Mortgage Industry
Before we talk about processing, it helps to understand how commission money actually moves through the system.
When a broker settles a loan, the lender (CBA, Westpac, NAB, ANZ, Macquarie, etc.) pays a commission. This commission does not go directly to the broker. Instead, it flows through the aggregator — the network the broker belongs to.
The flow looks like this:
Lender → pays commission to → Aggregator → pays commission to → Brokerage → pays commission to → Individual Broker
The aggregator takes their cut and passes the remainder to the brokerage as a "remittance" — a statement showing which commissions were earned, on which loans, and how much is being paid. The brokerage then calculates individual broker splits and pays each broker their share.
This happens for both upfront commissions (a one-time payment when the loan settles) and trail commissions (ongoing monthly payments for the life of the loan, typically 0.15-0.20% of the outstanding loan balance per year). Keeping that trail book accurate over the life of every loan is its own challenge — TrailAI reads aggregator statements and surfaces book balance, missing commissions, and refinance candidates in minutes.
The Remittance File Problem
Every aggregator delivers remittance data in their own format. There is no industry standard. This is the single biggest operational headache for brokerage finance teams.
Here is what we have seen across the 24+ aggregators our commission platform supports:
AFG (Australian Finance Group)
AFG provides structured CSV exports through their broker portal. Their reports are generally well-formatted, but the column structure differs between upfront and trail reports. Trail reports include historical loan identifiers that need to be matched against your internal loan database. AFG also provides volume bonuses as separate line items that need to be allocated across brokers based on their contribution to overall volume.
LMG (Loan Market Group)
LMG — which includes Loan Market, PLAN Australia, and Choice brands — has a centralised reporting system. The data is structured but includes sub-aggregator-level detail that needs filtering. If your brokerage operates under LMG, you will receive remittance that includes data for other brokerages in the group, and you need to extract only your records.
Connective
Connective provides commission data through their Mercury platform. Reports can be downloaded as Excel files or PDFs. The format has changed several times over the years, which means any automation needs to handle multiple format versions. Connective also splits commissions across different payment types (upfront, trail, bonus) in separate report sections.
Finsure
Finsure delivers commission statements that combine upfront and trail commissions in the same document. The challenge is reliably separating these two types since they have different processing rules — upfront commissions are typically one-off and tied to a settlement date, while trail commissions recur monthly and need to be tracked over the life of each loan.
Vow Financial (YBR Aggregation)
Since Vow Financial became part of YBR Aggregation, their reporting has gone through transitions. The remittance format includes both residential and commercial loan commissions, and the categorisation between them needs to be handled correctly for accurate broker split calculations (many brokerages have different split tiers for residential vs. commercial).
SFG
SFG provides commission data in their own format through their broker portal. The reports are functional but require manual mapping to match your internal broker and loan identifiers. SFG has a smaller market share which means less standardisation in how they report.
FAST (PCF)
FAST (now part of PCF) has a well-structured reporting system. However, as a white-label aggregator with multiple sub-brands, the remittance data can include commissions from different lender partnerships that need to be attributed correctly.
Mortgage Choice
Mortgage Choice operates as both a franchise network and an aggregator. Their remittance includes franchise-level fees and deductions that are unique to their model and need to be handled differently from standard aggregator remittance.
Aussie Home Loans
Similar to Mortgage Choice, Aussie Home Loans has its own commission structure and reporting format. The data includes brand fees, marketing levies, and other Aussie-specific deductions that need to be factored into net commission calculations.
NMB (National Mortgage Brokers)
NMB provides remittance through their own portal with a format that has evolved over time. Their reports include detailed lender information but require mapping to standardise lender names (different aggregators may use different names for the same lender).
Smaller Aggregators
Astute Financial, Outsource Financial, Buyers Choice, MoneyQuest, Custom Equity Group, Bendigo Bank Brokers, Regional Finance Brokers (Regfin), Vision Aggregation, Hai Money, Australian Asset Aggregation — each has their own reporting format, and the level of data quality varies significantly. Some provide clean CSV exports, others send PDF statements that need OCR processing.
For a brokerage that works with 3-5 of these aggregators, the finance team is essentially running 3-5 separate data processing pipelines every pay cycle.
Common Reconciliation Challenges
Beyond the format differences, there are several recurring problems that make remittance processing difficult:
Missing or Changed Loan References
Aggregators use their own internal loan reference numbers, which may not match your brokerage's reference system. When a broker settles a loan, the reference number in your CRM might be different from the reference number the aggregator uses in their remittance file. Over time, loan references can change due to refinancing, loan variations, or system migrations at the aggregator level.
Timing Mismatches
Lenders do not all pay on the same schedule. Some pay upfront commissions within 2 weeks of settlement, others take 4-6 weeks. Trail commissions can arrive at any point during the month. This means your expected commission for a given period might not match what actually arrives in the remittance file. Reconciling expected vs. actual payments requires tracking payment timing patterns for each lender and aggregator combination.
Clawback Handling
When a borrower refinances or discharges their loan within the clawback period (typically 1-2 years), the lender claws back some or all of the upfront commission. This clawback flows back through the aggregator as a negative line item in the remittance file. Your system needs to identify these, match them to the original commission payment, and calculate the correct deduction from the broker who originated the loan.
Split Commission Arrangements
Some loans involve multiple brokers — a referring broker and a writing broker, or a senior and junior broker who work on the deal together. The remittance file shows a single commission amount for the loan, but your brokerage needs to split it according to whatever arrangement was made. These split arrangements are not in the remittance data — they are internal business rules that need to be applied after the data is extracted.
GST Variations
Not all brokers are registered for GST. Some brokers operate as sole traders below the GST threshold, while others operate through companies or trusts that are GST-registered. RCTI generation needs to handle both cases correctly — applying GST where appropriate and generating GST-free invoices where the broker is not registered.
Automating Remittance Processing
We built our commission platform specifically to solve these problems. Here is how automation addresses each challenge:
AI-Powered Document Processing
Instead of manually mapping columns from each aggregator's format, the platform uses AI document processing (Azure Document Intelligence) to extract and normalise data from any format — CSV, Excel, PDF, or even scanned documents. The system learns the format of each aggregator and automatically extracts the relevant fields (loan reference, broker name, commission type, amount, lender, settlement date).
When an aggregator changes their format (which happens more often than you would expect), the AI adapts without requiring manual reconfiguration.
Intelligent Matching
The platform maintains a comprehensive loan and broker database. When remittance data is processed, it uses fuzzy matching to link commissions to the correct loan and broker — even when reference numbers do not match exactly or broker names are abbreviated differently across aggregators.
Unmatched records are flagged for human review rather than being silently dropped, so nothing falls through the cracks.
Automated Split Calculations
Commission split rules are configured once and applied automatically. The system handles tiered structures, team overrides, referral fees, and clawbacks without manual calculation. When a clawback appears in a remittance file, it automatically calculates the correct deduction based on the original commission and the broker's current split arrangement.
ABA File Generation
Once commissions are processed and approved, the platform generates correctly formatted ABA payment files for batch processing through your bank. One click to generate the file, one upload to your banking portal, and all brokers are paid.
Complete Audit Trail
Every commission is traceable from the source remittance file through to the RCTI and payment. You can answer "where did this number come from?" for any line item on any broker's RCTI. This makes audits straightforward and gives you confidence in your commission data.
What Processing 24+ Aggregators Looks Like in Practice
Here is a real example of what a pay cycle looks like with automated remittance processing:
Day 1 (Monday): Upload remittance files from the aggregators that have sent their statements. The platform processes them in minutes, extracting and normalising the data.
Day 1-2: Review the automated matching results. Most commissions (90%+) match automatically. Spend time only on the flagged exceptions — new loans not yet in the system, name mismatches, or unexpected amounts.
Day 2: Approve the processed commissions. The platform calculates all broker splits automatically based on your configured rules.
Day 2: Generate RCTIs for each broker and ABA payment files for your bank. Review and approve.
Day 3: Upload ABA file to your bank. Brokers are paid.
Total active time: 3-5 hours. Compare that to 20-40 hours of manual processing.
Getting Started
If your brokerage is processing remittance from multiple aggregators and spending too long on commission management, automation is worth exploring.
The first step is understanding your current workflow: how many aggregators you work with, how many brokers you pay, what split structures you use, and where the most time is spent. We have built commission automation for brokerages working with up to 24+ aggregators and can help you map out what automation would look like for your specific setup.
Tell us about your workflow to discuss your remittance processing workflow. You can also read our guide on RCTI invoicing for mortgage brokers for more detail on the invoicing side, or explore our mortgage broker software solutions page.