BookIQ data dictionary

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

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 in your book, how much 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.

Monthly commission
The total trail commission you received this month across all active loans and lenders, including GST. This is your top-line monthly income from your existing book. Settle nothing new and this is what arrives in your account.

Runoff (balance)
The percentage of your book's balance that left last month. Any loan that was on your book last month but not this month has run off. This is the rate at which your book is bleeding. Every loan that runs off takes its trail with it permanently.

Annualised runoff
If this month's 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.

Growth above replacement
Did the new loans you settled this month bring in more balance than the loans you lost? Positive means your book grew that month. Persistent negative figures mean your book is slowly contracting even while you settle new business.

Required new per 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.

HHI (Herfindahl-Hirschman Index)
A concentration score showing how dependent your book is on any single lender. Below 1,500 is well diversified. Between 1,500 and 2,500 is moderately concentrated. Above 2,500 is a risk. If one lender holds 40% or more of your book and changes their commission structure, that is a significant problem. HHI lets you spot it before it bites.

Clawback window
The number of active loans within their first 24 months of settlement. 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. 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.

Book balance - 23 months: 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.

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, weighted by balance. 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 less than 24 months old. 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 (over 24 months)
Active loans more than 24 months old. These are past clawback risk. 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, 48 and above). 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 subsequent month. Steep early drops mean loans are leaving quickly after settlement, which is a clawback exposure problem.

Loan age at discharge - cumulative distribution: Of all discharges in the period, what percentage happened before each age threshold? If 70% of your discharges happen within the first 24 months, 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 normal monthly repayments, estimated at 6.5% interest over 30 years. 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 full 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 24 months of settlement — 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. If the entire clawback population discharged tomorrow, you would lose this much trail income for the year, plus whatever upfront commission the lenders claw back.

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 50% of discharges happen before 18 months, 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?

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 came from discharges versus prepayments versus scheduled P&I. Different lenders fail in different ways.

Clawback by lender: Which lenders' loans are most concentrated in the 24-month 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 am I writing enough to keep up?

Current balance / 3 months / 6 months / 12 months
Where your book balance will sit at each future horizon if current runoff continues and you write zero new business. Plan your settlements around this. If your book will be 12% smaller in a year on a do-nothing basis, you need to know what new-business volume offsets that.

Commission now / Commission in 12 months
Today's monthly commission and what it will be in 12 months at the same do-nothing trajectory. Translates the balance projection into income terms.

Required new per month
The average dollar amount of new lending you need to settle each month to keep your book flat, based on runoff over the last 12 months. This is the hardest single number to track in a broker business, and it is right here.

Actual new added / Last 12-month average
What you have actually been settling on average. Compare this to Required new per month. If your actual is below the required, your book is shrinking despite your settlements.

Average loan age / Age-adjusted runoff
Average loan age is the current weighted-average age of your book. Age-adjusted runoff adjusts the runoff rate for the fact that older loans behave differently from newer ones. A young book looks low-runoff today but may accelerate as loans age into the prime refinancing window. Age-adjusted projections give a more honest forward picture.

12-month projected balance - flat rate vs age-adjusted: Two lines showing your book trajectory. The age-adjusted line is usually more pessimistic for young books and more optimistic for mature ones.

Replacement requirement vs actual new business: Your monthly target as a reference line against your actual settlements. Months where actual falls below the line mean your book shrank that month.

Missing Trail answers the question: am I being paid every dollar I am owed?

Open alerts
Loans on your book with no trail commission payment received for at least one full month, despite the loan still having a positive balance. Each one is potentially uncollected income. Most result from administrative errors at the lender end — billing system glitches, broker code mismatches — and can be recovered if you chase them.

Estimated missed income
Approximate total trail commission you should have received but did not, summed across all flagged loans. Calculated as gap months multiplied by the last known monthly trail amount. Brokers regularly recover thousands of dollars in retroactive trail by working through this list.

Balance at risk
Total outstanding balance across all flagged loans. If you do not chase these and they discharge, you lose both the missed trail and all future trail. Any within the 24-month clawback window also carry upfront commission risk.

In clawback window
Flagged loans settled within the last 24 months. These are the most urgent to action. The clock is running on clawback exposure, and the missing trail compounds the problem.

Missing trail by lender: Which lender accounts for the most missed income. Patterns here often reveal a systemic issue with one lender's payment processing.

Loan detail table: Every flagged loan with its reference, client name, lender, clawback status, gap start date, gap duration in months, last trail payment received, estimated missed income, and outstanding balance.

To use this table: sort by estimated missed income and start with the largest amounts. Contact the relevant lender's broker support team to lodge a query. Most missing trail can be recovered retroactively.

Annualised trail
Your current monthly commission multiplied by 12. This is the starting point for any trail book valuation.

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

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, adjusted trail, book balance, and active loan count across your full reporting period. The commission payments section below the summary table shows individual payments broken down by period, client, lender, loan ID, balance, amount (including and excluding GST), 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.

If you would like to check it out, please reach out to your Partnership Manager to get invited to the pilot program.