Hotel B&B Spreadsheet | Reservations, Guests, Housekeeping, Occupancy & Revenue Tracker
Run your hotel, B&B or guesthouse from one organised Excel system.
The BusinessOSLab Hotel / B&B / Guesthouse Business OS is an instant-download Excel operations system designed for small hotels, B&Bs, guesthouses, inns and boutique accommodation businesses.
Manage enquiries, guests, reservations, room availability, arrivals, departures, housekeeping, maintenance, guest requests, breakfasts, booking-channel commissions, invoices, expenses, staff shifts, occupancy and revenue — all from one organised workbook.
WHAT’S INCLUDED
• Blank Excel workbook ready for your property
• Filled example workbook showing the system in use
• Quick Start PDF guide
• README file
• 19 integrated hospitality-management sheets
19 BUSINESS MANAGEMENT SHEETS
Quick Start, Property Settings, Rooms & Rates, Extras & Fees, Booking Enquiries, Guest CRM, Reservations, Booking Calendar, Arrivals & Departures, Housekeeping, Maintenance, Guest Requests, Breakfast & Meals, Channels & Commissions, Invoices, Expenses, Staff & Shifts, Revenue & Occupancy and Business Dashboard.
BUILT FOR HOTELS, B&Bs & GUESTHOUSES
Track:
• Room types and capacities
• Standard, weekend and seasonal rates
• Booking enquiries
• Guest CRM and stay history
• Reservations and room allocation
• Deposits and guest balances
• Direct and OTA bookings
• Booking-channel commissions
• Room availability
• Booking conflict alerts
• Arrivals and departures
• Housekeeping schedules
• Maintenance and room downtime
• Guest requests
• Breakfasts and dietary requirements
• Invoices and payments
• Property expenses
• Staff shifts and labour costs
OCCUPANCY & REVENUE PERFORMANCE
Monitor:
• Occupancy rate
• Average Daily Rate (ADR)
• Revenue Per Available Room (RevPAR)
• Average length of stay
• Direct vs OTA revenue
• Booking-channel performance
• Room performance
• Overall revenue
IDEAL FOR
Bed and breakfasts, guesthouses, small independent hotels, boutique hotels, inns, owner-operated accommodation and small hospitality businesses.
YOUR DOWNLOAD
• Example Excel workbook with sample data
• Blank Excel workbook for your own property
• Quick Start Guide PDF
• README with compatibility and licence information
COMPATIBILITY
Microsoft Excel .xlsx format. Best used in Microsoft Excel. Compatibility with Google Sheets, Apple Numbers or other spreadsheet applications is not guaranteed.
IMPORTANT
Digital download only. No physical item will be shipped. No subscription required.
This is an operational and business-management tool only. It does not replace dedicated property-management/channel-management software, payment processing, accounting or tax software, safety procedures or legal/regulatory requirements. Accommodation rules and obligations vary by jurisdiction.