Mortgage Broker Commission Calculator
Estimate upfront and five-year trail commission after your aggregator split, runoff and clawback assumptions.
Your loans and commission
Your commission forecast
Example inputsCheck the marked fields to calculate your forecast.
- $29,433
- $6,500
- $5,700
- $537
- $6,070
Annual retained trail
| Year | Retained trail | Monthly average | Closing balance |
|---|---|---|---|
| Year 1 | $6,070 | $506 | $4,410,000 |
| Year 2 | $5,326 | $444 | $3,889,620 |
| Year 3 | $4,669 | $389 | $3,430,645 |
| Year 4 | $4,090 | $341 | $3,025,829 |
| Year 5 | $3,579 | $298 | $2,668,781 |
| Clawback cash recovered | $0 |
|---|---|
| Retained trail lost to the event | $0 |
| Five-year retained trail | $23,733 |
| Five-year operating costs | $60,000 |
| After operating costs | -$30,567 |
| Month | Gross trail | Retained trail | Net cash |
|---|---|---|---|
| 1 | $618.49 | $536.64 | $6,236.64 |
| 2 | $612.06 | $530.85 | $530.85 |
| 3 | $605.69 | $525.12 | $525.12 |
| 4 | $599.38 | $519.44 | $519.44 |
| 5 | $593.14 | $513.83 | $513.83 |
| 6 | $586.97 | $508.27 | $508.27 |
| 7 | $580.86 | $502.77 | $502.77 |
| 8 | $574.81 | $497.33 | $497.33 |
| 9 | $568.83 | $491.95 | $491.95 |
| 10 | $562.91 | $486.62 | $486.62 |
| 11 | $557.05 | $481.34 | $481.34 |
| 12 | $551.25 | $476.13 | $476.13 |
| 13 | $545.51 | $470.96 | $470.96 |
| 14 | $539.83 | $465.85 | $465.85 |
| 15 | $534.21 | $460.79 | $460.79 |
| 16 | $528.65 | $455.79 | $455.79 |
| 17 | $523.15 | $450.84 | $450.84 |
| 18 | $517.71 | $445.94 | $445.94 |
| 19 | $512.32 | $441.09 | $441.09 |
| 20 | $506.98 | $436.29 | $436.29 |
| 21 | $501.71 | $431.54 | $431.54 |
| 22 | $496.48 | $426.84 | $426.84 |
| 23 | $491.32 | $422.18 | $422.18 |
| 24 | $486.20 | $417.58 | $417.58 |
| 25 | $481.14 | $413.03 | $413.03 |
| 26 | $476.13 | $408.52 | $408.52 |
| 27 | $471.18 | $404.06 | $404.06 |
| 28 | $466.27 | $399.65 | $399.65 |
| 29 | $461.42 | $395.28 | $395.28 |
| 30 | $456.62 | $390.95 | $390.95 |
| 31 | $451.86 | $386.68 | $386.68 |
| 32 | $447.16 | $382.44 | $382.44 |
| 33 | $442.51 | $378.25 | $378.25 |
| 34 | $437.90 | $374.11 | $374.11 |
| 35 | $433.34 | $370.01 | $370.01 |
| 36 | $428.83 | $365.95 | $365.95 |
| 37 | $424.37 | $361.93 | $361.93 |
| 38 | $419.95 | $357.95 | $357.95 |
| 39 | $415.58 | $354.02 | $354.02 |
| 40 | $411.25 | $350.13 | $350.13 |
| 41 | $406.97 | $346.27 | $346.27 |
| 42 | $402.74 | $342.46 | $342.46 |
| 43 | $398.54 | $338.69 | $338.69 |
| 44 | $394.40 | $334.96 | $334.96 |
| 45 | $390.29 | $331.26 | $331.26 |
| 46 | $386.23 | $327.60 | $327.60 |
| 47 | $382.21 | $323.99 | $323.99 |
| 48 | $378.23 | $320.41 | $320.41 |
| 49 | $374.29 | $316.86 | $316.86 |
| 50 | $370.40 | $313.36 | $313.36 |
| 51 | $366.54 | $309.89 | $309.89 |
| 52 | $362.72 | $306.45 | $306.45 |
| 53 | $358.95 | $303.05 | $303.05 |
| 54 | $355.21 | $299.69 | $299.69 |
| 55 | $351.52 | $296.36 | $296.36 |
| 56 | $347.86 | $293.07 | $293.07 |
| 57 | $344.24 | $289.81 | $289.81 |
| 58 | $340.65 | $286.59 | $286.59 |
| 59 | $337.11 | $283.40 | $283.40 |
| 60 | $333.60 | $280.24 | $280.24 |
Dated clawback
Entered schedule
Example inputsCheck the marked fields to calculate the clawback.
- $1,463
- $2,925
- $1,200
| Schedule band | Second window |
|---|---|
| Recovery rate | 50% |
| Window | Trigger date | Recovery | Cash |
|---|---|---|---|
| 1: Day before | 30 Jan 2026 | 100% | $2,925 |
| 1: Boundary | 31 Jan 2026 | 100% | $2,925 |
| 1: Day after | 1 Feb 2026 | 50% | $1,463 |
| 2: Day before | 30 Jan 2027 | 50% | $1,463 |
| 2: Boundary | 31 Jan 2027 | 50% | $1,463 |
| 2: Day after | 1 Feb 2027 | 0% | $0 |
One-off commission
One-off result
Example inputsCheck the marked fields to calculate the commission.
- $1,000
- $1,000
- $0
Upfront Commission and the Aggregator Split
Upfront commission is the settled loan amount multiplied by the entered upfront rate. This commission calculator then applies the percentage you keep and subtracts your fixed upfront deduction. Existing trail balances earn no new upfront commission in this forecast.
For the starting $1 million of new settlements, a 0.65% rate excluding goods and services tax (GST) produces $6,500 gross upfront commission. Keeping 90% leaves $5,850. The $150 fixed deduction reduces retained upfront commission to $5,700.
Use the commission-eligible settlement amount from your agreement, including any net-of-offset adjustment. The same retained percentage applies to upfront and trail here. Fixed deductions come after that split and remain payable even when commission is zero.
Select the basis used by both commission rates. A 0.715% rate including 10% GST becomes 0.65% excluding GST after division by 1.1. Enter fixed deductions and operating costs excluding GST. The Moneysmart GST calculation explains this conversion for taxable amounts.
The starting rates, split and balance reductions are editable examples. Both balance reductions compound monthly. The forecast adds no further settlements and keeps fixed deductions payable for all 60 months.
Your figures stay in this page and are not saved between visits.
Enter your contract rates and goods and services tax (GST) basis.
After the split, fixed commission deductions and entered clawback. Excludes GST and operating costs.
Each year includes the balance reductions and your monthly deduction. Clawback cash is shown separately.
Mortgage Broker Trail Commission
Trail commission is forecast each month from the remaining eligible balance, multiplied by the annual trail rate and divided by 12. Your retained percentage applies next, followed by the fixed monthly deduction. The annual rows total each set of 12 months.
The forecast starts with your existing book plus the new settlements. The example combines $4 million of existing eligible balances with $1 million of settlements. At 0.15% annual trail, 90% retained and a $20 monthly deduction, the first year’s retained trail is $6,070.
Amortisation reduces balances through scheduled principal repayments. The annual principal-reduction setting approximates that effect with a constant percentage. Refinance or payout runoff then reduces the remaining balance separately. Both annual percentages convert to equivalent compound monthly reductions.
With 2% principal reduction and 10% runoff, 88.2% of the starting balance remains after a year. The example book closes year one at $4,410,000 and year five at $2,668,781. Its retained annual trail falls to $3,579 in year five.
These assumptions model a declining book without further lending. They do not reproduce each loan’s repayment schedule, lender day-count convention, offset movements or arrears rules. The Mortgage and Finance Association of Australia remuneration factsheet explains how upfront, ongoing trail and clawbacks work.
Clawbacks and Net Revenue
A clawback returns previously earned upfront commission. An early loan exit also removes future trail. The forecast shows those amounts separately so lost future revenue is not counted as cash you must repay.
Enter the original amount of one exiting loan within your new settlements, its exit month and the percentage of upfront commission recovered. The model applies your retained share to that recovery and leaves fixed fees unchanged. It stops trail on the loan’s remaining projected share from the exit month, after the general balance reductions.
For a separate example, enter $1 million of settlements, no existing book, 0.6% upfront and 0.12% trail. Keep 80%, set the upfront deduction to $100 and set monthly deductions and both annual reductions to zero. Before any exit, retained upfront commission is $4,700 and retained trail is $80 a month.
If a $500,000 loan exits in month 13 with 100% upfront recovery, the cash clawback is $2,400. Monthly retained trail falls to $40 from that month. Lost trail over the remaining 48 months is $1,920, and five-year retained commission after the clawback is $5,180.
The separate dated clawback calculator matches a refinance or full repayment to your entered contractual windows. Enter settlement and trigger dates, then set each window length and recovery percentage. Select whether each window includes its anniversary and whether recovery applies to gross upfront commission or your retained share.
The dated example uses a $500,000 loan at 0.65% upfront commission excluding GST, with 90% retained. Its first window recovers 100% through 12 months and its second recovers 50% through 24 months. A full exit just after the first anniversary produces $1,463 of repayment exposure. These editable percentages illustrate a contract, without prescribing any lender’s terms.
The boundary table shows the day before, on and after each window ends. With inclusive windows, the first boundary still recovers 100% and the following day recovers 50%. At the second boundary, recovery remains 50% before falling to zero the next day.
Windows use calendar-month anniversaries, clamped to the month’s last day when needed. Choose whether the boundary day belongs to the ending window. Use this model when your contract uses that convention. Partial repayments, hardship exemptions and contracts counting elapsed days need their own contractual calculation.
Future retained trail lost is an independent monthly estimate multiplied by your entered remaining period. At $50 a month over 24 months, it totals $1,200. That lost revenue is separate from the upfront repayment exposure and is never added to cash owed back. The dated calculation does not change the separate five-year forecast.
The event settings express your own contractual recovery terms. General runoff reduces future balances but triggers no additional cash clawbacks. This is a commission estimator for scenario planning. Actual aggregator remittance matching, delayed payments and account reconciliation belong in your commission records.
Using the Forecast in a Brokerage Budget
Compare retained commission with operating costs to see what the opening book and entered settlements can cover. The starting example produces $29,433 of retained commission over five years. At $1,000 a month, operating costs total $60,000 and the remaining amount is negative $30,567 before income tax.
The model records upfront commission in month one and clawback cash in the event month. Monthly net cash includes those events, while annual trail excludes them. The exported file includes all 60 monthly rows and the five annual totals as plain numbers.
Run separate scenarios for settlement volume, retention and loan exits. Multiplying future pipeline by a commission rate can overstate available income. Keep uncompleted applications outside this settled-book forecast, and allow for income tax and payment timing in your business cash budget.
Calculate a One-Off Commission
The one-off sales commission calculator multiplies a commissionable amount by your entered percentage, then subtracts your entered deductions. A fictional $100,000 amount at 1% produces $1,000 before deductions. Entering a $150 deduction leaves $850.
Use the commissionable amount your agreement defines and keep the same tax basis across amounts and deductions. This simple mode calculates a single linear commission. Ongoing mortgage trail and dated clawbacks remain separate calculations. Payroll, quotas, bonuses and tiered sales plans are outside this model.