Long-Term Rental Ledger | Landlord Schedule E Tax Spreadsheet (Google Sheets Template)
Item highlights
Seller's description
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.
Rent arrives on the first of the month. The costs keep their own calendar: a management fee off each check, a plumber the week a faucet gives out, an insurance premium once a year, and a property tax bill that comes whether the unit is full or empty.
Your Long-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 long-term rentals actually spend: management fees and leasing costs, repair calls and make-ready work, hardware-store supplies, landlord-paid utilities, the annual insurance premium, mortgage interest, attorney and bookkeeper fees, and county property taxes.
Every cost lands against a property so a quiet month and the month a water heater gives out both land on the right address, and each property's year adds itself up.
✓ WHAT YOU GET:
• Your Long-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 long-term rental owners — advertising a vacancy, cleaning and maintenance, management fees, repairs, supplies, utilities, insurance, mortgage interest, and taxes and licenses — each mapped to its Schedule E line
• Management fees go to Line 11, repair calls to Line 14, make-ready and grounds work to Line 7 cleaning and maintenance, attorney and bookkeeper fees to Line 10, and county taxes to Line 16 — every entry carries its Schedule E line and its address from the moment you log it
• 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 long-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 Long-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:
• Landlords logging management fees, repair calls, insurance, and utilities against each rental
• Long-term rental owners with tenants on annual leases who want every address kept separate
• Owners of a single rental or a small portfolio who want a full year of Schedule E numbers ready
• Owners who want the year's rental numbers already sorted by address when they sit down with their accountant
I designed this ledger myself — the lean category set, the Schedule E mapping, the per-property summary, the property-status list, the formulas, and the mobile forms are all my own work, built around a year of leases, rent checks, and repair calls.
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.
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.
Rent arrives on the first of the month. The costs keep their own calendar: a management fee off each check, a plumber the week a faucet gives out, an insurance premium once a year, and a property tax bill that comes whether the unit is full or empty.
Your Long-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 long-term rentals actually spend: management fees and leasing costs, repair calls and make-ready work, hardware-store supplies, landlord-paid utilities, the annual insurance premium, mortgage interest, attorney and bookkeeper fees, and county property taxes.
Every cost lands against a property so a quiet month and the month a water heater gives out both land on the right address, and each property's year adds itself up.
✓ WHAT YOU GET:
• Your Long-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 long-term rental owners — advertising a vacancy, cleaning and maintenance, management fees, repairs, supplies, utilities, insurance, mortgage interest, and taxes and licenses — each mapped to its Schedule E line
• Management fees go to Line 11, repair calls to Line 14, make-ready and grounds work to Line 7 cleaning and maintenance, attorney and bookkeeper fees to Line 10, and county taxes to Line 16 — every entry carries its Schedule E line and its address from the moment you log it
• 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 long-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 Long-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:
• Landlords logging management fees, repair calls, insurance, and utilities against each rental
• Long-term rental owners with tenants on annual leases who want every address kept separate
• Owners of a single rental or a small portfolio who want a full year of Schedule E numbers ready
• Owners who want the year's rental numbers already sorted by address when they sit down with their accountant
I designed this ledger myself — the lean category set, the Schedule E mapping, the per-property summary, the property-status list, the formulas, and the mobile forms are all my own work, built around a year of leases, rent checks, and repair calls.
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
Rental Property Spreadsheet: Multi Property Income and Expense Template, Rental Bookkeeping, Tenant Tracker Rent Payment Excel Google Sheets
Sale Price $11.43
Original Price $17.58
-
Digital download
Multi Property Rental Tracker Spreadsheet Dark Mode Landlord Bookkeeping Google Sheets Rental Income Expense Tenant Ledger Rent Management
Sale Price $7.99
Original Price $15.98
-
Digital download
Excel Rental Property Income & Expense Tracker | Schedule E Summary | Mortgage Split + Escrow Tracking | Depreciation | Landlord Template
$19.99
-
Digital download
Landlord Pro Toolkit | Rental Property Bookkeeping & Spreadsheet Pack
$39.99
-
Digital download
Rental Property Spreadsheet for up to 10 Properties, Rental Income & Expense Spreadsheet, Property Management Tool, Landlord Spreadsheet
Sale Price $5.25
Original Price $15.00
-
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
Rental Income & Expense Spreadsheet for up to 10 Properties in POUNDS, Landlord Spreadsheet, Property Management Sheet, Rent Payment Ledger
Sale Price $5.25
Original Price $15.00
-
Digital download
Rental Property spreadsheets investment income expenses tax deductions landlord manage Use Microsoft Excel Google Sheets or Numbers for Mac
$14.67
-
Digital download
Rental Income & Expense Tracker | Landlords Rental Property Spreadsheet | Rental Ledger | Rental Property Spreadsheet Long-Term Short-Term
$19.99
-
Digital download
Rental Property Income & Expense Tracker Excel Template | Landlord Spreadsheet for 50 Properties
Sale Price $10.12
Original Price $13.50
-
Digital download
Multi Unit Rental Income Expense Tracker Landlord Property Management Spreadsheet Google Sheets Rental Bookkeeping Excel Tenant Ledger
Sale Price $8.59
Original Price $17.18
-
Digital download
All-in One Rental Property Management Bundle for up to 15 Properties in Pounds, Landlord Excel Spreadsheet, Rent Ledger
Sale Price $5.25
Original Price $15.00
Shoppers with similar taste loved these
-
Digital download
Landlord Property Management Templates Bundle (Editable in Word)
$11.00
-
Digital download
Monthly Budget Spreadsheet | Pink Vibes Palette | Simple Annual Budget | Personal Finances Excel | Easy Google Sheets | Financial Planner
Sale Price $1.00
Original Price $2.50
-
Digital download
Eviction Notice Template | Printable Notice to Vacate Template | Lease termination form | Editable Landlord Rental Contract | PDF download
Sale Price $2.34
Original Price $4.68
-
Digital download
Simple Receipt Template: Printable Cash/Rental Payment (Digital Download, US Letter)
Sale Price $3.96
Original Price $6.00
-
Digital download
Editable Receipt Template: Excel & Google Sheets (Printable PDF)
Sale Price $4.42
Original Price $5.90
-
Digital download
Rent Payment Tracker | Rental Payment Ledger | Monthly Rent Payment Log | Landlord Rental Spreadsheet | Landlord Rental Payment Log
$1.99
-
Digital download
Late Rent Notice Template: Landlord Letter (Microsoft Word & PDF) Digital Download
Sale Price $3.96
Original Price $6.00
-
Digital download
Airbnb Host Bundle Template, Editable Airbnb Signs, Welcome Book Template, Airbnb Cleaning Checklist, Inventory Checklist, VRBO Host Bundle
$15.00
-
Digital download
Rental Property Management Google Sheets Airbnb Income and Expense Rental Tracker Bookkeeping Spreadsheet Vacation Rental Airbnb Template
$5.72
-
Digital download
30 Day Notice to Vacate — Editable Landlord Tenant Template
Sale Price $2.36
Original Price $3.14
-
Digital download
Landlord Non-Renewal Notice to Tenant - Move-Out Instruction & Cleaning Checklist
Sale Price $2.36
Original Price $3.14
-
Digital download
Walkthrough Inspection, Tenant Move-In & Move-Out Checklist
Sale Price $2.36
Original Price $3.14