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

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

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

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

    • Your Definitive Guide to Email Templates

      Welcome to the ultimate guide for creating and formatting Email Templates! Loft provides the capability to create & format your templates several different ways as outlined in our Key below: TEMPLATE KEY Email Body A template can be created for use ...

    • Reviewing Your Year-To-Dates

      Your Year-To-Dates are a great place to see how you performed for the year or a custom date range! Check out your sales volume, commissions and deduction totals. To see your YTDs click My Profile in the menu on the left. Financial Summary Scroll down ...

    • Validating your Agents 1099/T4A's against their YTD totals

      Validating your agent's ytd totals for reporting Depending on how you're reporting, see this article for more info on the various types of Income reporting available, you can validate your agent's income by comparing your Agent's profile YTD totals ...