CityLights Help Back to the app
Help centre

Payment variance report

Bookings where the money collected is more or less than the price.

What this page is for

Find stays that are not paid in full, or paid too much, so you can chase or refund the difference.

Who can use it

See money reports (by default Admin, Finance and Viewer).

How to run it

  1. Choose the check-in months, currency and properties.
  2. Leave Only bookings with a difference ticked to hide stays paid exactly, and select Show.
  3. Select a booking to open it.

Fields and columns

Column Meaning
Price The booking's gross amount. For a cancelled stay, the amount kept.
Collected Every verified payment for the booking, whenever it came in, minus refunds.
Difference Collected minus price. Negative (red): still to collect. Positive: collected more than the price.

Statuses and automation

Confirmed stays, no-shows and cancelled stays that kept money are included, by check-in month. Stays waiting for payment or approval are not.

Settings that change this page

The system currency (base currency under Settings).

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 does a paid booking show a difference? A payment may still be waiting for checking, or in a different currency with a missing exchange rate.

Troubleshooting

Problem What to do
A difference of a few cents The payment was in another currency; amounts are converted at the stay's month rate.

Related pages