Tenant turnover and sales per square metre

Flowtly Editorial Team8 minUpdated

Retail tenants often pay rent that depends on what they sell, so Flowtly lets you record each tenant's monthly sales and compare them across your centre. Two screens do this: one for entering the figures, one for comparing them.

These figures are for reporting. Nothing is invoiced from them.

Who can see the screens

Both appear only when the property-management features are switched on for your organisation. With the real-estate features off, the menu entries are not there at all.

Reading the figures needs the contracts viewer role. Entering and saving them needs contracts manager.

Where to find them

In the main menu, under Operations:

  • Tenant turnover - the entry grid.
  • Turnover comparison - the two charts.

They sit side by side in that menu group. The comparison is not a tab inside the grid.

Entering monthly figures

Tenant turnover shows a grid with one row per tenant and one column per month. Each cell holds that tenant's sales for that month.

Your staff enter these figures. Tenants do not report them themselves.

  • Choose the period with From and To. The grid opens on the current year so far, from January to the current month. When the months do not all fit on the screen, the grid says Scroll sideways to see more months above the table. Scroll the table sideways to reach them, or move the keyboard focus onto the table and use the arrow keys.
  • Rows begin as the tenants that already have a figure somewhere in the period. To record a figure for a tenant who has never reported one, use Add a tenant and pick them.
  • Type the figures straight into the cells. A comma and a full stop both work as the decimal separator.
  • Save figures writes the whole grid at once.

Only the cells you changed are sent. A save is all or nothing: if any figure is refused, nothing at all is written and the screen says so. When it succeeds you are told how many figures were added and how many were updated.

An empty cell is not a zero

This is the distinction to get right, and every part of both screens keeps it.

  • An empty cell means nobody reported a figure for that tenant and that month.
  • A 0 means the tenant did report, and the figure was zero: the shop sold nothing that month.

Those are two different statements. Read a blank as a zero and you will rank your tenants wrongly. So leaving a cell empty never records a zero, and typing 0 records a real figure.

Currency

Every figure carries a currency. Each tenant row has its own Currency picker, beside the tenant's name (on a phone, on the tenant's card). New figures you type for that tenant are saved in the currency it shows.

  • The picker starts on the tenant's own currency: the one their existing figures are in. A tenant with no figures yet starts on your organisation's currency.
  • Change it per tenant. Choosing EUR for one tenant does not touch any other row, so a centre where some tenants report in RON and others in EUR can enter both in the same grid.
  • A figure already saved keeps its currency when you edit it. Only new figures take the picker's currency.
  • A figure in a different currency from its row's picker shows its currency code next to the amount, so you can tell it apart at a glance.
  • Discard drops your currency choices along with your unsaved figures.

You can save the first figures for a tenant, or for a whole period, without any figure being stored yet: the picker supplies the currency.

Totals never add two currencies together. A tenant's total, the All tenants row and the grand total show one amount per currency, for example 5,000 RON + 700 EUR. The All figures in note above the grid lists every currency on screen.

Users who can only read the figures see no picker.

If a save does not go through

the screen says what happened
One of the figures is not a number A cell holds something that cannot be read as an amount. Correct it and save again.
The figures were rejected before anything was written A check refused one of the rows. Nothing was saved.
The figures could not be saved The save itself failed. Nothing was written.
Choose a currency for these figures A figure has no currency yet, which can happen while the list of currencies is still loading. Pick a currency in the tenant's row and save again.

Comparing tenants

Turnover comparison draws two charts over a period you choose with the same From and To fields.

Choose at most 36 months. A wider range is refused, and the screen says how many months you asked for. If the start month is after the end month it says that instead and draws nothing.

Turnover by month

One line per tenant across the months of the period.

  • A break in a line is a month that was not reported.
  • A reported zero is drawn at zero.

It is the same distinction as in the grid, shown as a picture: a gap and a zero look different because they mean different things.

Sales per m²

One bar per tenant: their turnover divided by the floor area their leases cover, averaged over the months they reported. Tenants are ranked, highest first, so the chart reads as a league table.

The average covers only the months a tenant actually has a figure for, so a bar built from a single month is not a trend.

When a tenant has no sales per m²

A per-square-metre figure can be legitimately missing, and the screen always says which of two reasons applies. Under Tenants with no sales per m² there is one line per tenant:

  • A lease in force records no floor area, so the turnover cannot be divided. This is the one you can act on: record the floor area on the contract and the tenant joins the comparison.
  • No lease was in force in the months reported, so there is no floor area to divide by. That usually means a figure was entered for a month outside the tenancy, which is worth checking.

Neither case is drawn as a zero. A tenant with no per-square-metre figure at all still appears in Turnover by month: they reported turnover, and that is what the chart shows.

If no tenant in the period has both a figure and a recorded floor area, the per-square-metre chart says so rather than showing an empty frame.

Figures in more than one currency

The charts do not convert currencies, and they never mix them: 100 RON is not 100 EUR, and a line or a ranking that added them together would be wrong. So the charts show one currency at a time.

  • They open on your organisation's currency when the period has figures in it, otherwise on the first currency found.
  • If the period holds figures in more than one currency, a warning names them and carries a picker to switch the currency the charts show.
  • Only figures in the shown currency are drawn, averaged and ranked. A tenant who reported only in another currency appears when you switch to it.
  • Switching the currency starts the selection of compared tenants again, because the tenants that have figures differ from one currency to another.

Example use cases

  • Monthly sales entry: Type each tenant's reported sales for the month into the grid and save them all at once.
  • Telling a zero from a missing figure: Check which tenants have a gap in their line and which reported a real zero before chasing anyone.
  • Ranking tenants by sales per m²: Open the comparison to see which tenants sell the most for the floor area their leases cover.
  • Tenants reporting in two currencies: Set the currency picker to EUR for the tenants who report in euros and leave the others on RON, then save the whole grid at once.
  • Finding tenants with no floor area: Use the list of tenants with no sales per m² to see whose contract still needs a floor area recorded.

Related terms