Free Airbnb Spreadsheet Template: Track Bookings, Occupancy & Payouts (Excel + Google Sheets)

If you host on Airbnb or VRBO, your payout emails tell you what hit the bank. They don’t tell you how full the calendar really was, what each booking site kept, or whether last month made money once the cleaner and the bills were paid. A simple Airbnb spreadsheet template fixes that in about ten minutes a week. Below you’ll find a free one you can download right now, plus a step-by-step way to set it up and the numbers worth watching.

Free Airbnb spreadsheet template showing monthly bookings, occupancy and payouts

Download the free Airbnb spreadsheet template

Staybright Lite is a free Excel workbook that also opens in Google Sheets. Enter your stays and it works out nights, guest totals, platform fees, net payouts and your average nightly rate, then rolls everything up into a monthly summary with a chart. Enter your email and the download starts straight away.

Free Airbnb Booking & Income Tracker (Staybright Lite)

XLSX · 25.5 KB · Free

A free Excel and Google Sheets tracker for one short-term rental: log up to 30 bookings and see nights booked, occupancy, gross, platform fees and net payout by month, with a chart. Upgrade to the full Staybright tracker for the dashboard, calendar, turnovers, cleaner pay, expenses and 5 properties.

Enter your email and the file downloads straight away. Up to 3 free downloads a day. Privacy policy

Running more than one listing? The full Staybright STR Host Tracker adds a profit dashboard, booking calendar, turnover planner, cleaner pay, expenses and up to 5 properties.

See the full Airbnb host spreadsheet >

What a good Airbnb spreadsheet should track

You don’t need fifty columns. You need the few that answer the questions you actually ask. Here’s what matters most for short-term rental hosts:

  • Every booking. Channel, guest, check-in, check-out and what the guest paid for the nights, the cleaning fee and any extras.
  • Platform fees. Airbnb, VRBO, Booking.com and card processors all take a cut, and the cut differs. Track it per booking so you can compare.
  • Net payout. The guest total minus the fee. This is the number to match against your bank.
  • Occupancy. Booked nights divided by the nights you were open. A stay from January 30 to February 2 should add two nights to January and one to February.
  • Average nightly rate (ADR). What you really earn per booked night, which is rarely your listed price.
  • Costs. Cleaning, supplies, utilities, repairs, mortgage or lease. Without these, you’re tracking revenue, not profit.

How to set up the free template in 4 steps

1. Open it in Excel or Google Sheets

In Excel, double-click the file and click Enable Editing if you see the yellow bar. In Google Sheets, upload the file to Google Drive, then right-click it and choose Open with Google Sheets.

2. Fill in Settings

Type your property name and your currency symbol. Then check the fee percentage for each channel against your own account. Fee plans vary by host, country and listing, so it pays to look rather than guess. The template comes with example rates you can overwrite.

3. Log your bookings

One row per stay. Pick the channel, type the guest name and dates, then the total charged for the nights (not the per-night price) and the cleaning fee. The blue columns fill in: nights, guest total, platform fee, net payout and average nightly rate. They’re locked so a stray keystroke can’t break them.

4. Read the Monthly Summary

The summary groups everything by month: bookings, nights booked, occupancy, gross revenue, fees and net payout. The chart shows gross next to payout, so you can see at a glance which months the fees bit hardest.

Airbnb booking log spreadsheet with platform fee, net payout and alerts

Three numbers to check every month

Occupancy vs last month

A drop of ten points in a month you’d normally fill is your signal to look at pricing, photos or minimum stays before the next slow stretch arrives.

Your real fee per channel

Divide total fees by total gross for each booking site. If one site takes three or four times what another does, it may be worth nudging repeat guests to book direct next time.

Average nightly rate vs your listed rate

Discounts for longer stays, last-minute price drops and weekly rates all pull ADR down. Seeing the real number stops you budgeting on the price you hoped for.

Free template vs the full Staybright tracker

The free version is perfect for one listing and up to 30 bookings. Once you’re juggling turnovers, cleaners and bills, the full Staybright STR Host Tracker does the heavy lifting.

FeatureFree LiteFull Staybright
Properties1Up to 5
Booking rows30500
Platform fee and net payout per bookingYesYes, plus per-booking override
Monthly summaryYesMonthly P&L with goals
Dashboard with 12 KPIs and 4 chartsNoYes
Double-booking and same-day turnover alertsNoYes
Booking calendar and full-year heatmapNoYes
Turnover planner and cleaning logNoYes
Cleaner pay: earned, paid and owedNoYes
Expenses and net profitNoYes, 1,000 rows
Property and channel comparisonNoYes
Tax-time summary, supplies, maintenance, checklistNoYes

Short-term rental host dashboard with profit, occupancy, ADR and RevPAR

How to keep turnovers from slipping

Missed or rushed turnovers are where hosts lose five-star reviews. A few habits help:

  • Log the clean when you log the booking. Put the check-out date in your cleaning schedule the moment a reservation lands.
  • Flag same-day turnovers. When a guest leaves at 11 and the next arrives at 3, your cleaner needs to know days ahead, not that morning.
  • Track what you owe. Mark each clean Done when it happens and Paid when you settle up. End-of-month pay stops being a guessing game.
  • Use a checklist. The same list every time means the coffee gets restocked and the smoke alarm gets checked.

The full tracker does all four for you: its Turnovers tab lists your next 25 check-outs with the next arrival at the same place, highlights same-day turnovers in coral, and shows “Not scheduled” until a clean is logged. A printable checklist is included.

Airbnb turnover planner and cleaning log with cleaner pay

Frequently asked questions

Is the Airbnb spreadsheet template really free?

Yes. Enter your email above and the download starts. There’s no trial timer and nothing to cancel.

Does it work in Google Sheets?

Yes. Upload the .xlsx to Google Drive and open it with Google Sheets. It uses standard formulas only.

Does it connect to my Airbnb account?

No. You type or paste your bookings, which keeps your data in your own file.

Can I use it for VRBO and direct bookings?

Yes. Airbnb, VRBO, Booking.com and Direct are set up, each with its own fee percentage you can change.

Get your free template and grow from there

Start with the free Lite version to get your bookings and payouts in one place. When you want your real profit, a calendar that shows every booked night, and a turnover plan your cleaner can follow, step up to the full tracker.

Grab the free Staybright Lite tracker above ↑ (enter your email in the download box near the top of this page)

Staybright STR Host Tracker: 18 tabs, dashboard, calendar, turnovers, cleaner pay, expenses, tax summary and up to 5 properties. Excel and Google Sheets.

Get the full Airbnb host spreadsheet >

Scroll to Top