Tenant effort rate
The Tenant effort rate report shows, for one property, how much of each tenant's reported turnover goes on occupancy cost: the rent plus service charge billed to the tenant, over the turnover the tenant reported, for the last twelve months. A high rate says the shop struggles to carry its rent, not that the rent is high.
The cost is the net of VAT amount on the invoices issued to the tenant. The turnover is taken as reported, and is read as net of VAT, because tenants' reports do not say whether it includes VAT.
Who can see the report
The report appears only when the property-management and tenant-turnover features are switched on for your organisation. It is open to anyone with the contracts manager or contracts viewer role; for anyone else it says that it needs the Commercial contracts viewer role.
Where to find it
On a property's own page, with the Tenant effort rate button. The report is always about that one property.
Choosing the twelve months
The report covers twelve months ending on the month you pick in To, the last month of the window. It opens on the last completed month. The chosen month stays in the page address, so a link you share opens the same window.
Reading the report
- Portfolio effort rate - all occupancy cost over all turnover of the tenants that have a rate.
- Tenants at risk - how many rated tenants are above the threshold over the twelve months.
- Turnover reported - how many tenants reported turnover in every month of the window, with the number of incomplete and not reported tenants below it.
- Effort rate by tenant - one bar per tenant, highest first, against a dashed threshold line. Tenants without a rate get no bar and are named below the chart.
- The table - each tenant's occupancy cost, turnover, effort rate and an At risk flag. A sum over fewer than twelve months says how many it covers, for example 9 of 12 months.
Amounts follow your organisation's amount format, and rates and months are written in the language you use Flowtly in.
The threshold
A tenant is flagged At risk when its twelve-month rate is above your organisation's threshold, 10 % unless your organisation has set another value. The threshold is shown on the report and is not changed from it. The flag reads the twelve-month figure only: a single month is never flagged on its own.
A tenant's months
Select a tenant to open its months: the twelve-month cost, turnover and rate, and one bar per month against the threshold. A month without a bar has no rate. A tenant that pays a share of its turnover as rent is marked Turnover rent: its rate tends toward the contractual share, so a flag against the threshold means something different for it.
When a tenant has no rate
A rate is shown only when every month of the window has both a cost and a turnover, because a rate from part of the period would read low or high depending on which months are missing. A tenant with no rate is never shown as 0 %; the report gives the reason instead:
| the report says | what it means |
|---|---|
| Turnover not reported | The tenant reported no turnover for a month. Enter it in Tenant turnover. |
| Turnover reported as zero | The tenant reported zero turnover, so there is nothing to divide by. |
| No rent billed | No rent was invoiced to the tenant for a month. |
| Billed outside the lease dates | Rent was invoiced outside the dates the lease records, for example before its rent start is set. |
| Charge category not mapped | The invoiced charges cannot be told apart as rent or service charge. |
| Invoice not linked to a lease | An invoice to the tenant is not linked to its lease. |
| Cost and turnover in different currencies | The cost was billed in another currency than the turnover; the amounts are not added together or converted. |
| Fewer than 12 complete months | The window does not hold twelve complete months for the tenant. |
When your organisation has no service charge category mapped, no rate can be shown for any tenant, and a warning above the report says why.
When the report is empty
- No leased units in this property - no tenant had billed rent in the selected period.
- No turnover reported for this period - tenants have billed rent, but none reported turnover for the twelve months. Enter the turnover, or import the tenants' reports, and open the report again.
- Effort rate could not be loaded - the figures did not arrive. Try again reloads them.
Example use cases
- Before a rent review, see which tenants of a shopping centre spend the largest share of their turnover on rent and service charge.
- Find the tenants above the threshold and talk to them before arrears build up.
- Check why a tenant has no rate, and fill in the missing turnover or link the invoice to its lease.