Report this item to Etsy

Long-Term Rental Ledger | Landlord Schedule E Tax Spreadsheet (Google Sheets Template)

Item highlights

  • Digital download
  • Digital file type(s): 1 PDF

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.

View more
Etsy's Purchase Protection

If something goes wrong with an order, we've got your back for all eligible purchases. View program terms

Price:$12.99

Loading
  • Etsy search, Pinterest, Google, a friend - whatever fits.

    0/100
  • Just yes or no - helps us welcome new customers.

    0/100
  • Tell us what you'd love a Ledger & Light tool for next.

    0/100

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

Title slide for the Long-Term Rental Ledger — “Expense Ledger” set over illustrated long-term rental objects on a desk. Expenses, mileage, and tax-ready reporting — with the categories you actually use.

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 type
    Digital download
  • Digital file type(s)
    1 PDF
Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

You may also like

Shoppers with similar taste loved these

Show more
Show more
Listed on Aug 2, 2026