On SME Professional, sales system data can be exported in two ways. Details on each option can be found below:
1. Reports page
Our Reports page contains a list of pre-set exports that include various sales data.
Go to Sales properties > Reports
Locate and click on the name of the relevant export
If applicable, set the required date range > Click Go
The export will be downloaded to your computer in the form of an Excel spreadsheet
For further details on what each report contains, please see the table below;
Report | Description |
Export property report (overview)
| Export provides an overview of the sales numbers for the required period. This includes the number of appraisals, instructions, viewings, sales (incl fees), fall throughs (incl. fees), rejections (incl fees), exchanges (incl fees), and the number in the pipeline and current stock (incl value and fees). |
Export property instructions report | List of current properties that have been instructed during the specified period, along with their associated fee values. |
Export property viewings report | List of properties that have had viewings take place during the required period, including the number of viewings and viewers. |
Export property sales report | List of properties that have had offers accepted during the required period, including the accepted date, offer amount and any fees. Additionally, it tracks any accepted offers that have since been rejected or withdrawn.
|
Export property fall-through report | List of properties that have experienced sales fall-throughs during the specified time period, meaning those properties had offers accepted but were later rejected or withdrawn.
|
Export property exchanges report | List of properties that have had an exchange date agreed within the required time period. This is also populated when a property is set to “Contracts exchanged”. This also shows the accepted offer value and any fees.
|
Export property pipeline report | List of all properties with an accepted offer that have not yet been completed.
|
Export property stock report | List of all properties currently set to a marketable status. |
Export potential buyers | List of all potential buyers added to the system within the required time period. This includes their matching criteria and their mortgage and finance information. |
Export offers | A comprehensive list of all offers submitted within the specified timeframe, including their statuses and relevant dates.
|
Export user activity | Provides a report of each user’s activity within the required period by giving a numerical value. This includes viewings, buyers, and offers, among other fields. |
Export owners - contact details for mailing systems | List of sales owner records, including those with enquiry or past client status, and their marketing consent.
|
Export potential buyers - contact details for mailing systems | List of all open potential buyer records, including their marketing consent, availability to buy status, reason for purchase, and financial status fields.
|
2. Individual pages
In addition to the pre-set reports, the data on most system pages can also be exported. To do so, click on either the Export or Copy buttons (located to the right of the search field).
The Export button will download the data into a CSV file (Excel spreadsheet), whereas the Copy button takes a copy of the data allowing it to be pasted where required.
Note: To create a bespoke export that includes data from multiple exports, a VLOOKUP can be performed on Excel.
