Commercial Real Estate Commission Tracking: How It Works and What to Look For

Commercial real estate commission tracking should be simple. In many brokerages, it isn’t.

Commercial real estate commission tracking is the process of calculating, allocating, and monitoring broker compensation across the life of a deal. In practice, that can include co-broker deductions, analyst participation, house splits, tiered plans, invoicing, and payment tracking.

Commercial real estate also adds more complexity than many generic commission tools are built for. One deal may use a flat percentage. Another may depend on lease terms. Another may be calculated by dollars per square foot. Another may involve multiple deductions before the final payout is determined.

That is why commercial real estate commission tracking is best understood as a workflow, not just a calculator.

In this guide, we’ll cover:

• what commercial real estate commission tracking is
• why spreadsheets break
• how CRE commission calculations work
• how commission splits are tracked on a deal
• what to look for in commission tracking software

What Is Commercial Real Estate Commission Tracking?

Commercial real estate commission tracking is the process of recording how compensation is earned, split, adjusted, and paid across brokerage deals.

That usually includes:

• gross fee calculation
• co-broker and referral deductions
• analyst and inside broker allocations
• house split logic
• direct and indirect expenses
• net commission by participant
• reporting on company gross fee, total inside commission, and company net

In other words, commission tracking is not only about the final payout. It is about maintaining a reliable record of how compensation moves from deal economics to broker payout.

For CRE firms, that matters because compensation structures are often more nuanced than in standard residential models. Firms may need to account for lease commissions, investment sales, team-based participation, special deductions, and broker-specific plans in the same system.

 

Why Spreadsheets Break CRE Commission Tracking

Spreadsheets are often the first system brokerages use for commission tracking because they are easy to start with. But they become fragile as deal volume, broker count, and compensation complexity increase.

Manual overhead

Someone has to enter deal data, update formulas, track split changes, and verify final numbers manually. That is time your operations team should not be spending on repetitive reconciliation.

Errors that damage trust

Broker commissions are sensitive. If a split is wrong or an expense is applied incorrectly, the issue is not only financial. It affects broker confidence in the process.

No real-time visibility

Leadership, finance, and brokers all need visibility into what has been earned, what has been deducted, and what is still outstanding. Spreadsheets make that harder.

Double entry across systems

This is where many brokerages run into a bigger structural problem. If deal data lives in one CRM and commission tracking lives in another tool or spreadsheet, teams end up re-entering information, reconciling discrepancies, and managing multiple versions of the truth.

That is why the real decision is often not only which tool can calculate commissions, but whether commission tracking should live inside the broader CRM workflow.

For many CRE firms, one connected system from deal to payout is more reliable than managing commissions in a separate silo.

 

What Commission Tracking Actually Requires in CRE

Commercial real estate commission tracking is usually a multi-stage financial workflow. A reliable process often includes four stages:

1. Gross fee calculated

This can be based on a flat percentage, a lease-term structure, a dollar-per-square-foot model, or a flat amount.

2. Deductions applied

Before inside splits are finalized, firms may need to account for co-broker fees, referral fees, marketing expenses, analyst participation, or transaction-related costs.

3. House split determined

The house split may depend on the broker’s compensation plan, year-to-date production, or tiered thresholds rather than a fixed percentage.

4. Invoice and payment tracked

The final step is not just “calculate and forget.” Brokerages still need visibility into invoicing, payment status, voucher distribution, and reporting.

This is why many teams eventually outgrow spreadsheets. The challenge is not only math. It is managing a connected workflow accurately and consistently across the life of the deal.

To make that workflow more concrete, let’s look at how commission tracking is typically structured inside a CRE CRM. The examples below use AscendixRE to show how brokerages can track commission roles, payout order, and deal-level calculations in practice.

Common Commission Roles in a CRE Deal

In practice, commercial real estate commission tracking usually involves several participant types on a deal. In AscendixRE, these roles can be tracked through separate commission records so brokerages can calculate payouts more consistently and report on them more clearly.

