Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 55 Current »

This guide has been reviewed against our global client base and classed as relevant to all regions

How to use the Power Reports library

Read a summary of the report and, if you want to run this report on your data, just import the RRD file beside it
For instruction on this, see first section below titled: Importing an RRD file & using Predefined Reports

Once imported, this report will be added as a Predefined Report in Power Reports
This means the report criteria can now be easily accessed and run - a Predefined Report can also be added as a category on an Organiser panel

After importing, report criteria can be built on, or criteria options removed, to suit your requirements

For more information on working with Power Reports, see Related articles section below

Importing an RRD file & using Predefined Reports

 First, read these instructions on how to import an RRD file

1 Save RRD file

  • Using the library below, click the required RRD file

  • Select Download and choose a place to store it on your PC/laptop

2 Access Power Reports screen

From the main menu:

  • Click Reports and select Power Reports

3 Locate RRD file

Locate the saved RRD file on your PC/laptop

  • Click and drag the file to the Predefined Reports section on Power Reports screen

    The Import Report screen will be displayed

4 Import Report

  • In New Report Name, enter an appropriate title for this report

  • Share with allows you to choose how you wish to share this report criteria
    Options are: Share with Everyone, Offices, Negotiators or Do not share

  • When sharing the report, tick the box if you want to stop the report criteria from being edited by those you are sharing it with

  • Click Save

5 Running a saved report & further options

The saved report is shown on the right of the Power Reports screen as a Predefined Report

  • Click the report to display its criteria to the left
    Ensure that all criteria options are entered/picked, as required (or leave blank to report on all)
    e.g. if a report requires date, office or negotiator criteria to be entered, ensure you enter the required date or date range/offices/negotiators before running the report

  • Click Run Report

  • Right-clicking over the Predefined Report gives further options

    • Sharing options displays the screen shown in step 4 to allow the share settings to be changed

    • Delete report removes the report criteria from the Predefined Report list

    • Export to file allows an RRD file to be saved for the current report criteria

    • Export to code - for use by Reapit Support

    • Create new report based on this allows a duplicate report to be created and saved

Predefined Reports can also be added as a category on an Organiser panel, as outlined here:  Adding and removing categories on the Organiser (see step 3b)

Potential business reports

 Click here for the potential business reports library

Report title

Report summary

RRD file(s) to export

Local applicants not yet on market

Applicants that, according to their applicant status, are not yet on the market but haven't been identified as a potential client in the applicant status screen

Need to use the Postcode criteria to enter required postcodes for your area

Once this report has been run and the applicants contacted - where relevant, applicants should be marked as a Potential Client in Applicant Status (to ensure they are included in a Potential Client report)

Potential clients out viewing

Active sales/lettings applicants from the current office, marked as potential clients

 Using the Time criteria

Need to enter the date range you want to report on

Current market appraisals

Live sales/lettings Market Appraisals that have an associated market appraisal diary appointment after a specific date

Could also add Last call to the Property criteria to return MAs not contacted since a given date

 Using the Time criteria

Need to enter the date you want to report after

Properties marked as 'lost instruction' after market appraisal

Returns sales/lettings properties with the status of lost instruction

Appraised but not instructed

