Short-Term Rental Ledger + Reporting | Airbnb Schedule E Tax Spreadsheet (Google Sheets)
Item highlights
If something goes wrong with an order, we've got your back for all eligible purchases. View program terms
Price:$24.99
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
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 typeDigital download
-
Digital file type(s)1 PDF
If something goes wrong with an order, we've got your back on all eligible purchases. View program terms
Meet your seller
More from this shop
-
Digital download
Online Retailer Expense & Mileage Ledger + Reporting | Schedule C Tax Report by Email (Google Sheets)
$24.99
-
Digital download
Child Care Expense Ledger | Schedule C Tax Spreadsheet (Google Sheets Template)
$12.99
-
Digital download
Food Vendor Expense Ledger | Schedule C Tax Spreadsheet (Google Sheets Template)
$12.99
-
Digital download
Event Planner Expense & Mileage Ledger + Reporting | Schedule C Tax Report by Email (Google Sheets)
$24.99
-
Digital download
Child Care Expense & Mileage Ledger | Schedule C Tax Spreadsheet (Google Sheets)
$17.99
-
Digital download
Online Retailer Expense & Mileage Ledger | Schedule C Tax Spreadsheet (Google Sheets)
$17.99
-
Digital download
Airbnb Short Term Rental All in One Excel Template Vacation Rental Performance Analysis Income Expenses Bookkeeping Profit & Loss Occupancy
$22.04
-
Digital download
Airbnb Bookkeeping Spreadsheet, Vacation Rental Income & Expense Tracker (Digital Download)
Sale Price $21.00
Original Price $28.00
-
Digital download
Short-Term Rental Income & Expense Estimator | Single Property Analysis | AIRBNB/VRBO Vacation Rental Data | Editable Google Sheets Template
$20.00
-
Digital download
Airbnb Income and Expense Spreadsheet | Bookkeeping | VRBO | Income Tracker | Property Management | Rental Property Tracker | Airbnb Google
$20.00
-
Digital download
Airbnb Bookkeeping Spreadsheet, Income Expense Tracker (Google Sheets Digital Download)
Sale Price $21.00
Original Price $28.00
-
Digital download
Airbnb Expense Tracker, Vacation Rental Spreadsheet (Google Sheets)
Sale Price $21.00
Original Price $28.00
-
Digital download
Airbnb Management Tool | VRBO Income Tracker | Property Management Finance Spreadsheet | Rental Property Tracker | Short Rental Spreadsheet
$20.00
-
Digital download
Short-Term Rental ROI Formulas | Single Property Analysis Estimator | AIRBNB/VRBO Vacation Rental Data | Editable Google Sheets Template
$20.00
-
Digital download
Airbnb Startup Budget Excel Spreadsheet to Help Designers and Hosts Calculate Costs to Furnish, Decorate & Stock a Short Term Rental
$38.96
-
Digital download
Airbnb Startup Budget Excel Spreadsheet to Help Designers and Hosts Calculate Costs to Furnish, Decorate & Stock a Short Term Rental
$38.96
-
Digital download
Airbnb Welcome Guide and Template Bundle Income and Expense Spreadsheet Airbnb Host Template Rental Airbnb Bundle Profit and Loss
$44.88
-
Digital download
The Rental Property Analyzer Tool for Tracking Short-Term Rental Income and Expenses on Google Sheets & Excel, ADR, RevPAR, and Occupancy
$24.99
Shoppers with similar taste loved these
-
Digital download
Rental Property Tracker Landlord Spreadsheet simple Property Income and Expense Excel Google Sheets Rental Bookkeeping Rent Payment Tracker
Sale Price $5.50
Original Price $11.00
-
Digital download
WORD COUNT TRACKER | Spreadsheet for writers | Novel Word Count Spreadsheet | NaNoWriMo Tracker | Google Sheets Template
$11.12
-
Digital download
Rental Property Template Landlord Spreadsheet Income and Expense Tracker Rental Bookkeeping Excel Google Sheets Real Estate Management
Sale Price $24.96
Original Price $35.66
-
Digital download
Rental Property Bookkeeping Excel Spreadsheet | Multi-Property Income & Expense Tracker
$18.03
-
Digital download
Real Estate Business Spreadsheet Bundle: House Flip Airbnb Calculator Bookkeeping Password Tracker Excel & Google Sheets Digital Download
$34.97
-
Digital download
Client Tracker, CRM Dashboard, Google Sheets, Small Business Template, Lead Tracker, Customer Seller Spreadsheet
Sale Price $13.91
Original Price $23.19
-
Digital download
Rental Property Tracker Landlord Spreadsheet Multi Property Income and Expense Excel Google Sheets Rental Bookkeeping Rent Payment Tracker
Sale Price $8.98
Original Price $17.95
-
Digital download
Rental Property & Airbnb Management Toolkit | Excel and Google Sheets | 12 Templates
$109.97
-
Digital download
Rental Property Income & Expense Tracker, Google Sheets Template (Digital Download)
Sale Price $21.00
Original Price $28.00
-
Digital download
Rental Income and Expense Excel Tracker for Property Management Template for Real Estate Transaction Spreadsheet for Landlord Tenant Tracker
$25.00
-
Digital download
Rental Property Bookkeeping Google Sheets Landlord Spreadsheet Multi Property Income and Expense Tracker Excel Tenant Tracker Rent Payment
Sale Price $8.59
Original Price $17.18
-
Digital download
Rental Property Bookkeeping Spreadsheet: 10-Year Summary (Google Sheet)
Sale Price $16.83
Original Price $33.66