Rental Property Deal Analyzer
Cash flow, cap rate, cash-on-cash and DSCR estimates for any rental, five deals side by side, and a 5-year projection.
Sample data shown · click to enlarge
Dashboard: payout, expenses, net, occupancy, ADR and RevPAR.
For Airbnb, Vrbo and direct-booking hosts
Every booking, payout and expense, in one host-friendly spreadsheet.
Log stays from your platform reports, plus expenses and mileage. Occupancy, average daily rate, RevPAR and net by listing update for every month and the year.
$27one-time · 2026 edition · instant download
Tax year 2026 closes in 52 days: get every payout and expense in one place first.
Buy now: instant access
Excel + Google SheetsNo subscriptionSecure checkout
- Up to 10 listings and 1,000 bookings, with nights and payout calculated
- Occupancy, ADR and RevPAR by month and by listing
- 15 short-term-rental expense categories, from cleaning to software
- Both 2026 IRS mileage rates built in, and editable
What's inside
A tour, tab by tab
Screenshots show the included sample data. Click any screenshot to enlarge it.
Tab · Bookings
Bookings
Check-in, check-out, listing, platform, guest, gross rent, cleaning fee, other guest fees and platform/host fees. Nights and payout are calculated. Taxes the platform collects and remits stay out of your numbers.
Tab · Monthly Summary
Monthly Summary
Nights booked, nights available, occupancy, ADR, RevPAR, payout, expenses and net for each month, for one listing or all of them.
Tab · Annual Summary
Annual Summary
Year totals by listing and category, ready to share with a tax preparer, who will decide how they're reported.
Tab · Dashboard
Dashboard
Headline numbers, charts by month and by listing, and data checks that catch missing dates or listings.
Listings
Each listing's nickname, platform, location and details. The nickname feeds every Listing dropdown.
Expense Log and Mileage Log
15 expense categories built for hosts, and a trip log that applies the 2026 IRS rates (72.5¢ through June 30, 76¢ from July 1).
In your download
Everything arrives in under a minute
Short-Term Rental Bookkeeping Spreadsheet 2026 (Excel, with sample data)
A blank Excel copy, ready for your records
A one-click Google Sheets copy link
A Start Here tab with setup steps
Is it right for you?
Who it's for
A great fit for
- Hosts with 1-10 short-term or vacation-rental listings
- Co-hosts and owners who want platform payouts and costs in one file
Not built for
- Automatic imports from Airbnb or Vrbo (you copy figures from their reports)
- Occupancy or lodging tax filing
Why it's the smart buy
More built in than a free template. A fraction of a subscription.
Everything a small landlord needs for the 2026 tax year, without another monthly bill or a bank login.
| Our templatesRent & Tally | Subscription landlord apps | Free templates online | Shoebox + bank statements | |
|---|---|---|---|---|
| One-time price, no monthly fee | Yes | Monthly or yearly fee | Free | Free |
| Ready for tax year 2026 (mileage rates, $2,000 1099-NEC threshold) | Built in | Varies | Rarely updated | No |
| Schedule E-style expense categories | 13 categories | Varies | Sometimes | No |
| Contractor totals and likely 1099-NECs | Yes | Varies | Rarely | No |
| Works in Excel and Google Sheets | Both | App only | Usually one | No |
| No bank login needed | Never asked | Often asks to link | Yes | Yes |
| Built-in checks catch missing data | Yes | Varies | Rarely | No |
| You keep your file forever | Yes | Tied to your plan | Yes | Paper only |
| Sample data and a setup guide | Yes | Usually | Sometimes | No |
A general comparison of common alternatives, not of any specific product. Features of individual apps and templates vary.
Questions
Short-Term Rental Bookkeeping 2026 FAQ
Does it connect to Airbnb or Vrbo?
No. You copy each stay from your platform's earnings or payout report. That keeps the file simple and private.
Which month does a booking count in?
Each booking counts in the month of its check-in date, with all of its nights and money.
How are occupancy taxes handled?
Taxes a platform collects and remits are left out. If you collect taxes yourself, keep them out of these columns and track them separately.
Which tax form does this go on?
That depends on how your rental is used, so your tax preparer will decide. The spreadsheet gives them clean totals.
Do they work in Google Sheets as well as Excel?
Yes. Every template comes as Excel files (sample and blank) plus a link that puts your own copy in Google Drive in one click. Excel 2010 or later on Windows or Mac, and Excel for the web, all work. No macros or add-ins.
Is there a subscription?
No. Each template is a one-time purchase. The file is yours to keep and use.
How do I get my files?
Right after checkout you'll see your download and Google Sheets links, and we email them to you as well.
Pairs well with
Complete your setup
Move-In/Move-Out Inspection & Maintenance Log
A room-by-room inspection, a deposit-return worksheet, a repair log and a preventive maintenance schedule.
Tax year 2026 closes · Dec 31, 2026
52days
10hrs
13min
55sec
Short-Term Rental Bookkeeping 2026, ready in minutes
Bookings, payouts, expenses and mileage for up to 10 listings, with occupancy, ADR and RevPAR worked out.
- Instant download
- Excel + Google Sheets
- One-time price
- No subscription