Where to find it in MyCRM

MyCRM is the aggregator platform used by LMG (and a number of smaller groups under MyCRM partnerships). The trail commission report is typically under Commissions → Reports → Commission Statement. Pull as CSV or XLSX for the most recent calendar month.

MyCRM also offers a longer-horizon Commission Detail export that includes historical periods on a single sheet. Useful for trend analysis but heavy — load it once and save the snapshot.

What's in the file

  • Loan reference / Loan number — the unique loan ID across periods.
  • Client name, mobile, email — borrower details. MyCRM exports lean towards more PII in the same file than other platforms; treat the file accordingly.
  • Lender, product, application number — bank, product code, and the original application reference.
  • Settlement date, loan amount — settlement date and principal at settlement.
  • Current balance, interest rate — period-end balance and the loan's current interest rate. (Yes, MyCRM exports include real interest rate — distinguishes it from AFG.)
  • Commission type, GST amount, net amount — type discriminator (Upfront / Trail / Clawback / Adjustment), GST component, and net commission. Important for accountants: the GST split is often higher than people expect.
  • Period start, period end — the commission period the row covers.
  • Loan writer, processor — who wrote the loan, and who processed it. Some brokerages assign separate writers and processors; the report distinguishes them.

Reading it for portfolio decisions

MyCRM's report supports a few views uniquely well:

  1. Interest-rate distribution — because real interest rates are on every row, you can plot rate vs market to find clients with above-market rates (refinance risk).
  2. Net vs gross commission — explicit GST handling lets you build clean net cash-flow models without iterating GST treatment per lender.
  3. Writer/processor split — if you pay processors and writers differently, the dual columns let you build accurate commission-split reports.

Common gotchas

  • PII heavy — the file has names, phones, emails. Don't email it; don't drop it into ad-hoc analytics tools without thinking about the data-handling implications. TrailScope's AI features explicitly exclude these columns from the model context.
  • Decimal precision — MyCRM exports interest rates as percent values to two decimal places. Some accounting tools assume basis points; multiply by 100 if your downstream system expects bps.
  • Date column format — usually DD/MM/YYYY Australian convention but the headers say Date generically. Confirm before parsing.
  • Cancelled applications — some MyCRM exports include zero-commission rows for cancelled applications. Filter them out before aggregation, or your loan count is inflated.

Working with this in TrailScope

The MyCRM column shape is auto-detected on upload. Because MyCRM carries real interest rates, retention scoring can use the rate-vs-market factor at full weight — one of the strongest signals of refinance risk. See all features →

FAQ

Does MyCRM expose the loan's real interest rate?

Yes — unlike AFG, MyCRM's Commission Statement includes the current interest rate per loan, which makes rate-vs-market analysis much easier.

Is the commission amount gross or net of GST?

MyCRM reports both — a GST column and a net column. Use net for your cash-flow model; gross for the broker's invoice.

Can I export historical periods at once?

Yes — the Commission Detail report lets you pull a multi-month or YTD slice. Use this for trend analysis; use the Commission Statement for monthly close.

Why do I see zero-commission rows?

Usually cancelled applications or trail-only loans in a non-paying period. Filter by commission amount > 0 if you want only paying rows.

Does MyCRM update fixed-rate expiry?

Sometimes, depending on the lender. Where present, the data is reliable; where missing, you can pull from each lender's portal or your CRM.