One dashboard, every property.
Own one hotel and a shared spreadsheet works. Own three, and every month becomes a reconciliation project: three PMS exports, three definitions of "occupancy," and a board deck that took longer to build than to read. Here is what a multi-property report actually needs to contain — and why the industry's own accounting standard is quietly becoming the baseline lenders expect, not a nice-to-have.
The second property is where the spreadsheet breaks
One hotel, one PMS, one owner reading one export — that scales fine on instinct. The second property changes the job entirely. Now someone has to open two systems, align two chart-of-accounts structures that were never built to match, and manually decide whether "F&B revenue" means the same thing in both exports. By the third property, that reconciliation is a part-time job nobody was hired to do, and it is usually done by whoever is most available, not most qualified.
What lenders and boards are actually asking for now
The hospitality industry's own accounting standard, USALI, has gone through a 12th edition revision aimed squarely at this problem: making property-level and portfolio-level numbers comparable, auditable and bank-ready without a translation layer. That is not an academic detail. When a lender, a board member, or a buyer's diligence team asks for financials, "our bookkeeper's spreadsheet" and "USALI-structured statements" read very differently — one looks like a small business, the other looks like an asset that can be financed, benchmarked and eventually sold on someone else's terms, not just yours.
- A common structure per property — the same accounts, the same definitions, whether the hotel has 20 rooms or 110.
- USALI-aligned statements — so a bank, an auditor or a buyer does not have to re-map your numbers before they trust them.
- Group-to-property drill-down — the portfolio number is a starting point, not the whole answer; you need to reach the property, then the line, that explains it.
- A refresh cadence people can trust — monthly at minimum, without a week of manual reconciliation between close and report.
A spreadsheet tells you what happened at each hotel. A report tells you what is happening to the portfolio — and which property is the reason.
What good drill-down actually looks like
Portfolio RevPAR moved 6% this month — good or bad? On its own, that number cannot say. Good drill-down means clicking that figure and landing on the one property that drove it, then the one line — rooms revenue, a rate change, a longer stay pattern — that explains the property. Without that path, every board conversation turns into someone opening three more spreadsheets live in the meeting, which is where good reporting systems quietly go to die.