Ascendix TechnologiesOpen/Close Panel

CRM Consulting Services and Commercial Real Estate Software Since 1996

Open Search
  • Services
    • CRM Consulting
    • Dynamics 365 Consulting
    • Salesforce Consulting
    • Salesforce Implementation Services
    • Salesforce AppExchange App Development
    • Salesforce Integration Services
    • Software Development Outsourcing
    • Ascendix CRM Concierge Service
  • Products
    • Ascendix Search
    • AscendixRE CRM
    • AscendixRE Pricing
    • AscendixRE Capital Markets
    • AscendixRE Land
    • Composer
    • MarketSpace
    • Property Listings Website
  • Industries
    • Financial Services
    • Commercial Real Estate
  • About
    • Our Team
    • Meet Our CEO
    • Engagement Models
    • How We Work
    • Ascendix Videos
  • Clients
  • Blog
  • Contact
  • Login

All You Need to Know about Real Estate Commissions Calculation and Tracking

July 28, 2020

Learn more about different real estate commission types, commissions payout order, procedure on how to calculate and track real estate commissions split on a deal. Find real estate agent commissions calculator examples and four real-live commissions calculations scenarios. Also, watch a video included into this post below on how to track real estate commissions in your AscendixRE CRM system.

 

Table of Contents

  • Real Estate Commission Types
  • Commissions Payout Order
  • How to Calculate Real Estate Commissions Split on a Deal
  • Real Estate Agent Commission Calculator Examples

Real Estate Commission Types

 

AscendixRE supports a feature of real estate commission tracking software like commission calculations for multiple real estate roles:

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 that worked on the Deal and will receive a portion of the commission.

 

Real Estate Commission Types

 

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.

 

Real Estate Commissions Payout Order

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

 

How to Calculate Real Estate Commissions on a Deal

 

How to Calculate Real Estate Commissions Split on a Deal

 

Step 1. Calculate Company Gross Fee

 

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

 

How to Calculate Company Gross Fee

How to Calculate Company Gross Fee

 

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 %))

 

How to Calculate Co-Broker Split

How to Calculate 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 commission

How to calculate Inside Broker’s Net commission:

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

 

How to Calculate Inside Broker’s Net Commission

How to Calculate Inside Broker’s Net Commission 

 

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.

 

How to Calculate Company Net

How to Calculate Company Net

 

Step 3. Calculate Total Inside Commission

 

The Total Inside Commission is calculated as:

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

 

How to Calculate Total Inside Commission

How to Calculate Total Inside Commission

 

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.

 

Real Estate Commission Calculator

 

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: 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.

 

Enter Financial Forecasting Information

Enter Financial/Forecasting Information

 

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.

 

Calculate Company Gross Fee, Total Inside Commission and Company Net

Calculate Company Gross Fee, Total Inside Commission and Company Net

 

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 enter the real estate commissions data of Inside Broker you need to find Related List Quick Links widget on the right side of the screen and “Commissions” link there.

Create New Commission

Create New Commission

 

To add Commissions information, do the following:

1.     Click on “Commissions”,

2.     Click New,

3.     Choose Commission Type: Inside Broker,

 

Choose Inside Broker Commission Type

Choose Inside Broker Commission Type

 

4.     Click Next,

5.     Add the user who is receiving commission,

6.     Select User from the list,

7.     Select Fee Method,

 

Enter Inside Broker Commission InformationEnter Inside Broker Commission Information

 

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.

  1. Enter Fee Percent (or Amount),
  2. Add House Percent,
  3. Enter Direct Expenses, Other Expenses, or Other Description,
  4. 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.

 

Inside Broker’s Commission Record

Inside Broker’s 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.

 

Real Estate CRM consulting

Example #2: 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.

 

Company Gross Fee, Total Inside Commission, and Company Net of a Deal

Company Gross Fee, Total Inside Commission, and Company Net of a Deal

 

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,

 

Choose Co-Broker Real Estate Commissions Type

Choose Co-Broker Real Estate Commissions Type

 

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.

 

Select Fee Method and Fee Percent

Select Fee Method and Fee Percent

 

Step 3. Enter Analyst’s Commissions

 

1.     Click New,

2.     Choose Commission Type: Analyst,

 

Choose Analyst Real Estate Commission Type

Choose Analyst Real Estate Commission Type

 

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.

 

Enter Fee Method “By Amount” and Fee Amount

Enter Fee Method “By Amount” and Fee Amount

 

Step 4. Add Expense

 

1.     Click New,

2.     Choose Commission Type: Expense,

 

Choose Expense Real Estate Commission Type

Choose Expense Real Estate Commission Type

 

3.     Click Next,

4.     Select Fee Method “By Amount”,

5.     Enter Fee Amount – 1, 000,

6.     Click Save.

 

Enter Fee Method “By Amount” and Fee Amount

Enter Fee Method “By Amount” and Fee Amount

 

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

 

Company Gross Fee, Total Inside Commission, Company Net

