Real estate commission tracker for UAE brokerages

Why commission tracking goes wrong

In a brokerage, commission is both the revenue and the main source of friction. The money arrives late and in pieces, especially on off-plan sales (property sold before it is built) where the developer, the company building the project, pays on its own schedule. Splits differ by agent, by deal type and sometimes by deal. Co-broker deals (where two brokerages share one sale) add a second company to the maths. And agents keep their own mental ledger of what they are owed, which rarely matches yours.

A tracker does not fix a disagreement about the split. It does remove the argument about the facts: what was agreed, what has come in, and what is still outstanding.

A note before the layout. I am not stating commission rates, how VAT applies, or what the law says about who may be paid. VAT is value-added tax. Those depend on your agreements and on UAE rules. Confirm with your accountant and the relevant authority. The tracker records what you have agreed, whatever that is.

The layout

Use two sheets, linked by a deal number.

Sheet 1: Deals

• Deal no. A unique number.
• Date closed and Type (off-plan sale, secondary sale, rental, co-broke).
• Project / property and Client.
• Sale price and Commission basis (percentage or fixed fee, as agreed in writing).
• Gross commission (calculated: price times percentage, or the fixed fee).
• Payer (developer, seller, buyer, other brokerage).
• Expected date and Status (invoiced, expected, part-received, received).
• Received amount and Received date.
• Outstanding (calculated: gross minus received).
• Invoice no. and a link to the agreement.

Sheet 2: Splits

One line per person per deal.

