What's inside
What a good lease abstract template contains
A lease abstract is the lease, minus the reading. One row of structured fields answers the questions a portfolio actually gets asked: who signed, when it ends, what the rent is, how it escalates, who can walk away and on what notice. A template gives those answers a standard home, so every lease in the portfolio answers them in the same place, in the same format.
The workbook's main sheet organizes 40 fields into eight families, with the header rows frozen and filtered. Full lease-system abstractions commonly run to 80 to 100 data fields per lease, per RSM US's lease abstraction planning guidance; the 40 here are the load-bearing core, sized to stay maintainable by hand:
| Field family | Fields | What it answers |
|---|---|---|
| Parties & Identification | Lease reference, site name, premises address, landlord, tenant, guarantor | Which agreement this is, and who is bound by it |
| Term & Dates | Execution, commencement, rent commencement, initial term, expiration, amendments | When the clock started, when it runs out, what changed along the way |
| Rent & Payment | Base rent, currency, payment frequency, security deposit, late payment terms | What is owed, in which currency, on what rhythm |
| Escalation | Type, rate or index, frequency, first escalation date, cap and floor | How the rent moves over the term |
| Renewal & Termination | Options, notice windows, renewal rent basis, early termination rights, fees | How long the income really lasts, and who can end it early |
| Rights & Restrictions | Permitted use, assignment and sublease, right of first refusal, exclusivity, access | What each side may do without asking the other |
| Obligations | Maintenance, utilities and taxes, insurance, restoration and removal | Who pays for what while the lease runs, and who cleans up after it |
| Legal | Governing law, notices, estoppel and SNDA, special provisions | Where disputes land, and how formal notice must travel |
Escalation gets a verbatim column on purpose. A clause such as "CPI + 1.5%" is an instruction, not a number, and abstracting it as this year's computed rent throws the instruction away. Record the clause exactly; run the math separately. The free lease escalation calculator models a clause against official index values, and the rent calculation page covers how extracted clauses become rent schedules at portfolio scale.
Renewal, termination, and assignment are the diligence families. When a portfolio changes hands, a buyer's counsel asks about them first: which leases renew automatically, which tenants can assign without consent, who holds a right of first refusal. With those provisions in columns, the answer is a filter, not a file hunt — the due diligence page covers that reading exercise at deal speed. Tower portfolios strain the escalation and rights families hardest; cell tower lease abstraction covers that industry's specifics.
Obligations and legal round out the abstract with the fields that surface late: restoration and removal duties are the classic end-of-term surprise, and notice addresses decide whether a termination letter was ever validly served.
Method
How to use the template
One row per lease
If a site carries more than one agreement — a ground lease plus tenant leases, say — give each its own row and group them with the lease reference column.
Amendments last
Abstract the signed original first, then read each amendment against it. A later amendment overrides the original wherever the two disagree, so the abstract records the current state, not the first one.
Verbatim, with references
Record values exactly as the document states them, currency and units included, and cite the page and clause for anything you may need to defend later: "EUR 1,250.00 (p. 4, cl. 3.2)".
N/A is an answer
N/A means the lease contains no such provision. Blank means nobody has looked yet. Auditors care about the difference, so keep it.
The workbook's second sheet carries the full ten-point version of this guidance, including the conventions that keep a shared file coherent: dates as YYYY-MM-DD so they sort and never flip day and month, renewal options as count x length ("5 x 3 yr"), and portfolio-specific columns added at the right edge rather than carved out of existing ones.
Download the template (.xlsx) — free, no email required.
Limits
What the template does not fix
A template fixes the format problem. It does not touch the reading problem. A careful abstract of a full lease and its amendments takes real hours per document — advisory firm RSM US estimates three to four hours to abstract each real estate lease, plus about an hour of quality review, with page count and complexity driving the total. The hours go into finding each of 40 values, checking whether an amendment moved it, and transcribing it without slipping a digit. The cost repeats for every lease in the stack, and it does not fall much with practice — the three hundredth lease reads at the same speed as the third.
Manual abstraction also drifts. Two careful readers summarize the same assignment clause two different ways, and the difference only surfaces when someone filters the column. And a finished workbook is a snapshot: correct on the day it was completed, aging from the first amendment after.
MYX Analyzer exists for exactly this gap — let the MYX Pro engine fill the template for you. Upload the documents; each column of a spreadsheet-style grid is a field defined by a plain-language prompt, and the engine does the reading: the same families this template covers, and well past them, with 500+ data fields extracted across 40+ languages. Every value lands with a confidence rating (HIGH / MEDIUM / LOW) and a reference to the page it came from, so your team verifies answers instead of re-reading files. Measured extraction quality is 94.7 % on internal evaluation sets; the workflow still assumes review, which is what the confidence flags are for.
Scale stops being a staffing question. Process hundreds of documents overnight with enterprise batch processing, then export to Excel with custom templates — including a layout like the one you just downloaded, so the deliverable your stakeholders expect stays the same while the typing disappears. The lease abstraction page walks the full workflow; plans and the 30-day free trial are on the pricing page.
FAQ
Is the lease abstract template really free?
Yes. The link on this page serves the Excel file directly: no email address, no form, no account. It is a goodwill template. Use it, adapt it to your portfolio, and share it inside your organization freely.
What is a lease abstract?
A lease abstract is a structured summary of a lease: the parties, dates, rent, escalation, renewal, termination, rights, obligations, and legal provisions pulled out of the full document into fields a reader can scan in a minute. The template gives those fields a standard home in Excel. The reading and transcribing is the part you still do by hand, or hand to software.
Can I add my own columns to the template?
Yes. Add portfolio-specific columns at the right edge under their own family band instead of repurposing existing ones; the header rows are frozen and filtered, so new columns inherit the same working layout. The workbook's second sheet carries ten guidance notes covering conventions such as date formats and the difference between N/A and blank.
Does the template work for telecom tower and ground leases?
Yes. The eight families are the classic abstract structure and apply to ground leases, tenant leases, and rooftop agreements alike. Tower portfolios tend to strain the escalation and rights families hardest, which is why those provisions get their own columns rather than one catch-all cell.
Keep the format, lose the typing
Start with the free template. When the reading itself becomes the bottleneck, watch the demo or upload a lease and see the grid fill in.
30-day free trial · Card required — first charge only when the trial ends · Cancel anytime