Commercial Property Register Template for Excel

What a commercial property register is

A commercial property register is a centralized record of every property a company owns or leases — its ownership, leases, encumbrances, financing, insurance, taxes, permits, and inspections — kept current in one place, so a lease option, a mortgage maturity, or a permit renewal never depends on which folder someone happens to open first.

A lease option window closes, and no one remembers which lease PDF buried the notice date. A refinancing lender’s diligence team asks for every encumbrance and covenant on a property, and the answer sits across eight folders. This commercial property register template for Excel keeps that record in one place before either moment arrives.

This is a record of a corporate property portfolio, not an income or investment model. It holds no cash-flow projections. A register proves what a company holds and owes against it, not what a property earns.

What’s inside the Excel workbook

This real estate portfolio spreadsheet template ships as one Excel workbook, 15 sheets deep. A Start Here tab leads, followed by 14 data sheets covering properties, ownership, leases, encumbrances, financing, insurance, taxes, permits, and inspections. Together they hold 169 fields behind 27 pre-built dropdown lists, and the workbook opens in Google Sheets as well as Excel.

Properties and ownership

Properties — 16 fields — is the master list every other sheet keys back to. It holds address, county, parcel number, legal description, and property type — Office, Retail, Industrial, Multifamily, Mixed-Use, Hospitality, Warehouse, Medical, Self-Storage, Land, and more. Occupancy status, square footage, lot size, and year built round out the row.

Property Owners and Property Investors sit alongside it, each on its own sheet. Property Owners records the title holder for a property, while Property Investors records an equity stake in a property held for investment. A property can carry a title holder without an investor, or both, without one sheet crowding the other.

Leases and encumbrances

Leases, Lease Parties, and Lease Amendments together form the property lease and encumbrance tracker at the core of this workbook. Leases holds 19 fields, starting with our role, lease type, and premises. Lease type covers Gross, Net, Modified Gross, Triple Net NNN, Ground Lease, Sublease, and Percentage structures.

Rentable square feet, term, base rent, security deposit, escalation type, option type, auto-renewal, renewal term, and CAM estimate round out the row. Lease Amendments logs every change to a lease on its own row. That keeps the original terms on record instead of overwriting them.

Encumbrances — 13 fields — tracks every mortgage, deed of trust, lien, mechanic’s lien, easement, covenant, restriction, or right of way against a property. Holder, type, category, and priority sit alongside recording date, recording reference, maturity, and release. That’s the detail a flat “encumbrances: see attached” note loses the moment a title company asks for it.

Financing, insurance, taxes, permits

Financings, Financing Parties, and Financing Covenants form the financing layer, framed entirely around property-secured debt. Financings holds 17 fields covering principal, interest rate, rate type, index, and spread. Maturity, amortization, interest-only period and end date, and prepayment penalty round out the loan terms.

LTV and DSCR sit alongside financing type — mortgage, mezzanine, construction loan, bridge loan, line of credit, or bond. Financing Covenants — 6 fields — ties each covenant to the financing it belongs to, not to the company as a whole. That keeps a covenant test scoped to one property’s financing, not the whole balance sheet.

Property Insurance, Property Taxes, Property Permits, and Property Inspections round out the obligation layer. Property Taxes carries assessed value and exemptions alongside jurisdiction and due date. Property Inspections carries correction deadlines and certificate expirations alongside inspection type and result.

Inspection types cover Building, Fire, Safety, Environmental, Health, Elevator, HVAC, Electrical, Plumbing, and Structural work. A failed inspection with a correction deadline stays visible until the reinspection closes it out.

How to build your property register

To build a commercial property register in Excel:

1. Add a row per property in Properties. Address, parcel number, legal description, and property type go on every row before anything else.
2. Key owners and investors to that property. Property Owners and Property Investors each point back to the same Properties row.
3. Log every lease and amendment as its own row. A renewal or a rent change goes into Lease Amendments, never over the original lease row.
4. Record every lien or claim in Encumbrances, with priority and a recording reference. A mortgage, easement, or mechanic’s lien each needs its own row and its own recording date.
5. Key financings, insurance, taxes, permits, and inspections to the property they belong to. None of these sheets stand alone; each one ties back to a Properties row.
6. Sort the obligation sheets by due date, expiration, or maturity. That’s the fastest way to see what’s coming due first across the whole portfolio.

One row per record

Each row in Properties should represent exactly one property. Leases, encumbrances, financings, insurance, taxes, permits, and inspections each key back to that property on their own sheet. Flattening a lien or a financing into a notes column loses exactly what this register exists to hold.

