Rental Property Spreadsheet, Landlord Rent Tracker & Schedule E, Rent Roll, Late Fees, Security Deposits | Excel Google Sheets Template

Seller's description

Know who owes you rent, what each property really made, and what goes on Schedule E, without retyping anything at tax time. This TeamTimeTools workbook is for small landlords with 1 to 20 properties. It works out late fees and deposits for you, sorts every bill and repair to its Schedule E line, and splits mortgage payments into interest and principal. Works in Excel and Google Sheets.

WHAT'S INCLUDED
1. Rental Property & Landlord workbook (Excel + Google Sheets), 11 tabs:
- Start Here: setup steps in plain English.
- Setup: tax year, grace period, late fee (flat $ or % of rent), and 22 expense categories already matched to Schedule E lines (room for 40).
- Properties (20): address, type, units, rental and personal days, depreciation, and each property's income, expenses and net.
- Rent Roll (150 leases): rent charged so far, late months, late fees, payments, balance owed, deposit held, days to lease end, rent increases, and alerts ("Owes $1,200 (2 late months)", "Lease ends in 30 days").
- Rent & Income (1,500 rows): rent payments, extra charges, deposits received, returned or kept, waived late fees, other income.
- Expenses (1,500 rows): by property, or "All properties" split by number of units.
- Maintenance (500 jobs): from reported to done to paid, with days open. Paid repairs flow to Schedule E; capital improvements stay off it.
- Mortgages (20 loans): interest vs principal for this year, or your Form 1098 interest.
- Schedule E: lines 3 to 21 for every property, plus principal paid, capital improvements, deposits held and rent owed for your records.
- Dashboard: income, expenses, net, cash flow, occupancy, monthly totals, who owes you, leases ending soon, open repairs.
- Tenant Ledger: pick a tenant and print their statement: monthly rent, late months and fees, every payment, and their deposit.
2. Start Here PDF with your Google copy link.

WHY IT'S DIFFERENT
- Late fees done for you: grace period, flat or % fee, a different fee for any lease, and one row to waive a month.
- Security deposits tracked separately, so they never inflate your income (a kept deposit counts, as the IRS says).
- Mortgage interest split from principal, with a check that warns if you also typed the interest on Expenses.
- Every list has a Check column that says exactly what's wrong (a typo in a property name, a date from last year), and the row stays out of the totals until it's fixed.
- Runs in Excel 2010 or newer, Google Sheets and LibreOffice. No Excel 365-only formulas, no macros, nothing locked.

TESTED
18 automated tests check every calculation against an independent model (28,515 cells), including hand-worked late fees, mortgage interest checked month by month, bad input, and a full file of 20 properties and 150 leases. Google Sheets matched the Excel/LibreOffice values cell by cell (11,131 cells, 0 differences).

HOW TO GET IT
1. After you buy, go to your Etsy account > Purchases and download the zip. Etsy also emails you a link.
2. Open Rental-START-HERE.pdf. Click the link and choose "Make a copy" for Google, or open the .xlsx in Excel.
3. Look at the sample, clear it, and add your properties and leases.

GOOD TO KNOW, PLEASE READ
- Record-keeping tool, not tax or legal advice. Your tax preparer has the final word. Check your state's rules on late fees and deposits.
- Cash basis, one tax year per file. For next year, make a fresh copy and carry over balances and deposits (Start Here shows how).
- Depreciation is typed in per property; the workbook doesn't calculate it. No charts and no bank connection: you type payments and bills.
- US Schedule E lines and dollars.
- Compatible with Google Sheets (free Google account), Excel 2010 or newer on Windows or Mac, and LibreOffice. Not designed for Apple Numbers.
- This is a digital download. Nothing physical will be shipped. Because it's a digital file, returns aren't accepted. If something isn't working, send me a message and I'll help.
- For your own use. Please don't resell or share the files or links.

HOW THIS WAS MADE
I designed this workbook with help from AI tools, which assisted with the formulas, layout and sample data. I chose the features after comparing the landlord spreadsheets already available and reading what landlords say goes wrong with them (missed late rent, deposits mixed into income, formulas that break). I tested every calculation against an independent check (18 tests) before listing.