Analyst − an Account or Contact acting as an Analyst for the Deal.

Co-Broker − an Account or Contact for a broker outside of your company that worked on the Deal and will receive a portion of the commission.

Expense − expenses related to closing the Deal such as marketing expenses, referral fees, etc.

Inside Broker − a User within your company who worked on the Deal and will receive a portion of the commission.

 

 

Commercial Real Estate Commissions Payout Order

 

• Co-Brokers are paid first.
• Expenses are paid second.
• Analysts are paid next.
• Inside Brokers are paid last from the remaining Gross Fee Amount.

 

 

If Inside Brokers have expenses, they will be subtracted from their total commission.

 

How to Calculate Commercial Real Estate Commissions Split on a Deal

The examples below show how these calculations can be tracked inside AscendixRE, a commercial real estate CRM built on Salesforce.

Step #1 – Calculate Company Gross Fee

The Company Gross Fee calculation gets the “Gross Fee Amount” from the Deal

 

 

as well as all the Co-Broker commission split records from this Deal.  The calculation is:

Company Gross Fee = Gross Fee $ * (1 – Sum (Co-Broker Split %))

 

 

The result from this calculation will be written back to the Company Gross Fee field on the Deal and will be shown as read-only. “Company Gross Fee” formula fields on all commission records tied to this Deal.

 

Step #2 – Calculate Company Net

 

“Company Net” calculation gets the “Gross Fee Amount” and the “Company Gross Fee” and the following groups of commission records for this Deal:

Deal Expenses − the “Amount” total from all “Expense” commission records for this Deal.

Analysts − the “Amount Percent” total from all Analyst commission records for this Deal.  The total percentage for the Analysts is taken from the “Company Gross Fee” to add to the Deal Expenses total.

Inside Broker’s Net Commission – to track this commission you need to consider the following calculations: Inside Broker Split %, House %, Direct Expenses, and Other Expenses.

• Inside Broker Split % − The “Fee Percent” total from all Inside Broker commission records for this Deal.
• House % − The “House” total from all Inside Broker commission records for this Deal.
• Direct Expenses − The “Direct Expenses” total from all Inside Broker commission records for this Deal.
• Other Expenses − The “Other Expenses” total from all Inside Broker commission records for this Deal.

 

 

How to calculate Inside Broker’s Net commission:

Inside Broker’s Net commission = Fee Percent – House – Direct Expenses – Other Expenses

 

 

The Company Net calculation is:

Company Net = Company Gross Fee – Deal Expenses – (Analysts and Inside Brokers Net Commissions)

The “Company Net” field is read-only and calculates upon save when any of the values above are changed.

 

 

Step #3 – Calculate Total Inside Commission

 

The Total Inside Commission is calculated as:

Total Inside Commission = Company Gross Fee ­­- (Deal Expenses and Analyst commissions).

 

 

This result is also shown as “Total Inside Commission” formula fields on all commission records tied to this Deal.

Watch a full video on how to track and calculate commercial real estate commissions below:

 

 

Step #4 – Calculate “Amount” and “Net Commission” by Commission Type

 

The “Amount” and “Net Commission” are calculated based on the commission type:

Co-Broker

Amount = Gross Fee Amount * Commission Fee Percent
Net Commission = Gross Fee Amount * Commission Fee Percent

Inside Broker

Fee Amount = Total Inside Commission * Fee Percent
Net Commission = Fee Amount – Fee Amount * House – Direct Expenses – Other Expenses

Analyst

Amount = Company Gross Fee * Fee Percent
Net Commission = Company Gross Fee * Fee Percent

Expense

Amount = Company Gross Fee * Fee Percent

The Commission Calculations are rigid and can’t be changed through configuration.

 

Commercial Real Estate Agent Commission Calculator Examples

 

Let’s see how to track real estate commissions by following the steps in the simple example below.

Example #1: Commercial Real Estate Deal Calculation with Inside Broker’s Commission

 

Step #1 – Enter Financial/Forecasting Information

 

