Skip to main content

10% off your first order— use codeat checkout.

Products/Small Hotel / B&B Operations Manager
Small Hotel / B&B

Small Hotel / B&B Operations Manager

$24.99

One-time purchase · Instant download · Both formats included

Works with

Microsoft ExcelGoogle SheetsMac + WindowsiPad + ChromebookNo subscription required

Secure checkoutInstant delivery30-day refund

Live Preview

Scroll through tabs at the bottom to explore all worksheets.

Save with a Bundle

This template is included in these bundles. Get more templates and save:

Small Hotel / B&B Complete Business Bundle

4 templates included

$39.99
$71.97
-44%

All Spreadsheets Bundle

91 templates included

$79.99
$1927.09
-96%

What's Included

16 tabs, formulas pre-wired
Sample data plus a blank version
Conditional formatting and dropdowns set up
Works in Excel and Google Sheets

Overview

Room inventory, reservations, revenue tracking across 8+ categories, housekeeping schedules, guest reviews, breakfast and F&B management, maintenance, staff scheduling, and seasonal rate planning. Built for boutique hotels and B&Bs that don't need (or want) a full PMS.

Tracks 10 professional tabs covering all hotel/b&b operations, room inventory with types, bed configs, rates, and amenities, reservation management with ota source tracking and special requests across 16 organized worksheets. Real formulas doing the work, not empty cells waiting to be filled. Tabs cover Settings, Dashboard, Reservations, Guest Management and 12 more.

Worksheets Included (16)

Settings
Dashboard
Reservations
Guest Management
Operations & Housekeeping
Staffing & Payroll
Inventory & F&B
Property & Utilities
Night Audit
Revenue & Channels
Pricing & Rates
Financial P&L
Budget & Accounts
Owner's Report
Comp Set
Instructions

Key Features

  • 10 professional tabs covering all hotel/B&B operations
  • Room inventory with types, bed configs, rates, and amenities
  • Reservation management with OTA source tracking and special requests
  • Monthly revenue tracker with 8 income and 10 expense categories
  • Housekeeping task tracker with linen, deep clean, and rating tracking
  • Guest experience & reviews tracker across 7 rating categories
  • Breakfast & F&B log with cost, revenue, and margin analysis
  • Maintenance work order log with vendor and warranty tracking
  • Staff scheduling with roles, shifts, and weekly payroll
  • Seasonal rate management across 4 room tiers
  • KPI dashboard with ADR, RevPAR, occupancy, and more
  • 146 formulas for automated calculations
  • Sample data version + blank template included

Ideal For

  • Boutique hotel owners
  • B&B operators
  • Inn keepers
  • Small hotel managers
  • Hospitality investors

Related Products

Small Hotel / B&B

Small Hotel / B&B Forms Package

6 professional hotel/B&B forms: guest registration, room inspection, reservation confirmation, incident report, housekeeping, maintenance

$9.99View →
Small Hotel / B&B

Small Hotel / B&B Business Plan Presentation

13-slide investor-ready boutique hotel business plan with burgundy & gold luxury theme

$7.99View →
Small Hotel / B&B

Small Hotel / B&B Operations Hub — Notion Template

Boutique hotel / B&B operations workspace for Notion

$29.00View →

Common Questions

Does this work in Excel AND Google Sheets?
Yes. Every spreadsheet ships in two formats: a native .xlsx file (Excel 2016+) and a Google Sheets copy you can open in your browser. Formulas, formatting, and validation work identically in both. Pick whichever your team uses.
Will the formulas break if I add my own rows?
No. Formulas use structured references and dynamic ranges where it matters, so inserting rows mid-table extends the calculations automatically. The Instructions tab in each workbook explains which rows are formula-driven vs. your input.
Is there a password on the file?
Yes. The workbook is lightly sheet-protected to prevent accidental formula overwrites. The password is included in the Setup Guide PDF that ships with every purchase. You're free to unprotect any sheet once you're in.
What if I need a refund?
30-day money-back guarantee, no questions asked. Email hello@fennecpress.com with your order number and we'll process the refund within a business day.
Can I re-download the file later?
Yes. Create a free account at fennecpress.com/account after purchase and your downloads stay accessible. A copy also lands in the confirmation email you received at checkout.
Can I use this for my business / my clients?
Yes. You own your copy outright and can customize it, share it with your team, and use it for as many internal or client-facing projects as you want. You can't resell the template itself, but any work product you create using the template is entirely yours.
Review us on Trustpilot

Get this template in the Small Hotel / B&B Complete Business Bundle

4 templates for $39.99, save 44%

View Bundle

Ready to Get Started?

Get instant access to Small Hotel / B&B Operations Manager

Secure Checkout
Instant Download
30-Day Refund
Powered by Stripe

Templates are tools, not advice. Nothing here is legal, tax, financial, or professional advice. Run big decisions past a qualified professional. Full terms.