Business-day-accurate occ/ADR feed
I fixed the timezone that was quietly lying about last night's occupancy.
The nightly PMS summary anchors 'yesterday' to a UTC cutoff around 7pm Pacific, so its 'last night' is really the night still in progress. That skews occupancy and ADR in the flash report, which matters when the number drives a decision.
How it works
I configured a daily Manager Report export on every property, keyed to the property's own business day so it reads true, delivered by email as Excel. A Python parser turns each into a single realized last-night row, with occupancy derived from occupied over available so it is format-proof, that overrides the timezone-skewed field in the flash.
- A targeted override, not a swap. The original export still feeds forecast, pickup, and year-to-date.
- Handles both shapes the scheduler emits (a clean xlsx versus a zip of CSVs with scaled fractions).
- Configured across all properties, with the portfolio shell correctly skipped since it does not roll up.
Building. The parser is tested green and the exports were configured portfolio-wide. The daily emails were later paused, so wiring the live override into the flash is the open step.
This is the least glamorous fix on the board and one of the most important. A report that is confidently wrong is worse than no report. Chasing a timezone off-by-one is precisely the detail an owner would never catch and an agent pipeline can encode once.