Homelead blog

Broker Commission Management Software: Legs, Payouts, Cancellations

A commission model that survives month-end: three formulas, three legs per deal, receivable versus payable with fixed statuses, scope-based visibility and automatic voiding on cancellation, with worked examples in INR and AED.

11 min readBy the Homelead team
Broker Commission Management Software: Legs, Payouts, Cancellations

Broker commission management software replaces the month-end spreadsheet with one commission record per deal: the formula, who owes it, who is owed, and what has actually been paid. The model that holds up in practice has three parts: a formula (percentage of deal value, a fixed amount, or days of rent), separate legs for the owner side, the buyer side and any reference, and a status on each leg so a cancelled booking voids what was due instead of leaving it quietly in a column.

Key takeaways

  • Three formulas cover almost every brokerage deal in India and the UAE: percentage of deal, fixed amount, and days or months of rent.
  • Split every deal into legs: owner (seller or landlord), buyer (or tenant) and reference (referrer, co-broker or channel partner). Each leg is either receivable or payable and is settled on its own.
  • Receivable and payable are separate ledger rows with statuses, never one "commission" number.
  • Agents see their own legs, managers their reporting line, finance everything.
  • Cancellation voids due legs automatically and flags paid legs for clawback.
  • Month-end is a checklist against bookings, not a rebuild of the sheet.

Why do commission spreadsheets break at month-end?

A commission sheet starts as one row per deal with columns for value, rate and amount. It works for the first thirty deals and then fails for predictable reasons:

  • The formula lives in a cell. Someone overwrites it with a hard-coded figure for a "special case", drags it down, and the special case becomes the formula for every deal below.
  • Legs collapse into one column. A deal that earns 1% from the seller, 1% from the buyer and owes 20% of one side to a referrer becomes a single figure. When the referrer asks what they are owed, the maths is rebuilt from memory.
  • Nothing links the sheet to the booking. A booking cancelled in February still shows a paid commission in March because the person handling the cancellation does not own the sheet.
  • Visibility is all or nothing. Either the whole team sees everyone's earnings or nobody sees anything and agents message accounts every week.
  • There is no history. When a figure changes, nobody can see what it was before or who changed it.

Software fixes this only if its commission model is built around formulas, legs and statuses. A CRM with one "commission amount" box per deal is a spreadsheet with a login.

Which commission formulas does a brokerage actually need?

Three formulas cover nearly every deal a brokerage in India or the UAE does. Use one per leg and never a free-text amount.

Percentage of deal value

The standard sale commission. In India, resale brokerage is usually negotiated as a percentage from each side; in Dubai, a percentage of the sale price from the buyer is the normal arrangement on secondary sales, and developers pay channel partners a percentage on off-plan units. Define the base clearly: the agreed price on the booking, not the list price and not the amount collected so far.

Fixed amount

A flat fee agreed up front: a referral fee, a finder's fee on a plot, or a fixed sum agreed with a developer for a launch. It does not move with price, so a renegotiation after booking leaves it unchanged.

Days or months of rent

Leasing commissions are quoted in rent time rather than percentages: fifteen days of rent from each side in many Indian cities, one month on a longer lease, or a percentage of annual rent in Dubai. Storing "15 days" as the formula means a rent revision at renewal recomputes correctly instead of someone recalling the old number.

Formula Typical use Base Watch out for
Percentage of deal Sales, resale, off-plan Agreed price on the booking Base changes if price is renegotiated
Fixed Referral and finder's fees, flat developer deals None Must still be tied to a booking so it can be voided
Days / months of rent Leasing Monthly rent on the lease Renewal at a new rent needs a new leg

If you run leasing alongside sales, the leasing CRM guide for Dubai brokerages covers how the lease record should feed rent-based commission.

What are the legs of a commission on a single deal?

A deal is not one commission; it is a small set of obligations pointing in different directions. Treat each as a leg with its own formula, counterparty, amount and status.

Owner leg

What the seller or landlord pays you for bringing the buyer or tenant. Receivable to the brokerage. Common on Indian resale and leasing; often zero on a Dubai secondary sale where the seller has their own broker.

Buyer leg

What the buyer or tenant pays you. Receivable. This is the main leg on most Dubai sales and on Indian leasing deals.

Reference leg

What you owe a third party for the lead: a referrer who passed the number, a co-broker on the other side, or a channel partner when you are the developer. Payable from the brokerage. Capture the reference person and the agreed reference commission at lead stage, because by booking time nobody remembers who sent the lead. Developers paying partners should read the channel partner management guide for the onboarding and allocation side.

