Page Comparison

...

fees and commission
tenancy income & forecast

To request this configuration to be enabled, click here to contact Reapit Support

Tip
This guide covers the Fees & Commission report

...

- for information on the Tenancy Income & Forecast report, click here: Tenancy income & forecast report (Tenancy Income Report)

...

This guide covers:

Table of Contents

minLevel	3
maxLevel	3
outline	false
type	list
printable	false

Launch report & main screen

1. Launch report

From Reports on main menu:

Click MI Analysis and select Tenancy Income Report

The screen in step 2 will be shown

2. Tenancy Income Report main screen

The Tenancy Income Report main screen is displayed - it allows two types of tenancy report to be run:

Fees & Commission - this report is covered in from step 3 this guide, see next section onwards
Tenancy Income & Forecast - this report is covered in this guidehere:
Tenancy income & forecast report (Tenancy Income Report)

Image Modified

Set up report criteria & run report

1. Set report type & output options

Report Type

Select Fees & Commission

Image Added

Output Options

Include renewal & alteration breakdowns
When ticked, includes a row per renewal/alteration that fall within the reporting period
When unticked, all renewal/alterations that fall within the reporting period will be displayed in one row
Include landlord fees with no associated tenancy
When ticked, will include detail of landlord fees that are not associated to a specific tenancy
Being able to apply landlord fees to a property is a configuration option, outlined in more detail here:
Add landlord fees to a property - configuration option
Show individual negotiator commission allocations (ticked by default)
When ticked, one row per negotiator with a fee split will be included in the report
When unticked, one row per tenancy will be shown in the report
Show individual office commission allocations
When ticked, one row per office with a fee split will be included in the report
When unticked, one row per office will be shown in the report

2. Choose what to include in the report

These options allow you to narrow down what is returned in the report to suit your requirements

Image Added

Tenancy Start

Specify a date or date range to limit tenancies returned in the report by the tenancy start date
Or click Select for predefined options of Last month and This month
Image Added
Or, to include all tenancies regardless of start/end dates, leave date fields blank

Income Period

Specify a date or date range to limit tenancies returned in the report by the income period
Or click Select for predefined options of Last/This month and Last/This/Next year
Image Added
- Or, to include all tenancies regardless of the income period, leave date fields blank

Status

Defaults to Tenancy Current - meaning that only current tenancies will be included in the report
Or, click Select one or more status and select required option(s)
- For a detailed pipeline report, select Arranging Tenancy (removing any other selected status options)
  Image Added

Property Office

To narrow the report down to properties from one or a selection of offices, click Select one or more office and select required offices
Or, to include properties for all offices, leave blank

Neg. Allocation
Field available when Show individual negotiator commission allocations is selected in Output Options

To narrow the report down to one or a selection of negotiators/managers, click
Select negotiator/manager and select required negotiators/managers
Or, to include all negotiators/managers, leave blank

Office Allocation
Field available when Show individual office commission allocations is selected in Output Options

To narrow the report down to one or a selection of negotiators/managers, click
Select negotiator/manager and select required negotiators/managers
Or, to include all negotiators/managers, leave blank

Renewal & Alteration
Field available when Include renewal & alteration breakdowns is selected in Output Options

Specify a date or date range to limit tenancies returned in the report by the renewal/alteration date
Or click Select for predefined options of Last month and This month
Or, to include all tenancies regardless of renewal/alteration dates, leave date fields blank
Image Added

3. Run report

To run the Fees & Commission report:

Select report type, output options and criteria (as outlined in steps 1 & 2 above) and click Report
Depending on the amount of data being returned, a prompt is shown detailing the current activity
Image Added
The Fees & Commission report is then displayed in a grid
Each column shown is explained in the next section
Image Added

Fees & Commission report output grid

Tip

Usual grid functions can be used (as seen throughout the system)
i.e. click column heading to sort by that column, click to the right of the heading for filter/group options or right-click column headings to export to Excel
Columns included in the grid are fixed and cannot be added to or removed
Right-click over a column showing monetary values for the option to show a total or average
Double-click an entry in the report to display the tenancy record

Info
Each column included in the grid is covered below (divided into category sections)

1. Basic detail

Image Added

Tenancy Ref - unique 9-digit tenancy reference
Type - displays Initial Tenancy, Renewal or Alteration, as appropriate
Property & Tenant Name(s) - property address & names of tenants are listed
Prp. Off - the property Main Office
Prp. Valuer - the property Key Contact
Ten. Neg. - the tenancy Key Contact

2. Office/negotiator fee splits & fixed negotiator commission

Image Added

Relate to the office/negotiator split and fixed negotiator commission figures specified on the tenancy, as outlined here: Tenancy commission allocation (or fee splits) - configuration option

3. Letting fees, tenancy dates & rent information

Image Added

Let. Fee % & Let. Fee Fixed - the letting fee as a percentage or fixed fee on the tenancy
Man. Fee Fixed & Man. Fee % - the management fee as a percentage or fixed fee on the tenancy
Start Date & End Date - the tenancy/renewal/alteration start & end dates
Rent Due - calculation of the rent value
Rent Received - the amount of rent received to date

4. More fee information

Image Added

Ten. Term Fees - calculation of the fees for the duration of the tenancy
Man. Fees Credited - value of any management fees credited
Let. Fees Credited - value of any letting fees credited
Sub Agt. Fee Value - value of any sub agent fees
Net Ten. Fee Value - net tenancy fee value (sub agent fees are deducted from this fee)

5. Break clause information

Image Added

Brk. Clause Dt. - where break clause(s) exists, displays date of earliest clause added
No Break Clause indicates none added (and following three columns will be blank)
Ten. Fees To Break Clause - value of letting fees up until the break clause
Sub Agt. Fee to Break Clause - value of sub agent fees up until the break clause
Net Agt. Fee to Break Clause - net value of agent fees up until the break clause

6. Agent & other fees received

Image Added

Agent Fee Recvd. - value of agent fee received
Addl. Agt. Fee - value of additional agent fee
Addl. Agt Fee Recvd. - value of additional agent fee received
Other Fee - value of other fees
Other Fee Recvd. - value of other fees received
Recvd. Fee Within Dates - value of other fees received within the dates specified in the income period
This can be narrowed down via the Income Period criteria which is selected when building the report
Shown in previous section titled: Set up report criteria & run report, step 2 - Income Period

Versions Compared

Old Version 3

New Version 4

Key

Launch report & main screen

Set up report criteria & run report

Fees & Commission report output grid

Related articles