Returns sales/lettings properties with property status of Market Appraisal and with at least one confirmed Market Appraisal appointment (that wasn't cancelled) within a set timeframe

 Using the Time criteria

Need to enter the date you want to report after

Cancelled appraisals

Cancelled market appraisal diary entries from last month on properties from the current office

Applicants registered as potential vendors/landlords without a vendor/landlord role

Current applicants that do not have a vendor/landlord role but, according to their applicant status, are a potential vendor/landlord

Missed vendor referrals

Live sales applicants from the current office who:

  • don’t have a vendor role at Pre-Appraisal or Market Appraisal

  • were registered after a specific date (need to enter a date in Time field)

  • are not marked as a Potential Client

  • does not have a buying position of First Time Buyer or Buying Agent

  • does not have a selling position of Renting or Nothing to sell

Use the Full address field to filter applicants by address

Potential landlords

(live/archived investors)

Archived sales applicants whose buying reason was set to Investor/To let - worth reviewing for potential landlords

 Live applicant records

To report on live applicant records, use this report criteria, but click Archived Applicant Record and select Include live records
Archived option can be left selected or de-selected, as required

Withdrawn last year

Archived sales or lettings properties from the current office with the status of Withdrawn along with a journal entry of Sales or Lettings status to Withdrawn created last year

 Using the Created criteria

Enter the date range to report between

Archived withdrawn properties

Archived properties with sales/lettings status set to withdrawn

Can be filtered by bedrooms, reception rooms, price/rent or address

Anniversary report

Live & archived properties (for the current office) with an exchanged date in a given range

e.g. to generate a list of people who exchanged in January one year ago, enter dates as from 01/01/yy to 31/01/yy

Applicant reports

 Click here for the applicant reports library

Report title

Report summary

RRD file(s) to export

Actively viewing applicants

Sales/lettings applicants who are actively viewing within a recent time period and who are looking to buy/rent within a specific price bracket

Applicants not contacted recently

Sales/lettings applicants registered at your office, owned by a specific negotiator, who have not had their last call updated since before a specified date

 If there is no last call date on the applicant record

(i.e. one has never been recorded) such applicants will not be returned in the results grid, see next section for another option for this report

Applicants contacted recently

Sales/lettings applicants registered at your office who have had recent contact
Criteria is set to Last Week, but can be changed

 For another option to get a list of applicants not contacted

Use the criteria in this section, but click Applicant has journal entries and change to Applicant does not have journal entries

Applicants with no selling/renting position

Current sales/lettings applicants with no selling/letting position entered

Hot applicants

Active sales/lettings applicants from the current office, marked as Hot

Hot applicants not viewed

Active sales/lettings applicants marked as Hot but who have never viewed a property

Missed hot sales applicants

Sales applicants that are renting or have nothing to sell, who have viewed this month but are not marked as Hot

Applicants not matched to properties

Active sales/lettings applicants registered at your office that have not been matched to any properties since a given date

 To enter a date

In the Created field, enter the date you wish to report from

Applicant housekeeping

Generates a report of applicants who were registered some time ago and who are no longer actively looking

Before running the report, need to alter the dates in both the Registered field and journal entries Created field to suit the timeframe you wish to report on

If needing to send the report to Reapit Support for applicants to be removed in bulk, ensure that the Registered column is added to the results grid before exporting it to Excel, as outlined here

Property reports

 Click here for the property reports library

Report title

Report summary

RRD file(s) to export

Recent MA to instruction

Properties with a recent market appraisal appointment plus a recent status change to for sale/to let

Fall-throughs last month

Live and archived sales properties that had an offer fall though last month

Recent contact with vendor or landlord

Sales/lettings properties registered at your office who have had recent contact logged
Criteria is set to Last Week, but can be changed

Properties not matched to any applicant

Current sales/lettings properties registered at your office that have not been matched to any applicants since a given date

 To enter a date

In the Created field, enter the date you wish to report from

Completions

Properties that have completed since a specific date

 To enter a date

In the Created field, enter the preset range you wish to report in

Key management

Report allowing you to manage keys and track their movements

No specific key criteria is selected, allowing you to choose what is relevant to you

Properties with specific certificate type

Lettings properties that have details of a specific certificate type uploaded
- use Type field to select the type of certificate you wish to report on (also may want to click Pick Property Criteria & add Lettings Status & Office options to narrow down report results)

e.g. select EICR type to return properties that have details of an electrical installation condition report uploaded

Compliance reports

 Click here for the compliance reports library

Report title

Report summary

RRD file(s) to export

Current properties with EPC

Current sales/lettings properties with an uploaded EPC graph

Current properties missing EPC

Current sales/lettings properties without an uploaded EPC graph

Current vendor/landlord marketing consent option

Current sales/lettings properties, focusing on marketing consent options

For the Marketing consent criteria, select the required option to report on
(e.g. given, not asked etc.)

Current vendor/landlord with no ID

Current sales/lettings properties to identify vendors/landlords without ID checks uploaded

Viewing reports

 Click here for the viewing reports library

Report title

Report summary

RRD file(s) to export

Viewings and follow ups

Viewing appointments within a specified time frame that weren't cancelled

 To view follow up data

After running the report, when viewing report results, use grid functionality to review the follow up data

i.e. right-click over grid column headings, select Pick columns, select Follow up and Is followed up, then right-click again and select Save grid layout
Follow up information will then be shown in future viewings reports

Cancelled viewings

Cancelled viewings (made with the current office) for the current office’s properties, within a given date range

 Using the Created criteria

Enter the date range to report between

Offer reports

 Click here for the offer reports library

Report title

Report summary

RRD file(s) to export

Offers from first time buyers

Offers logged in the last month by applicants who are first time buyers and registered with your office

Potential buyer last call

Offers set to Pending on your office’s properties that are set to For Sale - Available where the last call date is before a specific date

 Using the Last Call criteria

In Last Call, need to enter the date you want to report before

Accepted offers

Properties in the current office, where the property status is For Sale - Available/Unavailable or SSTC - Available/Unavailable, with an offer status of Accepted

An Offer report is also available which is similar to running a Power Report but with the addition of displaying Sales Progress information in the results grid, click here for more information

Landlord reports

 Click here for the landlord reports library

Report title

Report summary

RRD file(s) to export

Reporting on landlords with multiple properties

Returns list of landlords with more than one property - where needed, can add to criteria to narrow down

Former landlords

Live and archived landlords with a record of at least one property its status set to Tenancy Finished

Tenancy reports

 Click here for the tenancy reports library

Report title

Report summary

RRD file(s) to export

Current tenancies last month

Returns tenancies with Tenancy Current status on live properties where the tenancy status changed to current tenancy last month

Managed tenancies

Returns tenancies where the tenancy Role is set to Managed tenancy
This report also has blank criteria fields added for Manager & Status - allowing the report results to easily be filtered by Property Manager and/or Tenancy Status

Current tenancies with no inspection appointment booked in the next 12 months

Returns tenancies with Tenancy Current status on properties where no property inspection has been booked within the next 12 months
Use the Time criteria to altter the amount of months to report on

Certificates (lettings)

 Click here for the certificate reports library

Report title

Report summary

RRD file(s) to export

Properties with specific certificate type

Lettings properties that have details of a specific certificate type uploaded to AgencyCloud - use Type field to select the type of certificate you wish to report on (also may want to click Pick Property Criteria & add Lettings Status & Office options to narrow down report results)

e.g. select EICR type to return properties that have details of an electrical installation condition report uploaded

Properties with expired certificates

Expired certificates can also be seen on the Organiser Property Management panel, click here for more information

This report returns lettings properties with a certificate that has expired, providing today’s date is entered in the End Date field

Extra criteria has been added to this report which ensures that properties returned that are not external, have a gas supply and are from the current office (the Lettings Status field can also be completed to filter properties by status)
Any of the extra criteria options mentioned above can be changed/removed to suit

Properties with expiring certificates

Expiring certificates can also be seen on the Organiser Property Management panel, click here for more information

This report returns lettings properties with a certificate that will expire in the next 14 days

Extra criteria has been added to this report which ensures that properties returned that are not external, have a gas supply and are from the current office (the Lettings Status field can also be completed to filter properties by status)
Any of the extra criteria options mentioned above can be changed/removed to suit

Morning Meeting reports

 Click here for a set of reports that are useful for your morning meetings

Report title

Report summary

RRD file(s) to export

Applicants registered

Sales or lettings applicants registered the previous day in your office

Applicants called yesterday

Sales or lettings applicants registered to your office called the previous day

Applicants to call today

Sales or lettings applicants registered to your office to call today

Applicants to call tomorrow

Sales or lettings applicants registered to your office to call tomorrow

Diary today

Appointments in your office’s diary for today

Diary tomorrow

Appointments in your office’s diary for tomorrow

Diary yesterday

Appointments in your office’s diary from yesterday

MAs called yesterday

Sales or lettings MAs registered to your office called the previous day

MAs to call today

Sales or lettings MAs registered to your office to call today

MAs to call tomorrow

Sales or lettings MAs registered to your office to call tomorrow

Offers received yesterday

Sales or lettings offers for properties in your office made the previous day

Building a Power Report

Grids, print & export options after running a Power Report

Saving Power Report criteria and sharing reports

Support guidance & considerations when building Power Reports

Need more assistance? No problem! Just log a ticket on the Reapit Service Desk Portal at https://reapitsupport.refined.site/ and a member of our Support Team will be happy to help

  • No labels