Dates, options, and expirations

Sort or filter Leases by option date, Financings by maturity, or Property Permits by expiration — each view brings the next deadline in that category to the top. Add your own conditional-formatting rule to any date column for a visual cue between sorts.

In Excel: Home > Conditional Formatting > Highlight Cells Rules > A Date Occurring. The workbook ships with raw dates only. It carries no formulas or built-in alerts, and nothing here fires a reminder until you set one up.

Built for corporate real estate portfolios

Corporate real estate managers, controllers, general counsel, and facility or operations directors feel a scattered property record first. This happens most often at organizations that both own and lease space. They’re the ones asked to prove property status the moment an auditor or a buyer calls.

Free templates online typically stop at a single-tab rent-collection sheet, or a fixed-asset sheet built for depreciation schedules. This workbook runs the opposite way. It’s a corporate real estate tracking spreadsheet with 14 keyed sheets covering a property’s full lifecycle, from acquisition through financing, insurance, taxes, permits, and inspections.

Property Owners keys each property to the entity that holds title, so one commercial property portfolio register covers multiple entities without a spreadsheet per subsidiary. A holding company with properties across several states shares a single register, each property row pointing back to the entity that owns it. That’s the register wedge free rent-tracking templates and fixed-asset sheets never attempt.

When a spreadsheet stops working

This property compliance spreadsheet template covers a growing property portfolio before it runs into real edges. There’s no version history, so an overwritten maturity date loses its past. With more than one person editing the file, nothing controls who can see which property’s financing or encumbrance records.

Nothing fires an alert when a lease option, a financing maturity, or a permit expiration comes due. That gap can run for months. It usually surfaces during an audit, a refinancing, or a lease renewal.

From register to system

This template’s column headers match Lextree’s import templates, so it loads directly into commercial property management software — no re-keying, no remapping.

Deadlines that surface themselves

From there, dates drive reminders instead of waiting for someone to open the sheet. A lease option or a permit re-inspection chases itself through real estate compliance tracking instead of surfacing at the next audit or renewal.

Frequently asked questions

What is a commercial property register? A centralized record of every property a company owns or leases — its ownership, leases, encumbrances, financing, insurance, taxes, permits, and inspections — kept current in one place.

What’s the difference between a property register and a property management spreadsheet? A property management spreadsheet usually tracks one operational thread, often rent or maintenance, on a single tab. A property register keys every record type — ownership, leases, encumbrances, financing, insurance, taxes, permits, inspections — back to the same property, so no thread goes stale on its own.

Is this a rental income, ROI, or cash-flow spreadsheet? No. This is a record of a corporate property portfolio, not an income or investment model. It holds no rent roll, no cash-flow projections, and no tenant screening — those belong in a different kind of workbook entirely.

Does this track loan or debt covenants? It tracks the property-financing covenants tied to each property’s own financing — conditions like LTV, DSCR, and maturity thresholds on that loan. Company-wide financing covenants belong to a treasury record, not this one.

Is this a fixed-asset or depreciation register? No. This register records the properties themselves — ownership, leases, encumbrances, financing, and obligations — not purchase cost, depreciation, or net book value. A depreciation schedule is a different artifact, built for fixed-asset tracking, not this one.

Can I track property leases, mortgages, and insurance in Excel? Yes. Leases, Encumbrances, Financings, and Property Insurance are separate sheets, each keyed back to the same Properties row. A lease renewal option, a mortgage maturity, and a policy expiration all stay visible without crowding one column. The workbook opens in Google Sheets as well as Excel.

How do I track property encumbrances and liens? Log every mortgage, deed of trust, lien, mechanic’s lien, easement, or restriction on the Encumbrances sheet, one row per instrument. Priority, recording date and reference, maturity, and release each get their own field, so the standing of a claim on the property is never a guess.

Can one register cover multiple entities or a whole portfolio? Yes. Property Owners keys each property to the entity that holds title, so a holding company with subsidiaries across several states shares one register instead of a spreadsheet per entity.

How do I track property permits and inspections? Property Permits logs every permit or authorization with its issuing authority and expiration date. Property Inspections logs every inspection with its result, correction deadline, reinspection date, and certificate number and expiration, each keyed back to the property.

Who is this template for? Corporate real estate managers, controllers, general counsel, and facility or operations directors at organizations with more than one property, whether owned, leased, or both.

Is the template free, and does it work in Google Sheets? Yes. Enter your email below and the workbook is sent to your inbox — no credit card, no sales call. It opens in Google Sheets as well as Excel, dropdowns included.