Shiftmate
Real estate commission sharing table Excel template
Divide the agreed service fee into consultant share, office share and collection balance. Free commission tracking Excel file for real estate offices.
Prepared by:Shiftmate Product and Operations Team · Son kontrol:
Actual file previews
The images below are the actual data entry and executive summary pages of the workbook to be downloaded.
Step by step usage
Examine the example and prepare the blank file
Directly enter the finalized service fee for each transaction. The file does not derive the legal commission rate from the sales price. Write the advisor share as a percentage. The share is calculated on the total price; It does not mean actual payment authorization based on collection. Keep the contract and collection record separately. Use the yellow input fields on the tracking page; Do not change the blue formula fields. The sample sheet is filled with fictitious records and does not count towards the actual work total.
Write actual records in the yellow fields
Consultant share is service fee × entered rate, office share is service fee minus consultant share. Open collection is the subtraction of the total collected from the service fee. The ratio must be between 0% and 100%. If the collection exceeds the amount, a record check is requested. Upper totals show contractual shares and open collection separately; It does not show the bank balance. An empty mandatory field is distinguished from a real zero. Correct missing or incorrect records in the control column; Since these lines are excluded from the summary, do not use the total as a final report until the problem is resolved.
Fix control alerts and review summary
Compare the shares to the agreement. Also keep track of the uncollected amount.
What does this Excel file solve?
Divide the agreed service fee into consultant share, office share and collection balance. Free commission tracking Excel file for real estate offices. Directly enter the finalized service fee for each transaction. The file does not derive the legal commission rate from the sales price. Write the advisor share as a percentage. The share is calculated on the total price; It does not mean actual payment authorization based on collection. Keep the contract and collection record separately. Use the yellow input fields on the tracking page; Do not change the blue formula fields. The sample sheet is filled with fictitious records and does not count towards the actual work total.
What's inside the file?
Consultant share, Office share, Open collection. The file contains sample rows, canned formulas, data validation fields, risk colorings, and executive summary.
Calculation and control logic
Consultant share is service fee × entered rate, office share is service fee minus consultant share. Open collection is the subtraction of the total collected from the service fee. The ratio must be between 0% and 100%. If the collection exceeds the amount, a record check is requested. Upper totals show contractual shares and open collection separately; It does not show the bank balance. An empty mandatory field is distinguished from a real zero. Correct missing or incorrect records in the control column; Since these lines are excluded from the summary, do not use the total as a final report until the problem is resolved.
Worked example: Real estate commission sharing table: calculation example
The service fee is 60,000 TL. Consultant share is 40%. Collection is 30,000 TL. Result: Consultant share is 24,000 TL, office share is 36,000 TL and open collection is 30,000 TL.
Decisions that can be taken as a result of this
Compare the shares to the agreement. Also track the uncollected amount
Common usage mistakes
Considering the calculated share as the paid amount. Mixing prices with and without tax. Using the summary total as the final result without correcting the lines with control warnings
Limits and proper use
It does not calculate the statutory commission rate, tax or invoice. Includes single advisor share; Multilateral sharing should also be done. Calculated shares are not payment instructions. The file is prepared for 150 record lines. The parent summary includes all valid rows, regardless of filters. When capacity is full, open a new period copy; additional rows require the summary and validation ranges to be updated as well. There are no macros, external data connections or automatic notifications.
Compatibility and quality control
Two pages of this file were visually inspected; Formulas were recalculated and checked in empty, sample and incorrect entry scenarios. There was no separate device testing of the Excel desktop application. .xlsx without macro; formulas and drop-down lists are included in the file. The tracking page includes 150 preset record lines and a standalone Sample page. Prepared for desktop Excel; Check views and validations in other spreadsheet applications.
Scope of this file
This standalone file has been prepared for the real estate commission sharing table. It's not that Shiftmate automates this industry workflow; The application focuses on team, shift and timesheet management.
Relevant official and technical resources
Frequently asked questions
Should I enter the sales price?
No. Enter the service fee you agreed upon; The file does not derive a rate from the sales price.
Is the share calculated from the money collected?
No. It is calculated from the total agreed price. Check separately the collection and settlement terms for actual payment.
Is the commission rate automatically recommended?
No. You get the rate you will use from your own applicable agreement.
Do I need to create an account to download the file?
No. You can download the Excel file directly after creating a download request with your email address. Creating a workspace is not mandatory. If there is an area that does not meet your needs, you can request an edit via the contact form.