CityLights Help Back to the app
Help centre

Management dashboard

The month's key measures against last month, last year and your targets, with a 12-month trend and a PDF or Excel pack.

What this page is for

One page for owners and managers: how the business did in a month, compared with the month before, the same month last year and the targets you set. Each card shows a small line of the last 12 months.

Who can use it

See the management dashboard (by default Admin and Finance). Setting targets needs Set management targets and the MIS email (by default Admin).

How to

  1. Open Month and pick one, moving between years with the arrows (last month by default; the page compares one month with others, so one month is chosen), what the figures are For (the whole portfolio, or one property group or building) and the Currency, then select Show.
  2. Read each card: the big number is the month; below it, the change on last month, the change on the same month last year, and the target.
  3. Select MIS pack (PDF) for a printable pack, or Excel for the 12 months of figures in a spreadsheet.
  4. Select Targets to set or change the monthly targets.

Fields and columns

Field Meaning
Revenue Revenue of the nights stayed in the month (stays across a month end are split by night).
Occupancy Nights sold as a share of nights available (operational units times days in the month). Use the occupancy report to leave out-of-order nights out.
Average price per night (ADR) Revenue divided by nights sold.
RevPAR Revenue divided by nights available.
Money received Guest payments received in the month.
Owed by customers What customers owed at the end of the month. Shown when invoicing and receivables are on.
Expenses Expenses dated in the month. Shown when expenses are on.
Margin Revenue less expenses, as a share of revenue. Shown when both are available.
Open maintenance jobs Maintenance jobs still open at the end of the month. Lower is better.
Guest rating The average rating of reviews published in the month, out of 10.
Last month, Last year Green when the change is good for the business, red when it is not. Percentages change in points (pts).

Measures come from the modules you use, so the cards change when modules are turned on or off.

Statuses and automation

Figures are worked out when you open the page, from confirmed stays and no-shows. Money is converted at each month's exchange rate. When Day of the month to email the pack is set, the PDF pack for the month before is emailed on that day to the addresses in Email the monthly MIS pack to, once per month.

Settings that change this page

FAQs

Which currency are the amounts in? Always the system currency (the base currency under Settings). Amounts recorded in another currency are converted at the exchange rate of their month. An amount whose month has no rate is left out and a warning with a link to Exchange rates appears; currencies are never added together or shown as separate totals.

Why is a card showing "-"? There is no figure for that month, for example no stays or no exchange rate.

Why does revenue differ from profit and loss? Profit and loss counts whole stays by check-in month; this page counts the nights inside the month.

Can I see one building? Yes, choose it under For. Groups come from your property groups and buildings.

Troubleshooting

Problem What to do
Money cards show "-" in another currency Add the missing monthly exchange rates under Exchange rates.
The monthly email did not arrive Check both email settings, the email server settings and that the day has passed. Each month is sent once.
A target is missing Targets are set per month and per scope; set it under Targets for the same scope.

Related pages