R32 Group #1 – Listing Summaries 23 reports

R32 Group #2 – Listing Averages 20 reports

Welcome to the listing summary reports for REAL/Easy FOS and BOS. As listing contracts are written, pended and closed in BOS, it can be helpful to summarize how successful the company is at it's listing sales and marketing programs. The R32 sales summary reports can help you:

• Analyze your listing written business by current status to observe sales success and potential by comparing active, pending and closed units and volume with expired and cancelled levels.
• Observe how long your listing contracts are and the days on market by status, property type, and other criteria.
• Calculate how your listing prices hold up compared to sales prices to help improve listing pricing guidelines or identify turns in the market.
• Analyze average price statistics in various markets to assist in sales and market positioning and promotion.

Key to the listing summary reports value is the accurate and complete entry of written, expired, pended and closed listing business and changes in that business. Most important is entry of written listings including original and current prices, listing and expiration dates, sales associates and earned listing units. When listings are pending and closed it in important to update these changes in listing status, and enter the sales pending and closed dates and sales prices.

Effect of Listing Marketing:

How well your company lists and markets properties is partly reflected in a number of statistics:

Listing contract term. This is the length of the listing contracts your company is writing and can reflect the confidence sellers have in your company, as well as market conditions. For the summary reports, this figure is the number of days between the listing date and the expiration date.

Days on Market. This is the length in days it takes for listings to obtain purchase agreements (accepted offers). It is the number of days between the listing date and the pending date. Most sellers want to pick a company with a low days-on-market track record balanced with high closing sales prices. For the firm, a lower days on market figure can mean a number of things such as revenue coming in faster, a hot market, a successful marketing program with sellers, but also a need to rethink listing price levels.

Percent current listing price to original listing price. This statistic can reflect how successful the firm's agents and the seller are at targeting the listing's original price compared to the current market. If the original listing price is too-high, subsequent price changes indicated by a lower percent here might indicate slowing markets or a need to improve initial listing pricing levels.

Percent sales price to original listing price and to current (last) listing price. These statistic also help the firm analyze how well the original and/or current(changed) listing prices are held when sales are made. Most companies may find that the higher this percentage is, the lower the days on market is and the hotter the market is becoming. In active markets, this may exceed 100% indicating that listing prices may be too low.

Helping at different levels:

If a company is serving different market types, usually by branch, marketing programs need to be tailored for each one. Further, branch managers need to be able to assist agents with their listing efforts so they need to view individual agent listing statistics. And Broker/Owners need to track how listing production is doing company-wide. To help do this, the reports can be viewed and printed at these levels:

• Broker-owners with the company level reports.

• Branch managers and administrators would use the branch level reports.

• Agent level summaries can be printed to assist sales agents and managers

Running the summary reports:

As described, the R32 reports can be run to summarize listings written, pending, closed, and expired production. Listing date ranges and DOM (days on market calculation) as-of dates are requested before the report is run. Further, with branch or agent level reporting you can select individual branches/agents or all.

Normally, the report is displayed on the screen first and all or selected pages can be printed.

You can review the details behind the summaries with Drill-Downs.

When these reports are viewed on the screen, more details about each summary line (e.g. total of all active listings) can be viewed by using the "drill-down" feature. Two levels of details are available: listing details and agent details.

You can use the listing drill-down to observe the individual listing price, price percentages, and days on market contribution to the report subtotals. The agent level drill-down is used to view individual agent sides and volume generated for a selected listing.

 

How is our listing inventory doing? Use the Summary by Listing Status

The summary reports calculate totals and averages for the listing production figures from the detail listing data. There are a number of summary types available. Above is a sample of a branch level report of all written listings for a selected listing time period and "As of " a particular date (e.g. 12/31/1999).

The report totals the figures by current status with subtotals for

• Net Written (Active, Active-Offer-Written, Sold(closed)),

• and Written but Exp/Canc (expired or cancelled).

The items are:

Summary by Listing Status – Listing detail drill-down:

Information about the listings that make up any of the summary lines in the report can be viewed using the drill-down feature. This feature is activated when viewing the summary report on the screen, as shown above. To view the details of a summary line, such as the six sold listings of the sold summary line, position the cursor over that line to obtain the magnifying glass as shown above and double-click.

Above is a sample listing detail drill down. Two rows are used to display each listing.

The items included for each listing are:

Summary by Listing Status – Agent detail drill-down:

You can view the agent details for a selected listing using the agent detail drill-down. To view the agent details, move the cursor over the listing to obtain the magnifying glass and double click. Shown above is an example of the agent details of the E. River Drive listing. Detail shown includes:

The Group #1 reports can assist by summarizing the listing production by other criteria. The following pages illustrate these added summaries.

Summary by Property Type

The summary reports can calculate totals by the property types your firm markets. The sample above illustrates how totals for all listings written for a selected period can be compared by property type. Here, you can compare the units, volume, days on market, and percentages of original listing price for each of your property types.

 

