Long-Term Rental Ledger + Reporting | Landlord 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, your property miles, and a finished per-property Schedule E report for your accountant — all in one 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 + 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 Long-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 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 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 Long-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:
• 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 who drive to showings, lease signings, and maintenance calls and want those property miles credited to the right rental
• Long-Term Rental owners who work with an accountant and want a formatted per-property Schedule E summary sent at tax time

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.