All Collections
All About Reports
All About the Income Report
All About the Income Report
Alex Masterson avatar
Written by Alex Masterson
Updated over a week ago

The Income report was built for business owners looking to forecast their income. This report shows closed and forecasted transactions. All transactions with either a Closed (Settlement) Date or Forecasted Closed Date will appear on this report, regardless of whether the date occurred in the past.

In this report, you can quickly look at any date range to see your GCI, Net GCI, and even Net Income. You can also see any general expenses that were added under the Admin > Expenses tab. This is also a great place to quickly see the Net Agent Paid Income and Net GCI for each transaction.

You can also drill down and see much of this information at the agent level, which will let you know how much you are making from each agent within the designated date range.

Topics in this article:

How to Use the Report

Each time you adjust the drop-down filters at the top of the report, the report pulls up a new list of transactions and recalculates the data.

Explaining the Tiles at the Top of the Report

There are tiles found at the top of the Income report that show the breakdown of all the money you make, as it funnels from total volume to net income. In this section, we look at what each tile means and how each tile is calculated. Note that the number of tiles depends on whether you filter the report by team, by individual, by group, or by organization.

Count

What is "Count" in this report?

The orange number on this tile counts all closed and forecasted transactions within the date range specified in the report. Splits, outbound referrals, and rentals are included in this number. The smaller number at the bottom subtracts splits from the count.

How is this number calculated?

The Income report shows the number of transactions that have something entered into either the "Forecasted Closed Date" field or the "Closed (Settlement) Date" field. All transactions with either a Closed (Settlement) Date or Forecasted Closed Date will appear on this report, regardless of whether the date occurred in the past.

Volume

What is "Volume" in this report?

This tile shows the total amount of money made from the transactions listed in this report.

How is this number calculated?

This tile shows the sum of each transaction's "Transaction Amount" field.

GCI

What is "GCI" in this report?

This tile shows the total GCI for all the transactions listed in this report.

How is this number calculated?

This tile shows the sum of each transaction's "GCI" field.

GCI (after referrals)

What is "GCI (after referrals)" in this report?

This tile shows the sum of all adjusted GCI (after only referral adjustments have been made) for all transactions listed in this report.

How is this number calculated?

This tile takes the number from the GCI tile and factors in all the referral adjustments that are recorded in each transaction's Commission Form.

Deductions and Agent Income (admin only)

What is "Deductions and Agent Income" in this report?

This number is the sum of all agent income from the transactions listed in this report, as well as deductions recorded in the Commission Form.

How is this number calculated?

We add up all the values found in the "Deductions and Agent Income" column of this report. For more information on how this value is calculated for each transaction, see the section in this article called Explaining the Columns in the Report.

Net Agent Paid Income (agent only)

What is "Net Agent Paid Income" in this report?

This tile shows the sum of the agent's net income that was made from the transactions listed in this report. This number only factors in income made as the primary agent.

How is this number calculated?

We add up all the values found in the "Net Agent Paid Income" column of this report. For more information on how this value is calculated for each transaction, see the section in this article called Explaining the Columns in the Report.

Net GCI (admin only)

What is "Net GCI" in this report?

This tile shows the sum of what the team or brokerage has made from each transaction listed in this report.

How is this number calculated?

In this report, take the value in the GCI tile and subtract the value found in the Deductions and Agent Income tile.

Expenses (admin only)

ℹ️ Note: This tile is only visible when you filter the report by team. You can do this by selecting your team from the "Scope" drop-down at the top of the report.

What is "Expenses" in this report?

This tile shows the sum of all the expenses from the transactions listed in this report.

How is this number calculated?

We get this number by adding up all the expenses recorded under Admin > Expenses for any transaction that appears in this report.

Net Income (admin only)

ℹ️ Note: This tile is only visible when you filter the report by team. You can do this by selecting your team from the "Scope" drop-down at the top of the report.

What is "Net Income" in this report?

This tile shows the total amount of income you're forecasted to make within the specified date range of the report.

How is this number calculated?

In this report, take the value in the Net GCI tile and subtract the value found in the Expenses tile.

Explaining the Columns in the Report

Column Name

Where the Information Is Pulled From

ID

This column pulls in the ID found at the top of the Transaction Overview.

Transaction

This column pulls in info from the following form fields:

  • First Name

  • Last Name

Address

This column pulls in info from the following form fields:

  • Address Line 1

  • Address Line 2

  • City

  • State

  • Postal Code

Agent

This column pulls in info from the following form field:

  • Agent

Settlement/Forecasted Date

This column pulls in info from the following form fields:

  • Closed (Settlement) Date

  • Forecasted Closed Date

When both fields have a date entered in, the report shows the closed date. When there's no closed date, the report shows the forecasted date.

Transaction Amount

This column pulls in info from the following form field:

  • Transaction Amount

GCI

This column pulls in info from the following form field:

  • GCI

GCI (After Referrals)

This is the adjusted GCI after only referral adjustments.

You can find this value in the Commission Form. See the summary section below the Referral Adjustments section. The value in the "Adjusted GCI" field should match the value found under the GCI (After Referrals) column.

Deductions & Agent Income

In order to calculate this value, go to the transaction's Commission Form and do the following:

Add up...

  • Net Agent(s) Paid Income

  • Referral adjustments and pre-split adjustments deducted from the team GCI

    • these are "deduct" adjustments paid to another entity

  • Post-split adjustments deducted from the team/brokerage earnings

Then subtract...

  • Pre-split adjustments being paid to the team/brokerage

    • these are "add" adjustments that increase the team's GCI

  • Post-split adjustments adding to the team/brokerage earnings

Net Agent Paid Income

This number shows you how much the primary agent is paid after all splits and adjustments.

You can find this value in the Commission Form. In the Payments section at the bottom of the form, you can see the primary agent's net takeaway.

Net GCI

GCI column - Deductions & Agent Income column = Net GCI

Certified

If the transaction's Commission Form is certified, you'll see an orange checkbox.

Net GCI%

(Net GCI column / GCI column) x 100 = Net GCI%

Relevant Settings

Preference Settings

Go to Admin > Team Settings > Preferences to see preference settings. The following settings affect the Income report:

  • Include ROI expenses on the Income report

  • Allow TCs to view Income Report

Restriction Settings

Go to Admin > Team Settings > View Restrictions to see restriction settings. The following settings restrict who can see the Income report:

  • [Restrict] Agent View Of Income Report

  • [Restrict] ISA View Of Income Report

Did this answer your question?