What is BookIQ?
BookIQ is a trail commission intelligence dashboard built into Mercury Nexus. It gives you a single, structured view of your loan book covering book health, runoff, clawback exposure, lender concentration, forward projections, and missing trail income.
If you have access to commissions in Mercury Nexus, BookIQ is already available to you. No additional setup is required.
Navigating BookIQ
BookIQ is organised into tabs, each focused on a different aspect of your trail book. Use the navigation bar at the top of the screen to move between them.
Tab | What it covers |
Dashboard | High-level summary of book health |
Upload RCTI | Upload commission data from other aggregators |
Book Health | Loan age profile and cohort survival |
Runoff Analysis | Where balance is leaving and why |
Lenders | Concentration and runoff risk by lender |
Brokers | Performance and runoff by broker |
Forward View | Projected balance and commission over 12 months |
Missing Trail | Loans with no recent trail payment |
Book Valuation | Estimated value of your trail book |
Trail History | Month-by-month commission and balance record |
Client Book | All clients with active loans |
Your commission data
Your Connective commission data syncs automatically into BookIQ. You do not need to upload anything for this data to appear.
If you manage loans through other aggregators and want to include that data, you can upload RCTI files manually using the Upload RCTI tab.
Uploading RCTI files from other aggregators
Select the Upload RCTI tab.
Drag your file onto the upload area, or click to select it. Files must be CSV or Excel format and under 10MB.
Once uploaded, the file appears in your Upload History with its processing status.
Dashboard
The Dashboard is your starting point. Open it first to check whether your book is growing or shrinking and to spot any immediate concerns.
The summary cards show your active loans and balance, monthly trail commission, runoff rate and annualised runoff, growth above replacement, required new settlements per month, HHI concentration score, and the number of loans in your clawback window.
The charts below show your book balance trend, monthly commission trend, new settlements versus lost balance, and runoff rate over time.
Tip: A healthy book typically runs off between 1% and 1.5% per month. Annualised runoff above 15% is worth investigating further in the Runoff Analysis tab.
For a full explanation of each metric, see the BookIQ data dictionary.
Book Health
Book Health shows the age profile of your active loans and how past settlement cohorts have performed over time.
Use this tab to see what proportion of your book is within the 24-month clawback window, how many loans have passed through the clawback risk period, and how quickly individual cohorts are leaving your book after settlement.
Runoff Analysis
Runoff Analysis breaks down where balance is leaving your book and why. Balance leaves through four mechanisms: full discharges (loans paid off or refinanced), scheduled principal repayments, unscheduled prepayments (lump-sum extra repayments), and drawdowns that increase balance.
The tab includes a discharge analysis section with early-exit rates by lender and broker, and a clawback risk summary showing the total balance and trail income at risk if your early loans discharge.
Lenders
The Lenders tab shows your book by lender, including each lender's balance share, runoff rate, and clawback exposure.
Use this tab to identify concentration risk. If one lender holds a large share of your book and has a high runoff rate, that combination represents your highest risk position.
Brokers
The Brokers tab shows the same analysis by broker, including loan count, balance, commission, runoff rate, net balance growth, and clawback exposure for each broker.
Forward View
Forward View projects your book balance and commission income out to 12 months based on your current runoff rate, assuming no new business is written.
It also shows the monthly settlements required to keep your book flat, compared against your actual average over the past 12 months. Use the growth planning tool at the bottom of the tab to model what different growth targets require in monthly new settlements.
Missing Trail
Missing Trail flags loans that have a positive outstanding balance but have not generated a trail commission payment for at least one full month. These represent income you may be able to recover.
To act on missing trail, sort the loan detail table by estimated missed income and start with the highest values.
Note: Loans flagged as "In clawback window" are the most urgent to action. These loans are generating no trail income and remain at risk of triggering a clawback if they discharge early.
Book Valuation
Book Valuation provides an estimate of your trail book's market value, based on your annualised trail income and a 20-year projected cash flow model.
Use the valuation multiple slider to model different buyer or market scenarios. Trail books in Australia typically trade at 3x to 4x annualised trail.
Trail History
Trail History shows your month-by-month trail commission income, adjusted trail, book balance, and active loan count across your full reporting period. You can also view individual commission payments by period, client, and lender.
Client Book
Client Book lists all clients with at least one active loan, including their loan count, total balance, monthly trail, and loan status.
Find definitions for every metric
For a plain-English explanation of every metric, chart, and calculation in BookIQ, including benchmarks and what to watch for, see the BookIQ data dictionary.
BookIQ is currently in pilot phase.
If you would like to check it out, please reach out to your Partnership Manager to get invited to the pilot program.