Report this item to Etsy

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

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:$12.99

Loading
  • 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 Ledger” 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.

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 gathers every one of those costs in one place, assigned to the property it belongs to. Open the linked Expense Form on your phone, fill it in when the money goes out, choose the property, and the entry lands in your sheet on its own — sorted by property and mapped to its Schedule E line, ready for tax season.

Built for the way short-term rentals actually spend: turnover cleaning and laundry, host and platform commissions, guest supplies and consumables, utilities that run whether or not a guest is in the house, repairs between stays, insurance, mortgage interest, and occupancy taxes and permits.

Every cost lands against a property so you can see what a full season of stays really costs to run at each address.

✓ WHAT YOU GET:
• Your Short-Term Rental Ledger for Google Sheets — a private copy link arrives with your instant Etsy download
• A setup instruction PDF, delivered the moment you check out
• A mobile-friendly Expense Form that opens in any browser — no app to install
• A short email tips sequence to walk you through setup

✓ KEY FEATURES:
• Schedule E expense categories built for short-term rental hosts — commissions and host fees, cleaning and maintenance, supplies, utilities, repairs, insurance, mortgage interest, other interest, and taxes and licenses — 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 your deductions for each property on its own
• A "Getting rent-ready" tag for pre-service make-ready costs, kept separate from your current-year deduction total so those costs stay clearly set aside for your accountant
• Sample entries across example properties that show a full year of organized short-term rental records at a glance
• Budget lines with planned vs. actual spending side by side, updated live
• Dashboard with a month-by-month view of your spending against your budget, and each property's spend beside its status
• Receipt photo upload you add to the Expense Form once from the setup guide — snap a photo and attach it when you have the receipt

✓ HOW IT WORKS:
1. Check out and download your instruction PDF from Etsy right away
2. Open your Short-Term Rental Ledger from the link inside, then Make a Copy into your own Drive
3. Add your properties, follow the guide, bookmark the Expense Form on your phone, and log costs as they happen

✓ 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 running one home or a handful who want each listing's Schedule E numbers standing on their own
• Vacation-rental owners who hand their accountant a clean per-property summary each spring

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