Download a Pending Commissions Report

SUMMARY
The pending commissions report lists commission figures for pending transactions in a chosen time period.

Download a Pending Commissions Report

To download a pending commissions report:

  1. Click Reports from the top menu. 
  2. Click Pending Commissions from the Financials section of the left menu.
  3. Select the required filters. Select a Location (if the company has more than one location) and a Close Date range. 
  4. Select optional filters. Choose from the remaining optional filters to determine which transactions will be included in the report. Note that if an Acceptance Date range is specified, the report will filter on BOTH the Close AND Acceptance Date ranges entered.
  5. Click [Download Report]. 
  6. Open the resulting downloaded report in your spreadsheet software.

FAQ (Frequently Asked Questions)

  • Q: Why am I missing transactions on my Pending Commissions Report?
  • A: Only transactions that contain a Commission Disbursement Authorization, close date, and are set to a pending status will be included in the report. If you feel transactions are missing from a report, verify the following details on the transaction:
     
    • CDA: Confirm that a Commission Disbursement Authorization has been generated for the transaction. 
    • Close Date: Confirm the transaction has a “Close Date” and that it falls within the closing period selected for the report.
    • Acceptance Date: If you've entered an Acceptance Date range, confirm the transaction has an “Acceptance Date” and that it falls within the period you selected for the report.
    • Transaction Status: Make sure the transaction status is within a “Pending” status category.
    • Side or Label: Confirm the info on the transaction matches any applied filters for side or label.

Column Definitions

Sale Price

Amount entered as Sale Price on the transaction

Commission Basis

The basis amount on which commissions will be calculated (most commonly Sale Price).

Listing Volume

Total Sales Volume allocated to the Listing Agent(s) on the transaction.

Selling Volume

Total Sales Volume allocated to the Selling Agent(s) on the transaction.

Gross Commission

Total Commission before any off-the-top Referral Commission or Franchise Fees have been subtracted. (e.g. 3% Listing Side Commission x Sale Price + 3% Selling Side Commission x Sale Price)

Referral Commission

Total amount of Referral Commission being paid to in-house or external recipients. When calculated as a percentage, this is calculated as Gross Commission x Referral Commission percentage

Franchise Fee

Amount of off-the-top Franchise Fee being collected and paid to brokerage. When calculated as a percentage, this is calculated as (Gross Commission - Referral Commission) x Franchise Fee percentage.

Broker's Split of Commission

Broker's share of transaction's Net Commission + Broker share of In-house Referral Commission

Deductions from Broker

Total Deductions paid to external or in-house recipients from Broker's Split of Commission

Agent's Split of Commission

Agent(s) share of transaction's Net Commission (sometimes referred to as agent's Gross Commission) + agent's share of In-house Referral Commission

Agent Fees

Agent Fees paid to broker (will be broken down by custom Agent Fee name)

Total Agent Fees

Total of all Agent Fees paid to broker from Agent(s) Split of Commission 

Agents' Taxes

Taxes collected from Agent(s) Split of Commission

Deductions From Agents

Total deductions paid to external or in-house recipients from Agent(s) Split of Commission

Commissions Paid to Agents (incl. in-house referrals)

Calculated as: Agent's Split of Commission - Total Agent Fees - Agent's Taxes - Deductions From Agents

Client Fees to Brokerage

Total Client Fees collected from Buyer or Seller and paid to broker

Client Fees to Agents

Total Client Fees collected from Buyer or Seller and paid to agent(s)