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

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 and your property miles, logged from your phone into one per-property 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 + Mileage keeps those costs and the miles you drive for your rentals together in one sheet, each assigned to a property. Log an expense or a trip from your phone and it lands sorted by property on its own — and the miles you drive for turnovers, guest check-ins, restock runs, and hardware-store trips become a running deduction at the IRS standard mileage rate, carried to Auto and travel (Line 6) on each property's Schedule E.

✓ WHAT YOU GET:
• Your Short-Term Rental Ledger + Mileage 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 and a Mileage Form, both 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 "Getting rent-ready" tag for pre-service make-ready costs, kept separate from your current-year deduction total for your accountant
• Mileage Log with the current IRS standard mileage rate applied on its own, carried to Auto and travel (Line 6)
• Mileage Form on your phone — odometer start, end, destination, purpose, and the property, in one submit
• Costs and miles in one sheet, organized by property, so every listing's season stands on its own
• Budget lines and a live Dashboard that total and organize every cost per property on their own

✓ HOW IT WORKS:
1. Check out and download your instruction PDF from Etsy right away
2. Open your Short-Term Rental Ledger + Mileage from the link inside, then Make a Copy into your own Drive
3. Add your properties, set up your Mileage Form, then log expenses and trips from your phone as you go

✓ 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
• Hosts who drive turnovers, restock runs, and guest check-ins between their listings and want those miles on the right address

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.