The CTS Web Reports widget allows users to run reports related to the ‘Commission Tracking System’ module. This document covers the CTS Web Reports which can be run for/by a Manager, Team Leader, or Admin/Support staff.

Reports

Accrual Detail Report [SSRS]

This report contains a breakdown of Deal related (i.e. Invoice or Payment) accounting activity by Vendor for a specific accounting period. You can also use it to view the entire history of accounting activity on an invoice or deal. It contains Vendor, Invoice, Payment, Contact, and Deal details for every accounting action (Billing, Adjustment, Payment or Void). Each row represents either the gross or net allocation or reversal amount for a specific Vendor / Account for the action performed. When grouped, subtotals are summarized at the bottom of each group.

Report Fields:

• Action Type - Indicates which accounting process is reflected in a given row. Options:

  • Commission Expense - When an Invoice is created / billed, adjusted, or voided: The net commission estimate or reversal for each party entitled to a share of the fees.

  • Invoice Adjustment Allocation - When an invoice is adjusted: The proportional gross commission reversal or reallocation of the (adjusted) Invoice amount to each party entitled to a share of the fees.

  • Invoice Allocation - When an Invoice is created / billed: The proportional gross commission allocation of the Invoice amount to each party entitled to a share of the fees.

  • Invoice Void Allocation - When an Invoice is voided: A reversal of all gross commission amounts that were originally allocated to each party when the associated Invoice was created / billed or last adjusted.

  • Payment Gross Allocation - When a payment is applied: The actual gross commission amount distributed to each recipient for this Payment.

  • Payment Net Adjustment - When a payment is applied: The Net Adjustment/Expense amount distributed from one Vendor or Account and to another.

  • Payment Net Allocation - When a payment is applied: The actual net commission distribution amount distributed to each recipient for this Payment.

  • Payment Void Gross Allocation - When a payment is voided: A reversal of the original gross commission amount distributed to each recipient when the associated Payment was applied.

  • Payment Void Net Adjustment - When a payment is voided: A reversal of The Net Adjustment/Expense amount distributed from one Vendor or Account and to another when the associated Payment was applied.

  • Payment Void Net Allocation - When a payment is voided: A reversal of the original net commission amount distributed to each recipient when the associated Payment was applied.

• Action Type Detail - A more specific indication of which accounting process is reflected in a given row. Options:

  • Invoice Adjustment Recreation Allocation - When an invoice is adjusted: The proportional gross commission allocation of the (adjusted) Invoice amount to each party entitled to a share of the fees.

  • Invoice Adjustment Recreation Commission Expense - When an invoice is adjusted: The new net commission estimate for each party entitled to a share of the fees.

  • Invoice Adjustment Reversal Allocation - When an invoice is adjusted: A reversal of all gross commission amounts that were originally allocated to each party when the associated Invoice was created / billed or last adjusted.

  • Invoice Adjustment Reversal Commission Expense - When an invoice is adjusted: A reversal of all net commission amounts that were originally estimated for each party when the associated Invoice was created / billed or last adjusted.

  • Invoice Allocation - When an Invoice is created / billed: The proportional gross commission allocation of the Invoice amount to each party entitled to a share of the fees.

  • Invoice Commission Expense - When an Invoice is created / billed: The net commission estimate for each party entitled to a share of the fees.

  • Invoice Void Allocation - When an Invoice is voided: A reversal of all gross commission amounts that were originally allocated to each party when the associated Invoice was created / billed or last adjusted.

  • Invoice Void Commission Expense - When an invoice is voided: A reversal of all net commission amounts that were originally estimated for each party when the associated Invoice was created / billed or last adjusted.

  • Payment Gross Allocation - When a payment is applied: The gross commission distribution to each recipient for this Payment.

  • Payment Net Adjustment - When a payment is applied: The Net Adjustment/Expense amount distributed from one Vendor or Account and to another.

  • Payment Net Allocation - When a payment is applied: The net commission distribution to each recipient for this Payment.

  • Payment Void Allocation - When a payment is voided: A reversal of the original gross commission amount distributed to each recipient when the associated Payment was applied.

  • Payment Void Net Adjustment - When a payment is voided: A reversal of The Net Adjustment/Expense amount distributed from one Vendor or Account and to another when the associated Payment was applied.

  • Payment Void Net Allocation - When a payment is voided: A reversal of the original net commission amount distributed to each recipient when the associated Payment was applied.

• Accrual Date - The key accounting date for each process. Based on the Action Type Detail:

  • Invoice Adjustment Recreation Allocation - Invoice Adjustment Date or (if enabled) Adjustment Accrual Date

  • Invoice Adjustment Recreation Commission Expense - Invoice Adjustment Date or (if enabled) Adjustment Accrual Date

  • Invoice Adjustment Reversal Allocation - Invoice Adjustment Date or (if enabled) Adjustment Accrual Date

  • Invoice Adjustment Reversal Commission Expense - Invoice Adjustment Date or (if enabled) Adjustment Accrual Date

  • Invoice Allocation - Invoice Date or (if enabled) Invoice Accrual Date

  • Invoice Commission Expense - Invoice Date or (if enabled) Invoice Accrual Date

  • Invoice Void Allocation - Invoice Void Date or (if enabled) Invoice Void Accrual Date

  • Invoice Void Commission Expense - Invoice Void Date or (if enabled) Invoice Void Accrual Date

  • Payment Gross Allocation - Payment Date

  • Payment Net Adjustment - Payment Date

  • Payment Net Allocation - Payment Date

  • Payment Void Allocation - Payment Void Date

  • Payment Void Net Adjustment - Payment Void Date

  • Payment Void Net Allocation -Payment Void Date

• Amount - The Accrual Amount for this Vendor / Account on this accounting action. Based on the Action Type Detail:

  • Invoice Adjustment Recreation Allocation - The proportional gross commission allocation of the Invoice amount to this Vendor / Account, based on their overall share of the Deal on the Fee Splits / Split Worksheet form.

  • Invoice Adjustment Recreation Commission Expense - The net commission estimate for this Vendor / Account for this Invoice. Specifically, 100% of the gross amount allocated to an Outside Vendor or House Account, or a calculated net amount for an In-House Vendor or Staff Vendor, based on their current Split Plan and YTD Gross Commission.

  • Invoice Adjustment Reversal Allocation - A reversal of the gross commission amount that was originally allocated to this Vendor / Account when the associated Invoice was created / billed or last adjusted.

  • Invoice Adjustment Reversal Commission Expense - A reversal of the net commission amount that was originally estimated for this Vendor / Account when the associated Invoice was created / billed or last adjusted.

  • Invoice Allocation - The proportional gross commission allocation of the Invoice amount to this Vendor/ Account, based on their overall share of the Deal on the Fee Splits / Split Worksheet form.

  • Invoice Commission Expense - The net commission estimate for this Vendor / Account for this Invoice. Specifically, 100% of the gross amount allocated to an Outside Vendor or House Account, or a calculated net amount for an In-House Vendor or Staff Vendor, based on their current Split Plan and YTD Gross Commission.

  • Invoice Void Allocation - A reversal of the gross commission amount that was originally allocated to this Vendor / Account when the associated Invoice was created / billed or last adjusted.

  • Invoice Void Commission Expense - A reversal of the net commission amount that was originally estimated for this Vendor / Account when the associated Invoice was created / billed or last adjusted.

  • Payment Gross Allocation - The gross commission amount distributed to this Vendor / Account for this Payment.

  • Payment Net Adjustment - The Net Adjustment/Expense amount distributed from or to this Vendor / Account for this Payment.

  • Payment Net Allocation - The net commission amount distributed to this Vendor for this Payment.

  • Payment Void Allocation - A reversal of the original gross commission amount distributed to this Vendor / Account when the associated Payment was applied.

  • Payment Void Net Adjustment - A reversal of The Net Adjustment/Expense amount distributed from or to this Vendor / Account when the associated Payment was applied.

  • Payment Void Net Allocation - A reversal of the original net commission amount distributed to this Vendor / Account when the associated Payment was applied.

• Vendor Name - The Vendor or House Account Name on the Vendor / House Account forms.

• Vendor Record Type - Indicates whether this Vendor or Account reflects an outside party, or is in internal broker, staff member, or house account. Specifically, the Entity Type field on the Vendor / House Account forms.

• Vendor Type - The Vendor Type on the Vendor forms

• Vendor Code - The Vendor Code/Account # on the Vendor forms

• Vendor Account Code - The Account Code on the Vendor forms

• Vendor Reference # - The Account Reference Number on the Vendor forms

• Invoice Number - The Invoice # from the Create Invoice form. May reflect a custom Invoice number or may be identical to the System ID of the Invoice.

• Invoice Date - The billing date for this Invoice. Specifically, the Invoice Date on the Create Invoice form.

• Invoice Due Date - The date the Invoice is due. Specifically, the Due Date on the Invoices tab of the Closed Deal.

• Receivable - Indicates whether the Invoice is flagged as receivable, or is pending a specific event before it can be considered receivable. Specifically, the Receivable vs Due Upon Event indicator on the Invoices tab of the Closed Deal.

• Payment Method - The Method on the Payment Application form

• Payment Ref Number - The Reference # on the Payment Application form

• Payment Net Adjustment Type - The Type on the Net Adjustments form

• Deposit Date - The Deposit Date on the Payment Application form

• Void/Adjustment Type - Depending on the Action Type: The Void Type on the Void Payment or Void Invoice forms, or the Adjustment Type on the Adjust Invoice form.

• Contact Name - Contact Or Company Name - The name of the Contact or Company associated with this Vendor on the Fee Splits / Split Worksheet form for this Deal..

• Contact Primary Location - The Contact’s Primary Location

• Contact Primary Business Line - The Contact’s Primary Business Line

• Contact Primary Division - The Contact’s Primary Division

• Deal ID - The Internal ID on the Deal Settings form for the Deal. If there is no Internal ID, the report will display the System ID for the Deal.

• Deal Name - The Deal Name on the Deal Settings form

• Deal Type - The Deal Type on the Deal Settings form

• Deal Location - The Location on the Deal Settings form (vs. the Contact’s Primary Location)

• Deal Business Line - The Business Line on the Deal Settings form (vs. the Contact’s Primary Business Line)

• Deal Division - The Division on the Deal Settings form (vs. the Contact’s Primary Division)

• Comments - The descriptive comments associated with each accounting process. Based on the Action Type Detail:

  • Invoice Adjustment Recreation Allocation - The Adjustment Comments on the Adjust Invoice form

  • Invoice Adjustment Recreation Commission Expense - The Adjustment Comments on the Adjust Invoice form

  • Invoice Adjustment Reversal Allocation - The Adjustment Comments on the Adjust Invoice form

  • Invoice Adjustment Reversal Commission Expense - The Adjustment Comments on the Adjust Invoice form

  • Invoice Allocation - The Fee Details on the Invoices form

  • Invoice Commission Expense - The Fee Details on the Invoices form

  • Invoice Void Allocation - The Void Comments on the Void Invoice form

  • Invoice Void Commission Expense - The Void Comments on the Void Invoice form

  • Payment Gross Allocation - The Memo on the Apply Payment / Fee Application form

  • Payment Net Adjustment - The Memo on the Apply Payment / Fee Application form

  • Payment Net Allocation - The Memo on the Apply Payment / Fee Application form

  • Payment Void Allocation - The Void Comments on the Void Payment form

  • Payment Void Net Adjustment - The Void Comments on the Void Payment form

  • Payment Void Net Allocation - The Void Comments on the Void Payment form

• Trans ID - The System ID of this Deal

• Accrual ID - The System ID for this specific Accrual record

• Accrual Created Date - The date this accounting action was entered into the system

• Confirmation Date - The date this Accrual record was confirmed via the Accrual Export widget

• Confirmed By - The person who confirmed this Accrual record via the Accrual Export widget

Report Filters:

• Accrual Date - Date range. Defaults to the first & last day of the current fiscal year.

• Accrual Created Date - Date range. Refers to the date the Invoice or Payment action was entered into the system.

• Action Type(s) - No selection, single selection, multiple selections.

• Deal ID(s) - Text entry. Enter one or more Internal or System Deal IDs, separated by a comma.

• Exact Matches Only - Checkbox. When checked, the report will only return those exact Deal IDs, not all Deals containing any part of those Deal IDs.

• Invoice Number(s) - Text entry. Enter one or more Invoice Numbers, separated by a comma.

• Customer Name - not relevant

