An apartment lease expiration report should help an owner see which units may need a renewal decision, which dates are approaching, and what information is still missing. It is a planning record. It is not a promise that a resident will renew or a substitute for the lease and the property's approved notice process.
Start with the executed lease, amendments, current ledger, and property record for each unit. Keep the lease as the authority for dates and terms. A summary can make the pipeline easier to review, but it should point back to the source documents when a date, balance, or obligation matters.
Build the expiration list from the lease record
For each unit, show the property and unit identifier, lease end date, current rent or approved charge structure, notice or decision date required by the governing documents, and the current renewal status. If the lease has an option, extension, or month-to-month provision, record where the source term appears. Do not fill an unknown date from a calendar estimate.
Separate a confirmed renewal, a pending conversation, a notice received, and an unresolved record. “In discussion” does not mean the unit is renewed. The owner should be able to tell which units need a next action and which ones have a documented decision.
Connect the date to the property plan
Review approaching expirations with current occupancy, open balance status, known maintenance or turn work, and leasing activity. These records answer different questions. A lease expiration does not establish a vacancy, and a unit that may become vacant is not the same as a unit that is ready to market. Keep the dates and statuses separate.
Coastline's apartment vacancy guide covers the separate occupancy measure. Its multifamily management guide connects leasing activity with property reporting and follow-through. Use those views together without turning a forecast into a fact.
Give the owner a short decision list
For each near-term expiration, state the current record, the next action, who owns it, and the date for the next check. The action may be to verify the lease term, confirm a resident response, review a documented notice, update the leasing plan, or reconcile a unit status. Legal questions about notices, rent changes, or protected rights belong with the appropriate qualified reviewer.
Bring the right sample to the owner meeting
Choose a small group of upcoming expirations and trace each one from the executed lease to the current pipeline status. Check whether the unit identifier, dates, current ledger status, and next action agree across the records. If one record disagrees, document the mismatch rather than changing a summary field without finding the source.
The sample can show whether the pipeline is useful for decisions. Are approaching dates visible early enough for the property's process? Can the owner tell which items need a leasing conversation and which need a source-record correction? The answers should come from the records reviewed. They do not establish a renewal rate or predict revenue.
Review the list again after a decision is recorded. Keep the prior status traceable so an owner can see what changed and when. That history makes the report more useful than a new spreadsheet that replaces last month's unanswered questions.
If lease expirations, renewal status, and vacancy planning are difficult to reconcile, Request a Property Management Performance Review.
Sources
Coastline Equity, Apartment Vacancy Rate: What Owners Should Track Before Revenue Slips; Coastline Equity, What to Look for in a Multifamily Property Management Company.