Rent Ledger and Expense Tracker | Rental Income Spreadsheet for Landlords

Rent Ledger and Expense Tracker — a state-neutral rental income and expense spreadsheet for landlords. Instant digital download: an Excel workbook that also opens in free Google Sheets. Record rent, deposits, and expenses. This is not tax advice, not a Schedule E, and not a tax return.

DISCLAIMER — PLEASE READ
The seller is not a law firm and these materials were not prepared by attorneys. This product is a set of blank templates and general information for organizational use only. It is not legal advice, is not a substitute for advice from a licensed attorney, and does not create an attorney-client relationship. Laws, court decisions, and local practice vary by state, city, and county, and can change. You are responsible for confirming that any document you use complies with current federal, state, and local law and with your rental agreement. No outcome is guaranteed.

This product is not tax advice, not a Schedule E, and not a substitute for advice from a tax professional. Green cells are formula helpers only; they are not a legal or tax determination. Expense category names are inspired by common rental-expense groups discussed in IRS Publication 527. Using a category does not mean an amount is deductible. Official sources: https://www.irs.gov/publications/p527 and https://www.irs.gov/businesses/small-businesses-self-employed/tips-on-rental-real-estate-income-deductions-and-recordkeeping

WHAT YOU GET (instant digital download)
• Rent_Ledger_and_Expense_Tracker.xlsx — seven sheets: START HERE, Properties, Rent Ledger, Deposit Log, Expenses, Monthly Summary, Annual Summary, and a Receipt Log. Yellow cells are inputs. Green cells are formulas.
• How_To_Rent_Ledger_and_Expense_Tracker.pdf
• START_HERE.txt
• A filled SAMPLE workbook with clearly fake data and maroon SAMPLE rows
• How_To_Open_In_Google.pdf — a one-page card for free Google Sheets
• Instant digital download. Nothing ships. Edit in Excel, LibreOffice, or free Google Sheets. No Canva Pro required.

WHO IT IS FOR
Landlords and small property managers in any U.S. state who want a blank organizer for rent, deposits, and expenses. It is not written for a particular state. (This shop also has a Florida-titled rent ledger that includes a Florida interest helper; this listing is the all-state version.)

HOW IT WORKS
1. Read START HERE inside the workbook and the how-to PDF.
2. Enter each unit on Properties, using a short Property ID you will reuse.
3. Log rent periods and payments on Rent Ledger. Log deposits on Deposit Log. Log costs on Expenses.
4. Type a year on Monthly Summary if you want an optional overview. Annual Summary uses the same year.
5. Use the blank workbook, not the SAMPLE file, for your own records. Do not store Social Security or bank-account numbers in the file.

WHAT THIS IS NOT
It does not decide whether rent is late, whether a late fee is enforceable, whether a deposit must earn interest, how days are counted, what notice you must send, or whether any amount is taxable or deductible. It is not a three-day notice, not a lease, not a security-deposit return letter, not a Schedule E, and not a tax return.

Support covers file access only, such as a file that will not open. Questions about a legal or tax situation should go to a licensed attorney or a tax professional.
Personal use for properties you own or manage. Do not resell, share, or republish these files. Do not put Social Security numbers, full bank-account numbers, or government-ID numbers in these files.
Instant digital download — nothing ships. Refunds if a file will not open; other refunds follow Etsy's digital-item policy. Content reviewed November 12, 2026.
These templates were prepared with the help of software tools. They were reviewed before listing. They are still blank templates only, not legal or tax advice.