Basic information — shown in the dashboard header.
Room Configuration
Used across every tab for RevPAR and available room-night calculations.
Saving here also updates the Property setup field on the Dashboard tab.
Revenue & Reporting
Controls how revenue figures are displayed.
Google Drive Folders
Pre-fill folder names so you don't have to re-enter them after signing in to Drive.
Property setup
Total rooms — used to calculate RevPAR and available room-nights
Booking pace — upcoming months
On-the-books figures vs. same month last year
Pace vs. last year
Period
As of
On-books Rev.
LY Actual Rev.
Rev. Pace
On-books RevPAR
LY RevPAR
RevPAR Pace
No pace snapshots yet — add on-the-books figures for an upcoming month above.
Revenue pace chart
100% = on pace with last year
Revenue Pace by Month
on-books revenue ÷ prior-year actual revenue
Calendar
Import from CSV
Upload a "Business on the Books" export — daily rows are auto-segmented by month
File spans multiple months — each was totaled from its daily rows. Set "Import as" per month, then confirm.
Month
Days
Revenue
ADR
Occupancy
Import as
Add monthly data manually
One row per month
Monthly records
Year
Month
Revenue
ADR
Occupancy
RevPAR
No data yet — import a CSV or add a month manually above.
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 — imported from Daily Production by Rate CSV
Import a "Daily Production by Rate" CSV above to populate this report. Each import adds a week column — historical weeks are preserved.
Budget vs. Actual by month
Period
Room Revenue — Budget
Room Revenue — Actual
Room Revenue — Var $
Room Revenue — Var %
Room Fees — Budget
Room Fees — Actual
Room Fees — Var $
Room Fees — Var %
Restaurant — Budget
Restaurant — Actual
Restaurant — Var $
Restaurant — Var %
Parking — Budget
Parking — Actual
Parking — Var $
Parking — Var %
Total — Budget
Total — Actual
Total — Var $
Total — Var %
Set budget figures and enter actuals to see tracking here.
Monthly revenue budget
Enter or update the budgeted amount for each revenue category per month
Budget on file
Period
Room Revenue
Room Fees
Restaurant
Parking
Total
No budget entries yet.
Other revenue actuals
Room revenue is pulled automatically from your monthly data — enter fees, restaurant, and parking here
Room Revenue is sourced automatically from the monthly records in your History tab — no entry needed here.
Actuals on file
Period
Room Revenue (auto)
Room Fees
Restaurant
Parking
Total
No actuals entered yet — select a month and enter fees, restaurant, and parking above.
Not connected to Google Drive
Connect Google Drive
Sign in to automatically sync your PMS exports. Once connected, the dashboard re-imports current-year reports on every sync and locks historical files after first import.
Drive folder names
Live occupancy — overwrites daily
Prior year actuals — import once
Weekly channel snapshots
coming soon
How sync works — Current-year reports in the Current BotB and Production by Rate folders are re-imported on every sync, overwriting any existing data for those dates. Historical BotB reports are imported once and then locked; they are never re-fetched. If Drive converted your CSV files to Google Sheets format, the sync handles that automatically.