Are the Sheetly AI templates free?

Yes. Templates are built by Sheetly AI and released under the CC0 license (public domain). With a free verified account you can download one template per month; Pro subscribers get unlimited downloads. Viewing online is always free.

Can I use a template commercially?

Yes. Because they are CC0 (public domain), you can download, edit and use the templates freely — including in commercial projects — with no attribution required.

Do the templates include formulas?

Yes. Every template is a real .xlsx file with its own formulas, tabs and formatting, compatible with Excel (2016 or later), LibreOffice Calc and Google Sheets.

Can I ask for a custom spreadsheet?

Yes. Describe what you need and Sheetly AI builds a custom spreadsheet from scratch, beyond the ready-made templates in the library.

Boutique Guesthouse Occupancy & Efficiency Dashboard

Track room occupancy, rate mix, revenue, and housekeeping performance. Free .xlsx with formulas. Tracks Average Occupancy Rate, Average Daily Rate (ADR).

Operations · dashboard · CC0 public domain · Built by Sheetly AI

Preview of the Boutique Guesthouse Occupancy & Efficiency Dashboard template

About this template

This operations dashboard brings together indicators like "Average Occupancy Rate", "Average Daily Rate (ADR)" and "Monthly Room Revenue" in a single view. Edit the entries in the Data tab and the dashboard numbers update instantly — no need to build the spreadsheet from scratch.

This template helps boutique guesthouse managers monitor room occupancy, nightly rate mix, revenue, and housekeeping efficiency over time. Enter each room’s daily activity, including stay status, rate type, revenue, and cleaning metrics, to populate the dashboard. Use the KPIs and comparison bars to quickly assess performance trends, identify high-performing room segments, and optimize staffing and pricing. Review the data regularly to adjust rates, improve turnaround, and boost overall guesthouse profitability.

Released under the CC0 license (public domain): download, edit and use it freely — including commercially — with no attribution required.

Use cases

Visualize indicators like "Average Occupancy Rate" and "Average Daily Rate (ADR)"
Make faster decisions based on "Monthly Room Revenue"
Compare your operations without building the spreadsheet from scratch
Edit the entries in the Data tab and watch the dashboard recalculate automatically

Key features

Average Occupancy Rate
Average Daily Rate (ADR)
Monthly Room Revenue
Visual dashboard with 3 automatic indicators
Editable formulas in the Data tab
In-cell mini charts (sparklines)

What's inside the file

3 tabs: Dashboard, Data, Instructions
40 working formulas — including SUM, AVERAGE, COUNTA. They recalculate as you edit, so the sheet stays yours after download.
Sized for real data: up to 37 rows × 18 columns already laid out and formatted.
Built-in chart that updates with your numbers.

Everything is a normal .xlsx: it opens in Excel, Google Sheets, LibreOffice and Numbers, with no add-ons, no macros and no locked cells.

Download the .xlsx free

Related free templates

All-in-One Retail Store Sales & Inventory Control — free Excel template — Track daily sales, stock levels, margins, and profits in one place
Premium Restaurant & Hospitality Performance Tracker — free Excel template — Monitor revenue, covers, labor, and profitability KPIs across locations
Business Operations & Performance Control Center — Multi-module KPI-driven dashboard to monitor operational and financial performance. Free .xlsx with formulas.
Retail Store Management OS Dashboard — free Excel template — Integrated view of sales, inventory, supplier performance, and profit analytics. Free .xlsx with formulas.
Restaurant Performance & Growth Management OS — Track sales, costs, covers, and margins to scale your restaurant profitably. Free .xlsx with formulas. Tracks 30-Day Total Revenue, Average Daily Covers.
Construction Project Budget & Work Schedule Dashboard — Track project costs, timelines, and resource allocation in one view. Free .xlsx with formulas. Tracks Total Budgeted Cost, Total Actual Cost.

Browse every free Excel template built by Sheetly AI.