Long-Term Rental Ledger + Mileage | Landlord Schedule E Tax Spreadsheet (Google Sheets)
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.
Your rental costs and your property miles, logged from your phone into one per-property sheet.
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 + 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 showings, lease signings, inspections, and maintenance calls 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 Long-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 long-term rental owners, 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 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 each address carries its own year
• 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 Long-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:
• 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 drive to showings, lease signings, and maintenance calls and want those property miles credited to the right rental
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:$17.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 and your property miles, logged from your phone into one per-property sheet.
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 + 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 showings, lease signings, inspections, and maintenance calls 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 Long-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 long-term rental owners, 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 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 each address carries its own year
• 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 Long-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:
• 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 drive to showings, lease signings, and maintenance calls and want those property miles credited to the right rental
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
Online Retailer Expense Ledger | Schedule C Tax Spreadsheet (Google Sheets Template)
$12.99
-
Digital download
Child Care Expense Ledger | Schedule C Tax Spreadsheet (Google Sheets Template)
$12.99
-
Digital download
Photographer Expense & Mileage Ledger | Schedule C Tax Spreadsheet (Google Sheets)
$17.99
-
Digital download
Freelancer Expense & Mileage Ledger | Schedule C Tax Spreadsheet (Google Sheets)
$17.99
-
Digital download
Notary Expense & Mileage Ledger + Reporting | Schedule C Tax Report by Email (Google Sheets)
$24.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
Landlord Statement Template | Rental Payment Tracker | Tenant Billing Sheet | Excel & Google Sheet
Sale Price $5.83
Original Price $11.65
-
Digital download
Landlord Income & Expense Spreadsheet – CRA Tax Ready. An Excel file that helps Landlord to record and track rental revenue and expenses
$18.69
-
Digital download
Rental Property Tracker Excel, Rental Income and Expense Tracker, Landlord Spreadsheet, Property Management Tool
Sale Price $5.55
Original Price $15.85
-
Digital download
Rental Income Statement Excel Template: Airbnb, VRBO Landlord Tool
$16.50
-
Digital download
Excel Rental Property Income & Expense Tracker | Schedule E Summary | Mortgage Split + Escrow Tracking | Depreciation | Landlord Template
$19.99
-
Digital download
Rental Income Statement Excel Template: Airbnb, VRBO, Landlord Profit and Loss (Digital Download)
$14.50
-
Digital download
Landlord Rent Roll Spreadsheet | Rental Property Management Template for Google Sheets | Tenant Tracker & Lease Ledger | Real Estate Tool
$15.00
-
Digital download
10 Unit Rental Property Template
$18.00
-
Digital download
Rental Property Income and Expense Tracker Multi Unit Landlord Spreadsheet Rental Income Bookkeeping Rent Payment Ledger Tenant Real Estate
$18.71
-
Digital download
Blank Rental Ledger Sheet | Property Income Tracker | Excel & Google Sheet | Printable Landlord Finance Template | Rental Record Log
Sale Price $5.83
Original Price $11.65
-
Digital download
Multi-Property Rental Tracker Spreadsheet Airbnb Income & Expense Log Rental Budget Google Sheets Excel Landlord Property Management
$17.97
Shoppers with similar taste loved these
-
Digital download
Rental Property Income & Expense Tracker, Google Sheets Template (Digital Download)
Sale Price $23.80
Original Price $28.00
-
Digital download
Rental Property Bookkeeping Excel Spreadsheet | Multi-Property Income & Expense Tracker
$18.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 $20.19
Original Price $33.65
-
Digital download
Excel Vacation Property Spreadsheet, Small Business Spreadsheet, Airbnb Bookkeeping, Income Expense Tracker, Rental Property Management
$29.36
-
Digital download
WORD COUNT TRACKER | Spreadsheet for writers | Novel Word Count Spreadsheet | NaNoWriMo Tracker | Google Sheets Template
$11.11
-
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 Tracker Landlord Spreadsheet Multi Property Income and Expense Excel Google Sheets Rental Bookkeeping Rent Payment Tracker
Sale Price $8.97
Original Price $17.95
-
Digital download
Real Estate Business Spreadsheet Bundle: House Flip Airbnb Calculator Bookkeeping Password Tracker Excel & Google Sheets Digital Download
$34.97
-
Digital download
Rental Property & Airbnb Management Toolkit | Excel and Google Sheets | 12 Templates
$109.97
-
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