• Deal no. (links to Sheet 1)
• Person (agent, team leader, referrer, co-broker company)
• Role and Share (percentage of the brokerage's commission)
• Amount due (calculated from what has actually been received, not the gross)
• Paid, Paid date, Balance owed

The design choice that matters: calculate the share from what has been received, not from what is expected. That way an agent's "amount available to pay" never runs ahead of the cash.

Formulas that help

• Gross commission: =IF(basis="Percent", price*rate, fixed_fee).
• Outstanding: =gross-received.
• Share of received: =received_amount*share_percent, using a lookup on the deal number to pull the received amount from Sheet 1 (XLOOKUP or VLOOKUP).
• Total per agent this month: =SUMIFS(due_column, person_column, "Name", date_column, ">="&start, date_column, "<="&end).
• Check that shares per deal add to 100 percent: =SUMIF(deal_col, deal_no, share_col), flagged if not equal to 1.

A worked example

These figures are made up purely to show the mechanics. They are not typical rates and not advice.

Deal 0412 is an off-plan sale. The brokerage's gross commission, agreed with the developer, is AED 60,000. The developer pays in two parts: AED 30,000 now and AED 30,000 later on a stated trigger. The splits agreed in writing are 50 percent to the selling agent, 10 percent to the team leader, and 40 percent to the brokerage.

Person	Share	Due on AED 30,000 received	Due on full AED 60,000
Selling agent	50%	15,000	30,000
Team leader	10%	3,000	6,000
Brokerage	40%	12,000	24,000

After the first receipt, the agent can see AED 15,000 payable now and AED 15,000 still to come once the developer pays the second part. Your sheet shows an outstanding balance of AED 30,000 on the deal and the expected date for it. Nobody has to ask.

Whether you pay out the agent's first share before the second part arrives is your policy. The tracker just makes the policy visible.

Co-broker deals

Add the other brokerage as a "person" in the splits sheet with their agreed share, and mark the payer correctly. Record who invoices whom. Attach the written agreement, because co-broker splits are where memory fails first. A fuller ledger for these deals is in co-broke and referral deal tracking in Dubai.

Where software and AI can help

Most of this is rules and arithmetic, so it is a software job, not an AI job. Once the sheet works, the next step is a small web app. I build this as an Excel to web app project (Excel is Microsoft's spreadsheet program): the same two sheets become a database, the formulas become automatic, and agents log in to see their own commission only. That is a commission portal, which is a flavour of client portal where the clients are your agents.

What the software does: calculates every share from receipts, lists what is overdue from each payer, sends a reminder to your finance person when an expected date passes, and gives each agent a statement. A manager view shows total outstanding, total received this month and top earners, much like a KPI dashboard.

What AI can add, carefully: reading a developer's commission statement or an agreement and drafting the rows for your review, or writing a plain-language reminder to a developer's accounts team. A person must check any extracted figure against the document. AI should not decide splits, interpret contracts or approve a payment.

Do it yourself with Claude: Claude is an AI assistant you can use in a browser. Paste a commission statement (with names removed) and ask: "List each deal, gross commission, amount paid, date and anything unclear. Return it as a table I can paste into a spreadsheet." Check every row against the original.

When to move out of the spreadsheet

• Agents regularly ask you what they are owed.
• More than one person updates the sheet.
• You pay on receipt and need the split to follow the cash exactly.
• You have lost track of an unpaid developer commission at least once.
• You want agents to see their own numbers without seeing everyone else's.

Common mistakes in commission tracking

• Splits living in people's heads. Each agent's split should be written down and linked to the deal, including any change agreed part-way. A split changed over WhatsApp and never recorded is the cause of most disputes.
• One total column. If the sheet only shows "commission" with no gross, received and outstanding, you cannot tell money earned from money in the bank.
• No expected date. Without it, you cannot see which payer is late. Developer commission in particular can be tied to stages of the buyer's payments, so record the trigger as well as the date.
• Mixing currencies and taxes. If a deal involves anything other than dirham, or amounts with and without tax, label the column clearly and ask your accountant how to treat them.
• Letting agents edit their own lines. Agents should see their numbers, not change them. In a spreadsheet that is hard to enforce, which is another reason to move to a portal with read-only agent views.
• No monthly close. Once a month, lock the previous month, reconcile received amounts against the bank, and send each agent a statement. A tracker that is never reconciled is a list of hopes.

The monthly statement is worth doing even in a spreadsheet: one page per agent listing each deal, the share, what was paid and the balance owed. It builds trust, and it is the first thing a portal automates for you.

VAT, referral fees and what the brokerage really keeps

Two sources I read, a PropSpace guide for brokerages and an accounting firm's page for real estate companies, both warn about the same trap: commission booked as one gross figure with VAT mixed in. PropSpace states that 5 percent VAT applies to commission in the UAE and suggests the tracker adds it before invoicing. I have not confirmed that on the Federal Tax Authority site, and VAT treatment differs by deal type, so confirm the rate and how it applies to each deal type with your accountant. What I can say is the layout: add separate columns for commission before VAT, VAT, and the invoice total, so the split is calculated on the right base. Your agreement says whether splits apply before or after VAT; record which.

The same accounting page makes a useful point with a worked example: after VAT, the agent share and a referral fee, what the agency keeps can be well under a third of the headline commission. Here is my own illustration with made-up numbers, not typical rates. Commission before VAT AED 40,000. Agent split 50 percent, AED 20,000. Referral fee to an outside referrer AED 5,000. Brokerage keeps AED 15,000 before its own costs. Add a "referral fee" line to the Splits sheet and a "brokerage net" column to the Deals sheet, so the owner sees the number that pays the rent, not the headline.

Deals that fall through after commission is booked

The sources I read do not cover this, so treat it as my suggestion and check your agreements. Decide in advance what happens if a buyer defaults or a sale is cancelled after the developer or seller has paid part of the commission, and whether an agent who has been paid must return any of it. Put the rule in the written split agreement. In the tracker add a status of "cancelled" or "refund due" and a column for any amount to be returned, so the sheet never shows a cancelled deal as income. If you do not set this rule up front, you will make it up under pressure on the first deal that collapses.

Month-end reconciliation checklist

1. Every invoice raised matches a deal row, and the amount matches the agreement.
2. Every receipt in the bank is assigned to a deal and a date.
3. Every share paid out is traced to a receipt, not an expectation.
4. Any customer deposit or trust money you hold stays in a separate record from commission income. The accounting page warns against mixing escrow funds with operating cash.
5. Off-plan deals with staged payments are reviewed against the trigger for the next instalment.
6. Agents get their statement, and any query is logged against the deal.

What the owner wants versus what the agent wants

The owner wants cash forecast: what is owed, by whom, by when, and what the brokerage nets. The agent wants a statement they can trust: which deals, what share, what paid, what balance. Build both views from the same two sheets and do not let either see more than they need. If an agent can see everyone's split, you will have a different argument.

How I would approach this

Start with the two-sheet layout and fill in the last three months of deals. If that exercise finds money you had forgotten to chase, you have your answer on whether to invest more. Keep the written split agreement for each agent in one folder and link it in the sheet. Then, only if the sheet is straining, move it to a portal. The accounting itself, including VAT, stays with your accountant.