Company Gross Fee, Total Inside Commission, Company Net

 

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: Real Estate Deal Calculation with Inside Brokers’ and Analysts’ Commissions

 

In this example you may 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:

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

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

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

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

 

Inside Brokers’ Real Estate Commissions Calculator

Inside Brokers’ Real Estate Commissions Calculator

 

Step 3. Enter Analysts’ Commissions

 

Analysts’ real estate commissions are the following

1st Analyst receives 17% fees,

2nd Analyst receives 8% fees.

Analysts’ Real Estate Commissions Calculator

Analysts’ Real Estate Commissions Calculator

 

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

 

Final Deal Commissions Calculations

Final Deal 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.

 

Sample of Company Fee Gross Report

Sample of Company Fee Gross Report

 

Read also: A Full Guide on How to Create Reports in Salesforce

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

 

Sample Company Gross Report on the Dashboard

Sample Company Gross Report on the Dashboard

 

Commission calculations is an unavoidable part of any deal life cycle, and the easier you can track and manage such small but significant processes like real estate agent commission calculations, the faster you can complete this life cycle and start a new deal. Still puzzled with Commissions tracking or looking for real estate commission tracking software? Ask our CRM consultants for additional guidance and tips.

Real Estate CRM software AscendixRE

 

Recommended For You:

  • AscendixRE Stacking Plan Software: All You Need To Know
  • Salesforce Approval Process: All You Need to Know
  • Salesforce Lightning Migration Guide: Why You Should…

AscendixRE CRM Blog Commercial real estate CRM Consulting

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

About us

  • About Ascendix
  • Our Services
  • Case Studies & Reviews
  • Ascendix Videos

Products

  • Ascendix Search
  • AscendixRE CRM
  • AscendixRE Capital Markets
  • AscendixRE Land
  • Composer
  • Commercial Property Listings Website

Contact Us

  •   +1 888-346-3276 Ext 2
  •   +1 972-889-8090
  •   Contact Sales
  •   Request Support
  •   Ascendix Corporate Office
    12222 Merit Drive Suite 1760
    Dallas, Texas 75251
  • Facebook
  • LinkedIn
  • Twitter
  • YouTube

© 2021 Ascendix Technologies. All Rights Reserved | Privacy Policy Sitemap

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Read MoreCookie settings
REJECTACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience. Read our privacy policy.
Necessary
Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

CookieTypeDurationDescription
__cfduid11 monthThe cookie is set by CloudFare. The cookie is used to identify individual clients behind a shared IP address and apply security settings on a per-client basis. It does not correspond to any user ID in the web application and does not store any personally identifiable information.
cookielawinfo-checkbox-advertisement01 yearThis cookie is set by GDPR Cookie Consent plugin. The purpose of this cookie is to check whether or not the user has given their consent to the usage of cookies under the category 'Advertisement'.
cookielawinfo-checkbox-analytics01 yearThis cookie is set by GDPR Cookie Consent plugin. The purpose of this cookie is to check whether or not the user has given the consent to the usage of cookies under the category 'Analytics'.
cookielawinfo-checkbox-necessarypersistent11 monthsThis cookie is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-non-necessarypersistent11 monthsWe use this cookie to store the user consent for the cookies in the category "Non Necessary".
csrftoken011 monthsThis cookie is associated with Django web development platform for python. Used to help protect the website against Cross-Site Request Forgery attacks
iopersistentSessionThis cookie is set by HeyOliver and it preserves user session state across page requests.
pctrk01 yearUsed to count page views by unauthenticated users against license usage.
PHPSESSIDpersistent1 yearThis cookie is native to PHP applications. The cookie is used to store and identify a users' unique session ID for the purpose of managing user session on the website. The cookie is a session cookies and is deleted when all the browser windows are closed.
viewed_cookie_policypersistent11 monthsThe cookie is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Analytics

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.

