Report this item to Etsy

Short-Term Rental Ledger + Reporting | Airbnb Schedule E Tax Spreadsheet (Google Sheets)

Item highlights

  • Digital download
  • Digital file type(s): 1 PDF
View more
Etsy's Purchase Protection

If something goes wrong with an order, we've got your back for all eligible purchases. View program terms

Price:$24.99

Loading
  • You get a Google Sheets copy link and a setup guide. Nothing ships by mail.

    0/10
  • Etsy search, Pinterest, Google, a friend - whatever fits.

    0/100
  • Just yes or no - helps us welcome new customers.

    0/100
  • Tell us what you'd love a Ledger & Light tool for next.

    0/100

You can only make an offer when buying a single item

Delivery

Instant download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Seller's description

Specifications

Title slide for the Short-Term Rental Ledger — “Expense & Mileage Ledger + Reporting” set over illustrated short-term rental objects on a desk. Expenses, mileage, and tax-ready reporting — with the categories you actually use.

Form to sheet: log it in-the-moment on a Google Form on your phone, and the entry lands organized in your Google Sheet. No app, no re-typing. That's how every Ledger & Light tool works.

Your rental costs, your property miles, and a finished per-property Schedule E report for your accountant — all in one sheet.

One guest checks out at ten and the next checks in at four. Everything that has to happen in those six hours costs money: the turnover clean, the restock of coffee and paper goods, the hardware-store run before the next arrival, and the host fee the platform already took off the booking — a short-term rental spends in bursts, every time the calendar turns over.

Your Short-Term Rental Ledger + Reporting keeps your costs and property miles in one sheet, organized by property, then hands your accountant a finished report. When tax season arrives, send your Schedule E Summary, transactions, and mileage log as a formatted PDF — no export steps, no screen captures.

✓ WHAT YOU GET:
• Your Short-Term Rental Ledger + Reporting for Google Sheets — a private copy link arrives with your instant Etsy download
• A setup instruction PDF, delivered the moment you check out
• An Expense Form, a Mileage Form, and full setup guidance, all opening in any browser — no app to install
• A short email tips sequence after you finish setup

✓ KEY FEATURES:
• Schedule E expense categories built for short-term rental hosts, each mapped to its Schedule E line
• Host and platform commissions land on Line 8, turnover cleaning on Line 7, the supplies you put out for guests on Line 15, insurance on Line 9, and mortgage interest on Line 12 — the right Schedule E line is chosen as you log, per address
• A per-property Schedule E Summary that totals expenses and property miles for each property on its own
• A Properties tab where each property carries its status — Getting rent-ready, Listed, Rented, Under repair, Vacant, or Sold — plus an annual depreciation figure your accountant gives you, rolled into Depreciation (Line 18); the ledger records the figure, it never computes depreciation for you
• A "Getting rent-ready" tag for pre-service make-ready costs, kept separate from your current-year deduction total so those capitalize-candidate costs travel to your accountant clearly set aside
• Email Schedule E Report that sends your per-property summary, transactions, and mileage log to your accountant as formatted PDFs
• Tab Export that saves any tab as a PDF or PNG to your cloud storage, auto-named by year

✓ HOW IT WORKS:
1. Check out and download your instruction PDF from Etsy right away
2. Open your Short-Term Rental Ledger + Reporting from the link inside, then Make a Copy into your own Drive
3. Add your properties and their status, log costs and trips through the year; at tax time, email the per-property Schedule E report to your accountant

✓ PERFECT FOR:
• Airbnb and VRBO hosts logging turnovers, host fees, guest supplies, and repairs against each listing
• Short-term rental owners who want a whole season of stays kept straight address by address
• Hosts who drive turnovers, restock runs, and guest check-ins between their listings and want those miles on the right address
• Short-Term Rental hosts who work with an accountant and want a formatted per-property Schedule E summary sent at tax time

I designed this ledger myself — the category set, the Schedule E mapping, the per-property summary, the rent-ready tag, the formulas, and the mobile forms are all my own work, built around the rhythm of guests arriving and leaving.

Your instruction PDF is available immediately after purchase — no waiting, no shipping.

These tools help you stay organized. I'm not a CPA and nothing here is tax advice — your accountant has the final word.

The spreadsheet system, formulas, and tax categories are my own original design; AI tools assisted with the decorative illustrations.

  • Item type
    Digital download
  • Digital file type(s)
    1 PDF
Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Aug 2, 2026