Weekly Pulse Check - How to Validate your Report's Data and Brokerage Income

Weekly Pulse Check - How to Validate your Report's Data and Brokerage Income

Loft now sends out a weekly report, each Friday, providing a quick snapshot of what your Brokerage's activity has done over the week. In this article, we'll go through how to validate the data for each Report's section. Please navigate through each of the tabs per Report Section.

Admin/broker contacts are the contact types who receive weekly communication, which is an option in the user notification settings.



Definitions: 
** Company Income: Loft distinguishes between income type deductions and those that do not contribute to earnings like charity fees. To accurately predict Brokerage income, ensure your Deduction templates are set to both type income and Ledger type income.

** Closed Deals: Closed deals are based on a close date in the report range. If your deal has not been assigned a closed at date, this count will be off.

** Payouts Completed this week & Agent Payout Counts: The count per transaction NOT per deal. So if you have 3 Agents on one deal you will see a count of 3, rather than one. To see the total amount of deals closing for the period you can view the closed deals counts. 


If you would like more detail on income to the Brokerage can look at either the Brokerage Income report or the Performance report. 

The Brokerage Income report is using the close date for the deal and NOT the transacted at date. This report will show income to the company by Agent, by deduction and by office. 

The Performance report now includes a new column, Q, on the payroll details called "Deduction Income". This is the portion of the total deductions taken on an Agent payout that contributes to Brokerage income. 








​
​
​



Active Deals
Activity Transacted this Week
Company Snapshot this Month
Year to Date Transactions (Calendar)
Active Deals

Steps to Verify

Commission on Conditional Deals

Number of Conditional Deals

  • Head to the following menu: Reports/Performance 

  • Choose the following filters fields:

  • Viewing: Pending

  • Date Scope: Closed at

  • Start date/End date: Brokerage Start date end date leave blank

  • Deal Status: Conditional

  • Click Generate Report

  • Download your report into your preferred file format

  • Use Payroll tab of your report and sum the total of Column F (total_commissions)

  • Head to your Deal’s page

  • Click the Filter button

  • Leave all fields blank except the Sales Status field

  • Clear the Sales status field to display ‘Conditional’ only

  • Click Done



        Count will be at the top of the page

Commission on Firm Deals

Number of Firm Deals

  • Head to the following menu: Reports/Performance 

  • Choose the following filters fields:

  • Viewing: Pending

  • Date Scope: Closed at

  • Start date/End date: Brokerage Start date end date leave blank

  • Deal Status: Firm

  • Click Generate Report

  • Download your report into your preferred file format

  • Use Payroll tab of your report and sum the total of Column F (total_commissions)

  • Head to your Deal’s page

  • Click the Filter button

  • Leave all fields blank except the Sales Status field

  • Clear the Sales status field to display ‘Firm’ only

  • Click Done


        Count will be at the top of the page


Pending Company Income*

Pending Company Income per Agent

  • Head to the following menu: Reports/ Brokerage Income

  • Choose the following filters fields:

  • All Deal Sales Status: Conditional, Firm, Closed

  • Paid/Unpaid: Unpaid

  • Start date/End date: leave blank

  • Click Generate Report

  • Download your report into your preferred file format

  • Use Payroll tab of your report and sum the total of Column B (Income)

The average is the total Pending Commission income divided by the number of active agents that are in your brokerage for this time period.


Income to commission ratio


The ratio is the Total Company Income divided by
Total Commissions for this time period.


Activity Transacted this Week

Steps to Verify

Payouts Completed this Week

Commissions Paid this Week

  • Head to the following menu: Reports/Performance 

  • Choose the following filters fields:

  • Viewing: Completed

  • Date Scope: Transacted at

  • Start date/End date: Same time period (week) of the latest Pulse Check

  • Deal Status: All available statuses

  • Click Generate Report

  • Download your report into your preferred file format

  • Use Payroll tab of your report and count the number of any of the rows under your heading

  • Head to the following menu: Reports/Performance 

  • Choose the following filters fields:

  • Viewing: Completed

  • Date Scope: Transacted at

  • Start date/End date: Same time period (week)

    of the latest Pulse Check

  • Deal Status: All available statuses

  • Click Generate Report

  • Download your report into your preferred file format

  • Use Payroll tab of your report and sum the total of Column F (total_commissions)

Company Income Earned this Week

Income to Commission Ratio

  • Head to the following menu: Reports/ Deductions

  • Choose the following filters fields:

  • Brokerage Deductions: All income type deductions
    (see video time stamp 2:30 on how to denote all income type deductions)

  • Paid/Unpaid: Unpaid

  • Start date/End date: Same time period (week)

    of the latest Pulse Check

  • Click Generate Report

  • Download your report into your preferred file format

  • Use Payroll tab of your report and sum the total of Column I and/or K

