Hotel & Guesthouse Finance Dashboard — Excel Template

🏨 Hotel & Guesthouse Finance Dashboard — Excel Template

Take full control of your property's finances with this all-in-one Excel dashboard, designed specifically for hotels, guesthouses, and small hospitality businesses in Mauritius and beyond.

Whether you're managing a boutique guesthouse or a multi-room hotel, this template gives you a clear, real-time picture of your revenue, expenses, occupancy, and profitability — all in one place.

📊 What's Included

• Dashboard — Instant overview of Total Revenue, Total Expenses, and Net Profit
• Revenue Tracker — Monthly breakdown by category: Room Bookings (Standard, Deluxe, Suite), Restaurant & Dining, Bar & Beverages, Swimming Pool, Airport Transfers, Spa & Wellness
• Operating Costs — Track Staff Wages, Food & Beverage Stock, Utilities, Housekeeping, Maintenance, Marketing, Rent, Insurance, Transport & Miscellaneous
• Room Management — Monitor room inventory, occupancy rates, nightly rates, and monthly room revenue by room type
• Guest Booking Log — Record guest details, check-in/check-out dates, room type, total amount, payment method, and booking source
• Housekeeping Checklist — Daily room status tracker with assigned staff, check time, and notes

✨ Key Features

• All amounts in Mauritian Rupees (Rs) — easily adaptable to any currency
• Auto-calculating totals — just enter figures in the yellow cells
• Profit margin and occupancy rate calculated automatically
• Clean, professional design with colour-coded sections
• No macros or plugins required — works on Excel and Google Sheets

🎯 Perfect For

• Hotel owners and managers
• Guesthouse and B&B operators
• Hospitality students and consultants
• Anyone managing short-term rental properties

Instant digital download. No physical product will be shipped.