For short-term rental hosts
Bookings on two or three platforms, payouts minus fees, cleaners to schedule, bills for every property, and no clear answer to "am I actually making money?" This Microsoft Excel workbook puts a 1–10 listing short-term rental business in one file.
Today only: $17 with code FLASH24
What's inside
Log each reservation once and it works out nights, platform fee, payout and net revenue, and flags double-booked dates. The Pricing & Break-Even Calculator shows the nightly rate and nights you need to cover costs, and the Goal Planner turns a profit goal into nights and ADR targets.
Tap any preview to see it full size. Properties and bookings in the previews are example data.
Occupancy %, ADR, RevPAR, nights booked vs. available, gross booking revenue, platform fees, net rental revenue, taxes collected, expenses, net profit, tax set-aside, upcoming check-ins, next turnovers, results by month and by property.
An occupancy heat map (property × month), net revenue by property × month, platform mix and 2 charts.
Property, platform (Airbnb, Vrbo, Booking.com, Direct, Other), check-in / check-out, nights (calculated), guests, nightly rate, cleaning fee, platform fee %, taxes you collected, payout (calculated), status and cleaner. Blank rate / fee cells use your defaults. Overlapping stays at the same property are flagged.
Next 25 turnovers built from your bookings, with the next check-in, days until the next guest, cleaner and same-day flags. Cleaning fees charged vs. cleaning costs logged.
Cleaning, supplies, repairs, utilities, insurance, software, furnishings, mortgage interest, rent / lease and more, by property or shared; business miles at your own rate cells (check irs.gov for the current rate); category totals and a monthly profit summary with a tax set-aside % you choose.
Break-even nights and occupancy, break-even nightly rate at your target occupancy, the rate for a monthly profit goal, and an occupancy × nightly rate profit grid.
Profit goal to nights, occupancy, bookings and ADR needed, with actual-to-date, on-the-books and on-pace checks.
Good to know
Not tax, legal or accounting advice. Occupancy / lodging taxes and short-term rental rules vary by city, county and state, and platforms collect taxes for you in some places but not others. Check your local rules and check with a tax professional.
Not affiliated with or endorsed by Airbnb, Vrbo or Booking.com.
Pricing
The complete workbook, all 9 tabs.
$34 one-time
Today only: $17 with code FLASH24
FAQ
Microsoft Excel. It's built for Excel, with no macros and no add-ins.
It's built and tested for Microsoft Excel only. Google Sheets and Apple Numbers aren't confirmed, so we don't claim them.
No. It doesn't connect to or import from Airbnb, Vrbo or a channel manager: bookings are typed (or pasted) in.
No. Platform fee %s in the file are placeholder starting points, not current platform rates. Enter what your platforms actually charge. Mileage rate cells hold placeholder values. Check irs.gov for the current rate.
Room for 10 properties, 1,000 bookings and 600 expenses. Clearly labeled EXAMPLE rows (3 sample properties, about 200 bookings) show how it works; delete them or type over them.
No. It's a one-time purchase of $34. Pay once, no subscription.
Not tax, legal or accounting advice. Occupancy / lodging taxes and short-term rental rules vary by city, county and state, and platforms collect taxes for you in some places but not others. Check your local rules and check with a tax professional.
These are instant digital downloads, so all sales are final. If a file won't open or doesn't work as described, email [email protected] within 14 days and we'll fix it or give you a full refund.
Bookings, occupancy, turnovers, expenses and profit for up to 10 listings. $34, pay once.
Today only: $17 with code FLASH24