The ratio is the Total Company Income divided
by Total Commissions for this time period.

Company Snapshot this Month


Steps to Verify

Active Agent Count

Deals Created this Month

  • Head to the following menu: Brokerage/People

  • Filter Profile type: Agent

  • Filter Status type: Active



Count will be at the top of the page

  • Head to your Deal’s page

  • Click the Filter button

  • Filter Date: Creation date

  • Start/End Dates: Current month of the Pulse Check

  • Leave all Sales Status field blank

  • Click Done

        Count will be at the top of the page

Broker (Internal Brokerage Manager) Count

Deals Closing this Month**

  • Head to the following menu: Brokerage/People

  • Filter Profile type: Broker

  • Filter Status type: Active

  • Click Done




        Count will be at the top of the page

  • Head to your Deal’s page

  • Click the Filter button

  • Filter Date: Close date ***

  • Start/End Dates: Current month of the Pulse Check

  • Leave all Sales Status field blank

  • Click Done

         Count will be at the top of the page




Year to Date Transactions (Calendar)


Steps to Verify

Commission Paid

Closed Deal Count

  • Head to the following menu: Reports/Performance 

  • Choose the following filters fields:

  • Viewing: Completed

  • Date Scope: Transacted at

  • Start date/End date: Current calendar ytd dates

  • Deal Status: All deal statuses 

  • Click Generate Report

  • Download your report into your preferred file format

  • Use the Payroll tab of your report and sum the total of Column F (total_commissions)

  • Head to your Deal’s page

  • Click the Filter button

  • Filter Date: Close date

  • Start/End Dates: Current ytd

  • Select all Deal Status options except voided

  • Click Done



Count will be at the top of the page

Company Income

Agent Payout Count

  • Head to the following menu: Reports/ Deductions

  • Choose the following filters fields:

  • Brokerage Deductions: All income type deductions
    (see video time stamp 2:30 on how to denote all income type deductions)

  • Paid/Unpaid: Unpaid

  • Start date/End date: Current calendar ytd dates

  • Click Generate Report

  • Download your report into your preferred file format

  • Use Payroll tab of your report and sum the total of Column I and/or K

  • Head to the following menu: Reports/Performance 

  • Choose the following filters fields:

  • Viewing: Completed

  • Date Scope: Transacted at

  • Start date/End date: Current calendar year dates

  • Deal Status: All deal statuses 

  • Click Generate Report

  • Download your report into your preferred file format

  • Use the Payroll tab of your report and count the total rows under the header row or do a count function.

Income to Commission Ratio

Average Company Income per Agent

The ratio is the Total Company Income divided by Total Commissions for this time period.

The average is the total Commission income divided by the number of active agents that are in your brokerage for this time period.



​ * What is Company Income? Loft distinguishes between income type deductions and those that do not contribute to earnings like charity fees. To accurately predict Brokerage income, ensure your Deduction templates are set to both type income and Ledger type income.

** What are Closed Deals? Closed deals are based on a close date in the report range.
*** If your deal has not been assigned a closed at date, this count will be off.


 

    • Related Articles

    • LoftPro - Google Data Studio

      Connect Google Data Studio In order for us to enable GDS in your brokerage account you must first connect GoogleDrive, in Loft, via the Integrations page. Follow the steps in this article to connect ...

    • Accounting Entries for Other Income to the Brokerage

      Accounting Entries for Brokerage Other Income Until July 2nd, 2019, if your Brokerage was in receipt of income designated as 'Other Income' on the allocations page, Loft would post two entries for accounting requirements to record the transfer of ...

    • Acquiring a Brokerage that already uses Loft?

      Here is a list of all the things to consider when merging a brokerage into another. All of this (except 1 item can be done by the user) However, we can assist you with this migration. The cost for Loft to assist is $75/hour Brokerage to Brokerage ...

    • Other Income - Adding Non Commission Income to Agent and Brokerage Payments

      If your agents or brokerage are receiving income that is not classified as commission you can add this additional income to the Other income section on your deal's allocation page Head to your deal's allocations page>navigate to the section called ...

    • Report and Email tags - quick reference

      Below are the following tags that can be used with in any reports or email templates: ADMIN REPORT TAGS Deal Details Deal # {{deal_number}} MLS # {{mls_number}} Sellers {{seller_1_name}} {{seller_1_organization_name}} {{seller_1_single_line_address}} ...