Skip to content
  • There are no suggestions because the search field is empty.

Commissions Report

A guide to the Commissions Report, including available formats, filters, and field definitions.

The Commissions Report shows payments received for closed deals along with associated expenses. The report can be grouped by broker or office and is available in three formats: Company, House Broker, and Outside Broker.

  • Company format — Based on paid receivables. Includes paid and open payables associated with those receivables. House and Broker Expenses will be empty for receivables with open payables, and partial for receivables with partially paid payables.
  • Broker format — Based on paid payables only.
Filter Description
Format Company, House Broker, or Outside Broker.
Start/End Invoice Date Paid Available when Company format is selected.
Start/End Payable Date Paid Available when House Broker or Outside Broker format is selected.
Offices Available for Company format. Lists all offices the current user has access to.
Brokers Available for House Broker and Outside Broker formats. Lists brokers participating in deals the current user has access to.
Property Type Available for all formats.
Display Zero Payments Checkbox to include $0 payments within the selected date range. When checked, an additional option appears: Default Zero Payables to Invoice Paid Date — if selected, $0 payables are filtered by their associated receivable paid date instead of the payable due date.

Company Format — Field Definitions

Field Description
ID Deal ID.
Property Type Deal property type.
Space Type Space type, if applicable.
Date Paid Receivable paid date.
Rep Type Seller Rep, Buyer Rep, Landlord Rep, Tenant Rep, or Other Rep.
Deal Name Full deal name.
Seller / Landlord Seller or Landlord company name.
Buyer / Tenant Buyer or Tenant company name.
Property Address Property street address.
City Property city.
State Property state.
Brokers List of internal brokers participating in the deal.
Outside Brokers List of outside brokers, shown as company name with broker name in brackets.
Lease Type Lease type from Transaction Information. Empty for Sale and Other Rep deals.
SF Property square footage.
AC Property acreage.
Units Property units.
Transaction Total Total transaction value.
Total Commission House Gross.
Commission Paid Amount received per receivable.
% of Total Payment commission percentage.
Outside Commission Outside broker gross for brokers with House Paid = Yes, and outside brokers who share internal commission. Values are split by invoice.
Outside Commission Paid Sum of all payables paid to outside brokers with House Paid = Yes or who share internal commission.
Outside Expenses Sum of all expenses to be paid by outside brokers.
Amount Due Receivable amount due.
House Net House split dollar amount.
Broker Net Sum of all broker net values.
House % House Net as a percentage of Amount Due.
Broker Expenses Sum of internal broker expenses per payment.
House Expenses Sum of house expenses per payment.
Broker Net After Expenses Broker Net minus Broker Expenses.
House Net After Expenses House Net minus Broker Expenses minus Outside Expenses.

Broker Format — Field Definitions

Field Description
ID Deal ID.
Property Type Deal property type.
Payable Date Paid Payable paid date.
Office Office the deal belongs to.
Rep Type Seller Rep, Buyer Rep, Landlord Rep, Tenant Rep, or Other Rep.
Deal Name Full deal name.
Seller / Landlord Seller or Landlord company name.
Buyer / Tenant Buyer or Tenant company name.
Property Address Property street address.
City Property city.
State Property state.
Outside Brokers List of outside brokers, shown as company name with broker name in brackets.
Lease Type Lease type from Transaction Information.
SF Property square footage.
AC Property acreage.
Units Property units.
Transaction Total Total transaction value.
Total Commission Sum of commissions earned by internal brokers and outside brokers who share commission.
Deal % Broker commission percentage in the deal.
Broker Gross Broker commission amount.
Broker Net Broker split amount.
Broker % Broker split percentage.
Broker Expenses Internal broker expenses.
Broker Net After Expenses Broker Net minus Broker Expenses.
Commission Paid Payable amount received per receivable, to the broker after expenses.