Most rental spreadsheets start as one tab with an address in column A and grow sideways until nobody can find anything. Twenty columns in, the rent is in column N, the deposit is in a comment on cell R4, and the water heater’s install date lives in a text message.
A fancier spreadsheet will not fix that. What fixes it is the right tabs, one row per thing on each, and a short list of columns you actually fill in.
The tabs
Each tab holds one kind of thing, and a row is one of that thing.
- Properties: one row per building.
- Units: one row per door.
- Leases: one row per lease, with the tenants on it.
- Rent: one tenant ledger per tenancy, or one long ledger with a lease column.
- Expenses: one row per receipt.
- Deposits: one row per deposit held.
Six tabs sounds like a lot for a duplex. It is less work than the single-tab version, because nothing is typed twice. The address lives on Properties, and everything else points at the property’s name.
Properties
name, street address, city, state, ZIP, year built, purchase date, purchase price, HOA (yes or no), insurance carrier, policy renewal date.
Year built earns its place. Housing built before 1978 is target housing under the federal lead disclosure law (42 U.S.C. § 4852d), so a lease for those units generally needs the lead paint disclosure. Purchase date and price start the depreciation record. IRS Publication 527 is explicit that you need accurate records of what you spend on improvements, because those costs matter when you depreciate and when you sell, and the IRS says to keep records relating to a property until the period of limitations expires for the year you dispose of it.
Units
property name, unit label, bedrooms, bathrooms, square feet, pets allowed, parking, utilities the owner pays, appliance list with install years, current asking rent.
Use the unit label exactly as the lease writes it. If the lease says “Unit B,” the sheet says B, not “upstairs.” Appliance install years are the column people skip and later wish they had, the first time a 14-year-old water heater fails on a Sunday.
Leases
property name, unit label, tenant names, tenant phone and email, lease start, lease end (blank for month-to-month), monthly rent, rent due day, late fee terms as written in the lease, deposit amount, renewal or notice dates.
One row per lease, not per tenant. A renewal is a new row with new dates and rent, and the old row stays. That history is how you answer “what was the rent in 2024” without digging through email. A rent roll is this tab filtered to current leases, and rent roll explained covers how a lender reads one.
Rent
date, lease, description, charge, payment, balance, method, reference.
This is a tenant ledger, and it is the tab that settles arguments. Every charge and every payment is its own line with its own date. The free tenant ledger template has these columns and a sample.
Expenses
date, property, unit (if it applies), vendor, description, amount, category, repair or improvement, receipt link.
Pick categories that match the lines on Schedule E, so tax time is a sort and a sum, not a weekend. How to organize rental property expenses lists the lines. The repair or improvement column matters for the same Publication 527 reason as the purchase price: an improvement is depreciated, not deducted in one year, and mixing the two is a common way a spreadsheet hands your tax preparer a cleanup job.
Deposits
lease, amount received, date received, where it is held, interest owed (if your city requires it), move-out date, return deadline, amount returned, date returned.
A deposit is not rent and should never be mixed into the rent tab. Keeping it separate also puts the return deadline in a column you can sort.
Formatting habits that keep it usable
- Dates as YYYY-MM-DD. They sort correctly and nobody wonders whether 03/04 is March or April.
- No merged cells, no blank spacer rows. Both break sorting and filtering.
- One value per cell. Two tenants on a lease can share a cell. A phone number and an email cannot.
- Yes or no, not checkmarks or colors. A color does not survive a CSV export.
- Names that match across tabs. “Maple Duplex” on Properties and “12 Maple” on Units is two different buildings to a formula.
The free rental property spreadsheet template is the Properties and Units tabs in this format, with sample rows for a duplex, a fourplex, and a condo.
When to move it into software
A spreadsheet is a fine system as long as one person keeps it and nothing in it has to happen on a date. The signs that you have outgrown it are usually not about unit count:
- Two people edit it. You and a partner, or you and a part-time helper, and the versions start to drift.
- Things have to happen on time. Lease renewals, notice deadlines, deposit return dates. A spreadsheet stores the date. It does not remind you.
- You retype the same facts. The tenant’s name and rent go into the lease, the ledger, the receipt, and the notice by hand, four chances for a typo.
- Tenants need to see their own balance. A spreadsheet you email around is not a portal.
- You cannot answer “is everyone paid?” in under a minute.
If two of those sound familiar, the move is smaller than it looks. Moving your rentals from a spreadsheet to software walks through the order. In LeaseRooster, import takes properties, units, tenants, and leases from CSV or Excel, with a preview of every row before anything is created. Payment history and vendors do not import, so keep the old rent and expense tabs as your record of the months before you switched.
This is general information, not legal or tax advice. Confirm current requirements with an attorney or a tax professional before you act.