---
title: Power Broker Report
description: Power Broker Report
---

[Skip to content](https://support.dealius.com/knowledgebase/power-broker-report#main-content)

[Submit a Support Request](https://support.dealius.com/knowledgebase/kb-tickets/new?hsLang=en-us)

[![Screenshot 2025-01-09 at 6.32.09 PM](https://support.dealius.com/hs-fs/hubfs/Screenshot%202025-01-09%20at%206.32.09%20PM.png?width=192&height=61&name=Screenshot%202025-01-09%20at%206.32.09%20PM.png)](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. [Accounting Reports](https://support.dealius.com/knowledgebase/user-guide?hsLang=en-us#accounting-reports)

# Power Broker Report

## A report showing sale or lease transactions within a selected date range, filterable by deal status, office, and property type.

**Overview**

The Deal Activity Report reflects sale or lease transactions within the selected date range. Dates are based on:

- **Close Date** — when Deal Status is set to Closed.
- **Estimated Close Date** — when Deal Status is set to Active or Pending Close.

Admin Assistants can access this report if the **Reports** toggle is enabled for their user account under *Admin \> Users & Roles \> Edit User*. Once enabled, individual reports can be selected from a dropdown. Deals the current user does not have access to are excluded from the report.

**Filters**

| Filter | Description |
| --- | --- |
| Format | Sales or Lease. |
| Date Range | Based on deal close date. |
| Deal Status | Active, Closed, or Pending Close. |
| Office | Offices within the Dealius instance. |
| Property Type | Multi-select dropdown. |

![](https://support.dealius.com/hs-fs/hubfs/SCR-20250930-lzyy-png.png?width=346&height=556&name=SCR-20250930-lzyy-png.png)

**Sale Format — Columns**

| Column | Description |
| --- | --- |
| Deal ID | Unique deal identifier. |
| Property Address | Main property address if no space is linked; space address (including Unit/Suite # if present) if a space is linked. |
| City | Property city. |
| State | Property state. |
| Zip | Property zip code. |
| Property Name | Name of the property. |
| Property Type | Main property type (not space type). |
| SF Sold | Square footage sold. |
| Number of Units | Pulled from Property Profile \> Info tab. |
| Land Size (Acres) | Property acreage. |
| Close Date | Deal close date. |
| Investment Sale | Yes or No. |
| Owner-Occupied | Yes or No. |
| Actual Cap Rate | Percentage value. |
| Buyer Rep Brokers | List of buyer rep brokers including outside brokers. Format: First Last, First Last (Company) for outside brokers. *Example: Amy Burke, John Smith (CBRE).* |
| Buyer Company | Company name of the buyer. |
| Seller Rep Brokers | List of seller rep brokers including outside brokers, in the same format as above. |
| Seller Company | Company name of the seller. |

---

**Lease Format — Columns**

| Column | Description |
| --- | --- |
| Deal ID | Unique deal identifier. |
| Property Address | Main property address if no space is linked; space address if a space is linked. |
| Floor/Suite # | If applicable. |
| City | Property city. |
| State | Property state. |
| Zip | Property zip code. |
| Property Name | Name of the property. |
| Property Type | Main property type. |
| Space Type | Customizable under *Admin \> Manage Data \> Data Values \> Space Type*. |
| Lease Type | Customizable under *Admin \> Manage Data \> Data Values \> Lease Type*. Values include: Assignment, Direct-New, Direct-Renewal, Sublease. |
| SF Leased | Square footage leased. |
| Close Date | Lease Execution Date or Deal Close Date. |
| Tenant Company | Company name of the tenant. |
| Tenant Rep Brokers | List of tenant rep brokers including outside brokers. Format: First Last, First Last (Company) for outside brokers. *Example: Amy Burke, John Smith (CBRE).* |
| Landlord Company | Company name of the landlord. |
| Landlord Rep Brokers | List of landlord rep brokers including outside brokers, in the same format as above. |
| Additional Lease Type | Customizable under *Admin \> Manage Data \> Data Values \> Additional Lease Type*. |

- [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://support.dealius.com/hs-fs/hubfs/Dealius-logo-blue.png?width=300&height=84&name=Dealius-logo-blue.png)](https://dealius.com/)

201 Specialty Point, Sanford, FL 32771

<https://www.facebook.com/DealiusCRE/> <https://x.com/DealiusCRE> <https://www.instagram.com/dealiuscre/> <https://www.youtube.com/@dealius6576> <https://www.linkedin.com/company/dealius>

Copyright © 2025,