Home/Spreadsheets/Small Business Tools/Rental Booking Calendar
Rental Booking Calendar
A booking calendar for hosts running more than one place. Mark each night as booked on the month tab and the workbook tracks nights booked against your occupancy target for every unit. It opens in Microsoft Excel and in Google Sheets, has no macros and nothing to install, and is yours to reuse as often as you like.
What you get
- Nights booked and nights to target per unit, so you can see occupancy at a glance rather than guessing
- Every unit with its location, type and listing date, plus an active or inactive status
- Up to 7 booking types you name yourself, each with a full and a half code for part nights
- Click a day cell, pick a code from the dropdown - the cell colours itself and the totals move instantly
- Twelve month tabs that follow the start year you set, so the workbook works for any year
- Opens in Excel and in Google Sheets
$22.99one-time, no subscription
Buy on Etsy
Instant digital download · one-time purchase · no subscription

What it does
- Nights booked and nights to target per unit, so you can see occupancy at a glance rather than guessing
- Every unit with its location, type and listing date, plus an active or inactive status
- Up to 7 booking types you name yourself, each with a full and a half code for part nights
- Click a day cell, pick a code from the dropdown - the cell colours itself and the totals move instantly
- Twelve month tabs that follow the start year you set, so the workbook works for any year
- A weekly view showing how many units are booked and how many are still open
What it looks like


Every tab in the workbook
These are the actual sheet names in the file, not a feature list.
- Dashboard
- Instructions
- Menu
- Units
- January
- February
Works in
- Microsoft Excel 2016 or later, Windows and Mac
- Google Sheets — upload to Drive and open
- No macros, no add-ins, no subscription
Honest scope
This is a planning and bookkeeping template, not tax or accounting advice. The numbers it reports are the numbers you enter.
Others in Small Business Tools
- Craft Show Vendor KitA craft show vendor kit that answers the only question that matters after a market…$10.99View →

- PTA and PTO Treasurer SpreadsheetA treasurer's ledger for any parent group with a bank account: one register row per…$18.00View →

- RFI and Submittal LogAn RFI and submittal log for construction administration that ages every open item from…$16.99View →

- Home Inventory TrackerAfter a fire or a burglary the insurer asks for a list. People who have one get paid…$11.00View →
