Urbanica Hotel Performance Tracker

Real-Time Actuals vs Budget — Monthly Input Dashboard

Property Setup

Configure your property details. These are used for KPI calculations (RevPAR, Occupancy, etc.).

Quick Start

Go to the Data Input tab to enter your monthly actuals and budget figures. The dashboard, P&L, and variance analysis will update automatically as you type.

How it works: Enter actual revenue, expenses, and reservation data month by month. Optionally enter budget figures to see variance analysis. All KPIs, charts, and reports calculate in real time.

Save/Load: Use "Export Data" to save your inputs as a JSON file. Use "Import Data" to reload them later.

Monthly Data Input

Enter actual figures in blue fields. Enter budget figures in purple fields. Calculated rows update automatically.

Monthly Revenue: Actual vs Budget

ADR & Occupancy Trend

Monthly GOP: Actual vs Budget

Cost Breakdown (YTD)

Monthly Net Income Waterfall

Profit & Loss Statement

Auto-generated from your monthly input data.

Budget vs Actual Variance Analysis

Green = favorable variance (actual better than budget). Red = unfavorable. Shows only months with data entered.

YTD Variance by Category

Reservation Metrics

Room Nights, ALOS, and Reservations are derived from Data Input. Only cancellations and channel revenue breakdown need to be entered here.

Channel Mix (YTD)

ALOS & Reservations Trend

PREVIEW MODE | Interactive demo · Data input disabled