RCTI Invoicing for Mortgage Brokers: How to Automate It

What Is an RCTI and Why Do Mortgage Brokers Use Them?

A Recipient Created Tax Invoice (RCTI) is a tax invoice created by the buyer of a service rather than the seller. In the mortgage broking industry, the brokerage (or aggregator) creates the invoice on behalf of the broker — the person who originated the loan and earned the commission.

This is the standard arrangement across Australian mortgage brokerages because brokers earn commissions from dozens of different lender and aggregator relationships, and having each broker raise individual invoices for every commission payment would be a logistical nightmare.

Under ATO rules, both parties must have a written RCTI agreement in place, the recipient must be registered for GST, and the RCTI must meet all standard tax invoice requirements (ABN, GST amount, description of services, etc.).

For most brokerages, RCTI generation happens every pay cycle — fortnightly or monthly — and involves processing commission data from every aggregator and lender the brokerage works with.

The Manual RCTI Process (and Why It Breaks)

Here is what RCTI generation looks like at a typical brokerage today:

1. Download remittance files from each aggregator (AFG, LMG, Connective, Finsure, Vow, SFG, FAST, Choice, Mortgage Choice, NMB, etc.). Each aggregator has a different portal, different file format, and different column structure.
2. Import into Excel and manually map the columns to your internal format. AFG's CSV looks nothing like Connective's PDF report.
3. Match commissions to brokers by cross-referencing loan records, settlement dates, and lender names. For trail commissions, this means matching monthly trickle payments back to loans that may have settled years ago.
4. Calculate broker splits based on each broker's commission tier — which might vary by loan type, lender, or total volume. Factor in team overrides, referral fees, and clawback deductions.
5. Generate individual RCTIs for each broker, ensuring correct ABN, GST calculations, and line-item descriptions.
6. Generate ABA payment files to batch-process broker payments through your bank.
7. Reconcile expected vs. actual payments, chase discrepancies with aggregators, and file everything for audit.

This process takes a finance team 20-40 hours per pay cycle at a mid-sized brokerage. And that is when everything goes smoothly.

Where It Falls Apart

Format inconsistency. Every aggregator delivers commission data differently. AFG provides a structured CSV. Connective sends a PDF report. Finsure has a different column layout. When you process remittance from 5+ aggregators, your finance team spends most of their time on data wrangling — not actual commission management.

Trail commission complexity. Upfront commissions are relatively straightforward — they're tied to a specific settlement. Trail commissions are harder. They arrive monthly as small payments across hundreds or thousands of active loans. Matching each trail payment back to the right loan, broker, and split structure in a spreadsheet is where most errors happen. If you want visibility into the trail book itself — what is missing, what it is worth, and who is likely to refinance — TrailAI reads any aggregator statement and surfaces it in minutes.

Broker split edge cases. Simple percentage splits are easy. But real brokerages have tiered structures (different splits at different volume levels), team overrides (a percentage goes to the team leader), referral fees (a cut to whoever referred the client), and clawbacks (deductions when a client refinances within the clawback period). Managing all of these in formulas is fragile and error-prone.