• Contact(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

• Contact Location(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Location.

• Contact Business Line(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Business Line.

Group By Options (up to 3):

• Accrual Month

• Action Type

• Invoice Number

• Invoice ID

• Vendor Record Type

• Vendor Name

• Contact Name

• Contact Location

• Contact Business Line

• Contact Division

• Deal ID

• Deal Location

• Deal Business Line

• Deal Division

Click to go back to the list of reports.

Accrual Variance Report [SSRS]

A summary of all accounting (Invoice & Payment) activity for each Contact, Vendor or Account Entity Type for a given date range. Totals are calculated for gross and net allocations / distributions and include the Net to Firm estimates / distributions as well as Adjusted Net Payment amounts.

Report Fields:

• First column (Contact Name / Vendor Name / Account Entity Type) - Depending on the selected Totals display option, the name of the Contact (First & Last Name), Vendor (Vendor / Account Name from the Vendor / House Account form) or Account Entity Type (Entity Type on the Vendor / House Account form). Clicking on the name / type will run the Accrual Detail Report for that Contact / Vendor / Entity Type for the selected accrual dates.

• Invoice Allocation - The total proportional gross commission allocation of the Invoice amount to this Contact / Vendor / Entity Type for all Invoice activities (Billing, Adjustments and Voids), based on their overall share of the Deal on the Fee Splits / Split Worksheet form.

• Invoice Commission Expense - The total net commission estimate for this Contact / Vendor / Entity Type for all Invoice activities (Billing, Adjustments and Voids). Specifically, 100% of the gross amount allocated to an Outside Vendor or House Account, or a calculated net amount for an In-House Vendor or Staff Vendor, based on their current Split Plan and YTD Gross Commission.

• Invoice Net to Firm Allocation - The total estimated amount allocated to the firm for all Invoice activities (Billing, Adjustments and Voids). Specifically, the difference between the Invoice Allocation total and the Invoice Commission Expense total for this Contact / Vendor / Entity Type.

• Payment Gross Allocation - The total gross commission amount distributed to this Contact / Vendor / Entity Type for all Payment activities (Payments and Voids).

• Payment Net Allocation - The total net commission amount distributed to this Contact / Vendor / Entity Type for all Payment activities (Payments and Voids).

• Payment Net Adjustment - Payment Net Adjustment - The total Net Adjustment/Expense amount distributed from or to this Contact / Vendor / Entity Type for all Payment activities (Payments and Voids).

• Adjusted Payment Net - The total adjusted net commission amount distributed to this Contact / Vendor / Entity Type for all Payment activities (Payments and Voids). Specifically, the Payment Net Allocation plus the Payment Net Adjustment for this Contact / Vendor / Entity Type.

• Payment Net to Firm - The total net amount distributed to the firm for all Payment activities (Payments and Voids). Specifically, the Payment Gross Allocation minus the Payment Net Allocation plus the Payment Net Adjustment for this Contact / Vendor / Entity Type.

Report Filters:

• Accrual Date(s) - Date range. Defaults to the previous 7 days.

• Deal ID(s) - Text entry. Enter one or more Internal or System Deal IDs, separated by a comma.

• Invoice Number(s) - Text entry. Enter one or more Invoice Numbers, separated by a comma.

• Customer Name - not relevant

• Contact(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

• Contact Location - No selection, single selection, multiple selections. Refers to the Contact’s Primary Location.

• Contact Business Line - No selection, single selection, multiple selections. Refers to the Contact’s Primary Business Line.

• Vendor Record Type - Single selection. Refers to the Entity Type on the Vendor forms.

Display Options:

• Totals - Indicates what each row on the report should represent

  • By Contact - Totals for each Contact or Company, regardless of which Vendor they’re associated with on the Fee Splits / Split Worksheet for each Deal.

  • By Vendor - Totals for each Vendor, regardless of which Contact or Company they’re associated with on the Fee Splits / Split Worksheet for each Deal.

  • By Account Entity Type - Totals for each Account Entity Type, based on the Vendors / Accounts on the Fee Splits / Split Worksheet for each Deal.

Group By Options (up to 3):

Defaults to Vendor Record Type

• Accrual Month

• Deal ID

• Invoice Number

• Invoice ID

• Broker Location

• Broker Business Line

• Broker Division

• Vendor Record Type

• Vendor Name

• Deal Name

Click to go back to the list of reports.

Accruals Report [SSRS]

An accounting report with pertinent details for all Invoice and Payment related actions, including gross and net allocations to each of the parties involved in the deal and entitled to a share of the fees. Each row represents a specific action and the associated gross or net allocation to a specific Vendor or Account. When grouped, subtotals are summarized at the top of each group.

Report Fields:

• The first 2 columns display your selected Group By fields

• Action Type - Indicates exactly which accounting process is reflected in a given row and associated sub rows. Options:

  • Invoice Allocation - When an Invoice is created / billed: The proportional gross commission allocation of the Invoice amount to each party entitled to a share of the fees.

  • Invoice Commission Expense - When an Invoice is created / billed: The net commission estimate for each party entitled to a share of the fees.

  • Invoice Void Allocation - When an Invoice is voided: A reversal of all gross commission amounts that were originally allocated to each party when the associated Invoice was created / billed or last adjusted.

  • Invoice Void Commission Expense - When an invoice is voided: A reversal of all net commission amounts that were originally estimated for each party when the associated Invoice was created / billed or last adjusted.

  • Invoice Adjustment Reversal Allocation - When an invoice is adjusted: A reversal of all gross commission amounts that were originally allocated to each party when the associated Invoice was created / billed or last adjusted.

  • Invoice Adjustment Reversal Commission Expense - When an invoice is adjusted: A reversal of all net commission amounts that were originally estimated for each party when the associated Invoice was created / billed or last adjusted.

  • Invoice Adjustment Recreation Allocation - When an invoice is adjusted: The proportional gross commission allocation of the (adjusted) Invoice amount to each party entitled to a share of the fees.

  • Invoice Adjustment Recreation Commission Expense - When an invoice is adjusted: The new net commission estimate for each party entitled to a share of the fees.

  • Payment Allocation - When a payment is applied: The gross commission distribution to each recipient for this Payment.

  • Payment Net Allocation - When a payment is applied: The net commission distribution to each recipient for this Payment.

  • Payment Net Adjustment - When a payment is applied: The Net Adjustment/Expense amount distributed from one Vendor or Account and to another.

  • Payment Void Allocation - When a payment is voided: A reversal of the original gross commission amount distributed to each recipient when the associated Payment was applied.

  • Payment Void Net Allocation - When a payment is voided: A reversal of the original net commission amount distributed to each recipient when the associated Payment was applied.

  • Payment Void Net Adjustment - When a payment is voided: A reversal of The Net Adjustment/Expense amount distributed from one Vendor or Account and to another when the associated Payment was applied.

• Accrual Date - The key accounting date for each process. Based on the Action Type:

  • Invoice Allocation - Invoice Date or (if enabled) Invoice Accrual Date

  • Invoice Commission Expense - Invoice Date or (if enabled) Invoice Accrual Date

  • Invoice Void Allocation - Invoice Void Date or (if enabled) Invoice Void Accrual Date

  • Invoice Void Commission Expense - Invoice Void Date or (if enabled) Invoice Void Accrual Date

  • Invoice Adjustment Reversal Allocation - Invoice Adjustment Date or (if enabled) Adjustment Accrual Date

  • Invoice Adjustment Reversal Commission Expense - Invoice Adjustment Date or (if enabled) Adjustment Accrual Date

  • Invoice Adjustment Recreation Allocation - Invoice Adjustment Date or (if enabled) Adjustment Accrual Date

  • Invoice Adjustment Recreation Commission Expense - Invoice Adjustment Date or (if enabled) Adjustment Accrual Date

  • Payment Allocation - Payment Date

  • Payment Net Allocation - Payment Date

  • Payment Net Adjustment - Payment Date

  • Payment Void Allocation - Payment Void Date

  • Payment Void Net Allocation - Payment Void Date

  • Payment Void Net Adjustment - Payment Void Date

• Invoice Allocation - The gross commission allocation or reversal amount for this Vendor. Based on the Action Type:

  • Invoice Allocation or Invoice Adjustment Recreation Allocation - The proportional gross commission allocation of the Invoice amount, based on their overall share of the Deal on the Fee Splits / Split Worksheet form.

  • Invoice Void Allocation or Invoice Adjustment Reversal Allocation - A reversal of the gross commission amount that was originally allocated to this Vendor when the associated Invoice was created / billed or last adjusted.

• Commission Expense - The estimated net commission estimate or reversal amount for this Vendor. Based on the Action Type:

  • Invoice Commission Expense or Invoice Adjustment Recreation Commission Expense - The estimated net commission estimate for each entitled party for this Invoice. Specifically, 100% of the gross amount allocated to each Outside Vendor or House Account, or a calculated net amount for each In-House Vendor or Staff Vendor on the Fee Splits / Split Worksheet form, based on their current Split Plan and YTD Gross Commission.

  • Invoice Void Commission Expense or Invoice Adjustment Reversal Commission Expense - A reversal of all net commission amounts that were originally estimated for each entitled party when the associated Invoice was created / billed or last adjusted.

• Gross Payment - The actual gross commission or reversal amount distributed to this Vendor. Based on the Action Type:

  • Payment Gross Allocation - The gross commission amount distributed to this Vendor for this Payment.

  • Payment Void Allocation - A reversal of the original gross commission amount distributed to each recipient when the associated Payment was applied.

• Net Payment - The actual net commission or reversal amount distributed to this Vendor. Based on the Action Type:

  • Payment Net Adjustment - The Net Adjustment/Expense amount distributed from or to this Vendor / Account for this Payment.

  • Payment Net Allocation - The net commission amount distributed to this Vendor for this Payment.

  • Payment Void Net Adjustment - A reversal of The Net Adjustment/Expense amount distributed from or to this Vendor / Account when the associated Payment was applied.

  • Payment Void Net Allocation - A reversal of the original net commission amount distributed to this Vendor when the associated Payment was applied.

• Invoice Date - The billing date for this Invoice. Specifically, the Invoice Date on the Create Invoice form.

• Due Date - The date the Invoice is due. Specifically, the Due Date on the Invoices tab of the Closed Deal.

• Receivable - Indicates whether the Invoice is currently receivable, or is pending a specific event before it can be considered receivable. Specifically, the Receivable vs Due Upon Event indicator on the Invoices tab of the Closed Deal.

• Account Entity Type - Indicates whether this Vendor or Account reflects an outside party, or is in internal broker, staff member, or house account. Specifically, the Entity Type field on the Vendor / House Account form.

• Account Entity Name - The Vendor or House Account Name on the Vendor / House Account form.

• Contact Or Company Name - The name of the Contact or Company associated with this Vendor for this transaction.

• Contact Primary Location - The Contact’s Primary Location

• Contact Primary Business Line - The Contact’s Primary Business Line

• Contact Primary Division - The Contact’s Primary Division

• Deal ID - The Internal ID on the Deal Settings form for the Deal. If there is no Internal ID, the report will display the System ID for the Deal.

• Deal Name - The Deal Name on the Deal Settings form

• Deal Type - The Deal Type on the Deal Settings form

• Deal Location - The Location on the Deal Settings form (vs. the Contact’s Primary Location)

• Deal Business Line - The Business Line on the Deal Settings form (vs. the Contact’s Primary Business Line)

• Deal Division - The Division on the Deal Settings form (vs. the Contact’s Primary Division)

• Payment Method - The Method on the Payment Application form

• Payment Ref Number - The Reference # on the Payment Application form

• Payment Net Adjustment Type - The Type on the Net Adjustments form

• Trans ID - The System ID for the Deal

• Accrual ID - The System ID for this specific Accrual record

Report Filters:

• Accrual Date - Date range. Defaults to the first & last day of the current fiscal year.

• Deal ID(s) - Text entry. Enter one or more Internal or System Deal IDs, separated by a comma.

• Invoice Number(s) - Text entry. Enter one or more Invoice Numbers, separated by a comma.

• Contact Location(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Location.

• Contact Business Line(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Business Line.

• Contact Division(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Division.

Display Options:

• Show Details - Click here for more details about this setting

• Do Not Repeat Deal Data - Click here for more details about this setting

Group By Options (up to 2):

Defaults to Accrual Month and Invoice Number

• Accrual Month

• Contact Business Line

• Contact Division

• Contact Location

• Contact/Company Name

• Deal ID

• Deal Type

• Invoice ID

• Invoice Number

Click to go back to the list of reports.

Accruals Fiscal Year Summary [SSRS]

Designed for clients who accrue revenue at time of billing. Typically used if the firm’s fiscal year does not start in January. This report provides totals for revenue (gross) and commission expense (net) amounts accrued before and after a given month for the indicated, prior, and following fiscal years.

Report Fields:

• The first 2 columns display your selected Group By fields

• Fiscal Year [prior year]: Revenue - Total proportional gross allocation for all invoice activity (billing, adjustment & void) during the prior fiscal year. Allocations are based on each Contact’s overall share of the Deal on the Fee Splits / Split Worksheet form.

• Fiscal Year [prior year]: Commission Expense - The net commission estimate for all invoice activity (billing, adjustment & void) during the prior fiscal year. Estimates are 100% of the gross amount allocated to an Outside Vendor or House Account, or a calculated net amount for an In-House Vendor or Staff Vendor, based on their current Split Plan and YTD Gross Commission.

• Fiscal Year [selected year] Through [month prior to selected month]: Revenue - Total proportional gross allocation for all invoice activity (billing, adjustment & void) from the beginning of the selected fiscal year through the month prior to the selected month. Allocations are based on each Contact’s overall share of the Deal on the Fee Splits / Split Worksheet form.

• Fiscal Year [selected year] Through [selected month]: Commission Expense - The net commission estimate for all invoice activity (billing, adjustment & void) from the beginning of the selected fiscal year through the month prior to the selected month. Estimates are 100% of the gross amount allocated to an Outside Vendor or House Account, or a calculated net amount for an In-House Vendor or Staff Vendor, based on their current Split Plan and YTD Gross Commission.

• [selected month & year] Through Fiscal Year End: Revenue - Total proportional gross allocation for all invoice activity (billing, adjustment & void) from the beginning of the selected month through the end of the selected fiscal year. Allocations are based on each Contact’s overall share of the Deal on the Fee Splits / Split Worksheet form.

• [selected month & year] Through Fiscal Year End: Commission Expense - The net commission estimate for all invoice activity (billing, adjustment & void) from the beginning of the selected month through the end of the selected fiscal year. Estimates are 100% of the gross amount allocated to an Outside Vendor or House Account, or a calculated net amount for an In-House Vendor or Staff Vendor, based on their current Split Plan and YTD Gross Commission.

• Future Fiscal Years: Revenue - Total proportional gross allocation for all invoice activity (billing, adjustment & void) after the end of the selected fiscal year. Allocations are based on each Contact’s overall share of the Deal on the Fee Splits / Split Worksheet form.

• Future Fiscal Years: Commission Expense - The net commission estimate for all invoice activity (billing, adjustment & void)after the end of the selected fiscal year. Estimates are 100% of the gross amount allocated to an Outside Vendor or House Account, or a calculated net amount for an In-House Vendor or Staff Vendor, based on their current Split Plan and YTD Gross Commission.

Report Filters:

• Year - Required. Single selection. Indicates which year (for the Accrual Date) to focus on. By default, the current year is selected.

• Month - Required. Single selection. Indicates which month (for the Accrual Date) to focus on. By default, the current month is selected.

• Contact Location(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Location.

• Contact Business Line(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Business Line.

• Contact Division(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Division.

Display Options:

• Show Details - Click here for more details about this setting

Group By Options (up to 2):

Defaults to Contact Location and Contact (name)

• Contact

• Contact Business Line

• Contact Division

• Contact Location

• Deal Business Line

• Deal Division

• Deal Location

• Deal Type

Click to go back to the list of reports.

Accounting Broker YTD & Splits

View some Split Plan details for internal Brokers, as well as their current Split Percent and the total Gross Commission credited to the Broker for the year (as of the selected date).

Report Fields:

• Broker Name - The broker’s Last Name, First Name

• Split Plan Name - The Split Plan Name on the HR Split Information form

• Individual Split Plan to Date Gross Commission - The total Gross Commission amount earned for this Split Plan, even if that amount encompasses more than 1 year

• Individual Split Plan Percentage - The current anticipated Split % based on the total Gross Commission amount earned for just this Split Plan

• Start Date - The Start (date) on the HR Split Information form, i.e. when the Split Plan comes into effect.

• End Date - The End (date) on the HR Split Information form, i.e. the last day the Split Plan is in effect.

• Split Plan Type - The “Calculate YTD Production and Net Split Amounts” on the HR Split Information form. Indicates whether Net Commission amounts are calculated the moment the deal is booked (i.e. the Fee Splits / Split Worksheet form is saved) or when a Payment is entered.

• YTD Gross Commission (All Split Plans) - The total Gross Commission amount earned across all Split Plans for the current year

• Split Plan Percentage (All Split Plans) - The current anticipated Split % based on the total Gross Commission amount earned across all Split Plans for the current year. If there is currently more than one valid Split Plan, the calculation will refer to the Split Thresholds of the default Split Plan.

Report Filters:

• As Of Date - Required. Date (mm/dd/yyyy). Defaults to today’s date. Determines when the 12-month breakdown begins, and which Invoice adjustments or payments to include when calculating certain amounts. Click here for more information.

• Broker - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

• Split Plan Start Date - Date range (mm/dd/yyyy). Filters the report for Split Plans with a Start Date that falls within the indicated date range.

• Split Plan End Date - Date range (mm/dd/yyyy). Filters the report for Split Plans with an End Date that falls within the indicated date range.

• Broker Location - No selection, single selection, multiple selections. Refers to the Contact’s Primary Location.

• Broker Business Line - No selection, single selection, multiple selections. Refers to the Contact’s Primary Business Line.

• Broker Division(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Division.

Group By Options (up to 2):

Defaults to Broker Location and Broker Name

• Broker Location

• Broker Business Line

• Broker Division

• Broker Name

• Split Plan Name

• Start Date (of the Split Plan)

• End Date (of the Split Plan)

Sort By Options (up to 2):

• Broker Name

• Split Plan Name

• Individual Split Plan Percentage

• Start Date

• End Date

• YTD Gross Commission (all Split Plans)

• Split Plan Percentage (all Split Plans)

Display Options:

• Display Criteria on Report

• Break Page After a Group

Click to go back to the list of reports.

Assignments

A general overview of Assignments you have permission to see that includes key contract dates and the current status. Each row represents one Assignment.

Report Fields:

• Assignment ID - The Internal ID from the Assignment Settings form, or the System ID if there is no Internal ID

• Network ID - The Network ID from the Assignment Settings form

• Assignment Name - The Assignment Name from the Assignment Settings form

• Assignment Type - The Assignment Type from the Assignment Settings form (e.g. Landlord Representation, Buyer Representation, etc.)

• Business Line - The Business Line stored on the Assignment Settings form

• Location - The Location stored on the Assignment Settings form

• Building(s) SF - The total of all Building SF from the Property Details form for the Properties that are linked to that specific Assignment

• Contract Date - The Contract Date from the Assignment Settings form

• Expiration Date - The Expiration Date from the Assignment Settings form

• Broker - The names of any internal Contacts who are on the Assignment Contacts form with a Role of Listing Broker or Procuring Broker

• Status - The Status from the Assignment Settings form

Report Filters:

• Contract Date - Minimum date, maximum date, or range of dates. Defaults to the first through last day of the current year.

• Expiration Date - Minimum date, maximum date, or range of dates

• System/Created Date - Minimum date, maximum date, or range of dates. Refers to the date the Assignment was entered into the system.

• Location(s) - No selection, single selection, multiple selections

• Business Line(s) - No selection, single selection, multiple selections

• Assignment Type(s) - No selection, single selection, multiple selections

• Status - No selection, single selection, multiple selections

• Team Member(s) - No selection, single selection, multiple selections. Lists internal Contacts who are in your Office / Location(s). Refers to any Contact on the Assignment Contacts form.

Group By Options (up to 2):

• Assignment Type

• Business Line

• Location

• Contract Date

• Expiration Date

• Broker

• Status

Sort By Options (up to 2):

• Assignment ID

• Assignment Name

• Assignment Type

• Business Line

• Location

• Building(s) SF

• Contract Date

• Expiration Date

• Status

Display Options:

• Display Criteria on Report

• Break Page After a Group

Click to go back to the list of reports.

Assignments w/Contact Info

A general overview of Assignments you have permission to see that includes contact information for the Client as well as key contract dates and the current status. Each row represents one Assignment.

Report Fields:

• Assignment ID - The Internal ID from the Assignment Settings form, or the System ID if there is no Internal ID

• Network ID - The Network ID from the Assignment Settings form

• Assignment Name - The Assignment Name from the Assignment Settings form

• Assignment Type - The Assignment Type from the Assignment Settings form (e.g. Landlord Representation, Buyer Representation, etc.)

• Business Line - The Business Line stored on the Assignment Settings form

• Location - The Location stored on the Assignment Settings form

• Building(s) SF - The total of all Building SF from the Property Details form for the Properties that are linked to that specific Assignment

• Contract Date - The Contract Date from the Assignment Settings form

• Expiration Date - The Expiration Date from the Assignment Settings form

• Contact - The Name, Company and Direct Phone number for the Contact flagged as the Client on the Assignment Contacts form

• Broker - The names of any internal Contacts who are on the Assignment Contacts form with a Role of Listing Broker or Procuring Broker

• Status - The Status from the Assignment Settings form

Report Filters:

• Contract Date - Minimum date, maximum date, or range of dates. Defaults to the first through last day of the current year.

• Expiration Date - Minimum date, maximum date, or range of dates

• System/Created Date - Minimum date, maximum date, or range of dates. Refers to the date the Assignment was entered into the system.

• Location(s) - No selection, single selection, multiple selections

• Business Line(s) - No selection, single selection, multiple selections

• Assignment Type(s) - No selection, single selection, multiple selections

• Status - No selection, single selection, multiple selections

• Team Member(s) - No selection, single selection, multiple selections. Lists internal Contacts who are in your Office / Location(s). Refers to any Contact on the Assignment Contacts form.

Group By Options (up to 2):

• Assignment Type

• Business Line

• Location

• Contract Date

• Expiration Date

• Contact

• Broker

• Status

Sort By Options (up to 2):

• Assignment ID

• Assignment Name

• Assignment Type

• Business Line

• Location

• Building(s) SF

• Contract Date

• Expiration Date

• Status

Display Options:

• Display Criteria on Report

• Break Page After a Group

Click to go back to the list of reports.

Billings and Cash Collected [SSRS]

For Contacts you manage or support, see total amounts and deal counts for billed invoices and for payments received in a given month, year and previous years.

Report Fields:

• Broker - The broker’s Last Name, First Name. Refers to Contacts who are associated with an In-House or Staff Vendor on a deal’s Fee Splits / Split Worksheet form.

• Selected Month / Selected Year

  • Total Invoiced (Broker Share) - Total for each broker’s share of invoice amounts billed during the selected month or year. The share amount is calculated based on the gross commission allocated to that person on the deal’s Split Worksheet.

  • # Deals Billed - Total number of deals on which an invoice was billed during the selected month or year

  • Gross Cash Collected - Total for each broker’s Gross Commission amount from payments received during the selected month or year

  • # Deals Cash Collected - Total number of deals on which a payment was received during the selected month or year

  • Budget - The HR Goal amount from the Personnel (HR) record for each Contact for the selected year

• Previous 4 Years

  • Gross Cash Collected - Total for each broker’s Gross Commission amount from payments received during the indicated year

Report Filters:

• Billing Month Sent - Single selection. Indicates which month (for the Invoice Date) to focus on. By default, or if nothing is selected, the report will run for the current month.

• Billing Year Sent - Single selection. Indicates which year (for the Invoice Date) to focus on. By default, or if nothing is selected, the report will run for the current year.

• Broker Primary Location(s) - No selection, single selection, multiple selections

• Broker Primary Business Line(s) - No selection, single selection, multiple selections

• Deal Type(s) - No selection, single selection, multiple selections. Refers to the Deal Type field on the Deal Settings form.

• HR Status - No selection, single selection, multiple selections. “Active” is the default selection. Refers to the Status field on the broker’s HR/Personnel Record form.

• Broker(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

Group By Options (up to 2):

• Deal Business Line - The Business Line on the Deal Settings form

• Broker Location - The broker’s Primary Location

Sort By Options (up to 2):

• Deal Business Line

• Broker Location

• Gross Cash Collected 4 Years Ago

• Gross Cash Collected 3 Years Ago

• Gross Cash Collected 2 Years Ago

• Gross Cash Collected Previous Year

• Current Month Billings - i.e. for the selected month

• Current Month # Deals Billed - i.e. for the selected month

• Current Month Gross Cash Collected - i.e. for the selected month

• Current Month # Deals Cash Collected - i.e. for the selected month

• YTD Billings - i.e. for the selected year

• YTD # Deals Billed - i.e. for the selected year

• YTD Gross Cash Collected - i.e. for the selected year

• YTD # Deals Cash Collected - i.e. for the selected year

• Budget Current Year

Click to go back to the list of reports.

Broker Historical Review - Payments Received [SSRS]

A summary of Gross Commissions paid/credited to a broker during the selected year and five prior years. This report includes a comparison of total paid vs the annual goal for the selected year, as well as a 3-year average.

Report Fields:

• Broker - The broker’s Last Name, First Name. Refers to Contacts who are associated with an In-House or Staff Vendor on a deal’s Fee Splits / Split Worksheet form.

• Primary Location - The broker’s Primary Location

• Primary Business Line - The broker’s Primary Business Line

• Hire Date - The Start Date from the broker’s HR/Personnel File form

• Payments Received [Year] - Total Gross Commissions/Fees credited to this Contact from Payments received in the selected year

• [Year] Goal - The HR Goal amount for the selected year from the broker’s Personnel (HR) record

• % of Goal - An indication of how close the Broker is to meeting their Goal for the selected year.
  Specifically, the Payments Received for the select Year divided by the HR Goal for the same year.

• Three Year Average - Average of the total Gross Payments

• Prior Years Payments Received - Total Gross Commissions/Fees credited to this Contact from Payments received in the 4 years prior to the selected year

• Contact ID - The system ID assigned to the broker’s Contact record

Report Filters:

• Year - Number field. Enter a 4-digit year. Indicates which year (for the Payment Date) to focus on. By default, or if nothing is selected, the report will run for the current year.

• Broker Primary Location(s) - No selection, single selection, multiple selections

• Broker Primary Business Line(s) - No selection, single selection, multiple selections

• Broker(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

• HR Status - No selection, single selection, multiple selections. “Active” is the default selection. Refers to the Status field on the broker’s HR/Personnel Record form.

Group By Options (up to 2):

• Broker Primary Location

• Broker Primary Business Line

• HR Status

Sort By Options (up to 2):

• Broker Primary Location

• Broker Primary Business Line

• Broker

• Hire Date

• Selected Year Cash Collected

• Receivables

• Selected Year Budget

• Three Year Average

Click to go back to the list of reports.

Broker Pay Sheet [SSRS]

View In-House or Staff Vendor account activity for a specific pay period (or other date range) and for the entire fiscal year to that point. The account balance is summarized for the period and for the year, with a separate summary for Broker Draws. This report includes a detailed breakdown of Account Transactions for that date range. Account Transactions are debits or credits on the Vendor account that can be created manually, or that are automatically created when Payments are applied.

Results are limited to In-House and Staff Vendors only. Each Vendor will have their own page(s).

Click here to watch a video tutorial on the Broker Pay Sheet report.

Report Fields:

• Contact & Vendor Details

  • Vendor Name - The Vendor Name from the Vendor Details form

  • Pay Period - The name of the selected Pay Period

  • Effective Start - End Date - The selected Effective Start Date and Effective End Date

  • As Of - Today’s date

  • Name - First & Last Name of the Contact from the Vendor Details form

  • Primary Location - The Contact’s Primary Location

  • Primary Business Line - The Contact’s Primary Business Line

  • Primary Division - The Contact’s Primary Division

  • Salary - The Pay Rate & Frequency from the Compensation History on the Contact’s HR (Personnel File) record

  • Compensation Memo - The Compensation Memo from the Compensation History on the Contact’s HR (Personnel File) record

• Current Pay Period - Summary of all activity on this Vendor Account for this pay period (i.e. the selected Effective Start/End Date range), with subtotals and totals

  • Balance Forward - The account balance at the beginning of the pay period.
    Specifically, the total of all Account Transaction amounts from before the selected Effective Start Date.

  • Commissions - All of the Vendor’s Net Payments and Net Adjustments for this Pay Period.
    Specifically, the total of Account Transactions for the selected Effective Date range with a Type of “Commission Net Expense” or “Commission Payment”.

  • Non-Commission Sub Total - Any debits or credits on the account for this pay period that aren’t associated with Deal Payments or Payroll.
    Specifically, the total of Account Transactions for the selected Effective Date range with a Type other than “Commission Net Expense”, “Commission Payment” or “Payroll”.

  • Gross Pay Out - The recommended amount to process for payroll.
    Specifically, the total of Account Transactions for the selected Effective Date range with a Type other than “Payroll”.

  • Payroll - Any payroll related activity on the account for this pay period.
    Specifically, the total of Account Transactions for the selected Effective Date range with a Type of “Payroll”.
    Only displays if there is any activity. For example, if payroll is processed on a delayed schedule, you should see a Payroll amount for the previous pay period that was processed during this pay period.

  • Ending Balance - The account balance at the end of the pay period.
    Specifically, the total of all Account Transaction amounts up to and including the selected Effective End Date.

• YTD Payroll Information - Summary of all activity on this Vendor Account for this fiscal year (i.e. from the first day of the fiscal year through the selected Effective End Date), with subtotals and totals

  • Balance Forward - The Account Balance at the beginning of the year.
    Specifically, the total of all Account Transaction amounts from before the first day of the year.

  • Commissions - All of the Vendor’s Net Payments and Adjustments for this year.
    Specifically, the total of all Account Transactions for the year through the selected Effective End Date with a Type of “Commission Net Expense” or “Commission Payment”.

  • Non-Commission Sub Total - Any debits or credits added to the account this year that aren’t associated with Deal Payments or Payroll.
    Specifically, the total of Account Transactions for the year through the indicated Effective End Date with a Type other than “Commission Net Expense”, “Commission Payment” or “Payroll”.

  • Gross Pay Out - The recommended amount to process for payroll.
    Specifically, the total of Account Transactions for the year with a Type other than “Payroll”.

  • Payroll - All payroll related activity on the account for this year.
    Specifically, the total of Account Transactions for the year with a Type of “Payroll”.
    Only displays if there has been any Payroll activity this year.

  • Ending Balance - The account balance at the end of the pay period.
    Specifically, the total of all Account Transaction amounts up to and including the selected Effective End Date.

• Draw Balance - Summary of all Draw activity on this Vendor Account through the selected Effective End Date

  • Balance Forward - The Draw balance at the beginning of the pay period.
    Specifically, the total of all Account Transaction amounts from before the selected Effective Start Date with a Type that contains the word “Draw”.

  • Ending Balance - The Draw balance at the end of the pay period.
    Specifically, the total of all Account Transaction amounts up to and including the selected Effective End Date with a Type that contains the word “Draw”.

• Commissions for this Period -

  • Deal ID - The Internal ID on the Deal Settings form for the Deal. If there is no Internal ID, the report will display the System ID for the Deal.

  • System ID - The System ID for the Deal

  • Account Trans ID - The System ID for this Account Transaction

  • Date Paid - The Account Transaction Date (which will match the Payment Date from the Apply Payment form of the Deal)

  • Deal Name - The Deal Name on the Deal Settings form

  • Commission Paid - The total Payment Amount for this Payment

  • Deal % - This Vendor’s overall % share of the Total Fees on this Deal, i.e. the % of Deal for this Vendor on the Fee Splits / Split Worksheet form for the Deal

  • Gross to Broker - The Vendor’s Gross Commission for this Payment

  • Applied Split Plan - The Name of the Split Plan that was applied for this Vendor on this Payment

  • Split % - The % used to determine the Vendor’s Net Commission for this Payment. May have been manually applied (i.e. as a Fixed Net) or determined by the Applied Split Plan.

  • Net to Broker - Account Transaction Amount (which will match the Net Commission amount for this Vendor on the Payment)

• Commission Net Expense for this Period

  • Deal ID - The Internal ID on the Deal Settings form for the Deal. If there is no Internal ID, the report will display the System ID for the Deal.

  • System ID - The System ID for the Deal

  • Account Trans ID - The System ID for this Account Transaction

  • Date Paid - The Account Transaction Date (which will match the Payment Date from the Payment Application form of the Deal)

  • Deal Name - The Deal Name on the Deal Settings form

  • From - The name of the Vendor account that was debited (which will match the From Vendor on the Closed Deal Net Adjustments form and the Payer on the Payment Application form)

  • To - The name of the Vendor account that was credited (which will match the To Vendor on the Closed Deal Net Adjustments form and the Vendor/Account on the Payment Application form)

  • Type - The Type on the Closed Deal Net Adjustments form

  • Comments - The Memo on the Closed Deal Net Adjustments form

  • Amount - The $ to Apply amount on the Payment Application form. Note that if the amount is “From” this Vendor, the amount will show as a debit or negative number. If the amount is “To” this Vendor, the amount will show as a credit or positive number.

• Other Account Transactions

  • Account Trans ID - The System ID for this Account Transaction

  • Date - The Transaction Date on the Account Transaction Form

  • Type - The Transaction Type on the Account Transaction Form

  • Account - The other Vendor or House Account involved in this Transaction (i.e. the To Account or From Account on the Account Transaction Form that is not this Vendor)

  • Description - The Comments on the Account Transaction Form

  • Debit/Credit - The Amount on the Account Transaction form. Note that if the amount is “From” this Vendor, the amount will show as a debit or negative number. If the amount is “To” this Vendor, the amount will show as a credit or positive number.

Report Filters:

• Pay Period - Single selection from a list of pre-defined Pay Periods (via the Define Payroll Periods form). Defaults to the last completed Pay Period (based on today’s date).

• Effective Start Date - Required. Determines the beginning of the Account Transaction Date range that the report will encompass. Defaults to the Start Date associated with the selected Pay Period on the Define Payroll Periods form.

• Effective End Date - Required. Determines the end of the Account Transaction Date range that the report will encompass. Defaults to the End Date associated with the selected Pay Period on the Define Payroll Periods form.

• Broker Location - Required. Single selection from a list of locations. Defaults to your (the logged in user’s) primary Location.

• Vendor Type - Single selection. Refers to the Entity Type on the Vendor forms. Since this report only includes In-House and Staff Vendors by default, those are the only two options in the list.

• Broker(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

• Only include Vendors with activity in this Pay Period - Checkbox. Selected by default. When checked, will only include pages for Vendors which have at least one Account Transaction for the selected date range.

Click to go back to the list of reports.

Broker Pay Sheet Summary [SSRS]

A spreadsheet-style, one line per broker version of the Broker Pay Sheet report with only subtotals and totals for the selected Effective Date range.

Report Fields:

• Vendor Name - The Vendor Name from the Vendor Details form

• Contact Name - First & Last Name of the Contact from the Vendor Details form

• Primary Location - The Contact’s Primary Location

• Primary Business Line - The Contact’s Primary Business Line

• Primary Division - The Contact’s Primary Division

• Current Balance Forward - The Vendor account balance at the beginning of the pay period.
  Specifically, the total of all Account Transaction amounts from before the selected Effective Start Date.

• Current Commission Sub Total - All of the Vendor’s Net Payments and Net Adjustments for this Pay Period.
  Specifically, the total of Account Transactions for the selected Effective Date range with a Type of “Commission Net Expense” or “Commission Payment”.

• Current Non-Commission Sub Total - Any debits or credits on the account for this pay period that aren’t associated with Deal Payments or Payroll.
  Specifically, the total of Account Transactions for the selected Effective Date range with a Type other than “Commission Net Expense”, “Commission Payment” or “Payroll”.

• Current Gross Pay Out - The recommended amount to process for payroll.
  Specifically, the total of Account Transactions for the selected Effective Date range with a Type other than “Payroll”.

• Current Payroll - Any payroll related activity on the account for this pay period.
  Specifically, the total of Account Transactions for the selected Effective Date range with a Type of “Payroll”.
  For example, if payroll is processed on a delayed schedule, you should see a Payroll amount for the previous pay period that was processed during this pay period.

• Current Ending Balance - The account balance at the end of the pay period.
  Specifically, the total of all Account Transaction amounts up to and including the selected Effective End Date.

• YTD Balance Forward - The Account Balance at the beginning of the fiscal year.
  Specifically, the total of all Account Transaction amounts from before the first day of the fiscal year.

• YTD Commission Sub Total - All of the Vendor’s Net Payments and Adjustments for this fiscal year.
  Specifically, the total of all Account Transactions for the year through the selected Effective End Date with a Type of “Commission Net Expense” or “Commission Payment”.

• YTD Non-Commission Sub Total - Any debits or credits added to the account this fiscal year that aren’t associated with Deal Payments or Payroll.
  Specifically, the total of Account Transactions for the year through the indicated Effective End Date with a Type other than “Commission Net Expense”, “Commission Payment” or “Payroll”.

• YTD Gross Pay Out - The recommended amount to process for payroll.
  Specifically, the total of Account Transactions for the year with a Type other than “Payroll”.

• YTD Payroll - All payroll related activity on the account for this fiscal year.
  Specifically, the total of Account Transactions for the year with a Type of “Payroll”.

• YTD Ending Balance - The account balance at the end of the pay period.
  Specifically, the total of all Account Transaction amounts up to and including the selected Effective End Date.

• Draw Balance Forward - The Draw balance at the beginning of the pay period.
  Specifically, the total of all Account Transaction amounts from before the selected Effective Start Date with a Type that contains the word “Draw”.

• Draw Advance - The total of Account Transactions for the selected Effective Date range with a Type of “Draw Advance”

• Draw Recovery - The total of Account Transactions for the selected Effective Date range with a Type of “Draw Recovery”

• Draw Ending Balance - The Draw balance at the end of the pay period.
  Specifically, the total of all Account Transaction amounts up to and including the selected Effective End Date with a Type that contains the word “Draw”.

• Vendor ID - Unique System ID for the Vendor

• Contact ID - Unique System ID for the Contact

Report Filters:

• Pay Period - Single selection from a list of pre-defined Pay Periods (via the Define Payroll Periods form). Defaults to the current Pay Period (based on today’s date) or to the most current Pay Period in the list.

• Effective Start Date - Required. Determines the beginning of the Account Transaction Date range that the report will encompass. Defaults to the Start Date associated with the selected Pay Period on the Define Payroll Periods form.

• Effective End Date - Required. Determines the end of the Account Transaction Date range that the report will encompass. Defaults to the End Date associated with the selected Pay Period on the Define Payroll Periods form.

• Broker Location - Required. Single selection from a list of locations. Defaults to your (the logged in user’s) primary Location.

• Vendor Type - Single selection. Refers to the Entity Type on the Vendor forms. Since this report only includes In-House and Staff Vendors by default, those are the only two options in the list.

• Broker(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

• HR Status - No selection, single selection, multiple selections. “Active” is the default selection. Refers to the Status field on the broker’s HR/Personnel Record form.

• Only include Vendors with activity in this Pay Period - Checkbox. Selected by default. When checked, will only include entries for Vendors which have at least one Account Transaction for the selected date range.

Group By options (up to 2):

• Contact Name

• Primary Location

• Primary Business Line

• Primary Division

• Vendor Record Type

Click to go back to the list of reports.

Broker Ranking - Deal Statistics

A list of internal Contacts whose deals you are allowed to see, with rank, deal counts, total consideration (i.e. total lease/sale/transaction value), and square footage/acreage for a specific time frame.

All statistics on this report are based on Deals with a Closed Date that falls within the selected time frame, for which this Contact has an Expected Gross Commission on the Deal’s Fee Splits (Split Worksheet) form. Default ranking is based on the Contact’s Expected Gross Commission (not shown).

Report Fields:

• Rank - Each Contact’s ranking on this report, based on the current sort order

• Broker - The Last Name, First Name of the Contact. Refers to Contacts who are associated with an In-House or Staff Vendor on a deal’s Fee Splits / Split Worksheet form.

• Broker Primary Location - The Contact’s Primary Location

• Broker Primary Division - The Contact’s Primary Division

• Primary Business Line - The Contact’s Primary Business Line

• No. of Deals - Total number of Deals with a Closed Date in the selected date range

• Total Consideration - Total Transaction Value (e.g. lease value or sale price) from the Fee Calculation form associated with Deals with a Closed Date in the selected date range.

• Total Sq. Ft. - Total of Space SF from the Space Details form or (if the Deal is for the entire Property) the Building/Property SF from the Property Details form. This total includes all Space or Property Types except Land associated with Deals with a Closed Date in the selected date range.

• Acres - Total of Land Size (Acres) from the Space Details form or (if the Deal is for the entire Property) from the Building Details form. This includes only Land Spaces or Properties associated with Deals with a Closed Date in the selected date range.

Report Filters:

• Closed Date - Date range. Defaults to the first & last day of the current fiscal year. Refers to the Deal Closed Date on the Deal Settings form.

• Broker Location(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Location.

• Broker Business Line(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Business Line.

• Broker Division(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Division.

• Broker(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

• Broker Consideration Totals - Numeric min/max range.

• Broker SF Totals - Numeric min/max range.

• Broker Deal Count Totals - Numeric min/max range.

• Primary Business Line - Ignore: duplicate filter

• HR Status - No selection, single selection, multiple selections. “Active” is the default selection. Refers to the Status field on the broker’s HR/Personnel Record form.

Group By Options (up to 2):

• Location - Ignore: duplicate

• HR Status

• Broker

• Broker Primary Location

• Broker Primary Division

• Primary Business Line

Sort By Options (up to 2):

• HR Status

• Broker

• Broker Primary Location

• Broker Primary Division

• Primary Business Line

• No. of Deals

• Total Consideration

• Total Sq. Ft.

• Acres

Display Options:

• Display Criteria on Report

• Break Page After a Group

Click to go back to the list of reports.

Broker Ranking - Payments Received [SSRS]

A list of internal Contacts whose deals you are allowed to see, with rank, commission totals, and other deal statistics.

All statistics on this report are based on Deals with at least one Payment Date that falls within the selected time frame, for which this Contact has been credited a Gross Commission amount on the Payment Application form. Default ranking is based on the Contact’s paid Gross Commission.

Report Fields:

• Rank - Each Contact’s ranking on this report, based on the current sort order

• Broker - The Last Name, First Name of the Contact. Refers to Contacts who are associated with an In-House or Staff Vendor on a deal’s Fee Splits / Split Worksheet form.

• Broker Primary Location - The Contact’s Primary Location

• Broker Primary Division - The Contact’s Primary Division

• Primary Business Line - The Contact’s Primary Business Line

• Broker Gross - Total Gross Commission/Fees credited to this Contact from Payments received in the selected date range

• Net to Broker - Total Net Commission/Fees distributed to this Contact from Payments received in the selected date range. Does not include Net Adjustment amounts.

• Total Consideration - The Total Transaction Value from the Fee Calculation form, typically either the sales price or the value of the lease agreement (Lease Rate per SF x SF leased x Lease Term).

• Total Sq. Ft. - Total of Space SF from the Space Details form or (if the Deal is for the entire Property) the Building/Property SF from the Property Details form. This total includes all Space or Property Types except Land associated with Deals which received a Payment in the selected date range.

• Count - Total number of Deals with a Payment Date in the selected date range.

• Acres - Total of Land Size (Acres) from the Space Details form or (if the Deal is for the entire Property) from the Building Details form. This includes only Land Spaces or Properties associated with Deals which received a Payment in the selected date range.

Report Filters:

• Payment Date - Date range. Defaults to the first & last day of the current fiscal year. Refers to the Payment Date on the Payment Application form.

• Exclude Adjust - Yes/No. Defaults to “Yes”. Indicates whether or not to include voided Payments or Payment Voids in the calculations for the selected date range.

• Broker Location(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Location.

• Broker Division(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Division.

• Broker(s) - No selection, single selection, multiple selections. Lists of internal Contacts whose Deals you are allowed to see. Defaults to your name (i.e. the logged in user).

• Total Consideration Totals - Numeric min/max range.

• Total SF - Numeric min/max range.

• Count - Numeric min/max range.

• Broker Gross - Numeric min/max range.

• Broker Net - Numeric min/max range.

• Primary Business Line - No selection, single selection, multiple selections. Refers to the Contact’s Primary Business Line.

• HR Status - No selection, single selection, multiple selections. “Active” is the default selection. Refers to the Status field on the broker’s HR/Personnel Record form.

Group By Options (up to 2):

• HR Status

• Broker Division - Ignore: duplicate

• Broker

• Broker Primary Location

• Broker Primary Division

• Primary Business Line

Sort By Options (up to 2):

• HR Status

• Broker

• Broker Primary Location

• Broker Primary Division

• Primary Business Line

• Broker Gross

• Net to Broker

• Total Consideration

• Total Sq. Ft.

• Count

• Acres

Click to go back to the list of reports.

Commissions Paid Summary [SSRS]

A summary of Payments received (i.e. cash flow) with one line per grouping and totals for the Gross and Net Commissions, Net Adjustments and Net to Firm. More details are available for each group when you click on the Group By value. Subtotal amounts are located at the top of each group.

Report Fields:

• The first 2 columns display your selected Group By fields.

• Gross to Broker - The total gross commission amount distributed to the selected Group By fields for all Payments applied during the selected Payment Date range.

• Net to Broker - The total net commission amount distributed to the selected Group By fields for all Payments applied during the selected Payment Date range.

• Net Adjustments - The total Net Deduction / Expense amount distributed to the selected Group By fields for all Payments applied during the selected Payment Date range.

• Adjusted Net to Broker - Net to Broker plus Net Adjustments

• Net to Firm - Gross to Broker minus Net to Broker

Report Filters:

• Payment Date - Date range. Defaults to the first & last day of the current fiscal year. Refers to the Payment Date on the Payment Application form.

• Show Void? - Blank (=Yes)/No. Defaults to “No”. Indicates whether or not to include voided Payments or Payment Voids.

• Deal Name - Text entry. Use % as a wildcard symbol.

• Deal ID(s) - Text. Searches both the Internal Deal ID field on the Deal Settings form and the System ID for the Deal. Use a comma to separate multiple IDs (e.g. 5839, 3856a).

• Broker Location(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Location.

• Broker Business Line(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Business Line.

• Broker Division(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Division.

• Broker(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

• Deal Type(s) - No selection, single selection, multiple selections. Refers to the Deal Type field on the Deal Settings form.

• Deal Business Line(s) - No selection, single selection, multiple selections. Refers to the Business Line field on the Deal Settings form.

• HR Status - No selection, single selection, multiple selections. “Active” is the default selection. Refers to the Status field on the broker’s HR/Personnel Record form.

Group By Options (up to 2):

Defaults to Broker Location, then Broker

• Broker

• Broker Business Line

• Broker Division

• Broker Location

• Deal Business Line

• Deal Division

• Deal Location

• Deal Type

Click to go back to the list of reports.

Commissions Report - Payments Received [SSRS]

Breaks down individual Payments received (i.e. cash flow) by Broker with Gross, Net, and Adjusted Net amounts. This report includes key details of the Payment, Deal, and Property. When grouped, subtotals and totals are summarized at the bottom of each group.

Report Fields:

• Confidential - The Confidential checkbox from the Deal Settings or Lease/Sale Details forms. When a Deal is identified as Confidential, it is excluded from Comp search results unless Confidential Deals are specifically included.

• Deal ID - The Internal ID on the Deal Settings form for the Deal. If there is no Internal ID, the report will display the System ID for the Deal.
  Note: You can click on the Deal ID to go directly to that Deal.

• Broker - The broker’s Last Name, First Name

• Outside Broker - The name(s) of any outside brokers who are allocated a share of the deal commissions/fees.
  Specifically, the name(s) of Contacts or Companies listed on the Fee Splits / Split Worksheet form with an Outside Vendor record.

• Deal Type - The Deal Type on the Deal Settings form

• Deal Business Line - The Business Line on the Deal Settings form (vs. the broker’s Primary Business Line)

• Seller/Lessor - The first Contact or Company on the Deal Contacts form with a Role of “Seller/Landlord”

• Buyer/Lessee - The first Contact or Company on the Deal Contacts form with a Role of “Buyer/Tenant”

• Property Address - The Property Address from the Lease/Sale/Deal Location form

• SF - Space SF from the Space Details form or (if the Deal is for the entire Property) the Building/Property SF from the Building Details form.

• Transaction Value - The Total Transaction Value from the Fee Calculation form, typically either the sales price or the value of the lease agreement (dollar amount x SF leased x term).

• Deal % - This broker’s share of the Total Fees on the Deal. Matches the % of Deal for that Broker on the Fee Splits / Split Worksheet form.

• Payment Date - The Payment Date on the Payment Application form

• Payment Created Date - The date the Payment was actually entered in the system

• Commissions Paid - The total Payment Amount before distribution

• Gross to Broker - The broker’s Gross share of that Payment, i.e. the amount that will be added to their Production Credit / YTD Total.

• Net to Broker - The broker’s Net share after splitting their Gross Commission with the firm. Generally calculated based on their current YTD Total and their Split Plan.

• Net Adjustment - Total Net Adjustment / Net Expense amount applied for this Payment. If the Net Adjustment was taken from the Broker, the amount will be negative. If it was given to the Broker, the amount will be positive.

• Adjusted Net to Broker - Final Net amount distributed to Broker after all splits or adjustments have been applied.
  Specifically, the Net to Broker amount minus the Net Adjustment amount.

• Split % - The broker’s Net Commission Split percent for this Payment. Should match up with the Net to Broker divided by the Gross to Broker.

• Split Plan - The name of the Split Plan that was applied to calculate the Net to Broker, or an indication that a Fixed Net was applied to override system calculations

Report Filters:

• Payment Date - Date range. Defaults to the first & last day of the current fiscal year. Refers to the Payment Date on the Payment Application form.

• First Payment Only - Checkbox. Defaults to unchecked. When checked, only the very first Payment on the Deal will be included on the report, provided it falls within the Payment Date filter range. If there are other Payments on the Deal that fall within the Payment Date filter range but they are not the first Payment on the Deal, they will not display on the report.

• Show Voids - Checkbox. Defaults to unchecked. Indicates whether or not to include voided Payments or Payment Voids.

• Show Split Plan - Checkbox. Defaults to checked. Indicates whether or not to include the Split Plan Name (or Fixed Net indicator).

• Deal Name - Text entry. Use % as a wildcard symbol.

• Deal ID(s) - Text. Searches both the Internal Deal ID field on the Deal Settings form and the System ID for the Deal. Use a comma to separate multiple IDs (e.g. 5839, 3856a).

• Broker Location(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Location.

• Broker Business Line(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Business Line.

• Broker Division(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Division.

• Broker(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

• Deal Type(s) - No selection, single selection, multiple selections. Refers to the Deal Type field on the Deal Settings form.

• Deal Business Line(s) - No selection, single selection, multiple selections. Refers to the Business Line field on the Deal Settings form.

• HR Status - No selection, single selection, multiple selections. “Active” is the default selection. Refers to the Status field on the broker’s HR/Personnel Record form.

Display Options:

• Do Not Repeat Deal Data - Click here for more details about this setting

Group By Options (up to 2):

Defaults to: Broker, Deal Business Line

• Broker

• Broker Business Line

• Broker Division

• Broker Location

• Buyer/Lessee

• Deal Business Line

• Deal Division

• Deal ID

• Deal Location

• Deal Name

• Deal Type

• HR Status

• Month - i.e. the Payment Date’s month

• Primary Salesperson - Refers to the name of the Contact flagged as the Primary Salesperson on the Deal Contacts form

• Property Address

• Quarter - i.e. the Payment Date’s quarter

• Seller/Lessor

• Side Represented - Refers to the Side Represented field on the Deal Settings form

• Split Plan

• Year - i.e. the Payment Date’s year

Click to go back to the list of reports.

Commissions Report - Payments Received - Basic [SSRS]

Breaks down Payments received (i.e. cash flow) by Broker with Gross, Net, and Adjusted Net amounts. Only includes Payments distributed to Contacts associated with In-House or Staff Vendors on the Deal’s Split Worksheet. This report includes key details of the Payment, Deal, and Property. When grouped, subtotals and totals are summarized at the bottom of each group. When not grouped, this report has a format that is easier to work with in Excel than the Commissions Report - Payments Received [SSRS].

Report Fields:

• Confidential - The Confidential checkbox from the Deal Settings or Lease/Sale Details forms. When a Deal is identified as Confidential, it is excluded from Comp search results unless Confidential Deals are specifically included.

• Deal ID - The Internal ID on the Deal Settings form for the Deal. If there is no Internal ID, the report will display the System ID for the Deal.

• Broker - The broker’s Last Name, First Name

• Outside Broker - The name(s) of any outside brokers who are allocated a share of the deal commissions/fees.
  Specifically, the Last Name, First Name of Contacts listed on the Fee Splits / Split Worksheet form with an Outside Vendor record.

• Deal Type - The Deal Type on the Deal Settings form

• Deal Business Line - The Business Line field on the Deal Settings form.

• Seller/Lessor - The first Contact or Company on the Deal Contacts form with a Role of “Seller/Landlord”

• Buyer/Lessee - The first Contact or Company on the Deal Contacts form with a Role of “Buyer/Tenant”

• Property Address - The Property Address from the Lease/Sale/Deal Location form

• SF - Space SF from the Space Details form or (if the Deal is for the entire Property) the Building/Property SF from the Building Details form. Does not pertain to Land Spaces or Properties.

• Transaction Value - Total value of the transaction, typically either the sales price or the value of the lease agreement (dollar amount x SF leased x term).

• Deal % - This Broker’s share of the Total Fees on the Deal. Matches the % of Deal for that Broker on the Fee Splits / Split Worksheet form.

• Date Paid - The Payment Date on the Payment Application form

• Payment Created Date - The date the Payment was actually entered in the system. Displays only if that option is selected on the widget before running the report.

• Commissions Paid - The total Payment Amount before distribution

• Gross to Broker - The Broker’s Gross share of that Payment, i.e. the amount that will be added to their Production Credit / YTD Total.

• Net to Broker - The broker’s Net share after splitting their Gross Commission with the firm. Generally calculated based on their current YTD Total and their Split Plan.

• Net Adjustment - Total Net Adjustment / Net Expense amount applied for this Payment. If the Net Adjustment was taken from the Broker, the amount will be negative. If it was given to the Broker, the amount will be positive.

• Adjusted Net to Broker - Final Net amount distributed to Broker after all splits or adjustments have been applied.
  Specifically, the Net to Broker amount minus the Net Adjustment amount.

• Split % - The broker’s Net Commission Split percent for this Payment. Should match up with the Net to Broker divided by the Gross to Broker.

Report Filters:

• Payment Date - Date range. Defaults to the first & last day of the current fiscal year. Refers to the Payment Date on the Payment Application form.

• First Payments Only - Yes/blank (blank=No). Defaults to blank (“No”). When “Yes” is selected, only the very first Payment on the Deal will be included on the report, provided it falls within the Payment Date filter range. If there are other Payments on the Deal that fall within the Payment Date filter range but they are not the first Payment on the Deal, they will not display on the report.

• Show Void? - Yes/No. Defaults to “No”. Indicates whether or not to include voided Payments or Payment Voids.

• Deal Name - Text entry. Use % as a wildcard symbol.

• Deal ID(s) - Text. Searches both the Internal Deal ID field on the Deal Settings form and the System ID for the Deal. Use a comma to separate multiple IDs (e.g. 5839, 3856a).

• Show Payment Created Date - Yes/No. Defaults to “No”. Indicates whether or not to include the date the Payment was entered into the system.

• Broker Location(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Location.

• Broker Business Line(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Business Line.

• Broker Division(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Division.

• Broker(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

• Deal Type(s) - No selection, single selection, multiple selections. Refers to the Deal Type field on the Deal Settings form.

• Deal Business Line(s) - No selection, single selection, multiple selections. Refers to the Business Line field on the Deal Settings form.

• HR Status - No selection, single selection, multiple selections. “Active” is the default selection. Refers to the Status field on the broker’s HR/Personnel Record form.

Group By Options (up to 2):

Defaults to Broker

• Broker

• Broker Business Line

• Broker Division

• Broker Location

• Buyer/Lessee

• Deal Business Line

• Deal Division

• Deal ID

• Deal Location

• Deal Name

• Deal Type

• HR Status

• Month - i.e. the Payment Date’s month

• Primary Salesperson - Refers to the name of the Contact flagged as the Primary Salesperson on the Deal Contacts form

• Property Address

• Quarter - i.e. the Payment Date’s quarter

• Seller/Lessor

• Side Represented - Refers to the Side Represented field on the Deal Settings form

• Split Plan - Refers to the name of the Split Plan selected for each In-House or Staff Vendor on the Split Worksheet of the Deal

• Year - i.e. the Payment Date’s year

Click to go back to the list of reports.

Deal Activity [SSRS]

View Closed Deal details by Broker for a given time period. This report reflects all deals (regardless of billing or payment status), and can include Total Consideration, Total Commission/Fees, a breakdown of In-House vs Outside commissions, and the broker’s allocated Gross Commission amount.

Report fields:

• Deal ID - The Internal ID on the Deal Settings form for the Deal. If there is no Internal ID, the report will display the System ID for the Deal.

• Deal Name - The Deal Name from the Deal Settings form

• Booking Date - The Booking Date from the Fee Splits / Split Worksheet form, i.e. the date the deal was booked into the accounting/GL system

• Closed Date - The Deal Closed Date from the Deal Settings form, typically the date a lease was finalized or when escrow closed on a sale

• Deal Type - The Deal Type on the Deal Settings form

• Referral Type - The Referral Type on the Deal Settings form, i.e. the type of lead that generated the deal

• Assignment ID - The System ID of the Assignment the Deal is linked to

• Business Line - The Business Line from the Deal Settings form

• Division - The Division from the Deal Settings form

• Seller/Landlord - The first Company on the Deal Contacts form with a Role of “Seller/Landlord”

• Buyer/Tenant - The first Company on the Deal Contacts form with a Role of “Buyer/Tenant”

• Represented - The Side Represented field from the Deal Settings form

• Property Address - The Street Address from the Lease/Sale/Deal Location form

• City - The City from the Lease/Sale/Deal Location form

• State - The State/Province from the Lease/Sale/Deal Location form

• SF - The Space SF from the Space Details form, or (if the Deal is for the entire Property) the Building/Property SF from the Building Details form. Does not pertain to Land Spaces or Properties.

• Acres - Total of Land Size (Acres) from the Space Details form or (if the Deal is for the entire Property) from the Building Details form. This pertains only to Land Spaces or Properties.

• Lease Rate - The Actual/Starting Rent on the Lease Details form

• Term - The Term (# of months) from the Lease Details form

• Sale Price/SF - Reflects the final Sale Price per square foot. Specifically, the Sale (Actual) Price from the Sale Details form divided by the Space SF from the Space Details form or (if the Deal is for the entire Property) the Building/Property SF from the Property Details form.

• Consideration - The Total Transaction Value from the Fee Calculation form, typically either the sales price or the value of the lease agreement (Lease Rate per SF x SF leased x Lease Term).

• Total Commission - Total Fees (Gross Commission) from the Fee Calculation form. Note that this includes all fees & commissions, not just this Contact’s share.

• Outside Comm - The total commission/fee amount for any outside brokers who are allocated a share of the deal commissions/fees.
  Specifically, the total Expected Gross for Contacts listed on the Fee Splits / Split Worksheet form with an Outside Vendor record.

• In-house Gross - The total commission/fee amount for any internal parties or accounts who are allocated a share of the deal commissions/fees.
  Specifically, the total Expected Gross for House Accounts or for Contacts listed on the Fee Splits / Split Worksheet form with an In-House or Staff Vendor record.

• Gross to Broker - The broker’s Expected Gross Commission.
  Specifically, the Expected Gross Commission for this Contact on the Fee Splits / Split Worksheet form, provided the Contact is associated with an In-House or Staff Vendor record on that form.

• Deal % - Percent of the total commission/fee amount that is allocated to the broker.
  Specifically, the Gross to Broker divided by the Total Commission.

• Broker - The broker’s Last Name, First Name

Report Filters:

• Closed Date - Date range. Defaults to the first & last day of the current fiscal year. Refers to the Deal Closed Date from the Deal Settings form.

• Deal Location(s) - No selection, single selection, multiple selections. Refers to the Location field on the Deal Settings form.

• Deal Business Line(s) - No selection, single selection, multiple selections. Refers to the Business Line field on the Deal Settings form.

• Deal Division(s) - No selection, single selection, multiple selections. Refers to the Division field on the Deal Settings form.

• Referral Type - No selection, single selection, multiple selections. Refers to the Referral Type field on the Deal Settings form.

• Deal Type - No selection, single selection, multiple selections. Refers to the Deal Type field on the Deal Settings form.

• Deal Status - No selection, single selection, multiple selections. Refers to the Status field on the Deal Settings form.

• Broker - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

• Total Consideration Range - Numeric min/max range. Refers to the Total Transaction Value from the Fee Calculation form.

• Broker Location(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Location.

• Exclude Commission Amounts - Yes/No checkbox. Defaults to unchecked (i.e. commission amounts will be included). Checking the box hides the Total Commission, Outside Comm., In-House Gross, Gross to Broker and Deal % fields from the report.

Group By Options (up to 2):

• Broker Division

• Broker Business Line

• Broker Location

• Deal Location

• Primary Salesperson

• Deal Status

• Deal Name

• Booking Date

• Closed Date

• Deal Type

• Referral Type

• Assignment ID

• Business Line

• Division

• Seller/Landlord

• Buyer/Tenant

• City

• State

• Deal %

• Broker (default)

Sort By Options (up to 2):

• Property Address

• Deal Status

• Deal ID

• Deal Name

• Booking Date

• Closed Date

• Deal Type

• Referral Type

• Assignment ID

• Business Line

• Division

• Seller/Landlord

• Buyer/Tenant

• City

• State

• SF

• Acres

• Lease Rate

• Sale Price/SF

• Consideration

• Total Commission

• Outside Comm.

• In-house Gross

• Gross to Broker

• Deal %

Display Options:

• Display Criteria on Report

• Break Page After a Group

Click to go back to the list of reports.

Deal Activity Detail - Excel [SSRS]

Spreadsheet-style report that includes robust deal, property, deal participant, and broker share details and is designed to be exported to Excel. From there, sort and filter to conduct your own analysis and/or create your own graphs, charts, or pivot tables.

Report Fields:

• Deal ID - The Internal ID on the Deal Settings form for the Deal. If there is no Internal ID, the report will display the System ID for the Deal.

• Confidential - The Confidential checkbox from the Deal Settings or Lease/Sale Details forms. When a Deal is identified as Confidential, it is excluded from Comp search results unless Confidential Deals are specifically included.

• Deal Name - The Deal Name on the Deal Settings form

• Transaction Value - The Total Transaction Value from the Fee Calculation form, typically either the sales price or the value of the lease agreement (Lease Rate per SF x SF leased x Lease Term).

• Total Fees - Total Fees (Gross Commission) from the Fee Calculation form. Note that this includes all fees & commissions, not just this Contact’s share.

• Outside Gross - The total commission/fee amount for any outside brokers who are allocated a share of the deal commissions/fees.
  Specifically, the total Expected Gross for Contacts listed on the Fee Splits / Split Worksheet form with an Outside Vendor record.

• In-House Gross - The total commission/fee amount for any internal parties or accounts who are allocated a share of the deal commissions/fees.

• Gross to Broker - The broker’s Expected Gross Commission.
  Specifically, the Expected Gross Commission for this Contact on the Fee Splits / Split Worksheet form, provided the Contact is associated with an In-House or Staff Vendor record on that form.

• Deal % - This broker’s share of the Total Fees on the Deal. Matches the % of Deal for that Broker on the Fee Splits / Split Worksheet form.

• Payment Status - Indicates whether the Total Fees of the Deal have been Fully Paid, Partially Paid, or whether no Payment has been received yet for this Deal.

• Closed Date - The Deal Closed Date on the Deal Settings form, typically the date a lease was finalized or when escrow closed on a sale

• Broker - The broker’s Name

• Deal Type - The Deal Type on the Deal Settings form

• Broker Location - The broker’s Primary Location

• Broker Business Line - The broker’s Primary Business Line

• Broker Division - The broker’s Primary Division

• Referral Type - The Referral Type on the Deal Settings form, i.e. the type of lead that generated the deal

• Side Represented - The Side Represented field on the Deal Settings form

• Client - The name of the Company which is designated as the Client on the Deal Contacts form

• Seller/Landlord - The first Company on the Deal Contacts form with a Role of “Seller/Landlord”

• Buyer/Tenant - The first Company on the Deal Contacts form with a Role of “Buyer/Tenant”

• Property/Space Type - Space Type from the Space Details form or (if the Deal is for the entire Property) the Property Type from the Lease/Sale/Deal Location form.

• Primary Use - Primary Use from the Space Details form or (if the Deal is for the entire Property) the Primary Use from the Building Details form.

• Property Name - The Property Name from the Lease/Sale/Deal Location form

• Property Address - The Street Address from the Lease/Sale/Deal Location form

• City - The City from the Lease/Sale/Deal Location form

• State - The State/Province from the Lease/Sale/Deal Location form

• Zip Code - The Zip/Postal Code from the Lease/Sale/Deal Location form

• County - The County from the Lease/Sale/Deal Location form

• SF - Space SF from the Space Details form or (if the Deal is for the entire Property) the Building/Property SF from the Building Details form. Does not pertain to Land Spaces or Properties.

• Acres - Land Size (Acres) from the Space Details form or (if the Deal is for the entire Property) from the Building Details form. This pertains only to Land Spaces or Properties.

• Units - # Units from the Building Details form. This pertains only to Healthcare, Hospitality, Manufactured Housing, Multi-Family, and Self-Storage Properties.

• Lease Rate - The Actual/Starting Rent on the Lease Details form

• Rate Type - The Actual/Starting Rent Type on the Lease Details form. Indicates what is included (or not included) in the Lease Rate: e.g. NNN, Gross, etc.

• Lease Term - The Term (# of months) from the Lease Details form

• Commencement Date - The Commencement (date) from the Lease Details form

• Free Rent (mth(s)) - The Free Rent on the Lease Details form

• TI Allowance / SF - The TI Allowance / SF on the Lease Details form

• Sale Price - The Sale (Actual) Price from the Sale Details form

• Deal Location - The Location on the Deal Settings form (vs. the broker’s Primary Location)

• Deal Business Line - The Business Line on the Deal Settings form (vs. the broker’s Primary Business Line)

• Deal Division - The Division on the Deal Settings form (vs. the broker’s Primary Division)

• Market - The Market from the Lease/Sale/Deal Location form

• Sub-Market - The SubMarket/District from the Lease/Sale/Deal Location form

• Micro-Market - The Micromarket/Node from the Lease/Sale/Deal Location form

• Seller/Landlord Business Type - The Business Type from the Company Details form for the first Company on the Deal Contacts form with a Role of “Seller/Landlord”

• Seller/Landlord Parent Company - The Parent Company name from the Company Details form for the first Company on the Deal Contacts form with a Role of “Seller/Landlord”

• Seller/Landlord Parent Business Type - The Business Type from the Company Details form for Parent Company of the first Company on the Deal Contacts form with a Role of “Seller/Landlord”

• Tenant/Occupier Industry Type - The Tenant/Occupier Industry Type from the Lease Details form

• Booking Date - The Booking Date from the Fee Splits / Split Worksheet form, i.e. the date the deal was booked into the accounting/GL system

• On Market Date - The On Market (date) from the Lease/Sale Details form

• Months on Market - The Months On Market from the Lease/Sale Details form, which is typically calculated as the number of months between the On Market and Off Market (Sign Date).

• Assignment ID - The ‘Internal ID’ from the Assignment Settings form, or the System ID if there is no Internal ID

• System Deal ID - The System ID of this Deal

• Comp Type - The Comp Type from the Record Settings form. Indicates whether this Deal is a Lease, a Sale, or some other kind of deal such as Consulting or Referral. Effectively indicates whether this Deal will also show up in Comp searches (Lease, Sale).

Report Filters:

• Deal Closed Date - Date range. Defaults to the first & last day of the current fiscal year. Refers to the Deal Closed Date on the Deal Settings form.

• First Payment Date - Date range. Refers to the Payment Date of the first Payment applied to a Deal, even if other Payments have been applied to the same Deal.

• Broker Location(s) - No selection, single selection, multiple selections

• Broker Business Line(s) - No selection, single selection, multiple selections

• Deal Type(s) - No selection, single selection, multiple selections. Refers to the Deal Type field on the Deal Settings form.

• Referral Type(s) - No selection, single selection, multiple selections. Refers to the Referral Type field on the Deal Settings form.

• Broker Division(s) - No selection, single selection, multiple selections

• Broker - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

• Total Consideration - Numeric min/max range. Refers to the Total Transaction Value from the Fee Calculation form.

• Deal Payment Status - No selection, single selection, multiple selections. Indicates whether the Total Fees of the Deal have been Fully Paid, Partially Paid, or whether no Payment has been received yet for this Deal.

Click to go back to the list of reports.

HR Split Plans Report [SSRS]

Find all of the details for brokers' commission split plan(s): date ranges, dollar ranges, and the split percentage for each tier.

Report Fields:

• The first 2 columns will display your selected Group By fields with sub-totals for each Group.

• Contact Name - The First and Last Name of the broker

• Title - The Title from the Contact Details form

• Primary Division - The broker’s Primary Division

• Salary - The Pay Rate & Frequency from the Compensation History on the Contact’s HR (Personnel File) record

• Compensation Comments - The Compensation Memo from the Compensation History on the Contact’s HR (Personnel File) record

• Split Plan Name - The Split Plan Name on the HR Split Information form

• Start Date - The Start (date) on the HR Split Information form, i.e. when the Split Plan comes into effect.

• End Date - The End (date) on the HR Split Information form, i.e. the last day the Split Plan is in effect.

• Default - The “Use this Plan by default” setting on the HR Split Information form

• From $ - The low end of the range for a split threshold.
  Specifically, the From $ on the HR Split Information form.

• To $ - The high end of the range for a split threshold.
  Specifically, the To $ on the HR Split Information form.

• Split % - The broker’s commission split with the firm while their total gross for the year falls within the range for this tier.
  Specifically, the Split % on the HR Split Information form.

• Contact Id - The system ID assigned to the broker’s Contact record

• Hr Id - The system ID assigned to the broker’s HR / Personnel File record

• Split Plan Id - The system ID assigned to this Split Plan

Report Filters:

• Split Plan Dates - Date range. Defaults to the first & last day of the current fiscal year. Refers to the Start and End Dates on the HR Split Information form.

• Broker Location(s) - No selection, single selection, multiple selections

• Broker Business Line(s) - No selection, single selection, multiple selections

• Broker Division(s) - No selection, single selection, multiple selections

• Broker(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

Display Options:

• Display Record IDs - When checked, the Contact Id, Hr Id, and Split Plan Id fields will display at the end of the report.

• Display Contact Split Detail - When checked, the individual split threshold tiers will automatically display for each Split Plan.

Group By Options (up to 2):

• Primary Business Line

• Primary Division

• Primary Location

• Split Plan Name

• Split Plan Type - Determines whether net commissions are calculated when the Deal is booked or when a Payment is received. Specifically, the “Calculate YTD Production and Net Split amounts” field on the HR Split Information form.

Click to go back to the list of reports.

Lease Expirations w/Contact Info [SSRS]

See details of lease expirations from your team’s past lease deals to help plan your client follow up and business prospecting. This report includes the option to display contact details for the Lessor and Lessee as well as links to each Deal, Contact, Company, and email address.

Report Fields:

• Deal ID - The Internal ID on the Deal Settings form for the Deal. If there is no Internal ID, the report will display the System ID for the Deal.

• Broker - The broker’s Last Name, First Name

• Commencement - The Commencement (date) from the Lease Details form

• Expiration - The Expiration (date) from the Lease Details form

• Term - The Term (# of months) from the Lease Details form

• Represented - The Side Represented field on the Deal Settings form

• Lessor - The Company name of the first party on the Deal Contacts form with a Role of “Seller/Landlord”

• Lessor Name - The Contact name of the first party on the Deal Contacts form with a Role of “Seller/Landlord” (if that party is a Contact, not just a Company)

• Lessor Phone - The Direct Phone number of the first party on the Deal Contacts form with a Role of “Seller/Landlord” (if that party is a Contact, not just a Company)

• Lessor Email - The Email address of the first party on the Deal Contacts form with a Role of “Seller/Landlord” (if that party is a Contact, not just a Company)

• Lessee - The Company name of the first party on the Deal Contacts form with a Role of “Buyer/Tenant”

• Lessee Name - The Contact name of the first party on the Deal Contacts form with a Role of “Buyer/Tenant” (if that party is a Contact, not just a Company)

• Lessee Phone - The Direct Phone number of the first party on the Deal Contacts form with a Role of “Buyer/Tenant” (if that party is a Contact, not just a Company)

• Lessee Email - The Email address of the first party on the Deal Contacts form with a Role of “Buyer/Tenant” (if that party is a Contact, not just a Company)

• Address - The Street Address from the Deal’s Lease Location form

• SF Leased - Space SF from the Space Details form or (if the Deal is for the entire Property) the Building/Property SF from the Building Details form

• Total Consideration - The Total Transaction Value from the Fee Calculation form, typically the value of the lease agreement (Lease Rate per SF x SF leased x Lease Term).

• System ID - The System ID of the Deal

Report Filters:

• Lease Expiration Date - Date range. Defaults to the first & last day of the current fiscal year.

• Lease Commencement Date - Date range. Refers to the Commencement (date) on the Lease Details form.

• Occupancy Date - Date range. Refers to the Occupancy (date) on the Lease Details form.

• Broker Location(s) - No selection, single selection, multiple selections

• Broker Business Line(s) - No selection, single selection, multiple selections. Refers to the Broker’s Primary Business Line.

• Broker Division(s) - No selection, single selection, multiple selections. Refers to the Broker’s Primary Division.

• Broker(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

• Deal Type(s) - No selection, single selection, multiple selections. Refers to the Deal Type field on the Deal Settings form.

Display Options:

• Include Contact Details

• Start each grouping on a new page or tab (same option as Break Page After a Group)

• Display Criteria on Report

Group By Options (up to 2):

• Broker

• Broker Business Line

• Broker Division

• Broker Location

• Deal Business Line

• Deal Location

• Expiration

• Lessee

• Lessor

• Month

• Quarter

• Represented

Click to go back to the list of reports.

Lease Options w/Contacts & Notice Date [SSRS]

See details of lease options from your team’s past lease deals to help plan your client follow up and business prospecting. In addition to typical filters, this report offers detailed date range searches for all of the lease options tracked within your system: Renewals, Purchase Options, Expansion Options, and Early Termination. The report includes various options to display or hide each Lease Option and/or contact details for the Lessor and Lessee.

Report Fields:

• Deal ID - The Internal ID on the Deal Settings form for the Deal. If there is no Internal ID, the report will display the System ID for the Deal.

• Renewal Option - The Renewal (option date) from the Lease Details form

• Renewal Option Notice - The Renewal Notice (date) from the Lease Details form

• Renewal Option Note - The Renewal Notes from the Lease Details form

• Purchase Option - The Purchase (option date) from the Lease Details form

• Purchase Option Notice - The Purchase Notice (date) from the Lease Details form

• Option to Purchase Note - The Purchase Notes from the Lease Details form

• Expansion Option - The Expansion (option date) from the Lease Details form

• Expansion Option Notice - The Expansion Notice (date) from the Lease Details form

• Expansion Option Note - The Expansion Notes from the Lease Details form

• Early Termination Option - The Early Termination (option date) from the Lease Details form

• Early Termination Option Notice - The Expansion Notice (date) from the Lease Details form

• Early Termination Option Note - The Expansion Notes from the Lease Details form

• Side Represented - The Side Represented field from the Deal Settings form

• Lessor - The Company name of the first party on the Deal Contacts form with a Role of “Seller/Landlord”

• Lessor Contact - The Contact name of the first party on the Deal Contacts form with a Role of “Seller/Landlord” (if that party is a Contact, not just a Company)

• Lessor Phone - The Direct Phone number of the first party on the Deal Contacts form with a Role of “Seller/Landlord” (if that party is a Contact, not just a Company)

• Lessor Email - The Email address of the first party on the Deal Contacts form with a Role of “Seller/Landlord” (if that party is a Contact, not just a Company)

• Lessee - The Company name of the first party on the Deal Contacts form with a Role of “Buyer/Tenant”

• Lessee Contact - The Contact name of the first party on the Deal Contacts form with a Role of “Buyer/Tenant” (if that party is a Contact, not just a Company)

• Lessee Phone - The Direct Phone number of the first party on the Deal Contacts form with a Role of “Buyer/Tenant” (if that party is a Contact, not just a Company)

• Lessee Email - The Email address of the first party on the Deal Contacts form with a Role of “Buyer/Tenant” (if that party is a Contact, not just a Company)

• SF Leased - Space SF from the Space Details form or (if the Deal is for the entire Property) the Building/Property SF from the Building Details form

• Address - The Street Address from the Lease Location form

• Broker - The Broker’s Contact name

• Lease Option Comments - The Lease Option Comments from the Lease Details form

• System ID - The System ID of the Deal

Display Options:

• Include Contact Details - display/hide: Lessor Contact, Lessor Phone, Lessor Email, Lessee Contact, Lessee Phone, Lessee Email

• Include Renewal Option - display/hide: Renewal Option (date), Renewal Option Notice (date), Renewal Option Note

• Include Purchase Option - display/hide: Purchase Option (date), Purchase Option Notice (date), Purchase Option Note

• Include Expansion Option - display/hide: Expansion Option (date), Expansion Option Notice (date), Expansion Option Note

• Include Early Termination Option - display/hide: Early Termination Option (date), Early Termination Option Notice (date), Early Termination Option Note

Report Filters:

• Renewal Option Date - Date range.

• Renewal Option Notice Date - Date range.

• Purchase Option Date - Date range.

• Purchase Option Notice Date - Date range.

• Expansion Option Date - Date range.

• Expansion Option Notice Date - Date range.

• Early Termination Option Date - Date range.

• Early Termination Option Notice Date - Date range.

• Property Name - Text. Filters for deals with that text as part of the Property Name.

• Broker Location(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Location

• Broker Business Line - No selection, single selection, multiple selections. Refers to the Contact’s Primary Business Line.

• Broker Division(s) - No selection, single selection, multiple selections. Refers to the Contact’s Primary Division.

• Deal Type(s) - No selection, single selection, multiple selections. Refers to the Deal Type field on the Deal Settings form.

• Deal Business Line(s) - No selection, single selection, multiple selections. Refers to the Business Line field on the Deal Settings form.

• Broker(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

• Total Consideration - Numeric min/max range. Refers to the Total Transaction Value from the Fee Calculation form.

• Total Fees - Numeric min/max range. Refers to the Total Fees from the Fee Calculation form.

• In-House Gross - Numeric min/max range. Refers to the total commission/fee amount for any internal parties or accounts who are allocated a share of the deal commissions/fees.
  Specifically, the total Expected Gross for Contacts listed on the Fee Splits / Split Worksheet form with an In-House or Staff Vendor record or for House Accounts.

Group By Options (up to 2):

• Broker

• Broker Division

• Broker Location

• Deal Type

• Deal Business Line

• Primary Salesperson

• Side Represented

• Lessor

• Lessee

Sort By Options (up to 2):

• Broker

• Broker Division

• Broker Location

• Deal Type

• Deal Business Line

• Primary Salesperson

• Purchase

• Renewal

• Expansion

• Early Termination

• Side Represented

• Lessor

• Lessee

• Address

• SF Leased

Click to go back to the list of reports.

Production Summary Report [SSRS]

View totals for the number of deals closed during a given month or year and the Expected Gross Commission allocated to internal brokers on those deals. A table, bar graphs, and pie charts break the information down by Location, Business Line, Division, and Top 15 Brokers.

Report Fields:

• The first 2 columns will display your selected Group By fields with sub-totals for each Group

• Goal ($) - The Broker’s applicable HR Goal Amount for the selected Month/Year

• Goal (%) - The percent of the Broker’s Goal that has been reached through the selected Month/Year.
  Specifically, the Gross Commissions: YTD (see below) divided by the Goal ($) (see above).

• Gross Commissions: MTD - Total of the Expected Gross Commission for all (internal) brokers from deals closed in the selected month.
  Specifically, the total Expected Gross Commission amount allocated to In-House Vendors on the deal’s Fee Splits / Split Worksheet form from deals with a Deal Closed Date in the selected month.

• Gross Commissions: YTD - Total of the Expected Gross Commission for all (internal) brokers from deals closed in the selected year.
  Specifically, the total Expected Gross Commission amount allocated to In-House Vendors on the deal’s Fee Splits / Split Worksheet form from deals with a Deal Closed Date in the selected year.

• Deal Count: MTD - Total number of deals closed in the selected month.
  Specifically, the total number of deals with a Deal Closed Date in the selected month.

• Deal Count: YTD - Total number of deals closed in the selected year.
  Specifically, the total number of deals with a Deal Closed Date in the selected year.

Report Filters:

• Closed Deal Date Month - Single selection from a pulldown menu. Defaults to the current month. Refers to the The Deal Closed Date on the Deal Settings form, typically the date a lease was finalized or when escrow closed on a sale.

• Closed Deal Date Year - Single selection from a pulldown menu. Defaults to the current year. Refers to the The Deal Closed Date on the Deal Settings form, typically the date a lease was finalized or when escrow closed on a sale.

• Location(s) - No selection, single selection, multiple selections. Refers to the Location field on the Deal Settings form.

• Division(s) - No selection, single selection, multiple selections. Refers to the Division field on the Deal Settings form.

• Business Line(s) - No selection, single selection, multiple selections. Refers to the Business Line field on the Deal Settings form.

• Gross Commission Range - Numeric min/max range. Refers to the Total Fees from the deal’s Fee Calculation form.

• Broker(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

Display Options:

• Show Details? - By default, the report displays only the subtotals and totals for each selected grouping, with the option to expand each group to see its contents. When this box is checked, each group is expanded on the report as soon as it opens.

• Include Broker Goals? - When checked, the Goal ($) and Goal (%) columns display on the report.

Group By Options (up to 2):

• Broker

• Deal Business Line

• Deal Location

• YTD Count

Click to go back to the list of reports.

Projected Income Report [SSRS]

View a forecast of projected (pipeline), unbilled, billed (invoiced), and/or paid gross commissions and other fees with details about the deal, invoice, payment, and broker. Includes a breakdown of those amounts for the next 12 months based on the invoice due date or the payment date. Flexible options allow you to include pipeline deals, unbilled invoices, and/or recent payments. You can also indicate whether the amounts should reflect the broker’s gross or net, or the anticipated or paid net for the firm.

Report Fields:

• Deal ID - The Internal ID on the Deal Settings form for the Deal. If there is no Internal ID, the report will display the System ID for the Deal.

• Activity Type - Indicates whether each row represents a projected payment from a Pipeline deal (i.e. a deal that hasn’t closed yet), an unbilled vs billed Invoice on a closed deal, or from a received Payment

• Deal Name - The Deal Name from the Project/Deal Settings form

• Deal Type - The Deal Type on the Project/Deal Settings form

• Buyer/Tenant - The first Company on the Deal Contacts form with a Role of “Buyer/Tenant”

• Seller/Landlord - The first Company on the Deal Contacts form with a Role of “Seller/Landlord”

• Broker Name - The First & Last Name of the Contact whose details and amounts are reflected in this row for this invoice or (anticipated) payment

• Broker Location - The broker’s Primary Location

• Broker Business Line - The broker’s Primary Business Line

• Close Date - The Deal Closed Date on the Deal Settings form, typically the date a lease was finalized or when escrow closed on a sale

• Deal Status - The ‘Status’ from the Project/Deal Settings form

• Probability - The Est. Probability (%) from the deal’s Pipeline form

• Size - For Land Spaces or Properties: Land Size (Acres) from the Space Details form or (if the Deal is for the entire Property) from the Building Details form. For all other Space/Property Types: Space SF from the Space Details form or (if the Deal is for the entire Property) the Building/Property SF from the Building Details form.

• Side Represented - The Side Represented field on the Deal Settings form

• Escrow Deposit($) - The Escrow Deposit from the Sale Details form

• Total Fees - For Pipeline Deals: Total Estimated Fees ($) from the Pipeline form.
  For Closed Deals: Total Fees (Gross Commission) from the Fee Calculation form.
  Note that in all cases, this includes all fees & commissions, not just this Contact’s share.

• In-House Fees - The total commission/fee amount for any internal parties or accounts who are allocated a share of the deal commissions/fees.
  Specifically, for Pipeline Deals: The Est. Gross In-House Fees ($) from the Pipeline form.
  For Closed Deals: The total Expected Gross for Contacts listed on the Fee Splits / Split Worksheet form with an In-House or Staff Vendor record or for House Accounts.

• Outside Fees - The total commission/fee amount for any external parties or accounts who are allocated a share of the deal commissions/fees.
  Specifically, for Pipeline Deals: Est. Outside Fees ($) + Est. Referral Fees ($) from the Pipeline form.
  For Closed Deals: The total Expected Gross for Contacts listed on the Fee Splits / Split Worksheet form with an Outside Vendor record.

• Invoice # - The Invoice # from the Create Invoice form. May reflect a custom Invoice number or may be identical to the System ID of the Invoice.

• Invoice ID - The System ID of this Invoice

• Invoice Amount (Weighted) - Total invoice amount multiplied by the probability of closure, e.g. $10,000 x 50% = $5,000.
  Specifically, for Pipeline Deals: Total Invoice Amount from the Payment Schedule on the Pipeline form x Est. Probability (%) on the Pipeline form.
  For Closed Deals: Invoice Amount from the Invoicing form x 100% (all Closed Deals have a 100% probability of closure).

• Due Date - The date the (anticipated, billed or paid) Invoice is due.
  Specifically, for Pipeline Deals: Due Date from the Payment Schedule on the Pipeline form.
  For Closed Deals: the current Due Date from the Invoicing form.

• Invoice Remaining - The current unpaid amount for this Invoice.
  Specifically, the Invoice Amount minus the Payment Amount applied to this Invoice.

• Broker Gross Share - The broker’s current share of this Invoice before their share is split with the firm.
  Specifically, for Pipeline Deals: The Total Invoice Amount on the Pipeline form multiplied by the % Share (Gross) for this Contact from the Deal Share form.
  For Closed Deals: The Invoice Amount from the Invoicing form multiplied by the Split $ (Listing Side + Procuring Side) for this Contact from the Fee Splits / Split Worksheet form divided by the Total Fees from the Fee Calculation form. Note that to ensure accuracy, this calculation uses the actual $ amounts rather than the Split % from the Fee Splits / Split Worksheet form.

• Broker Remaining Gross - The broker’s share of the remaining balance on this Invoice before their share is split with the firm.
  Specifically, for Pipeline Deals: The Total Invoice Amount on the Pipeline form multiplied by the % Share (Gross) for this Contact from the Deal Share form (i.e. the same as for Broker Gross Share since a Pipeline Invoice can’t have any Payments applied to it).
  For Closed Deals: The Invoice Remaining amount (Invoice Amount minus Amount Paid on this Invoice) divided by the unpaid balance of the Total Fee amount (Total Fees minus Total Paid on the Deal) multiplied by the unpaid balance of this Contact’s Split $ from the Fee Splits / Split Worksheet form (Expected Gross minus Paid Gross).

• Payment Amount - The Payment Amount from the Payment Application form

• Paid Date - The Payment Date from the Payment Application form

• Prior - The anticipated or paid amount for this Broker or for the firm, if the Due Date for the Invoice or (for Payments) the Payment Date is earlier than the month for the As Of Date. The amount will reflect gross or net for the Broker or the firm depending on your selection on the widget before running the report. Except for Payments, the amount includes all invoice adjustments made to date.

• Year-Month - 12 columns representing the 12 months that start with the As Of Date’s month. These columns contain the anticipated or paid amount for this Broker or for the firm, if the Due Date for the Invoice or (for Payments) the Payment Date falls in this month. The amount will reflect gross or net for the Broker or the firm depending on your selection on the widget before running the report. Except for Payments, the amount includes all invoice adjustments made to date.

• After - The anticipated or paid amount for this Broker or for the firm, if the Due Date for the Invoice or (for Payments) the Payment Date is later than the last Year-Month column on this report. The amount will reflect gross or net for the Broker or the firm depending on your selection on the widget before running the report. Except for Payments, the amount includes all invoice adjustments made to date.

• System ID - The System ID of this Deal

Display Options:

• Represent the amounts on this report as

  • Gross to Firm - The commission/fee amount due to a broker or other internal party before net split calculations

  • Estimated Net to Firm - The estimated commission/fee amount due to the firm after net split calculations. Net split calculations are based on the broker’s current YTD Production Credit (total gross commission received) and their current split plan.

  • Estimated Net to Broker(s) - The estimated commission/fee amount due to the broker after net split calculations. Net split calculations are based on the broker’s current YTD Production Credit (total gross commission received) and their current split plan.

Report Filters:

• As Of Date - Required. Date (mm/dd/yyyy). Defaults to today’s date. Determines when the 12-month breakdown begins and whether an amount is included in one of those months or in the Prior or After columns. Click here for more information.

• Include Payments (in this period) - Checkbox. Determines whether to include Payments with a Payment Date that falls within the 12-month breakdown.

• Include Unbilled Invoices - Checkbox. Determines whether to include unbilled Invoices with a Due Date that falls within the 12-month breakdown.

• Include Pipeline - Checkbox. Determines whether to include projected Invoices with a Due Date that falls within the 12-month breakdown.
  Note: If none of the above boxes are checked, the report will only include billed Invoices with a Due Date that falls within the 12-month breakdown.

• Probability minimum % - Numeric. Refers to the Est. Probability (%) on the Pipeline form.

• Broker Location(s) - No selection, single selection, multiple selections

• Broker Business Line(s) - No selection, single selection, multiple selections

• Deal Type(s) - No selection, single selection, multiple selections. Refers to the Deal Type field on the Deal Settings form.

• Deal Status - No selection, single selection, multiple selections. Refers to the Status field on the Deal Settings form.

• Broker Division(s) - No selection, single selection, multiple selections

• Broker(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

Group By Options (up to 2):

• Deal ID

• Deal Type

• Broker Location

• Broker Activity Type

• Broker Business Line

• Close Date

• Deal Status

• Invoice #

• Invoice ID

• Due Date

• Invoice Status Aging - Refers to the Aging categories for Invoices, e.g. 0-30 days, 31-60 days, etc.

• Broker

Click to go back to the list of reports.

Revenue Projection Report [SSRS]

An older version of the Projected Income [SSRS] report. View a forecast of projected (pipeline), unbilled, and billed gross commissions and other fees with details about the deal, invoice, and broker. Includes a breakdown of those amounts for the next 12 months based on expected or actual invoice due date. You have the option to include Pipeline deals or only report on Closed Deals.

Report Fields:

• Broker - The broker’s Last Name, First Name

• Deal ID - The Internal ID on the Deal Settings form for the Deal. If there is no Internal ID, the report will display the System ID for the Deal.

• Deal Name - The Deal Name from the Project/Deal Settings form

• Close Date - The Deal Closed Date on the Deal Settings form, typically the date a lease was finalized or when escrow closed on a sale

• Status - The Status from the Project/Deal Settings form

• Probability - The Est. Probability (%) from the deal’s Pipeline form

• Buyer/Tenant - The first Company on the Deal Contacts form with a Role of “Buyer/Tenant”

• Seller/Landlord -The first Company on the Deal Contacts form with a Role of “Seller/Landlord”

• Sq.Ft./Acres - For Land Spaces or Properties: Land Size (Acres) from the Space Details form or (if the Deal is for the entire Property) from the Building Details form. For all other Space/Property Types: Space SF from the Space Details form or (if the Deal is for the entire Property) the Building/Property SF from the Building Details form.

• Side Represented - The Side Represented field on the Deal Settings form

• Total Transaction Value - The Total Transaction Value from the Fee Calculation form, typically either the sales price or the value of the lease agreement (Lease Rate per SF x SF leased x Lease Term).

• Gross Fees - Total Fees (Gross Commission) from the Fee Calculation form. Note that this includes all fees & commissions, not just this Contact’s share.

• In-House Fees - The total commission/fee amount for any internal parties or accounts who are allocated a share of the deal commissions/fees.
  Specifically, for Pipeline Deals: The Est. Gross In-House Fees ($) from the Pipeline form.
  For Closed Deals: The total Expected Gross for Contacts listed on the Fee Splits / Split Worksheet form with an In-House or Staff Vendor record or for House Accounts.

• Invoice # - The Invoice # from the Create Invoice form. May reflect a custom Invoice number or may be identical to the System ID of the Invoice.

• Invoice Amount - The entire amount anticipated or billed on this Invoice.
  Specifically, for Pipeline Deals: Total Invoice Amount from the Payment Schedule on the Pipeline form.
  For Closed Deals: Invoice Amount from the Invoicing form.

• Due Date - The date the (anticipated or billed) Invoice is due.
  Specifically, for Pipeline Deals: Due Date from the Payment Schedule on the Pipeline form.
  For Closed Deals: The current Due Date from the Invoicing form.

• Amount Paid - The total Payment Amount applied to this Invoice

• Outstanding - The current unpaid amount for this Invoice.
  Specifically, the Invoice Amount minus the total Payment Amount applied to this Invoice.

• Deal Share % - This broker’s share of the Total Fees on the Deal.
  Specifically, for Pipeline Deals: % Share (Gross) for this Contact from the Deal Share form.
  For Closed Deals: % of Deal for that Broker on the Fee Splits / Split Worksheet form.

• Broker Gross Commission - The broker’s share of this Invoice before their share is split with the firm. Specifically, for Pipeline Deals: The Total Invoice Amount on the Pipeline form multiplied by the % Share (Gross) for this Contact from the Deal Share form.
  For Closed Deals: The Outstanding amount (see above) multiplied by the Deal Share % (see above).

• Prior - The anticipated (gross) amount for this Broker, if the Due Date for the Invoice is earlier than the selected Actual/Estimated Due Date month.

• Year-Month - 12 columns representing the 12 months that start with the selected Actual/Estimated Due Date month, with the anticipated (gross) amount for this Broker.

• After - The anticipated (gross) amount for this Broker, if the Due Date for the Invoice is later than the last Year-Month column on this report.

Report Filters:

• Only Closed Deals - Checkbox. Filters out Pipeline Deals from the results on the report.

• Due Date - Required. Pulldown with a list of months. Defaults to the current month. Determines when the 12-month breakdown begins and whether an amount is included in one of those months or in the Prior or After columns.

• Actual/Estimate - Required. Pulldown with a list of years. Defaults to the current year. Determines when the 12-month breakdown begins and whether an amount is included in one of those months or in the Prior or After columns.

• Deal Type(s) - No selection, single selection, multiple selections. Refers to the Deal Type field on the Deal Settings form.

• Deal Status - No selection, single selection, multiple selections. Refers to the Status field on the Deal Settings form.

• Deal Location(s) - No selection, single selection, multiple selections. Refers to the Location field on the Deal Settings form.

• Deal Business Line(s) - No selection, single selection, multiple selections. Refers to the Business Line field on the Deal Settings form.

• Broker(s) - No selection, single selection, multiple selections. Lists internal Contacts whose Deals you are allowed to see.

Display Options:

• Do Not Repeat Deal Data - Click here for more details about this setting

Group By Options (up to 2):

• Broker

• Buyer/Tenant

• Closed Date

• Deal ID

• Deal Name

• Due Date

• Seller/Landlord

• Side Represented

• Status

Click to go back to the list of reports.

Related Articles

• CTS Web Reports for Brokers

• CTS Web Reports for Managers, Team Leaders & Staff

• CTS Web Reports for Executives, Admins & Corporate

• CTS Receivables Reports for Brokers

• CTS Receivables Reports for Executives, Admins & Corporate

• CTS Web & Receivables Reports Comparison Chart

If you have any questions or would like to schedule a detailed training on this feature, please contact [email protected].

© 2023 CoStar Group