The CTS Receivables Reports widget allows users to run accounting reports related to the ‘Commission Tracking System’ module. This document covers the CTS Receivables reports which can be run for/by executives, administrative staff, or for corporate reporting.

Reports

Invoice Audit List [SSRS]

This report contains a list of all Invoice and Invoice Void records, regardless of billing, payment or void state of the Invoice. You can audit all invoice records via this report, e.g. to determine why the system-assigned Invoice # may have skipped a sequential number (generally it’s because another Invoice was voided, and the system assigned that number to the Void record).

Report Fields:

• System Seq. # - The System ID assigned to that Invoice or Invoice Void 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.

• Record Type - Indicates whether the record is an Invoice, a Voided Invoice (i.e. an Invoice that has been voided), or an Invoice Void (i.e. the record that represents the Void action).

• 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

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

• Invoiced 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.

• Payment Status - Indicates whether the Invoice is

  • Open (not fully paid & Due Date is in the future),

  • Past Due (not fully paid & Due Date is in the past),

  • Paid (fully paid),

  • Voided (not paid and also voided),

  • Void (represents a Void record, therefore cannot be paid), or

  • Unbilled (not invoiced, i.e. not given an Invoice # and Invoice Date)

• Invoice/Void Amount - For Invoices: the Invoice Amount. For Voids: the Void Amount (which is the negative of the Invoice Amount)

• Void Date - The Void Date on the Void Invoice form

• Last Revised/Adj Date - The most recent date any modification was made to or activity taken on the Invoice

• Adj Amount - The total Adjustment Amount of all Adjustments made to that Invoice

• Fee/Void Details - For Invoices: the Fee Details on the Invoices tab of the Closed Deal. For Voids: the Void Comments on the Void Invoice form.

Report Filters:

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

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

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

• System Sequence # - Min-max range for Invoice System IDs

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

• Invoice Due Date - Min-max range.

• Invoice/Void Amount - Min-max range for Invoice Amount or Invoice Void Amount

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

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

• Property - Text entry. Filters for deals with that text as part of the Street Address.

Group By Options (up to 2):

• Deal Business Line

• Deal ID

• Deal Location

• Deal Name

• Property

Sort By Options (up to 2):

• Adj Amount

• Deal Business Line

• Deal ID

• Deal Location

• Deal Name

• Invoice Due Date

• Invoice #

• Invoice/Void Amount

• Invoiced Date

• Last Revised/Adj Date

• Payment Status

• Property

• Record Type

• System Sequence #

• Void Date

Click to go back to the list of reports.

Open Balances [SSRS]

A summary of A/R totals for each Closed Deal that has not been fully paid. Includes total Expected Gross (Total Fees) for the entire Deal, how much of that amount was invoiced vs not invoiced, how much was paid, and the remaining balance. This is a great report for finding Deals which may need a small write-off, which still need to be invoiced, or which may need to go to Collections.

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 on the Deal Settings form

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

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

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

• Brokers - The names of any Contacts who are linked to an In-House Vendor on the Fee Splits / Split Worksheet form

• Expected Gross - Total Fees from the Fee Calculation form.

• Invoiced - The total amount billed on this Deal, i.e. the total Invoice Amount from Invoices which have been assigned an Invoice Date and Invoice # (regardless of whether the Invoice has been paid)

• Uninvoiced - The total Expected Gross amount that has not been billed on this Deal.
  Specifically, the Expected Gross amount minus the Invoiced amount.

• Paid - The total Payment Amount applied to this Deal.

• Outstanding - The remaining balance of unpaid fees on this Deal.
  Specifically, the Expected Gross amount minus the Paid amount.

• Brokers/Staff Gross Remaining - The total Gross amount on this Deal that hasn’t (yet) been paid to internal brokers or staff.
  Specifically, the portion of the Outstanding amount that is allocated to In-house or Staff Vendors on the Split Worksheet (as opposed to Outside Vendors or House Accounts).

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.

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

• Deal Location(s) - No selection, single selection, multiple selections. Refers to the Location field on the Deal Settings 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

• Deal Location

• Deal Name

• Landlord/Seller

• Primary Salesperson

• Property Address

• Tenant/Buyer

Sort By Options (up to 2):

• Deal ID

• Deal Name

• Property Address

• Landlord/Seller

• Tenant/Buyer

• Expected Gross

• Invoiced

• Uninvoiced

• Paid

• Outstanding

Click to go back to the list of reports.

Open Invoice Statement [SSRS]

Produces statements with open invoices and (if selected) payment history for Customer accounts. The relevant pages of this report are designed to be sent to each Customer so they can see their billed invoices, upcoming billings (i.e. unbilled invoices), payment history, and current balance.

Report Fields:

• Date - Today’s date

• Address & Phone number under the logo - Displays the Address & Phone Number from the selected Remittance Address or the Remittance Address for the user’s primary location

• Bill To - Displays the Address & Email from the Customer form

• Open Invoices - Displays billed and unbilled invoices

  • 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

  • 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 Date - The billing date for this Invoice. Specifically, the Invoice Date on the Create Invoice form.

  • Amount - The entire amount billed on this Invoice. Specifically, the Invoice Amount from the Invoicing form.

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

  • Paid - The total amount applied to this Invoice via Payment(s).

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

  • Total Outstanding - The remaining balance of unpaid fees from the Invoices listed in this section. Specifically, the total (Invoice) Amount minus the total Paid amount.

• Payment History - Displays Payments

  • 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

  • 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.

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

  • Method - The Method on the Payment Application form

  • Reference/Description - The Reference # on the Payment Application form

  • Amount - The amount applied to this Invoice Number from this Payment.

  • Total Paid - The total Amount paid on Payments listed in this section.

• Please remit payment to - Displays the Address, Phone Number, and Attention To from the selected Remittance Address or the Remittance Address for the user’s primary location

• Wiring Instructions - The Wiring/ACH Instructions from the Remittance Address form

Report Filters:

• Customer - Customer Account Entity lookup.

• Deal Close 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.

• 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.

• Include customers with balance greater than - When populated, the report will only produce statements for Customers which have a total account balance that exceeds the specified amount.

• Include paid invoices paid after [date] - If selected and a date is not specified, the report includes invoices with and without payments. If selected and a date is specified, the report only includes invoices with applied payments.

• Include Payment History after [date] - When selected, displays the Payment History section with Payments applied to this Customer’s Deals. If the [date] field is populated, the Payment History section only displays Payments with a Payment Date after the indicated date. If this option is not selected, the entire Payment History section is hidden.

Display Options:

• Include Remittance Address under Logo - When selected, displays the selected Remittance Address under the logo (e.g. for windowed envelopes). If not selected, the Remittance Address under the logo is hidden (it still displays at the bottom of the statement).

• Include Customer Email Address - When selected, displays the Email address from the Customer record in the “Bill To” section of each statement.

• Remit Address - Allows you to select which Invoice Remittance Address is displayed on each statement. If none of the available addresses are selected, the statement displays the Remittance Address for the user’s primary location.

Click to go back to the list of reports.

Open Invoices and Aging Summary [SSRS]

View a list of open (billed and not paid) Invoices with key billing details, current aging (both the specific # of days aged past the Due Date and the Aging category), and the latest Status information.

Report Fields:

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

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

• Payment Status - Indicates whether the Invoice is Open (not fully paid & Due Date is in the future) or Past Due (not fully paid & Due Date is in the past)

• Invoice Amount - The entire amount billed on this Invoice. Specifically, the Invoice Amount from the Invoicing form.

• Amount Paid - The total amount applied to this Invoice via Payment(s).

• Outstanding - The current unpaid amount for this Invoice.

• Customer - The name of the Company on the Deal Contacts form designated as the “Billing Customer”

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

• 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 - The Deal Name on the Deal Settings form

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

• Broker(s) - The names of any Contacts who are linked to an In-House Vendor on the Fee Splits / Split Worksheet form

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

• Aging - A categorization of how many days are between the Due Date of the Invoice and today’s date

• # Days Aged - The specific number of days past the Invoice Due Date (displays 0 if the Invoice is not yet Due)

• Revenue Type - The Revenue Type on the Invoicing form

• Status Details - The Status Details on the Invoicing form

Report Filters:

• Due Date - Date range. Defaults to today’s date as the max date (so by default, the report only includes past due Invoices). Refers to the Due Date on the Invoice.

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

• Buyer/Seller - Text entry. Filters for invoices with that text as part of the Company name for the first Contact or Company on the Deal Contacts form with a Role of “Buyer/Tenant” or “Seller/Lessor”.

• Aging - No selection, single selection, multiple selections. Refers to the number of days past the Invoice Due Date.

• As Of Date - Required. Date (mm/dd/yyyy). Defaults to today’s date. Determines which Invoices, Adjustments or Payments to include when calculating Aging and certain amounts. Click here for more information.

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

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

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

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

Group By Options (up to 2):

Defaults to Aging

• Deal Business Line

• Primary Salesperson

• Due Date

• Payment Status

• Customer

• Assignment ID

• Deal ID

• Deal Location

• Aging

• # Days Aged

• Revenue Type

Sort By Options (up to 2):

• Invoice No.

• Due Date

• Payment Status

• Invoice Amount

• Amount Paid

• Outstanding

• Customer

• Assignment ID

• Deal ID

• Aging

• # Days Aged

Display Options:

• Display Criteria on Report

• Break Page After a Group

Click to go back to the list of reports.

Receivables [SSRS]

View a list of open (billed and not paid) Invoices with key billing details, a breakdown of outside vs internal balances, and key deal information.

Report Fields:

• Revenue Type - The Revenue Type on the Invoicing form

• 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.

• System Date - The date the Invoice was entered into the system, whether it was billed on the same date or on a later date. May also be different from the Invoice Date.

• 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.

• Invoice Amount - The entire amount billed on this Invoice. Specifically, the Invoice Amount from the Invoicing form.

• Paid Amount - 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.

• Outside Unpaid - The amount of unpaid fees on this Invoice allocated to any outside brokers, i.e. Contacts listed on the Fee Splits / Split Worksheet form with an Outside Vendor record.

• InHouse Unpaid - The amount of unpaid fees on this Invoice allocated internally, i.e. to House Accounts or to Contacts listed on the Fee Splits / Split Worksheet form with an In-House or Staff Vendor record.

• Outside % - The percentage of unpaid fees on this Invoice allocated to any outside brokers, i.e. Contacts listed on the Fee Splits / Split Worksheet form with an Outside Vendor record.

• InHouse % - The percentage of unpaid fees on this Invoice allocated internally, i.e. to House Accounts or to Contacts listed on the Fee Splits / Split Worksheet form with an In-House or Staff Vendor record.

• 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

• Customer - The name of the Customer Account Entity associated with the Deal on the Invoicing form

• Broker(s) - The names of any Contacts who are linked to an In-House Vendor on the Fee Splits / Split Worksheet form

• Deal Type - The Deal Type on the Deal Settings 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)

• Invoice ID - The System ID of this Invoice

Report Filters:

• As Of Date - Required. Date (mm/dd/yyyy). Defaults to today’s date. Determines which Invoices, Adjustments or Payments to include when calculating Aging and certain amounts. Click here for more information.

• Due Upon Event - Yes/No. Refers to the Revenue Type on the Invoicing form. Indicates whether to include Invoices which are designated as “Due Upon Event” rather than “Receivable”.

• 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.

• 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.

Group By Options (up to 2):

Defaults to: Revenue Type

• Deal Business Line

• Customer

• Deal Division

• Deal ID

• Deal Location

• Deal Name

• Month Due

• Primary Salesperson

• Revenue Type

• Deal Type

Click to go back to the list of reports.

Unbilled Invoices [SSRS]

A general overview of Invoices which have been entered into the system but not billed yet (i.e. not assigned an Invoice # and Invoice Date). Includes the Fee Details for each Invoice to help determine which invoices are ready to be billed.

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.

• Invoice ID - The System ID of this Invoice

• 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

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

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

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

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

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

• Brokers - The names of any Contacts who are linked to an In-House Vendor on the Fee Splits / Split Worksheet form

• Billing/Customer - The name of the Company on the Deal Contacts form designated as the “Billing Customer”

• Fee Type - The Fee Type on the Invoicing form

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

• Fee Details - The Fee Details on the Invoicing form

• Outside Fees - The portion of this Invoice Amount allocated to any outside brokers, i.e. Contacts listed on the Fee Splits / Split Worksheet form with an Outside Vendor record.

• In-House Fees - The portion of this Invoice Amount allocated internally, i.e. to House Accounts or to Contacts listed on the Fee Splits / Split Worksheet form with an In-House or Staff Vendor record.

• Invoice Amount - The entire amount on this Invoice. Specifically, the Invoice Amount from the Invoicing form.

Report Filters:

• Due Date - Date range. Refers to the Due Date on the Invoice

• Invoice Amount - Min-max range for the Invoice Amount

• Billing/Customer Company - Text entry. Filters the report for the name of the Company on the Deal Contacts form designated as the “Billing Customer”. Filters for Customer Names that contain this entry.

• Deal Closed Date - Date range. Refers to the Deal Closed Date on the Deal Settings form.

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

• 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 Type(s) - No selection, single selection, multiple selections. Refers to the Deal Type field on the Deal Settings form.

Group By Options (up to 2):

• Billing/Customer

• Business Line

• Deal ID

• Deal Location

• Deal Name

• Deal Type

• Property

Sort By Options (up to 2):

• Billing/Customer

• Brokers

• Business Line

• Closed Date

• Deal ID

• Deal Location

• Deal Name

• Deal Type

• Due Date

• Fee Details

• Fee Type

• In-House Fees

• Outside Fees

• Property

• Total Fees

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 Managers, Team Leaders & Staff

• 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