Property · Short Let - Template 55
Airbnb Income & Expense Tracker
Know whether your short let is full enough, and priced right.
Instant download
Microsoft Excel◆Google Sheets◆.xlsx file
Most rental spreadsheets stop at money in and money out. This one also tracks the nights you had available, so it can show you real occupancy, your average nightly rate and RevPAR for every property, every month. Log a booking once and sixteen linked tabs do the rest, from the changeover cost per night to the mileage claim and the tax year summary. Built for Airbnb, Vrbo, Booking.com and direct bookings, for one property or up to twelve, in the same file year after year.
Buy on Etsy →
Secure checkout on Etsy · file delivered instantly · zero formulas to write
What's inside · 16 tabs
- Properties - your register of lets, with a per property performance table underneath
- Bookings - one row per stay - platform fees and net payout work themselves out
- Expenses - every cost, tagged to a property, a category and a tax year
- Turnovers - the changeover log, and what each clean really costs you per night sold
- Mileage - trips to your properties with the rate applied automatically
- Six dashboards - portfolio, monthly, annual, five year, comparison and custom, over any dates you choose
- Occupancy Planner - nights sold against nights available, month by month, with ADR and RevPAR
- Booking Calendar - twelve months of nights that colour themselves in from your bookings
- Tax Summary - income and costs by category, lined up with your own tax year
- Host Setup Guide - a 12 page printable guide, plus a blank copy of the workbook to start on