Receivable versus payable

Receivable legs are money coming in and sit next to your invoices. Payable legs are money going out and sit next to your expenses. Net brokerage is receivable minus payable, and your internal agent payout policy should be applied to that net figure, not to the deal legs. Keep the agent split out of the deal record: it is an incentive matter computed on net, and mixing it into deal legs is how agents end up seeing each other's earnings.

Worked example 1: Indian resale (illustrative)

A 3 BHK resale in Pune, agreed price ₹1.2 crore.

Leg Formula Direction Amount
Owner 1% of deal Receivable ₹1,20,000
Buyer 1% of deal Receivable ₹1,20,000
Reference 20% of buyer leg Payable ₹24,000

Gross receivable ₹2,40,000, payable ₹24,000, net brokerage ₹2,16,000. A GST-registered brokerage charges GST on top of each receivable invoice, and the referrer's payment may attract TDS under section 194H; confirm current rates with your accountant or at the Income Tax Department.

Worked example 2: Dubai secondary sale (illustrative)

An apartment in JVC sold at AED 2,000,000. You represent the buyer, another brokerage represents the seller, and a 50:50 co-broking split is agreed.

Leg Formula Direction Amount
Buyer 2% of deal Receivable AED 40,000 plus VAT at the standard rate
Owner None — AED 0
Reference (co-broker) 50% of buyer leg Payable AED 20,000

Net brokerage AED 20,000 before internal payout. VAT on brokerage services follows the Federal Tax Authority's rules at tax.gov.ae, and the broker's registration details should sit on the deal file as the Dubai Land Department requires.

Worked example 3: lease (illustrative)

A Jaipur flat let at ₹25,000 per month with 15 days of rent from each side: tenant leg ₹12,500 receivable, owner leg ₹12,500 receivable. At renewal with rent revised to ₹27,500, a fresh pair of legs recomputes to ₹13,750 each because the formula is stored, not the number.

How should receivable and payable move through statuses?

Every leg needs a status, and the permitted moves should be fixed so money cannot be undone silently.

  • Due: the booking is confirmed and the formula has produced an amount.
  • Paid: money moved, with date, mode and reference. A receivable leg can be paid in parts; store each part as its own receipt against the leg.
  • Cancelled: voided before any money moved, with a reason.
  • Failed: a bounced cheque or failed transfer; the leg stays due.
  • Refunded: reachable only from Paid, with reason and amount.

The rule that matters: nothing goes from Paid back to Due by editing a cell. A paid leg that was wrong becomes a refund plus a new leg, and both rows stay visible. That is also what an auditor wants: a trail, not a corrected total. Tax belongs on the leg too; store the tax amount and whether tax is included in or added to the formula result, so the invoice view and the net figure agree.

Who should be able to see commission figures?

Scope visibility is the difference between a commission system agents trust and one they route around.

Role Should see Should not see
Agent Legs on their own bookings, status, what was paid and when Other agents' deals, company-level payables
Team lead or branch manager All legs in their reporting line, summaries by agent Other branches
Finance or owner Everything, including payables, refunds and change history —

Tie visibility to the reporting line rather than a separate commission permission list, so that moving a user to another team moves their visibility with them. Any change to a leg (amount, status, payee) should be logged with before and after values and the user who made it. The agent performance and commission tracking guide goes deeper on the manager's view.

What happens to commission when a booking is cancelled?

Cancellation is where spreadsheets lose the most money, because commission is often paid out before the deal has actually closed.

  1. Void every due leg automatically. When the booking is cancelled, legs still at Due move to Cancelled with the cancellation reason attached. Nobody should need to remember this.
  2. Flag every paid leg. A reference leg already paid becomes a clawback conversation; a receivable already collected may need a refund net of a deduction. The system should surface these, not hide them.
  3. Record the cancellation itself. Reason, refund amount to the customer, deduction or cancellation charge, and supporting documents.
  4. Keep the history. The cancelled booking and its voided legs stay in the ledger so quarter-end still reconciles.

Add a one-line timing policy: pay reference and partner legs only after the linked receivable is collected, or after the agreement is registered. This single rule removes most clawbacks.

How do you reconcile commissions at month-end?

