---
title: "Landlord Rent & Expense Tracker Spreadsheet (Excel)"
description: "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…"
url: "https://builtbyestrada.ai/products/landlord-tracker/"
lang: "en"
---

# 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](mailto:hello@builtbyestrada.ai) within 30 days of purchase and we refund you in full.

Landlord-Tracker.zip SCREENSHOTS · full version

  [![Landlord Rent & Expense Tracker: the Rent ledger tab, with EXAMPLE data](https://builtbyestrada.ai/img/products/landlord-tracker/1-720.webp)](https://builtbyestrada.ai/img/products/landlord-tracker/1-1440.webp)

Rent ledger: tab with EXAMPLE data [See the whole tab](https://builtbyestrada.ai/img/products/landlord-tracker/1-1440.webp)

  [![Landlord Rent & Expense Tracker: the Expenses tab, with EXAMPLE data](https://builtbyestrada.ai/img/products/landlord-tracker/2-720.webp)](https://builtbyestrada.ai/img/products/landlord-tracker/2-1440.webp)

Expenses: tab with EXAMPLE data [See the whole tab](https://builtbyestrada.ai/img/products/landlord-tracker/2-1440.webp)

  [![Landlord Rent & Expense Tracker: the Year summary tab, with EXAMPLE data](https://builtbyestrada.ai/img/products/landlord-tracker/3-720.webp)](https://builtbyestrada.ai/img/products/landlord-tracker/3-1440.webp)

Year summary: tab with EXAMPLE data [See the whole tab](https://builtbyestrada.ai/img/products/landlord-tracker/3-1440.webp)

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

[Download the free version (.xlsx) ↓](https://builtbyestrada.ai/downloads/landlord-tracker-free.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

YOU THE SHEET

You type what a tenant paid and the date It shows Paid, Late or Partial and keeps the balance

You add a lease with its end date It flags it to renew 60 days before it ends

You pick a category for a bill It lands on the right Schedule E line for that property

You open Year summary at tax time Rents, 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) ↓](https://builtbyestrada.ai/downloads/landlord-tracker-free.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

-   [Rental property calculator →](https://builtbyestrada.ai/tools/rental-calculator/)
-   [Rental & BRRRR Analyzer →](https://builtbyestrada.ai/products/rental-analyzer/)

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