1. Open Deal record,
2. Enter Gross Deal Value,
3. Choose Gross Fee Method, which is a percent or a flat amount,
4. Enter Gross Fee Percent if you chose percent OR Gross Fee Amount if you chose flat amount,
5. Click “Save”.

*Note: In the leasing space the Gross Deal Value would be the Total Rent over the period of years and in the sale space it would be the Sale Price of the property.

 

 

In this example below $2, 000, 000 is this entire Gross Deal Value and the commission or Gross Fee Percent is 3%.

The estimated Gross Fee Amount is $60, 000 that equals to 3% out of $2, 000, 000.

 

 

You can see that the sum in Gross Fee Amount is duplicated in Company Gross Fee, Total Inside Commission and Company Net.

The reason is we have not reduced this $60, 000 any further because we haven’t started tracking Brokers’ Commission Split and House Split or Co-broker’s commissions etc.

To learn how to enter Inside Broker’s commission, read the next step.

 

Step #2 – Add Inside Broker’s Commission

 

 

To add Commissions information, do the following:

1.     Click on “Commissions”,

2.     Click New,

3.     Choose Commission Type: Inside Broker,

 

 

4.     Click Next,

5.     Add the user who is receiving a commission,

6.     Select User from the list,

7.     Select Fee Method,

 

 

For example, Inside Broker was splitting this deal 80/20 with the House where she was getting 80% and the House was getting 20%.
Then you’d put in 20 for House but for a Fee Percent you’re going to be putting in not 80 but a 100 because Victoria is getting 100% of that 80% balance.

Another case if Inside Broker were splitting this deal with another Inside Broker let’s say 50\50. Then this Fee Percent would not be a 100 it would be 50. We’d need to create another Commission Record for the second person that was splitting that deal with her.

8. Enter Fee Percent (or Amount),
9. Add House Percent,
10. Enter Direct Expenses, Other Expenses, or Other Description,
11. Click Save.

In this example we put a 100 for Fee Percent and Save. It will bring us directly not to the Deal record but to the Commission record.

 

 

If we look at the numbers, we started off with $60, 000 that was the 3% of the $2, 000 000. Now that 80/20 split has reflected on the Company Net (income of the company where Inside Broker works) that resulted in 12 000$ because  Inside Broker is getting 48 000$ (Net Commission) and 20% ($ 12,000) goes in House.

It is one of the simplest scenarios of Commission Splits of the Deal.  Below are more complicated examples of real estate commission calculators.

 

 

Example #2: Commercial Real Estate Deal Calculation with Expenses, Analyst’s and Co-Broker’s Commissions

 

To this real estate deal scenario into the reality, we have to fill in financial information of the deal, analyst’s and co-broker’s fees and expenses amount.

 

Step #1 – Enter Financial/Forecasting Information

 

1. Open the Deal record,
2. Fill in Gross Deal Value − $ 1, 200, 000,
3. Choose Gross Fee Method −“By Percent”,
4. Enter Gross Fee Percent − 5%,
5. Click “Save”,

As a result, you get $60, 000 Gross Fee Amount, Company Gross Fee, Total Inside Commission, and Company Net.

 

 

Step#2 – Add Co-Broker’s Commissions

 

To enter commissions information, go to Related List Quick Links widget and click “Commissions” link. Then do the following:

1.     Click New,

2.     Choose Commission Type: Co-Broker,

 

 

3.     Click Next,

4.     Find an Account or a Contact to Add,

5.      Select Fee Method “By Percent”,

6.     Enter Fee Percent – 25,

7.      Click Save.

 

 

Step #3 – Enter Analyst’s Commissions

 

1.     Click New,

2.     Choose Commission Type: Analyst,

 

 

3.     Click Next,

4.     Find an Account or a Contact to Add,

5.     Select Fee Method “By Amount”,

6.     Enter Fee Amount – 9, 900,

7.     Click Save.

 

 

Step #4 – Add Expense

 

1.     Click New,

2.     Choose Commission Type: Expense,

 

 

3.     Click Next,

