Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info

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

Panel
panelIconId1f5d3
panelIcon:calendar_spiral:
panelIconText🗓️
bgColor#FFEBE6

Available from version 12.173

Panel
panelIconId1f527
panelIcon:wrench:
panelIconText🔧
bgColor#EAE6FF

Configurable option for Enterprise customers
To request this option to be enabled on your system, click here to contact Reapit Support

The fees & commission report within tenancy income reporting provides the ability to run a detailed report providing an indication of fees/commission earned which can be broken down by negotiator/office

Tenancy income reporting also provides the ability to run a Tenancy Income & Forecast report, click here for more information: Tenancy income & forecast report (tenancy income report) Tenancy income reporting functionality is a configuration option, click here for more information:
Tenancy income report - configuration option

This guide covers:

Table of Contents
minLevel3
maxLevel3
outlinefalse
typelist
printablefalse

...

1. Basic detail

  • Tenancy Ref - unique 9-digit tenancy reference

  • Type - displays Initial Tenancy (i.e. a tenancy that has not yet been renewed), Renewal, Alteration or Periodic 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

Being able to set negotiator/office fee splits and negotiator fixed commission is a configuration option - click here for more information: Tenancy commission allocation (or fee splits) - configuration option

  • Off. Split - the name of the office that has been allocated the fee

  • Off. Split% - the percentage of the split fee that has been allocated to the office

  • Neg. Split - the name of the negotiator that has been allocated the fee

  • Neg. Split% - the percentage of the split fee that has been allocated to the negotiator

  • Fixed Neg Commission - the value of the fixed fee that has been allocated to the negotiator

Note

Data will only show here when you have chosen an Output Option of Show individual office commission allocations and/or Show individual negotiator commission allocations
When choosing either/both of these options, one row will display per office allocation and one per negotiator allocation

2a. Unallocated percentage negotiator/office fee splits (plus configuration option)

  • When choosing the Output Option(s) to Show individual negotiator commission allocations and/or Show individual office commission allocations (as shown in step 1 in previous section)
    and a percentage fee split has not been allocated in full (or at all), this will be indicated in the report as UNASSIGNED
    In this example, the Output Option of Show individual negotiator commission allocations has been selected and the tenancy fee split allocation has only been entered to cover 75% - therefore the remaining 25% will display as UNASSIGNED

Configuration option

  • A configuration option is available which will automatically assign any unallocated negotiator/office percentage fee splits to the Key Contact of the tenancy (for a negotiator split) or Main Office for the property (for an office split) - when this is the case, an asterisk (*) will be displayed beside the negotiator/office name that has been automatically assigned the fee
    This configuration results in there being no unassigned negotiator/office fee splits across the system

  • The example below shows how the above unallocated negotiator fee split will display in the report when this configuration is enabled
    Kian Kettlewell is the Key Contact on the tenancy so the unassigned allocation has been automatically assigned to him - the asterisk beside his name indicates the auto-assigned fee

    Two configuration options are available - one for unallocated negotiator splits and one for unallocated office splits - to request one/both of these configuration options to be enabled, click here to contact Reapit Support

3. Letting fees, tenancy dates & rent information

  • 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

  • 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

  • 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 earliest break clause

  • Sub Agt. Fee to Break Clause - value of sub agent fees up until the earliest break clause

  • Net Agt. Fee to Break Clause - net value of agent fees up until the earliest break clause

6. Agent, additional & other fees

Additional fees & Other fees are shown as two separate options (in addition to the total agent fees)
This assists when an agent pays a negotiator’s commission to some fee items (but not all)
What is classed an ‘additional fee’ or an ‘other fee’ is dependent on configuration, as outlined below

  • Agent Fee Recvd. - value of agent fee received

  • Addl. Agt. Fee - value of additional agent fee due
    The additional agent fee is calculated from specific nominal fee(s) - the nominal fee type(s) used for additional agent fees are dependent on business requirements and are set in configuration

  • Addl. Agt Fee Recvd. - value of additional agent fee received

  • Other Fee - value of other fees due
    The other fee is calculated from specific nominal fee(s) - the nominal fee type(s) used for other fees are dependent on business requirements and are set in configuration

  • Other Fee Recvd. - value of other fees received

  • Recvd. Fee Within Dates - value of 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

...

Tenancy pipeline

The example below shows how to run a pipeline report for a specific office
To run the report for all offices, leave the Property Office field blank (or untick)

Individual negotiator allocation

The example below shows how an individual negotiator can run a report to see details of all current tenancies where they will receive a fee allocation for tenancies starting that month

Image RemovedImage Added

Income for this month

The example below shows how to run a company report that will include renewal and alteration breakdowns for current tenancies for the income period of a specified month
This will impact the grid column titled Recvd. Fee Within Dates (found far right of results grid)

Image RemovedImage Added

...