With formulas, legs and statuses in place, month-end becomes a checklist.

  • List every booking confirmed in the month; confirm each has its legs created and the formula base matches the agreed price.
  • Receivable legs still at Due: chase, and check whether the booking has stalled.
  • Payable legs at Due: release only where the linked receivable is Paid, per your policy.
  • Cancellations in the month: confirm due legs were voided and paid legs flagged.
  • Partial payments: confirm the sum of receipts equals the amount marked paid.
  • Refunds: each has a reason and a matching outgoing entry.
  • Export the commission statement and the change history for the accountant.
  • Compare commission received with revenue booked; a widening gap is usually uncollected buyer legs, not a sales problem.

How Homelead handles broker commissions

Homelead uses one commission formula everywhere: Percentage of deal, Fixed, or Days/Month of rent, applied to sales and leases alike. Each booking carries three legs, owner, lead (the buyer or tenant) and reference, and each leg is payable separately. The reference name, phone and reference commission are fields on the lead itself, so a referral is captured when the lead arrives rather than reconstructed at booking.

The Finance → Commission tab shows agreed versus paid for every deal, lets finance mark a leg as paid or record a refund, and gives a summary split into receivable and payable. Commission due and received also appear on the dashboard. Visibility follows the user's scope: an agent sees their own, a manager their reporting line, an admin all of it.

Commission Payments table listing leads with commission amount, commission type, payment status and actions to receive or mark paid
Commission payments in Homelead, tracked per deal by type and status

Commission entries sit in the same ledger as the rest of the company's money, with the status graph Due → Paid / Cancelled / Failed and Paid → Refunded, so a payment cannot be undone by editing. Delete is an archive with restore, and the Audit Logs screen records who changed a commission payment with before and after values (see security). When a broker records a Cancel & Refund on a booking, with reason, refund amount, deduction and attachments, the due commissions on that booking are voided. Statements export to CSV and PDF, and the ledger filters by payee, lead, broker, project, branch and date.

For builders, the Channel Partners master stores each partner's commission percentage and project allocation, and commission payments track the legs per deal. Broker management, commissions and payouts are included in every plan; see Homelead pricing. To see the Commission tab working on your own bookings, book a 20-minute online demo on your own data, or message +91 72400 44472 on WhatsApp.

Frequently asked questions

What is broker commission management software?

It is the part of a real-estate CRM or finance tool that stores a commission formula per deal, splits it into receivable and payable legs (owner, buyer, reference), tracks each leg's status from due to paid or refunded, and voids due legs when a booking is cancelled, so commissions are computed from bookings rather than rebuilt in a spreadsheet.

Should agent splits be stored on the deal?

No. Store the deal legs (what the brokerage receives and pays) on the booking and compute the agent's share separately from net brokerage under your incentive policy. Mixing agent splits into deal legs exposes one agent's earnings to another and makes clawbacks messy.

How do you handle GST or VAT on commission?

Record the tax amount on each leg and state whether the formula result is inclusive or exclusive of tax. In India a registered brokerage charges GST on its commission invoices and commission paid to referrers may attract TDS under section 194H; in the UAE brokerage services are subject to VAT under FTA rules. Confirm current rates with your accountant.

What should happen to a referral fee when the booking is cancelled?

If the fee is still due, it should be voided automatically with the cancellation reason. If it was already paid, the system should flag it for clawback or a refund entry. A policy of paying referral and partner legs only after the receivable is collected avoids most of these cases.

Can a brokerage doing both sales and leasing use one commission model?

Yes, provided the formula set includes days or months of rent alongside percentage and fixed. The legs stay the same: owner (landlord), buyer (tenant) and reference, and the lease's monthly rent is the base for rent-time formulas.

How often should commissions be reconciled?

Monthly against confirmed bookings, with a weekly glance at receivable legs still at Due and at cancellations. Monthly reconciliation keeps partner payouts and agent incentives tied to money actually collected.

Keep reading

  • Real Estate CRM for Developers in Bangalore: A Buying Checklist

    Bangalore developers sell through large channel-partner networks, to IT-professional and NRI buyers, with site visits packed into weekends. This guide turns those realities into a CRM checklist you can run in a demo.

    12 min read · Bangalore, Real Estate CRM
  • Channel Partner Management for Builders: Onboarding to Payouts

    An end-to-end operating model for builders who sell through channel partners: partner master, inventory access, lead registration, booking requests, payout legs and a dispute rule set your team can apply without arguments.

    13 min read · channel partners, builder CRM
  • CRM for Builders: 25 Features to Check Before You Sign (Checklist)

    A printable 25-point evaluation checklist for builders choosing a CRM, grouped by unit inventory, booking controls, CLP collections, channel partners and audit logs, with a demo test for every item so you score vendors instead of trusting feature lists.

    12 min read · CRM for builders, builder CRM checklist

Latest posts