4.     Select Fee Method “By Amount”,

5.     Enter Fee Amount – 1, 000,

6.     Click Save.

 

 

And here is how the numbers have changed considering Co-Broker’s and Analyst’s fees together with Expenses:

 

 

The original amount of Company Gross Fee, Total Inside Commission, and Company Net was $ 60,000. After all the real estate commission calculations Company Gross Fee is $ 45,000, Total Inside Commission − $34,100, and Company Net − $34, 100. Below is more complicated real estate commissions calculator scenario.

Example #3: Commercial Real Estate Deal Calculation with Inside Brokers’ and Analysts’ Commissions

 

In this example, you may have one more multiple commission calculation scenario inside a particular deal. The beginning is the same, to start the calculations you need to enter financial information of the deal, then add Inside Brokers’ and Analysts’ fees.

 

Step #1 – Enter Financial/Forecasting Information

 

1. Open Deal record,
2. Enter Gross Deal Value − $ 1,500,000,
3. Choose Gross Fee Method − “By Percent”,
4. Enter Gross Fee Percent – 4%,
5. Click “Save”

Gross Fee Amount, Company Gross Fee, Total Inside Commission, and Company Net equals to $60, 000.

Step #2 – Add Inside Brokers’ Commissions

 

We enter deal commissions for 4 Inside Brokers:

1^st Inside Broker gets 25% Split Fee, 10 % goes in House,

2^nd Inside Broker gets 25% Split Fee, 15 % goes in House,

3^rd Inside Broker gets 25% Split Fee, 10 % goes in House,

4^th Inside Broker gets 25% Split Fee, 25 % goes in House, 1,000 is Direct Expenses.

 

 

Step#3 – Enter Analysts’ Commissions

 

Analysts’ real estate commissions are the following

1^st Analyst receives 17% fees,

2^nd Analyst receives 8% fees.

 

 

Let’s check how the numbers have changed after all the commissions calculations.

 

 

Company Gross Fee stays the same $60, 000 as before, Total Inside Commission are now $45, 000 and Company Net is $7, 750.

*Note: All the real estate commission calculations can be edited as long as the deal is still open. Another point to add is the Commissions are not really intended for invoice purposes. They are just meant for a tracking mechanism.

Further, you may use Commissions for reporting as a part of Company Gross Fee, Total Inside Commission, and Company Net.

 

 

 

And then this report can be placed on the Dashboard and re-used any time you need this report.

 

 

What to Look for in CRE Commission Tracking Software

If you are evaluating software, do not judge platforms only by whether they can “calculate commissions.” The better question is whether they can support how your brokerage actually works.

Integrated or separate?

If commission data lives in the same system as deals, contacts, and reporting, you eliminate a lot of double entry and reporting friction.

Can it handle your specific structures?

CRE firms often deal with leasing splits, flat fees, team allocations, and non-standard formulas. The system should support those scenarios without forcing your team back to spreadsheets.

Does commission tracking cost extra?

Some brokerages end up paying for a CRM and then paying again for a separate commission tool. That increases total cost and keeps commission data disconnected from the rest of the workflow.

Can your team adapt the process as the business changes?

Commission structures evolve. Your system should make it easier to update logic, reporting, and workflows as needed.

Does it support reporting and visibility?

Leadership, finance, and brokers all need clarity on what has been earned, deducted, and paid. Commission tracking should improve visibility, not create another back-office black box.

How AscendixRE Helps Track CRE Commissions

AscendixRE approaches commission tracking as part of a broader CRE workflow, not as an isolated back-office task.

Because it is built for commercial real estate and delivered on Salesforce, teams can manage deal data, broker activity, reporting, and commission tracking in one connected environment. That matters because commission tracking works best when it is tied to the same records where the deal was sourced, updated, and closed.

Instead of exporting deal data into a separate system, brokerages can keep calculations, participant roles, and reporting tied to the same CRM records. For firms dealing with variable commission structures, that can reduce double entry, improve visibility, and create a more reliable process from deal to payout.