BookIQ data dictionary

The Dashboard is your daily snapshot. It answers the question: is my book growing or shrinking, and how fast?

The cards are in two groups. Snapshot cards show your book as at the latest month and don't change with the period. Performance over time cards average over the period you choose: 1, 6, 12 or 24 months.

Active loans
The number of loans currently on your book paying you trail. Trend matters more than the absolute number. If you are losing more loans each month than you are settling, your book is shrinking.

Active balance

The total outstanding balance across every loan on your book, what your customers collectively still owe their lenders. Trail commission is paid as a percentage of this balance, so this is your revenue base. A larger active balance means larger monthly trail.

Lender Diversity Index
A score from 0 to 100 showing how evenly your book is spread across lenders. A higher score means your loans sit with more lenders. A lower score means you lean heavily on a few. The card also shows roughly how many lenders your book is effectively spread across. 70 to 100 is well diversified, 40 to 69 is moderately concentrated, and below 40 is highly concentrated. If one lender holds a large share of your book and changes its commission structure, the impact is proportional to that share.

Clawback window
The share of your book, and the number of loans, still inside their lender's clawback window. If any of these discharge early, the lender may claw back part of the upfront commission you were paid. This is your at-risk pool. Windows vary by lender, and some lenders don't claw back at all. You can see each lender’s window in the Clawback window column on the Lenders tab. The label shows the window used, or varies by lender when your lenders differ. A fast-growing book will always have a meaningful clawback population. The concern is the runoff rate within this group, shown in the Runoff Analysis tab.

Monthly commission
The average trail commission you received each month over the period, across all active loans and lenders, including GST, compared with the period before. This is your top-line monthly income from your existing book.

Runoff rate
The average share of your book's balance that left each month through discharges and repayments. Every loan that runs off takes its trail with it permanently.

Tip: Healthy mortgage books typically run off between 1% and 1.5% per month. Above 2% is a warning sign, your book is shrinking faster than most brokers can replace it.

Annualised runoff rate
If the monthly runoff rate continued for a full year (compounded), what percentage of your book would be gone? This translates the small monthly figure into something easier to act on. 1% per month compounds to roughly 12% per year. Anything under 12% annualised is healthy. 15% or above means your book has a retention problem.

Net book growth
The new lending you settled, after subtracting the balance that left. Positive means your book grew. Persistent negative figures mean your book is slowly contracting even while you settle new business.

New lending needed/month
The dollar amount of new lending you need to settle each month just to keep your book the same size. This is your treadmill speed. Your sales target should be this number plus whatever growth you actually want.

Each Performance over time card shows how many months it averaged over. If you have less history than the period you chose, it uses the months you have.

Book balance: Shows whether your book is growing, flat, or shrinking. Look at the slope over time rather than any single month.

Monthly trail commission: Tracks whether your monthly income is trending up or down alongside your balance.

New vs lost balance: A visual comparison of new settlements against lost balance each month. When the bars above the line exceed those below, you are growing.

Runoff rate trend: Shows whether your runoff rate is stable, worsening, or improving over time. It has two lines. Monthly runoff % (excl. repayments) counts loans that left your book. Monthly runoff % (incl. repayments) also counts principal repaid on loans that stayed.

Book Health answers the question: how old is my book, and how have my past cohorts of borrowers behaved?

Average loan age
The average time in months since each active loan settled. Older loans are stickier but lower-balance. A book averaging 3 months of age is volatile and heavily exposed to clawback. A book averaging 4 years is stable but slowly amortising. The 18 to 36 month range is the sweet spot, past most clawback risk, before serious amortisation.

In clawback window
Active loans still inside their lender's clawback window. These are the loans that, if discharged, will trigger upfront commission clawback. As a percentage of your book, this depends on your growth rate. Fast-growing brokers may have 60% or more in clawback. Mature, steady books may have around 30%.

Mature loans
Active loans past their lender's clawback window. If they discharge, you stop receiving future trail but the lender cannot reclaim what they have already paid you. A higher proportion of mature loans means lower clawback risk and a more predictable income base.

Current book by loan age band: Distributes your loans across age brackets (0 to 12 months, 12 to 24, 24 to 36, 36 to 48 and 48+). Shows the age shape of your book at a glance.

Cohort survival: For each settlement-month cohort, tracks what percentage of those loans are still on your book each month afterwards. Steep early drops mean loans are leaving quickly after settlement, which is a clawback exposure problem. The heatmap shows the same figures as a grid, shading from green towards orange as survival falls.

Loan age at discharge - cumulative distribution: Of all discharges in the period, what percentage happened before each age threshold? The marker shows your clawback window. If most of your discharges happen before the marker, you have an early-exit and clawback problem.

Runoff Analysis answers the question: where is balance leaving my book, and why?

Every month, balance leaves your book through one of four mechanisms:

Lost loans / Lost balance / Retention / Runoff rate
The same core runoff metrics from the Dashboard, decomposed by cause. The retention figure (for example, 99.0%) is reassuring, but the runoff figure (1.0%) is what compounds into a meaningful annual loss.

Scheduled P&I
The principal portion of customers' normal monthly repayments. This is structural and unavoidable.

Unscheduled prepayments
When customers paid more than their scheduled repayments, lump sums or extra repayments. If these are very high, your customers are aggressively paying down, which reduces your trail revenue without any discharge event ever occurring.

Drawdowns
When customers redrew or drew down on a loan facility, increasing balance. This is the only mechanism that adds balance without a new settlement.

Peak runoff
The single highest monthly runoff rate in the reporting period. Tells you what a bad month looks like for your book. Planning for the peak is more prudent than planning for the average.