ABA file generation. Banks require payment files in the ABA (Australian Bankers' Association) format — a fixed-width text file with very specific formatting rules. Generating these manually or through basic tools is tedious and one wrong character can cause the entire batch to be rejected.

What Automated RCTI Generation Looks Like

We have built a commission and RCTI platform that processes lender remittance from 24+ Australian aggregators — including AFG, LMG, Connective, Finsure, Vow Financial, SFG, FAST, Choice, Mortgage Choice, Aussie Home Loans, NMB, PLAN Australia, Astute Financial, Outsource Financial, Liberty Financial, Resimac, Plenti, Amanah, Buyers Choice, MoneyQuest, and more.

Here is how the automated process works:

1. Upload Aggregator Remittance Files

Upload the raw remittance files from your aggregators — PDFs, CSVs, Excel files, whatever format they provide. The platform uses AI-powered document processing (built on Azure Document Intelligence) to extract and normalise the data regardless of the source format.

No manual column mapping. No copy-pasting between spreadsheets. The system recognises the aggregator format and extracts the relevant fields automatically.

2. Automatic Commission Matching

The platform matches each commission payment to the correct loan record and broker in your system. For trail commissions, it maintains a running history of every loan and automatically attributes monthly trail payments to the originating broker — even for loans settled years ago.

When a payment does not match (new loan not in the system, broker name mismatch, etc.), it is flagged for manual review rather than silently dropping it.

3. Broker Split Calculation

Commission splits are calculated automatically based on your configured split structures. The platform handles:

• Tiered splits — different percentages at different volume levels
• Team overrides — a percentage routed to the team leader or mentor
• Referral fees — cuts to referring brokers or external parties
• Clawback deductions — automatic adjustments when loans are refinanced within the clawback period
• GST handling — correct GST calculations for each broker based on their registration status

4. RCTI Generation

Individual RCTIs are generated for each broker with the correct ABN, GST amount, commission line items, and payment details. These are formatted to meet ATO requirements and can be emailed directly to brokers or downloaded as PDFs.

5. ABA Payment File Generation

Once RCTIs are approved, the platform generates ABA-formatted payment files ready for upload to your bank. Batch payments to all brokers in a single file — correctly formatted, with the right BSB and account numbers, and matching the RCTI amounts exactly.

6. Reconciliation and Audit Trail

Every step is logged. You can see exactly which remittance file each commission came from, how the split was calculated, when the RCTI was generated, and when the payment was made. This gives you a complete audit trail for regulatory compliance and makes financial audits straightforward.

Aggregator-Specific Challenges

One of the biggest obstacles to automating RCTI generation is that every aggregator provides commission data differently. Here are some of the challenges we have encountered:

AFG (Australian Finance Group) provides well-structured CSV exports, but the column names and order can change between report types (upfront vs. trail). Their trail commission reports include historical loan data that needs to be reconciled against your internal records.

Connective uses a portal-based system where you download reports as PDFs or Excel files. The format is different for upfront and trail, and the column structure has changed several times over the years.

Finsure provides commission statements in a format that combines upfront and trail in the same report, requiring parsing logic to separate them correctly.

LMG (Loan Market Group) has a structured reporting system, but the data includes sub-aggregator-level detail that needs to be filtered and mapped to your specific brokerage.

Vow Financial (YBR Aggregation) and SFG each have their own reporting portals with distinct export formats and terminology.

FAST, Choice, Mortgage Choice, Aussie Home Loans, NMB, PLAN Australia — each has their own system with varying levels of data quality and format consistency.

The smaller aggregators — Astute Financial, Outsource Financial, Buyers Choice, MoneyQuest, Bendigo Bank Brokers, Regfin, Vision Aggregation — often have less standardised reporting, which makes automation even more valuable since manual processing of non-standard formats is where most errors occur.

The Business Case for Automation

For a brokerage processing commissions from 3+ aggregators with 10+ brokers:

Time savings. Manual RCTI generation takes 20-40 hours per pay cycle. Automated processing reduces this to 2-4 hours (mostly review and approval). That is 30+ hours saved every pay cycle.

Error reduction. Spreadsheet-based commission management has an error rate of 3-5% across the industry. Automated systems with AI-powered data extraction reduce this to under 0.5%. Fewer errors mean fewer disputes with brokers and less time spent on corrections.

Faster payments. When RCTI generation is automated, brokers get paid faster. This improves morale and makes your brokerage more competitive for attracting top talent.

Scalability. Adding a new aggregator or growing from 10 to 50 brokers does not proportionally increase the workload for your finance team. The platform handles the additional volume without additional manual effort.

Audit readiness. Every commission is traceable from source remittance file to RCTI to payment. When your auditor asks "where did this payment come from?", you can show the exact aggregator file, the matching logic, and the split calculation — in seconds, not hours.

How to Get Started

If you are a mortgage brokerage still managing commissions in spreadsheets, here is a practical path to automation:

Step 1: Audit your current process. Document how many aggregators you process, how many brokers you pay, what split structures you use, and how long each pay cycle takes. This gives you a baseline to measure improvement against.

Step 2: Identify your biggest pain points. Is it the remittance file processing? The split calculations? The RCTI generation? The ABA files? Most brokerages find that remittance file processing (data extraction and normalisation) consumes the most time.

Step 3: Talk to someone who has built this before. We have built commission and RCTI automation for brokerages processing remittance from 24+ aggregators. We understand the edge cases, the aggregator-specific quirks, and the compliance requirements.

Tell us about your workflow to discuss your commission workflow and see if automation makes sense for your brokerage. You can also explore our mortgage broker software solutions page or read our guide on how to automate commission tracking for mortgage brokers for more detail on the broader commission management problem.