Edit the highlighted input cells; calculated results update automatically.
What's inside
- Twenty-nine booking rows for Airbnb, VRBO, Booking.com, and direct reservations
- Check-in, check-out, and automatic nights calculations
- Gross booking, cleaning fee, platform fee, taxes collected, and host payout tracking
- Occupancy, average daily rate, and RevPAR summary
- Separate expense register and net short-term rental income
Best for: Airbnb hosts · Vacation rental owners · Short-term rental managers
Use in Google Sheets
This download is an XLSX workbook. Import it into your own Google Sheet to use it there.
- 1. Download the file, then opensheets.new.
- 2. In Google Sheets, choose File > Import > Upload.
- 3. Select Replace spreadsheet, then edit the yellow input cells.
Made for practical spreadsheet work by the Digital Store team. Formulas and example values are checked against the downloadable workbook; updated October 7, 2026. Use the file as a planning aid and verify decisions with your own records or professional advisor where appropriate.
Worked example
Six-booking sample included in the workbook
Inputs
- Bookings
- 6
- Booked nights
- 31 of 365 available nights
- Gross bookings
- $8,220
- Annual expenses
- $5,420
Outputs
- Occupancy
- 8.5%
- Average daily rate
- $265.16
- RevPAR
- $22.52
- Net short-term rental income
- $2,070
Platform fees, taxes, payouts, and expense rules vary by marketplace and jurisdiction. Enter the amounts that apply to your listing.
Related free templates
View Rental Property Accounting
Customer feedback
No reviews yet. Try the file and be the first to share how it worked for you.
Write a review
Download this file first to unlock review submission.
FAQ
Is the sample free?
Yes. The base workbook or pack shown on this page can be downloaded without payment, an account, a credit card, or an email address.
What software do I need?
The product is supplied as an editable spreadsheet or pack designed for Microsoft Excel and Google Sheets.
Can I edit it?
Yes. Inputs, labels, categories, and sample records can be changed in your spreadsheet app. Formulas are intended to remain intact when you replace the example values.
What does the Airbnb Spreadsheet Template help me do?
Track short-term rental bookings, nights, occupancy, platform fees, host payouts, expenses, and net income. It includes twenty-nine booking rows for airbnb, vrbo, booking.com, and direct reservations.
Is this a subscription?
No. The current download is free and does not create a recurring subscription, account, or payment obligation.