How to Track Tenant Leases and Deposits in a Spreadsheet

Rent rolls show balances; they do not show who to call, when the lease ends, or how much deposit is held. A free tenant tracker spreadsheet stores tenant, unit, lease start/end, deposit, contact, and status with expiry highlighting.

Tenant file columns that save midnight searches

1. Tenant and unit
2. Lease start and end
3. Monthly rent — should match rent roll
4. Deposit held — amount and bank account note
5. Phone and email
6. Emergency contact — optional but valuable
7. Status — active, notice given, vacant

Sort by lease end quarterly — renewals negotiated 90 days out beat vacancy gaps.

Sync with rent roll monthly

When rent changes on renewal, update both the tenant tracker and rent roll — mismatched rent amounts cause collection arguments you cannot defend.

Deposits are liabilities, not income

Track deposit balance separately from rent collected. At move-out, note deductions on the maintenance log if damage repairs apply — state rules govern timelines and itemization.

When tenant CRM software wins

Screening integration, e-sign leases, and portal messaging justify platforms at scale. Small landlords with stable tenants often keep a tenant sheet for years until turnover volume demands automation.

These templates are recordkeeping tools, not lease generators or legal advice. Use state-compliant lease forms and deposit rules.