Skip to main content

Data Validation against PMS Reports

Written by Michael Gimingham

There may be times when numbers in your Property Management System (PMS) and FLYR don't match exactly — whether that's your Occupancy calendar, Pick-up details, or revenue figures. Before escalating, a few common causes are worth ruling out.

Common reasons for discrepancies

  • Hourly data updates. FLYR refreshes data every hour. A recent booking may simply need to come through in the next update cycle.

  • Net vs. gross. FLYR displays all data in net by default. If you're comparing against a gross figure in your PMS, the difference you're seeing is likely formatting, not a true discrepancy.

  • Currency settings. If revenue looks inconsistent, check that the display currency in FLYR Insights matches your local reporting currency.

  • Transaction code alignment. FLYR calculates ADR using raw reservation data imported directly from your PMS. Discrepancies can arise when transaction codes — such as "Accommodation Service Charge" or "Late Departure" — aren't consistently included across both systems. Make sure the codes you're comparing are aligned before escalating.

It's also worth checking whether the integration with your PMS has known limitations that could explain the difference — some integrations have specific data handling behaviors that affect what FLYR receives. You can find the details in our Help Center.


When to reach out

If a discrepancy of more than 1% persists after the next hourly update and isn't explained by the above, contact our team via the chat icon in the bottom-left corner of the platform. This routes your query to the full support team for the fastest response.

To help us investigate, please include:

  • The exact property name

  • The specific dates and data points that don't align

  • Screenshots or daily revenue reports from your PMS — these are almost always requested, so having them ready will speed up resolution significantly


Which reports to pull from your PMS

Pull all reports in Excel where possible, using net values throughout. When selecting your date range, go slightly beyond the affected dates — for example, if the discrepancy appears around October 12–15, pull the full month of October. Below you can find the name of the reports in your PMS and which filters or settings should be used.


Mews

Manager Report By Day

  • Mode: Day | Group by: Service | Status: Confirmed | Values: Net value

Reservation Report

  • Group by: Space category | Date range: exact day, 00:00 to 00:00 | Reservation type: Staying


Opera

History and Forecast Report

  • By day

Financial Transactions with Generates

  • By day


Cloudbeds

Occupancy History and Forecast

  • Apply the relevant date filters

Transaction Details

  • Apply the relevant date filters


Protel

DQE Report (Protel onPrem)

  • Day by day | Net values | Exclude virtual/account rooms

Data Validation Report (Protel pAir)

  • Net values | Exclude virtual/account rooms


Infor

Occupancy & Statistics Report

  • Apply the relevant date filters

Posting Journal Report

  • Pull for the specific day | Filter by room category


Shiji

History and Forecast Report

  • Net values


StayNTouch

Business on the Books Report

  • Dates where the discrepancy appears | Net values


Apaleo

General Manager Report

  • Apply the relevant date filters

Revenues Report

  • Pull for the specific day


RmsCloud

History and Forecast Report

  • Net values


Clock

Occupancy/Revenue Forecast Report

  • Net values

Did this answer your question?