Short-Term Rental Ledger | Airbnb Schedule E Tax Spreadsheet (Google Sheets Template)
Item highlights
If something goes wrong with an order, we've got your back for all eligible purchases. View program terms
Price:$12.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.
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 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
Long-Term Rental Ledger + Mileage | Landlord Schedule E Tax Spreadsheet (Google Sheets)
$17.99
-
Digital download
Event Planner Expense & Mileage Ledger | Schedule C Tax Spreadsheet (Google Sheets)
$17.99
-
Digital download
Reseller Expense & Mileage Ledger | Schedule C Tax Spreadsheet (Google Sheets)
$17.99
-
Digital download
Maker Expense & Mileage Ledger | Schedule C Tax Spreadsheet (Google Sheets)
$17.99
-
Digital download
Food Vendor Expense Ledger | Schedule C Tax Spreadsheet (Google Sheets Template)
$12.99
-
Digital download
Short-Term Rental Analysis Calculator Tracker | Rental Tracking Spreadsheet | Rental Management | Rental Bookkeeping | Google Sheets | Rent
Sale Price $9.00
Original Price $12.00
-
Digital download
Airbnb Short Term Rental All in One Excel Template Vacation Rental Performance Analysis Income Expenses Bookkeeping Profit & Loss Occupancy
Sale Price $11.00
Original Price $22.00
-
Digital download
Airbnb EasyROI Calculator - Short-Term Rental ROI Spreadsheet Excel Google Sheets
Sale Price $17.87
Original Price $29.78
-
Digital download
Airbnb Income and Expense Tracker | Deluxe Short-Term Rental Spreadsheet
Sale Price $10.98
Original Price $18.30
-
Digital download
Airbnb & Vrbo Short-Term Rental Property Accounting Template
$15.00
-
Digital download
PLR Airbnb Property Management Expenses, Airbnb Host Spreadsheet, Airbnb Bookkeeping, Short Term Rental Property, Airbnb Budget Spreadsheet
Sale Price $9.55
Original Price $12.73
-
Digital download
Airbnb Spreadsheet Vacation Rental Tracker Booking Calendar Income Expense Template Short-Term Rental Management Profit Loss Bookkeeping
Sale Price $9.99
Original Price $19.98
-
Digital download
Rental Income Statement Spreadsheet: Airbnb, Vrbo, Landlord P&L (Google Sheets Template)
$11.50
-
Digital download
Rental Property Management Google Sheets Airbnb Income and Expense Rental Tracker Bookkeeping Spreadsheet Vacation Rental Airbnb Template
Sale Price $2.75
Original Price $11.00
-
Digital download
Short-Term Rental Start Up Cost Calculator | Single Property Analysis | AIRBNB/VRBO Vacation Rental | Editable Google Sheets Template
$10.00
-
Digital download
Rental Property Income & Expenses Spreadsheet, Short Term Vacation Rental Properties Bookkeeping Tracking Spreadsheet, Property Management
$8.95
-
Digital download
Short-Term Rental Income Tracker | Single Property STR Spreadsheet | Easy Expense & Profit Management
$9.99
Shoppers with similar taste loved these
-
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 Tracker Landlord Spreadsheet Multi Property Income and Expense Excel Google Sheets Rental Bookkeeping Rent Payment Tracker
Sale Price $8.93
Original Price $17.87
-
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
Rental Property Income & Expense Tracker, Google Sheets Template (Digital Download)
Sale Price $21.00
Original Price $28.00
-
Digital download
WORD COUNT TRACKER | Spreadsheet for writers | Novel Word Count Spreadsheet | NaNoWriMo Tracker | Google Sheets Template
$11.11
-
Digital download
Rental Property & Airbnb Management Toolkit | Excel and Google Sheets | 12 Templates
Sale Price $27.49
Original Price $109.97
-
Digital download
Excel Vacation Property Spreadsheet, Small Business Spreadsheet, Airbnb Bookkeeping, Income Expense Tracker, Rental Property Management
$29.34
-
Digital download
Rental Property Bookkeeping Spreadsheet: 10-Year Summary (Google Sheet)
Sale Price $16.75
Original Price $33.50
-
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
$17.91
-
Digital download
Real Estate Business Spreadsheet Bundle: House Flip Airbnb Calculator Bookkeeping Password Tracker Excel & Google Sheets Digital Download
$34.97
-
Digital download
Rental Income and Expense Excel Tracker for Property Management Template for Real Estate Transaction Spreadsheet for Landlord Tenant Tracker
Sale Price $12.50
Original Price $25.00