Verifying session…

Performance Dashboard

RevPAR = Total Revenue ÷ Available Rooms

Variance vs Budget

Forward Pace — Current BotB vs. Last Year

On-books revenue from current BotB import vs. same month last year actuals

Booking Pace — Same Time Last Year

No file loaded — upload Reservations by User report
No file loaded — upload prior year report

Upload both reports above to see booking pace

Upload history

Property Setup

Total rooms — used to calculate RevPAR across all tabs

On-Books Pace Snapshots

Manual on-the-books figures vs. same month last year actuals

Pace vs. Last Year

PeriodAs of On-books Rev.LY Actual Rev.Rev. Pace On-books RevPARLY RevPARRevPAR Pace

Revenue Pace Chart

100% = on pace with last year

Revenue Pace by Month

On-books revenue ÷ prior-year actual revenue

Calendar

Add monthly data manually

One row per month — use for historical actuals not covered by BotB uploads

Monthly records

YearMonthRevenueADROccupancyRevPAR

Year-over-year trends

Each line is one calendar year

Total Revenue

by month, $

ADR

average daily rate, $

Occupancy

by month, %

RevPAR

revenue ÷ available rooms

Channel Production Report

Rooms booked per rate plan, by week — upload via the Data Upload tab
No production data yet — upload a "Daily Production by Rate" CSV in the Data Upload tab. Each upload adds a week column and historical weeks are preserved.

Budget vs. Actual by month

Period Room Revenue — BudgetRoom Revenue — ActualRoom Revenue — Var $Room Revenue — Var % Room Fees — BudgetRoom Fees — ActualRoom Fees — Var $Room Fees — Var % Restaurant — BudgetRestaurant — ActualRestaurant — Var $Restaurant — Var % Parking — BudgetParking — ActualParking — Var $Parking — Var % Misc — BudgetMisc — ActualMisc — Var $Misc — Var % Total — BudgetTotal — ActualTotal — Var $Total — Var %
Set budget figures and enter actuals to see tracking here.

Business on the Books — Current

Daily occupancy data — re-upload any time to refresh. Overwrites existing data for the same dates.
● Live data
📄
Drop BotB CSV files here
Supports single or multiple files — all will be merged
Current BotB — Upload the "Business on the Books" CSV export from StayNTouch. Each upload overwrites daily data for the dates covered, so you always have the latest occupancy picture. Upload as often as you like — daily is recommended.

Business on the Books — Historical

Prior year actuals — import once, never overwritten. Used for YOY comparisons.
● Historical
📁
Drop historical BotB CSV files here
Prior year exports — data is inserted once and never overwritten
Historical BotB — Upload prior-year Business on the Books exports. Each date row is inserted only if no data already exists for that date — existing historical data is never overwritten. Upload your full prior year once to establish the baseline.

Production by Rate — Channel Production

Weekly channel production snapshots by rate plan. Each upload adds a new week column.
● Weekly
📊
Drop Production by Rate CSV files here
Weekly snapshots — each file adds or updates one week column
Production by Rate — Upload the "Daily Production by Rate" CSV export from StayNTouch. Each file represents one week. Re-uploading the same week overwrites that week's data. Historical weeks are preserved.

Booking Pace — Reservations by User

Same-time-last-year pace reports. Upload current year and prior year to compare booking windows.
● Pace
Current Year Report
Current year
Created last 365 days, next month arrivals
Prior Year Report (STLY)
Prior year
Same window one year earlier
Reservations by User by Date Range — Run this report twice in StayNTouch: once for the current booking window (last 365 days, next month arrivals) and once for the prior year equivalent window. The dashboard reads Total Revenue and Room Nights from the report header to calculate ADR, occupancy, and RevPAR pace.
Upload history

Upload Summary