LMG (Loan Market Group)

How statements arrive

LMG issues a recipient created tax invoice each commission run through its broker platform. Brokers export it as an .xlsx workbook; the commission lines sit on a single sheet with one row per payment line and around two dozen named columns.

Format: .xlsx · sheet RCTILWNewExcel

What MyLoanBook reads

• Client name and loan account, used to match the same loan month to month.
• Lender, used for concentration analysis and lender-level trail rates.
• Settlement date, used to place every loan on its clawback timeline.
• Loan balance, used to derive the trail rate and to track paydowns.
• Payment type: TRAIL, UPFRONT, DISCHARGED, ARREARS and fee lines.
• Commission GST Inclusive, the amount paid to you after the split, which is the income figure throughout MyLoanBook.
• Lender Payment, the gross figure, kept for reference and never used as income.

Columns expected in the export

Notes

• Upload the export unmodified. Renaming columns, deleting rows or saving through another spreadsheet tool can change the sheet name or the date formats and the file will be rejected with a clear message.
• One file per commission run. Upload each month's file and MyLoanBook keeps the history, so the month-on-month comparison, lost and gained clients, and run-off are calculated from your own statements rather than estimated.
• The public quick analysis on the home page reads the same file entirely in your browser. Nothing is uploaded; it is a way to see the headline numbers before you request beta access.