What is BookIQ?
BookIQ is a trail book intelligence dashboard in Mercury Nexus. It gives you one view of your loan book: how it is performing today, where balance is leaving and why, where your clawback exposure sits, and where your book is heading over the next 12 months.
BookIQ is available to principals (partner-level users). You'll find BookIQ in Commissions, and Commissions opens on BookIQ by default.
BookIQ shows your whole partner group's book, covering every broker on your Connective commission statements.
The first time you open BookIQ, your Connective commission history is imported automatically. If it is still running, a banner on the Dashboard lets you know.
Navigating BookIQ
BookIQ is organised into tabs across the top of the screen, each focused on one part of your trail book.
Tab | Use it to |
Dashboard | Check whether your book is growing or shrinking, and read your Trailbook Analysis |
Upload RCTI | Add commission data from other aggregators |
Book Health | See the age profile of your book and how past settlement cohorts have held up |
Runoff Analysis | Find out where balance is leaving your book and why, and review clawback risk |
Lenders | Check how diversified your book is and which lenders' loans run off fastest |
Brokers | Compare runoff, growth and clawback exposure by broker |
Forward View | Set a 12-month growth target and see the new business it takes |
Book Valuation | Estimate what your trail book is worth |
Trail History | Review and reconcile your month-by-month trail income |
Client Book | Find clients with active loans |
Get help on any screen
Select the help icon in the BookIQ toolbar to open the help panel. It explains the terms used on the tab you're viewing.
Most cards and charts also have an ⓘ icon. Hover over or select it to see what the figure means, how to read it, and what to watch for.
Your commission data
Your Connective commission data flows into BookIQ automatically, so you don't need to upload anything for it to appear. BookIQ uses up to your last 48 months of commission statements.
If you also have loans through another aggregator, upload those RCTI files to see your whole book in one place.
Upload 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.
Tip: Statements can be uploaded in any order. When an earlier month arrives late, BookIQ corrects the month after it, so your new and lost balance figures stay accurate.
Dashboard
The Dashboard is your starting point. Open it first to see where your book stands today and whether it is growing or shrinking over time.
The page is split into two parts: a Snapshot of your book right now, and Performance over time, which follows the period you choose.
Check where your book stands today
The Snapshot cards show your book as at the latest month of data. They don't change when you change the period.
Card | What it tells you |
Active loans | How many loans are on your book, with the change since last month |
Active balance | Total outstanding balance, the base your trail is paid on, with the change since last month |
Lender Diversity Index | How evenly your book is spread across lenders, from 0 to 100 (higher is better) |
Clawback window | The share of your book still inside its lender's clawback window, and how many loans that is |
The Lender Diversity Index card also tells you how many lenders your book is effectively spread across. A score of 70 to 100 is well diversified, 40 to 69 is moderately concentrated, and below 40 is highly concentrated.
Read your Trailbook Analysis
The Trailbook Analysis Overview is an AI-generated summary of your book. It opens with a short executive summary, followed by counts of key strengths, risks, notable trends and recommendations.
Read the executive summary at the top of the card.
Select See strengths, risks and recommendations, or any of the count pills, to expand the detail.
Select Hide strengths, risks and recommendations to collapse it again.
The first time, select Generate analysis to create your summary. After that, it refreshes automatically when you open the Dashboard after your data has changed, and the card shows the date it was generated.
Review performance over a period
Use the period selector beside Performance over time to choose 1, 6, 12 or 24 months. Your choice stays in place as you move between tabs.
Card | What it tells you |
Monthly commission | Average trail income per month over the period, compared with the period before |
Runoff rate | Average share of your book balance leaving each month |
Annualised runoff rate | What the monthly runoff rate adds up to over a year |
Net book growth | Average monthly growth after runoff. Positive means your book grew |
New lending needed/month | The new lending you need each month just to keep your book the same size |
Each card shows how many months it actually averaged over. If you have less history than the period you chose, it uses the months you have.
The charts below the cards show your book balance, monthly trail commission, new versus lost balance, and your runoff rate trend. The runoff rate trend shows two lines: Monthly runoff % (excl. repayments), which counts loans that left your book, and Monthly runoff % (incl. repayments), which also counts principal repaid on loans that stayed.
Note: Charts need at least two points to draw a trend, so if you choose 1 month the charts show the last 6 months. The cards still show your 1-month figures.
Book Health
Book Health shows how old your book is and how past groups of settlements have held up over time.
Use it to see how much of your book is still inside its lender's clawback window, and how quickly loans leave after they settle. Loans are grouped into age bands of 0 to 12, 12 to 24, 24 to 36, 36 to 48 and 48+ months.
The cohort charts track each group of loans that settled in the same month. The cohort survival heatmap shows the percentage of each group still on your book in each month after settlement. Steep early drops mean loans are leaving soon after they settle, which is where clawback exposure comes from.
Runoff Analysis
Runoff Analysis breaks down where balance is leaving your book and why. Balance leaves through full discharges, scheduled principal repayments and extra lump-sum repayments, while redraws add balance back.
The discharge section shows early exit rates by lender and broker, and the average age loans reach before they leave.
Note: A loan that is discharged and re-written, including a refinance you kept, counts as a discharge here, and its replacement counts as new business. Discharge figures are higher than the number of clients you actually lost.
Review the loans behind your clawback risk
The Clawback risk section shows the balance and trail income at risk if loans still inside their lender's clawback window discharge early.
Select View loans beside the Clawback risk heading.
Review the list of loans still inside their lender's clawback window. Select a column heading to sort the list.
Use the back option on the list to return to where you were.
How clawback windows work
Clawback windows vary by lender. Most are between 12 and 24 months, and some lenders don't claw back at all. BookIQ applies each lender's own window, based on Connective's commission guide, so a loan only counts as at risk while it is inside its lender's window.
Wherever BookIQ shows a clawback figure, the label tells you which window was used. When your book includes lenders with different windows, it shows varies by lender.
Note: Clawback windows are set by Connective and can't be changed in BookIQ. To see each lender’s window, check the Clawback window column on the Lenders tab. If you think a window is wrong, contact [email protected].
Lenders
The Lenders tab shows your book by lender, including each lender's balance share, runoff rate, clawback window and clawback exposure.
The summary at the top shows your Lender Diversity Index (trail book), the same 0 to 100 score as the Dashboard, worked out from loans paying you trail. It can differ slightly from the Dashboard score, which covers your whole book.
Use this tab to spot concentration risk. A lender that holds a large share of your book and also has a high runoff rate is your highest-risk position.
The Balance reduction by component chart shows how each lender's existing balance reduced over the last 48 months, split into discharges, scheduled repayments and extra repayments. New loans are counted separately as new lending.
Brokers
The Brokers tab shows the same analysis by broker, including loan count, balance, commission, new lending, runoff rate, net growth and clawback exposure.
A broker with high settlements and high runoff is replacing what they lose without growing. A broker with fewer settlements and very low runoff is quietly building a stronger book.
Forward View
Forward View answers two questions on one page: where your book stands today, and where it's heading depending on how much new business you write. You set one growth target, and every projection on the page moves with it.
The page is laid out in four sections, top to bottom.
Your book today
These figures describe your book right now and don't change when you move the growth target.
Card | What it tells you |
Current balance | The starting point for every projection on the page |
Trail commission (monthly) | What you earn on the book as it stands |
Runoff rate | The share of your balance leaving each month, and roughly how many dollars that is |
Recent writing pace | Your average new settlements per month over the last 12 months |
Runoff never stops. Even with no growth target, some balance leaves every month as loans repay or refinance, so holding your book flat still takes new business.
Set your 12-month growth target
This is the one control on the page. It sets your net book growth after runoff, and BookIQ works out how much new business that takes.
Drag the Net book growth over 12 months slider to any target from -20% to +50%.
Or select a preset: Write nothing, Hold flat, My recent pace or Stretch.
Read the New business required to hit target card. It shows the monthly pace your target needs, how much of it replaces runoff, and how it compares with your recent pace.
The slider starts at your recent pace. If your recent pace sits outside the slider's range, a note shows your actual rate.
Where your book is heading
These figures and charts update as you move your growth target: your balance in 3, 6 and 12 months, and your trail commission in 12 months, each compared with today.
The balance and commission charts show two lines. The dashed line is what happens if you write no new business, and stays the same whatever your target. The gap between the two lines is the work your new business has to do.
Discharge & clawback risk
This section shows where today's book is exposed, based on loan age rather than your growth target. It shows the loans still inside their lender's clawback window, the balance at risk, and the monthly and annualised trail at risk if those loans discharged.
Select View loans beside the Discharge & clawback risk heading to see the loans behind these figures.
Note: Forward View needs at least two months of commission data to make projections. If BookIQ can’t model a growth target for your book, Forward View shows where your book heads with no new business instead: the dashed line at today’s runoff rate, and the solid line adjusted for loan age.
Book Valuation
Book Valuation estimates your trail book's market value from your annualised trail income, using both a simple multiple and a 20-year projected cash flow model.
Use the valuation multiple slider to model different buyer or market scenarios and see how the multiple changes the estimate. Trail books in Australia typically trade at 3x to 4x annualised trail.
Note: Book Valuation is an estimate to help you plan. It isn't a formal valuation of your business.
Trail History
Trail History shows your month-by-month trail income, book balance and active loan count for up to the last 48 months. Trail income is shown excluding GST.
Below the summary, the commission payments list shows each payment by period, client, lender, loan ID, balance, amount and payment type. Use it to reconcile payments or check what a lender paid in a given month.
Client Book
Client Book lists every client with at least one active loan, with their loan count, total balance, monthly trail and loan status.
Use the search bar to find a client, and select a column heading to sort the list.
Find definitions for every metric
For a plain-English explanation of every metric and chart in BookIQ, including benchmarks and what to watch for, see the BookIQ data dictionary. You can also select any figure's ⓘ icon in BookIQ.
Need help?
If you need help with BookIQ, contact your Partnership Manager or email [email protected].