Summary by Price Ranges

This summary can help managers compare listing marketing between various price level groupings. The above shows how the report totals the listing marketing results by price range. The report can show relative strengths and concentrations in certain price levels.

The price range divisions are based on the listing's original listing price. For original listing prices up to $250,000 the ranges are $25,000. For original listing prices from over $250,000 to 1 million, the ranges are $50,000. And for original list prices over 1 million, the ranges are summarized every $250,000.

 

Summary by Month

Managers can compare listing marketing during the year using the summary by month report. The row summaries are based on the month of the listing date. The number of months compared is dependent on the listing date range specified when running the report

 

If seller source of business is assigned for your listings, the summary by source can help managers compare where listing business is coming from.

 

Summary by City

Compare listing business by city using the above summary. Listings are summarized by the city name entered for each property in BOS listing management. Note that a preferences table for cities can be built to help the effectiveness of this report. Data entry personnel should use this drop-down when entering listings.

Summary by District

Compare listing business by district using the above summary. Here, listings are summarized and then market strength can be compared by the district assigned for each property in BOS listing management.

For version 10 conversions, the district is the same as the version 10 market area. The assigned market area in version 10 listing data is assigned to the BOS listing district. Further, districts can be expanded using the update within BOS Preferencesà District.

Sample Summary by Agent Report

Special Summary by Agent Report

A special summary report can be used to quickly compare your listing agents. As shown above, the total net written volume, prices, units, days on market, and percentage of original/current list prices can be compared.

R32 - Group #1 Reports for Company Level

Company Level Summaries

All summary reports are also available at the company-wide level. Above is an example of the "by Status" report. Other company level summaries include: by property type, by price range, by month, by seller source, by city and by district.

Agent Level Summaries

Summary reports help agents as well. Above is an example of the "by Status" report. Other agent level summaries include: by property type, by price range, by month, by seller source, by city and by district.

Agent level reports can be printed ad-hock for just one agent in one office, or printed for all or many agents at once.

Averages by Listing Status

To help with listing management, a group of "Average" reports are available for the same levels and breakdowns as the summary reports. These reports calculate volume and price averages from the listing production figures from the detail listing data. A number of report types are available.

Above is a sample of a branch level report calculating average volume per unit and prices per property of all written listings for a selected listing time period and "As of " a particular date (e.g. 12/31/1999).

The above report totals the figures by current status with subtotals for

The items are:

Average by Listing Status – Listing detail drill-down:

Information about the listings that make up any of the average lines in the report can be viewed using the drill-down feature. This feature is activated when viewing the average report on the screen, as shown above. To view the details of an average summary line, such as the six sold listings of the sold average line, position the cursor over that line to obtain the magnifying glass as shown above and double-click.

Above is a sample listing detail drill down. Two rows are used to display each listing.

The items included for each listing are:

Average by Listing Status – Agent detail drill-down:

Agent details for a selected listing can be viewed using the agent detail drill-down. To view the agent details, move the cursor over the listing to obtain the magnifying glass and double click. Shown above is an example of the agent details of the E. River Drive listing. Detail shown includes:

The Group #2 reports can assist by comparing the average listing prices by other criteria.

The average reports can help compare the price levels by property types and other criteria that your firm markets. The sample above illustrates how averages for all listings written for a selected period can be compared by property type. Here, you can compare the total units and property counts and average volume, original listing prices, current listing prices, and average sale prices for each of your property types.

Other criteria that can be compared include: by price range, by month, by seller source, by city and by district.

Sample Average by Agent report with agent averages

A special average report can be used to quickly compare your listing agents. As shown above, the net written and written but expired/cancelled categories are averaged and contribution of each agent listed.

Company Level Average Reports - sample above

All average reports are also available at the company-wide level. Above is an example of the "by Status" report. Other company level average reports include: by property type, by price range, by month, by seller source, by city and by district.

Average reports can help agents as well. Above is an example of the "by Status" report. Agents can also anlayze their listing business by property type, by price range, by month, by seller source, by city and by district.

Agent level reports can be printed ad-hock for just one agent in one office, or printed for all or many agents at once for one office or many offices.

Group 1: Listing Summary Reports (new and version 10 R32, R52, A20, A26 contents):

Branch Level Reports:

Agent Level Reports:

Company Level Reports:

R32companylistsummarybystatus

R32companylistsummarybytype (property type)

R32companylistsummarybyprice (price range)

R32companylistsummarybymonth

R32companylistsummarybysource (seller source)

R32companylistsummarybycity

R32companylistsummarybydistrict

R32companylistsummarybyagent (special report to compare agents)

Group 2: Listing Average Reports:

Branch Level Reports:

Agent Level Reports:

Company Level Reports:

(If you are interested in having Executive Systems build custom reports for your company call 877-705-9750 or Contact Us Via Email for a free estimate)

Home