Free download · Word and Excel
A commercial lease abstract template that cites the lease.
A free lease abstract template for retail, office and light industrial leases: a Word form and a filled-in sample, every line citing its lease section. The Excel version works out the rent schedule, notice deadlines and critical dates.
No email, no sign-up, no macros. Word: one .docx, under 100 KB, a blank form and the sample. Excel: one .xlsx, under 100 KB, five sheets. Made for Word 2010 or later, Google Docs, Excel 2010 or later, Google Sheets and LibreOffice.
Sample lease abstract · Linden Street Bakery LLC
| Field | Entry | Lease |
|---|---|---|
| Premises | Suites 101 and 102 · 2,400 sq ft | §1.2–1.3 |
| Term | Mar 1, 2025 – Dec 31, 2028 | §3.1–3.2 |
| Base rent | $30.00 per sq ft per year · $6,000.00 a month | §4.1 |
| Escalation | +3% each lease year | §4.2 |
| Pro-rata share | 12.973% | §5.1 |
| Renewal notice deadline | Apr 5, 2028 | §20 |
All 10 checks pass(the Excel version)
Apr 5, 2028 is 270 days before Dec 31, 2028, counted by date (2028 is a leap year). The Excel version works it out from the expiration and the notice period; its checks say the entries are complete, typed as dates and numbers, and in order.
Lease abstract meaning
What a lease abstract is
A lease abstract is a short summary of the terms of a lease that drive money and dates (parties, premises, term, rent and how it rises, recoveries, deposit, options, insurance, repairs, use and assignment), each with the section of the lease it came from. Producing one is called lease abstraction, or abstracting a lease. It is what a property manager, owner, lender or buyer reads instead of the lease, so it is only as good as its references. It summarizes the lease; it does not replace it.
Where it sits in the job: the landlord’s lease administration checklist.
The form
The lease abstract form, section by section
| 1. Lease documents | Lease date; amendments, side letters and other documents, latest first |
|---|---|
| 2. Parties | Landlord and tenant legal names, trade name, guarantor, how and where notices go |
| 3. Premises | Property, suites, rentable area, the measurement standard named, the share’s denominator, the stated share and area ÷ denominator |
| 4. Term | Commencement, rent commencement, expiration, term in months, holdover rent |
| 5. Base rent | Rate and monthly rent, the escalation as worded, free rent, when rent is due, late charge, percentage rent, base rent over the term |
| 6. Recoveries (CAM, taxes, insurance) | Lease type, what the tenant shares, administrative fee and its base, base year, gross-up, cap, exclusions, estimate, statement due, audit right |
| 7. Security deposit | Cash, letter of credit and its expiry, return |
| 8. Options | Recorded in the Options table, after section 14 |
| 9. Tenant insurance | General liability each occurrence, additional insured, property, workers’ compensation, waiver of subrogation, certificates and their expiry |
| 10. Maintenance and repairs | Landlord’s and tenant’s share, HVAC service, alterations |
| 11. Use | Permitted, exclusive and prohibited uses |
| 12. Assignment and subletting | Consent, permitted transfers, recapture or profit sharing |
| 13. Other terms | Estoppel, subordination and non-disturbance, signage, default and cure, surrender |
| 14. Flagged for counsel | Ambiguous clauses, with their section |
| Rent schedule | Each lease year: from, to, monthly and annual rent, rent per sq ft, months, rent for the period |
| Options | Renewal, termination, expansion, first offer or first refusal, purchase: terms, notice required, notice deadline, renewal term |
| Critical dates | Each date in order, its amount, when to raise it, and its lease reference |
Every line has three cells: the field, the entry, and the lease reference. When the lease is silent, the entry says “Not addressed”, so the next reader knows it was checked.
Sample lease abstract
A lease abstract example, filled in
Sample · Linden Street Bakery LLC · Larkspur Retail Center
| Field | Entry | Lease reference |
|---|---|---|
| Landlord | Larkspur Retail Center LLC | Parties, p. 1 |
| Tenant | Linden Street Bakery LLC | Parties, p. 1 |
| Premises | Suites 101 and 102, 2,400 sq ft rentable | §1.2–1.3 |
| Permitted use | Retail bakery and café | §1.4 |
| Term | Mar 1, 2025 to Dec 31, 2028: 46 months; rent from Mar 1, 2025 | §3.1–3.2 |
| Base rent | $30.00 per sq ft per year: $6,000.00 a month | §4.1 |
| Escalation | +3% each lease year, on the previous year’s rent | §4.2 |
| Pro-rata share | 12.973% (2,400 ÷ 18,500) | §5.1 |
| Recoveries | CAM, taxes and insurance; administrative fee 10% of CAM, excluding taxes and insurance | §5.1–5.2 |
| Cap | Controllable CAM, 5% a year, non-cumulative | §5.4 |
| Security deposit | $10,000.00 cash | §6 |
| Insurance | General liability $2,000,000 each occurrence; landlord as additional insured | §12 |
| Renewal option | One 5-year term; notice at least 270 days before expiration: by Apr 5, 2028 | §20 |
| Holdover rent | 150% of the last monthly rent: $9,834.54 | §21 |
Critical dates · six of twelve
| Date | Event | Amount | Raise on |
|---|---|---|---|
| Mar 1, 2027 | Rent change, lease year 3 | $6,365.40 | Dec 31, 2026 |
| Jun 30, 2027 | Certificate of insurance on file expires | May 31, 2027 | |
| Mar 1, 2028 | Rent change, lease year 4 | $6,556.36 | Jan 1, 2028 |
| Apr 5, 2028 | Renewal option: notice deadline | Jan 6, 2028 | |
| Dec 31, 2028 | Expiration | Jul 4, 2028 | |
| Jan 1, 2029 | Holdover rent, if the tenant stays without a renewal | $9,834.54 |
A worked case on a fictional lease, not a real tenant’s. The core terms are the ones in the lease administration checklist above; the certificate is the one read in how to read an ACORD 25; the rent schedule is worked out in rent escalation clauses. The share’s denominator, the cap and the other clauses are the template’s own.
Before release, the Excel version was evaluated on this sample and on 30 variants (other dates, notice counted in months, fixed steps, a lease ending mid-month, values typed as text), and every entry of the Word sample was compared with it.
The Excel version
The lease abstract template in Excel, with the dates worked out
The rent schedule, from the clause
Rate, area and escalation in; each lease year’s monthly and annual rent and rent per square foot out, each increase applied to the previous rounded rent. Fixed steps and index rents are typed by year.
Notice deadlines, counted the lease’s way
In days or in months, from the expiration or any date: 270 days before Dec 31, 2028 is Apr 5, 2028; nine months before is Mar 31, 2028.
A critical dates calendar
Every date the abstract produces, in order, with when to raise it and its status on the date you choose.
Ten checks
Dates out of order, a share over 100%, a missing step, a number typed as text: each turns the check cell red.
The lease abstraction process
How to abstract a lease: the lease abstraction process, step by step
- 1Collect every document: the lease, each amendment, side letters, any commencement-date memo. A field cites the latest document that sets it.
- 2Read for money and dates first: legal names, premises and area, term, rent and its escalation, recoveries, deposit.
- 3Work each date out the way the lease counts it, and write the date: 270 days before Dec 31, 2028 is Apr 5, 2028.
- 4Cite every line, section and page. Where the lease is silent, write “Not addressed”.
- 5Flag, don’t interpret: an ambiguous clause goes to counsel with its section, and the abstract keeps the lease’s words.
- 6Before anyone relies on it, have a second person check each figure and date against the lease.
What it does not do · said plainly
Where a template stops being the right tool.
A template holds one lease as it stands on the day you fill it in.
- Read the lease for you: every entry is typed from the documents
- Decide what an ambiguous clause means: it has a line for what to ask counsel
- Compute index (CPI) increases: each year’s rent is typed once the index is published (percentages and fixed steps are worked out)
- Remind anyone: the Excel version lists each date and when to raise it, but a file sends no alerts
- Keep the lease’s history: an amendment means rewriting the abstract
- Check a tenant’s certificate against the requirement, or prorate a partial month
When you outgrow it
ChargeRecoveries keeps each lease as a record, not a document: its rent clause (steps, percentages, CPI with floors and caps), options with their notice dates, deposits and insurance, and works the rent out on any date.
Today brings option notice dates up 90 days ahead, lease ends 180, rent changes 60, and certificates and letters of credit 30 days before they expire. On Pro + AI, the assistant reads a lease PDF and proposes its dates, share and recovery clauses, each with the page and sentence it came from; a person confirms each one, and it does not read rent schedules or options yet.
The method behind it: the landlord’s lease administration checklist. Also free: the rent roll template and the CAM reconciliation template.
Questions
Lease abstract template: questions
What is a lease abstract?
A short summary of the lease terms that drive money and dates: parties, premises, term, rent and escalations, recoveries, deposit, options, insurance, repairs, use and assignment, each with the section it came from. It summarizes the lease; it does not replace it.
What is lease abstraction, and who does it?
Lease abstraction is the work of reading a lease and its amendments and recording the terms that drive money and dates in an abstract, each with its section. A lease administrator or property manager usually does it, and a second person checks each figure and date against the lease.
What should be included in a commercial lease abstract?
The parties’ legal names, premises, area and share, the term, base rent and its escalation, CAM, tax and insurance recoveries, the deposit, options with their notice deadlines, insurance requirements, the repair split, use, assignment, and a table of critical dates. Each line cites the lease.
Is there a free lease abstract template in Word?
Yes: this .docx, with a blank form and a filled sample, no email or sign-up. It is made for Word 2010 or later, Google Docs and LibreOffice; save it as a PDF from any of them. An Excel version works out the rent schedule and deadlines.
How do you abstract a lease?
Gather the lease and every amendment, then record the terms that drive money and dates, citing the section for each. Work each deadline out the way the lease counts it, flag ambiguous clauses for counsel, and have a second person check the figures.
How do you calculate an option notice deadline?
Count back from the date the lease names, its way. 270 days before Dec 31, 2028 is Apr 5, 2028, because 2028 is a leap year; nine calendar months before is Mar 31, 2028, as commonly read. Whether a weekend moves it is in the notice clause.
Is a lease abstract legally binding?
No. It is a summary for the people who administer the lease. The lease and its amendments govern where they differ, and an ambiguous clause is flagged for counsel, not settled in the abstract. This template is not legal advice.
Can I use it in Google Docs or Google Sheets?
Both files are built for it: the Word file uses plain tables, with no macros or form fields; the Excel version uses only functions Sheets has (SUMIFS, INDEX, MATCH, SMALL, EOMONTH, ROUND). Upload either to Drive and open it with Docs or Sheets.
Published by ChargeRecoveries · Version 2026-10 · Updated Oct 31, 2026 · The sample is a worked case on a fictional lease. An abstract summarizes the lease and is not legal advice; the lease and its amendments govern.