---
title: Brokers - Export Earnings History
description: Brokers - Export Earnings History
---
[Skip to content](https://support.dealius.com/knowledgebase/brokers-export-earnings-history#main-content)
[Submit a Support Request](https://support.dealius.com/knowledgebase/kb-tickets/new?hsLang=en-us)
[](https://dealius.com/)
Open main navigation
Close main navigation
- [Submit a Support Request](https://support.dealius.com/knowledgebase/kb-tickets/new)
- [Contact us](https://support.dealius.com/knowledgebase/kb-tickets/new)
[Contact us](https://support.dealius.com/knowledgebase/kb-tickets/new?hsLang=en-us)
How can we help you?
- There are no suggestions because the search field is empty.
1. [Dealius Knowledge Base](https://support.dealius.com/knowledgebase?hsLang=en-us)
2. [User Guide](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us)
3. [Brokers](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#brokers)
# Brokers - Export Earnings History
## A guide to the Earnings History export, including column definitions for both split calculation methods.
**Overview**
The **Export Earnings History** button downloads an .xlsx file containing broker commission information for the selected fiscal year. The content and column structure of the export depend on the **Calculate Commission Splits Based On** setting in *Admin \> System Settings \> Environment Configuration*. This setting is only available to Super Admin role. Contact Dealius support for making any changed in this section.
---
**Columns — Split Based on Actual Close Date**
Lines are ordered by Actual Close Date, or by Estimated Close Date if no Actual Close Date exists.
| Column | Description |
| --- | --- |
| System Close Date | The actual close date of the deal. |
| Is House Referral | Yes/No — indicates whether the deal is a house referral. |
| Does House Referral Affect Split | Yes/No — indicates whether the house referral deal is included in the split calculation. |
| Deal ID | Unique deal identifier. |
| Broker Name | Name of the broker. |
| Broker Commission | Commission percentage. |
| Broker Gross | Value earned by the broker. |
| Broker Split Original | Split percentage applied automatically. |
| Broker Net | Broker net amount. |
| House Split | House split percentage. |
| House Net | House net amount. |
| Broker Cumulative | Total broker gross by fiscal year for each payment/payable (sum of current and all previous Broker Gross values in the associated FY). |
| Broker Paid Cumulative | Total broker gross for paid payables by fiscal year (sum of current and all previous paid Broker Gross amounts in the exported FY). |
---
**Columns — Split Based on Paid Date**
The export contains payables for closed deals, ordered by Paid Date (or Due Date if unpaid), then by System Close Date.
| Column | Description |
| --- | --- |
| System Close Date | The actual close date of the deal. |
| Is House Referral | Yes/No — indicates whether the deal is a house referral. |
| Does House Referral Affect Split | Yes/No — indicates whether the house referral deal is included in the split calculation. |
| Actual Payment Date | Date the receivable was paid. |
| Deal ID | Unique deal identifier. |
| Invoice ID | Associated invoice identifier. |
| Deal Type | Type of deal. |
| Representation Type | Rep type for the deal. |
| Square Feet | Property square footage. |
| Gross Commission | Commission percentage per payment. |
| Broker Gross Amount | Value earned by the broker per payment. |
| Broker Net Amount | Broker net per payment. |
| Due Date | Estimated payable payment date. |
| Payee | Broker name. |
| Paid Date | Date the payable was paid. |
| Broker Net Paid | Payable paid value. |
| Broker Split Original | Split percentage applied automatically. |
| Broker Split Custom | Adjusted custom split percentage. |
| House Split | House split percentage. |
| House Net | House net amount. |
| Broker Cumulative | Total broker gross by fiscal year for each payment/payable. |
| Broker Paid Cumulative | Total broker gross for paid payables by fiscal year for each payment/payable. |
---
> **Note:** If a broker participates in a dual rep deal on both sides and payments fall on the same date, the export groups payables by representation type within the same deal and date — Buyer/Tenant Rep payables appear first, followed by Seller/Landlord Rep payables. The same logic applies to split-level calculations.
- [User Guide](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#main-content)
- [People](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#people)
- [Comps](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#comps)
- [Tracker](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#tracker)
- [Closing & Deleting a Deal](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#closing-deleting-a-deal)
- [List of Deals](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#list-of-deals)
- [System Settings](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#system-settings)
- [Outlook Plug-in](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#outlook-plug-in)
- [Cashflow](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#cashflow)
- [Manage Data](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#manage-data)
- [Notifications](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#notifications)
- [Brokers](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#brokers)
- [Tasks](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#tasks)
- [Authorization / Login](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#authorization-login)
- [Adding a Deal](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#adding-a-deal)
- [Properties](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#properties)
- [Leaderboards](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#leaderboards)
- [QuickBooks Integration](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#quickbooks-integration)
- [Glossary & Formulas](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#glossary-formulas)
- [Accounting](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#accounting)
- [Listings](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#listings)
- [Accounting Reports](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#accounting-reports)
- [Deal Profile & Entries](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#deal-profile-entries)
- [My Settings](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#my-settings)
- [CRM Pro](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#crm-pro)
- [Dealia - AI](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#dealia-ai)
- [Outlook Sync](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#outlook-sync)
- [Public API](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#public-api)
- [SharpLaunch Integration](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#sharplaunch-integration)
- [Roles & Permissions](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#roles-permissions)
- [Reports](https://support.dealius.com/knowledgebase/reports?hsLang=en-us#main-content)
- [Reporting Videos & Tutorials](https://support.dealius.com/knowledgebase/reports?hsLang=en-us#reporting-videos-tutorials)
- [Login & Settings](https://support.dealius.com/knowledgebase/login-settings?hsLang=en-us#main-content)
- [Login & User Profile Settings](https://support.dealius.com/knowledgebase/login-settings?hsLang=en-us#login-user-profile-settings)
- [Tracker](https://support.dealius.com/knowledgebase/tracker?hsLang=en-us#main-content)
- [Broker Tracker Video & Tutorials](https://support.dealius.com/knowledgebase/tracker?hsLang=en-us#broker-tracker-video-tutorials)
- [Accounting](https://support.dealius.com/knowledgebase/accounting?hsLang=en-us#main-content)
- [Accounting Videos & Tutorials](https://support.dealius.com/knowledgebase/accounting?hsLang=en-us#accounting-videos-tutorials)
- [Deals](https://support.dealius.com/knowledgebase/deals?hsLang=en-us#main-content)
- [Deals Videos & Tutorials](https://support.dealius.com/knowledgebase/deals?hsLang=en-us#deals-videos-tutorials)
- [People](https://support.dealius.com/knowledgebase/people?hsLang=en-us#main-content)
- [People Videos & Tutorials](https://support.dealius.com/knowledgebase/people?hsLang=en-us#people-videos-tutorials)
- [Tasks](https://support.dealius.com/knowledgebase/tasks?hsLang=en-us#main-content)
- [Task Videos & Tutorials](https://support.dealius.com/knowledgebase/tasks?hsLang=en-us#task-videos-tutorials)
- [Dashboard](https://support.dealius.com/knowledgebase/dashboard?hsLang=en-us#main-content)
- [Dashboard Videos & Tutorials](https://support.dealius.com/knowledgebase/dashboard?hsLang=en-us#dashboard-videos-tutorials)
- [Properties & Listings](https://support.dealius.com/knowledgebase/properties-listings?hsLang=en-us#main-content)
- [Properties & Listings Videos & Tutorials](https://support.dealius.com/knowledgebase/properties-listings?hsLang=en-us#properties-listings-videos-tutorials)
[](https://dealius.com/)
201 Specialty Point, Sanford, FL 32771
Copyright © 2025,