Hotel Daily Flash Report (Excel template)

Built for General Managers and Financial Controllers who want the day's numbers on one page without rebuilding a spreadsheet every month. Type ten figures a day: rooms available, rooms sold, room revenue, F&B revenue, other revenue, budget and last year. The workbook returns occupancy, ADR, RevPAR, month-to-date and year-to-date totals, plus the variance against budget and last year in value and percent.

What is inside: a Read me sheet with the formulas explained; Daily Input with 31 rows and colour-coded cells (yellow to type, grey calculated); MTD-YTD with month-to-date ratios and a year-to-date block; Flash Summary, a one-page A4 printout that pulls any date you choose; and an Example sheet filled with a full sample month so you can see every formula working.

Format: .xlsx for Excel 2016 or newer, Google Sheets and LibreOffice. No macros. Fully editable, all formulas visible.

License: one property or one business, unlimited internal users. No resale or redistribution. Refund within 7 days if the file is faulty or cannot be downloaded.