Commercial Rent Roll: A Financing Preparation Checklist

A commercial rent roll should help a financing reviewer understand who occupies the property, what rent is contracted and when that income could change. A total rent figure is only the beginning. A useful submission connects the dated tenant schedule to leases, actual collections and a clear explanation of upcoming expirations.

What is a commercial rent roll?

A rent roll is a schedule of a property’s tenants or units and rental terms as of a stated date. For a financing discussion, use it alongside operating statements and supporting leases. The OCC’s Commercial Real Estate Lending handbook describes collecting and analyzing operating statements and rent rolls to assess property performance and tenant rollover risk. It is U.S. bank supervisory guidance, not a universal checklist or a statement of CGFS lending requirements. Source: https://www.occ.gov/publications-and-resources/publications/comptrollers-handbook/files/commercial-real-estate-lending/pub-ch-commercial-real-estate.pdf

The practical worksheet below focuses on existing income-producing commercial property. It is an internal preparation aid. A lender may request a different format or additional evidence, and the completed schedule does not establish valuation, eligibility or approval.

Start with one dated row per space

Record the property address, reporting date, currency and area measurement used. Give each space a stable identifier so the rent roll, lease files and collection records refer to the same unit. Include vacant spaces rather than omitting them from the schedule.

For occupied space, useful columns include tenant legal name, area, occupancy status, lease commencement, expiry, current base rent, payment frequency and scheduled rent changes. Keep expense recoveries or other charges separate from base rent. Add a source-document reference and a notes column for unresolved items.

Distinguish a signed lease from a proposal and distinguish lease commencement from the date cash rent begins. If there is a concession or rent-free period, show its dates and treatment explicitly. Ask the property’s legal advisers to clarify uncertain clauses rather than silently interpreting them in the spreadsheet.

Reconcile contracted rent, billed rent and cash

Use three separate views for a chosen period: rent scheduled under the documents, rent billed and cash received. Explain differences with a short reconciliation. A bank deposit total alone may include prior-period collections, deposits or other receipts that should not be treated as the same month’s base rent.

Consider a fictional property with $100,000 of monthly scheduled base rent before concessions. A documented $5,000 concession leaves $95,000 billed for the month. Assume $90,000 is collected against those bills, leaving $5,000 outstanding. If a further $8,000 arrives against older invoices, total cash received is $98,000.

The $98,000 of cash does not mean current monthly rent is $98,000 or that all current bills were paid. The reconciliation is $100,000 scheduled less $5,000 concession = $95,000 billed; less $90,000 current-period collections = $5,000 still outstanding. Prior-period collections explain the additional $8,000 in cash. These hypothetical figures illustrate recordkeeping, not a CGFS transaction.

Keep the arrears schedule beside the reconciliation, showing the relevant period and status. Where the operating statement uses a different accounting basis, ask the accountant to explain the bridge. Do not overwrite one report simply to force the totals to match.

Map lease expirations against the financing timeline

Lease rollover means existing leases reaching expiry and potentially being renewed or replaced. The OCC handbook includes review of tenant strength, rollover risk, renewal assumptions and re-leasing costs. A borrower can make that review easier by presenting a dated expiry schedule and labeling renewal assumptions separately from executed agreements.

For your own analysis, group expiring leases by quarter and calculate both the area affected and the base rent represented. Use a consistent reporting date and denominator. Add the proposed loan maturity date to the same timeline so the team can see whether important leasing decisions occur shortly before refinancing is expected.

Illustration: a fully occupied property has 40,000 square feet and $1.2 million of annualized current base rent. One tenant occupies 10,000 square feet and contributes $360,000 of that rent, with its lease expiring in nine months. That tenant represents 25% of area but 30% of current base rent. Area alone would understate its share of rent.

Annualizing current rent does not promise a full year of collections. In a simple scenario with three months of downtime at that tenant’s current $30,000 monthly base rent, foregone base rent is $90,000. Estimate any tenant improvements, leasing commissions, concessions and unrecovered operating costs separately, using transaction-specific support. The $90,000 is neither total leasing cost nor a valuation reduction.

Keep renewal assumptions reviewable

Build a short scenario note for each material expiry: current documented position, proposed renewal assumption, alternative vacancy period, estimated costs and supporting evidence. Assign an owner and review date. If a tenant is discussing renewal, identify the discussion as such until the necessary documents are executed.

The purpose is to show what would change in property cash flow, not to predict a tenant’s decision with certainty. Compare the base and downside cases using the same periods and expense assumptions. Explain changes in recoveries and operating costs instead of assuming every lost rent dollar flows through identically.

Rent roll preparation checklist

• Date the schedule and state the property, currency and area basis.
• Include every space and clearly distinguish occupied, vacant and proposed leases.
• Link material terms to signed leases, amendments and supporting schedules.
• Separate base rent, recoveries, concessions, arrears and deposits.
• Reconcile scheduled rent, billing and cash collections for the same period.
• Summarize expirations by both area and base rent, alongside financing milestones.
• Label assumptions, missing documents and responsible follow-up owners.

Frequently asked questions

Does a fully occupied building eliminate leasing risk?

No. Occupancy is a snapshot. The expiry example shows why an occupied building can still face a significant change in rent during the financing period. Review the dates, collections and evidence behind the current position.

Should market rent be mixed with current lease rent?

Keep it in a separate forecast or comparison column, with its source and date. A proposed market rent is an assumption; it should not replace the amount documented in an existing lease.

Is a rent roll enough to obtain financing?

No. It is one part of a broader property funding package. Capital providers may also review operating costs, valuation, existing debt, sponsor information and other transaction documents. Their requirements and final decisions remain independent.

Connect the rent roll to your property funding brief

Use the rent roll to support the current-income section of your broader property narrative. The CGFS property funding brief explains how to organize the asset, purpose, funding amount and supporting evidence: https://www.creativeglobalfundingservices.com/commercial-property-funding-brief-worksheet/

Creative Global Funding Services connects qualified businesses and project owners with potential capital providers for requests of USD $1 million or more. Present the requested amount, proposed use of funds and a dated rent roll together. Financing remains subject to review, due diligence, acceptable terms and final capital-provider approval. Start a funding discussion: https://www.creativeglobalfundingservices.com/request-funding.php

This article provides general preparation information and fictional examples, not legal advice or a property valuation. Featured image: original AI-generated conceptual illustration; it does not depict a real CGFS client or financed property.