A multi-site operator where every location typed yesterday's numbers by hand, then head office stitched them together

Every morning, a clerk at each location opened the management software, read off yesterday's occupancy and revenue, and retyped the numbers into a shared spreadsheet that got uploaded to a common drive. About ten minutes a site, every day, before anyone had looked at a single decision. Across the group that came to roughly 70 hours of staff time a month spent copying numbers from one screen into another.

It was also fragile. Locations had migrated between systems at different times, so the platforms did not agree on field names or history, and the year-before figures simply did not exist in the newer installs. Manual entry meant frequent slips and half-filled templates, and the one person who had started building a proper dashboard had to abandon it for lack of time. Management could see a daily snapshot, but not the structured, comparable view they actually wanted to run the business on.

We started where the cost was: the daily copy step. Instead of a person reading a screen and retyping, each location's numbers are now extracted directly from the source and dropped into one place automatically, on a schedule, with no one in the loop for the routine case.

The harder half was making locations comparable. The systems disagreed and the migrated sites were missing history, so we normalized everything to a single structured shape, reservation line by reservation line where the detail existed, and folded the older records the group already held back in so the year-over-year math was real and not a gap. On top sits one dashboard: occupancy and revenue per location, the group roll-up, and the month-to-date and same-period-last-year comparisons management had been assembling by hand. Reads are role-based, so a regional manager and head office see the cut that fits them.

The morning retype is gone. The numbers land on their own, the same figures everywhere, and the roughly 70 hours a month that went into copying them now go into reading them. The errors and the half-filled templates went with the manual step.

Management stopped working from a flat daily snapshot. They now open one view with the breakdowns and the year-over-year context they had wanted all along, built on the group's own consolidated history rather than whatever a given site's newest system happened to retain. The dashboard that had stalled for lack of time exists, and it stays current without anyone tending it.