BuiltByEstradaBook a call

Landlord Rent & Expense Tracker

Construction and Housing line

A spreadsheet for landlords with 1 to 10 doors. Type what each tenant pays and every bill you pay; it shows who's late and what they owe, sorts your expenses into the IRS Schedule E lines with a deductible column, and adds up the year for each property. A clean record to hand to your tax preparer.

Google Sheets and Excel file

Fare

$19

launch price

Secure checkout by Stripe, which adds sales tax where it applies. You download the file as soon as you pay.

Not what you needed? Write to us within 30 days of purchase and we refund you in full.

Landlord-Tracker.zipSCREENSHOTS · full version
Landlord Rent & Expense Tracker: the Rent ledger tab, with EXAMPLE data
Rent ledger: tab with EXAMPLE data See the whole tab
Landlord Rent & Expense Tracker: the Expenses tab, with EXAMPLE data
Expenses: tab with EXAMPLE data See the whole tab
Landlord Rent & Expense Tracker: the Year summary tab, with EXAMPLE data
Year summary: tab with EXAMPLE data See the whole tab

Screenshots of the full version, taken from the real file. Every number in them is an EXAMPLE.

Download the free version (.xlsx) ↓

Free file: one property with up to 4 units, rent ledger, expenses and a year summary. Leases, mileage, repairs and up to 10 properties are in the full version only. See what each one has

What you do, what the sheet does

YOUTHE SHEET
You type what a tenant paid and the dateIt shows Paid, Late or Partial and keeps the balance
You add a lease with its end dateIt flags it to renew 60 days before it ends
You pick a category for a billIt lands on the right Schedule E line for that property
You open Year summary at tax timeRents, expenses, income or loss and cash on cash are already added up

What the full version has

  • Properties tab: up to 10 properties and 30 units, with your rent due day and grace days
  • Tenants & leases tab: rent, deposit and lease dates, with Renew soon and Expired flags
  • Rent ledger tab: 12 months per unit with rent due, late fee, paid, days late and balance
  • Expenses tab: Schedule E categories, deductible yes or no, receipt links
  • Mileage log tab: trips at the standard mileage rate (optional)
  • Year summary tab: rents and expenses by Schedule E line per property, income or loss, cash on cash
  • Repairs & turnover tab: open repairs, make ready days, a reminder to log the bill

Who it is for

Landlords with 1 to 10 doors who track rent and bills by hand and want a clean record of the year for their tax preparer.

The tenants, rents and bills already in the file say EXAMPLE. Delete them and add your own; they are not real people or places.

Free version and full version

The free file covers one property with up to 4 units, a 12-month rent ledger, expenses by Schedule E category and a simple year summary.

FREE FILE (.XLSX)

  • 5 tabs: Start here, Property, Rent ledger, Expenses, Year summary
  • One property, up to 4 units
  • 12-month rent ledger with balance and who's late
  • Up to 60 bills, each on its Schedule E line
Download the free version (.xlsx) ↓

FULL VERSION · $19

  • 8 tabs, Start here included
  • Up to 10 properties and 30 units
  • Tenants & leases with Renew soon and Expired flags, late fees on the ledger
  • Up to 300 bills with deductible yes or no and receipt links
  • Mileage log, repairs & turnover, cash on cash per property
Buy the full version →

Transfers

Made by BuiltByEstrada in McAllen, Texas. In English and Spanish.