Comparative Production Report

SUMMARY
Learn how to download and interpret the Comparative Production Report.

Introduction

The Comparative Production report allows you to measure seasonal performance company-wide, by Location, or by agent for any given month across multiple years, as well as totals for each year. Monthly and annual figures are included for Sales Volume, Sales Average, number of transactions, and (for Commission Module subscribers) Sales Units.

Who Can Do This?

Only admins with permission to Enter Financial Data or View Financial Reports have access to run the Comparative Production report.

Video 🎥

4:23

Download a Comparative Production Report

To download a Comparative Production report:

  1. Click [Reports] from the top menu. 
  2. Click [Comparative Production] from the Financials section of the left menu.
  3. If your company has more than one Location in Pipeline, select your desired Location from the dropdown list. By default, Company-wide is selected.
  4. Choose your desired Closing Period range from the dropdown list. By default, 2 Years is selected.
  5. Optionally, run the report for a specific agent. LEAVE THIS FIELD BLANK TO RUN THE REPORT FOR ALL AGENTS.
    To run the report by agent, start typing the agent's name then select the agent when they appear in the dropdown menu.
  6. Click [Download Report] to download the report to your computer.
The report will only include figures for transactions in a Closed Status. If your office is subscribed to Commission Module, the report will only include Closed transactions where commissions have been entered.

View the Download

To view the downloaded Comparative Production report:

  1. Open the saved report in your preferred app for spreadsheets.
Pipeline Pro Tip: To quickly expand all columns in Excel to match the width of your specific timeline's data, click the upper left master cell, then double-click any column separator.

The report will include separate sections to compare Sales Volume, Sales Average, Transactions Closed, and Sales Units.

Each section of the report will include:

  • Separate columns for each year within your selected Closing Period.
  • Separate rows for each month's totals including the total amount, and the amount of variance from the month in the previous year.
  • At the bottom of each section, a row for each year's totals including the total amount, and the amount of variance from the previous year.