CookieTypeDurationDescription
__utma02 yearsThis cookie is set by Google Analytics and is used to distinguish users and sessions. The cookie is created when the JavaScript library executes and there are no existing __utma cookies. The cookie is updated every time data is sent to Google Analytics.
__utmb030 minutesThe cookie is set by Google Analytics. The cookie is used to determine new sessions/visits. The cookie is created when the JavaScript library executes and there are no existing __utma cookies. The cookie is updated every time data is sent to Google Analytics.
__utmc0The cookie is set by Google Analytics and is deleted when the user closes the browser. The cookie is not used by ga.js. The cookie is used to enable interoperability with urchin.js which is an older version of Google analytics and used in conjunction with the __utmb cookie to determine new sessions/visits.
__utmt010 minutesThe cookie is set by Google Analytics and is used to throttle the request rate.
__utmz06 monthsThis cookie is set by Google analytics and is used to store the traffic source or campaign through which the visitor reached your site.
_gapersistent2 yearsThis cookie is installed by Google Analytics. It registers a unique ID that is used to generate statistical data on how the visitor uses the website.
_gat_gtag_UA_76342539_1persistent1 minuteGoogle uses this cookie to distinguish users.
_gat_UA-76342539-1persistent1 minuteThis is a pattern type cookie set by Google Analytics, where the pattern element on the name contains the unique identity number of the account or website it relates to. It appears to be a variation of the _gat cookie which is used to limit the amount of data recorded by Google on high traffic volume websites.
_gidpersistent1 dayThis cookie is installed by Google Analytics. The cookie is used to store information of how visitors use a website and helps in creating an analytics report of how the wbsite is doing. The data collected including the number visitors, the source where they have come from, and the pages viisted in an anonymous form.
_uv_id02 yearsThe cookie is set by Slideshare.net. It collects data on the user's visits to the website, such as which pages have been read.
bcookiepersistent2 yearsThis cookie is set by linkedIn. The purpose of the cookie is to enable LinkedIn functionalities on the page.
browser_idpersistent1 yearA unique indentifier for the web browser
bscookie12 yearsUsed by the social networking service, LinkedIn, for tracking the use of embedded services.
cusidpersistent30 minutesThis cookie is set by Clickdimensions and is used to establish and continue a user session with the site. When a user views a page on the site, the script code attempts to update this cookie. If it does not find the cookie, a new one is written and a new session is established. Each time a user visits a different page on the site, this cookie is updated to expire in 30 minutes, thus continuing a single session for as long as user activity continues within 30-minute intervals. This cookie expires when a user pauses on a page on the site for longer than 30 minutes.
cuvid02 yearsThe cookie is set by ClickDimensions. This cookie is typically written to the browser upon the first visit to the site from that web browser. If the cookie has been deleted by the browser operator, and the browser subsequently visits the site, a new __cuid cookie is written with a different visitor unique ID. This cookie is used to determine unique visitors to the site and it is updated with each page view. Additionally, this cookie is provided with a unique ID that the application uses to ensure both the validity and accessibility of the cookie as an extra security measure.
cuvonpersistent30 minutesThis cookie is set by Clikdimensions and is used to signal the last time a visitor viewed a page. It expires in 30 minutes from set/update.  
GPS030 minutesThis cookie is set by Youtube and registers a unique ID for tracking users based on their geographical location
heyo_pPersistentRegisters a unique ID that is used to generate statistical data on how the visitor uses the website.
heyo_ssessionRegisters a unique ID that is used to generate statistical data on how the visitor uses the website.
ho_*-active_quickview_tabPersistentKeeps the current state of the web app and is set by HeyOliver.
ho_*-heyoliver_referrersessionThis cookie is set by HeyOliver and collects information of the user's referrer.
ig_did19 yearsThis cookie is set by Instagram.
li_sugrpersistent2 monthsLinkedIn Insight Tag, when IP address is not in a Designated Country
lisscpersistent1 yearUsed by the social networking service, LinkedIn, for tracking the use of embedded services.
UIDR01 yearThis cookie is set bu scorecardresearch.com. The cookie is used to tracks the users activity across the internet on the browser such as visit timestamp, IP address, and most recently visited webpages. and may the data send to 3rd party for analysis and reporting to help their clients better understand user preferences.
vuid02 yearsThese cookies are used by the Vimeo video player on websites.
YSC1This cookies is set by Youtube and is used to track the views of embedded videos.
Advertisement

Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.

CookieTypeDurationDescription
_fbppersistent2 monthsThis cookie is set by Facebook to deliver advertisement when they are on Facebook or a digital platform powered by Facebook advertising after visiting this website.
fr12 monthsThe cookie is set by Facebook to show relevant advertisments to the users and measure and improve the advertisements. The cookie also tracks the behavior of the user across the web on sites that have Facebook pixel or Facebook social plugin.
IDE12 yearsUsed by Google DoubleClick and stores information about how the user uses the website and any other advertisement before visiting the website. This is used to present users with ads that are relevant to them according to the user profile.
uid01 yearThis cookie is used to measure the number and behavior of the visitors to the website anonymously. The data includes the number of visits, average duration of the visit on the website, pages visited, etc. for the purpose of better understanding user preferences for targeted advertisments.
UserMatchHistorypersistent1 monthThis cookie is set by Linkedin and is used to track visitors so that more relevant ads can be presented based on the visitor's preferences.
VISITOR_INFO1_LIVE15 monthsThis cookie is set by Youtube. Used to track the information of the embedded YouTube videos on a website.
Functional

Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.

CookieTypeDurationDescription
langpersistent1 yearThis cookie is used to store the language preferences of a user to serve up content in that stored language the next time user visit the website.
lidcpersistent1 dayThis cookie is set by LinkedIn and used for routing.
mid09 yearsThe cookie is set by Instagram. The cookie is used to distinguish users and to show relevant content, for better user experience and security.
test_cookiepersistent11 monthsThis cookie is set by doubleclick.net. The purpose of the cookie is to determine if the users' browser supports cookies.
upersistent2 months
Save & Accept