Total discharges / Balance discharged / Trail commission lost
Cumulative totals across the reporting window. Total discharges is how many loans completely left. Balance discharged is the total balance they carried. Trail commission lost is the monthly trail those loans were generating. If these numbers are large relative to your current book, your historical retention has been poor.

Early discharges / Average age at exit / Highest early exit
Early discharges are loans discharged within their lender's clawback window, the worst kind, because they trigger clawback and deny you trail. Average age at exit shows how long loans typically stay before discharging. Highest early exit identifies the lender or broker with the worst early-exit rate.

Loans in clawback / Balance at risk / Monthly trail at risk / Annualised trail at risk
A quantification of your worst-case clawback exposure, for loans still inside their lender's clawback window. If that whole group discharged tomorrow, you would lose this much trail income for the year, plus whatever upfront commission the lenders claw back. Select View loans to see the loans behind these figures.

Monthly balance flow - stacked by cause: Shows discharges, scheduled P&I, prepayments, and drawdowns as stacked bars per month.

Lost balance by month: Time series of just the discharge component. Spikes here mean a bad refinancing month.

Retention vs runoff rate: Mirror time series; when one goes up, the other goes down. Useful for spotting trends.

Discharge count and balance by month: How many loans left and how much balance they took. Fifty small discharges and five large ones look very different but may affect your income equally.

Loan age at discharge - cumulative distribution: What percentage of discharges happened before each age threshold. If a large share happens before your clawback window marker, that is a clawback-exposure problem.

Early discharge rate by lender: Which lenders see the most early refinancing. High rates suggest those lenders' customers are price-sensitive and easily moved by competitors.

Early discharge rate by broker: Same view by broker. High numbers suggest the broker is losing customers to competitors quickly after settlement.

The Lenders tab answers the question: where is my book concentrated, and which lenders carry the most risk?

Lender Diversity Index (trail book)
The same 0 to 100 score and bands as the Dashboard, worked out from loans paying you trail. The Dashboard scores your whole book, so the two scores can differ slightly. The summary also names your largest lender and its share, and the lender with the highest runoff rate.

Concentration risk lives in this tab. If one lender holds a large share of your book and restructures their commission or has a service problem, the impact is proportional to that share. The runoff rate per lender tells you which lenders' customers are most likely to refinance away.

Lender balance share: Your book broken down by lender, the concentration view.

Balance share vs runoff rate: Which lenders are large and have high runoff? Those are your top concentration risks.

Balance reduction by component - lender: For each lender, how much of their balance reduction over the last 48 months came from discharges versus extra repayments versus scheduled P&I, with new lending and drawdowns shown separately. Different lenders fail in different ways.

Clawback by lender: Which lenders' loans are most concentrated inside their clawback window.

The Brokers tab shows the same analysis as Lenders, but by broker rather than lender.

A broker with high settlements but high runoff is treadmilling, lots of activity, no growth. A broker with lower settlements but very low runoff is quietly building a profitable book.

Broker balance ranking: Who has the largest book.

Balance reduction by component - broker: Whether a broker's book leaks through discharges or through prepayments.

Clawback by broker: Which brokers have the highest clawback exposure. Usually correlated with recent new business volume.

Forward View answers the question: where is my book heading, and how much new business do I need to write to get where I want? You set one 12-month growth target, and the projections move with it.

Current balance
Your book balance today, the starting point for every projection on the page.

Trail commission (monthly)
What you earn each month on the book as it stands.

Runoff rate
The share of your balance leaving each month, and roughly how many dollars that is. Runoff never stops, so holding your book flat still takes new business.

Recent writing pace
Your average new settlements per month over the last 12 months. Compare it with the new business your target needs.

Net book growth over 12 months (growth target)
The change in book balance you want over the next 12 months, after runoff, from -20% to +50%. The presets are Write nothing, Hold flat, My recent pace and Stretch. The slider starts at your recent pace.

New business required to hit target
The monthly new lending your target needs, how much of it just replaces runoff, and how it compares with your recent pace. If this is well above your recent pace, your target needs a step up in writing.

Balance in 3, 6 and 12 months / Trail commission in 12 months
Where your balance and monthly trail will sit at each horizon if you hit your growth target, compared with today.

Loans in clawback zone / Balance at risk / Trail at risk
The Discharge & clawback risk section shows where today's book is exposed, based on loan age rather than your growth target. It covers loans still inside their lender's clawback window.

Projected balance and projected commission: Two lines over 12 months. The solid line follows your growth target. The dashed line is what happens if you write no new business, and stays the same whatever your target. The gap between them is the work your new business has to do.

Annualised trail income
The ongoing trail commission your active book generates over a year, including GST. This is the starting point for any trail book valuation.

Simple valuation
Annualised trail income multiplied by the valuation multiple. Gives a quick, market-based estimate of what a buyer might pay for your book today.

Detailed estimate (DCF valuation)
A discounted cash flow model projecting 20 years of trail income at your current runoff rate, discounted back to a present value. This is a more precise estimate that accounts for how your book is expected to decay over time.

Valuation multiple
Adjust the slider to model different buyer or market scenarios. Trail books in Australia typically trade at 3x to 4x annualised trail. High-quality books with low runoff and a diverse lender mix can achieve 4x to 5x.

Trail History shows your month-by-month trail commission income, book balance, and active loan count for up to the last 48 months. Trail income is shown excluding GST. The commission payments section below the summary table shows individual payments broken down by period, client, lender, loan ID, balance, amount, and payment type (trail, upfront, or other).

Use Trail History to review your income record, reconcile individual payments, or look up what a specific lender paid in a given month.

Client Book lists all clients with at least one active loan, including their loan count, total balance, monthly trail, and loan status. Use the search bar to find a specific client, and select a column heading to sort the list.

If you need help with BookIQ, contact your Partnership Manager or email [email protected].