NNN landlord due diligence review with rent roll variance rows, lease documents, CAM checks, and a retail property context.

!NNN landlord due diligence review with rent roll variance rows, lease documents, CAM checks, and a retail property context.

A rent roll looks simple until someone asks whether every number is backed by the lease.

For a refinance, sale, lender package, partner review, or internal portfolio cleanup, the rent roll becomes more than a summary of tenants and rent. It becomes the operating index for the property: base rent, recovery method, CAM estimates, reimbursement caps, abatements, deposits, options, tenant obligations, and exceptions that affect income.

The problem is that many NNN rent rolls are built from a mix of spreadsheets, accounting exports, old lease abstracts, email notes, PDFs, and memory. That may work for monthly operations. It usually falls apart during diligence.

This checklist is for landlords who want to clean up the rent roll before the questions arrive.

Start With The Active Lease Record

Before editing the rent roll, confirm which documents control each tenant's economics.

For every tenant, gather:

Do not rely on the original lease if amendments changed the suite, rent schedule, term, use, options, reimbursement method, or deposit. A clean rent roll starts with the active lease record, not the oldest PDF in the folder.

Verify The Basic Rent Roll Fields

Start with the rows everyone expects to see. These are basic, but they are also where diligence questions begin.

For each tenant, confirm:

Then tie each field to a source. A diligence-ready rent roll should be able to answer, "Where did this number come from?" without a folder search.

Reconcile Current Rent To The Lease Schedule

Current rent should not be copied from last month's invoice without checking the lease.

For each lease, compare the rent roll to:

Common diligence issues include rent escalations that were never billed, abatements that were extended informally, and CPI increases that were calculated once but not updated in later years.

If the rent roll says the tenant pays $12,000 per month, the backup should show why that is the correct amount for the current billing period.

Separate Base Rent From Recoveries

A NNN rent roll should not blur base rent, CAM, taxes, insurance, utilities, and other reimbursements into one monthly charge.

For each tenant, split the row into:

This matters because buyers and lenders will usually care which income is contractual base rent and which income is reimbursement. It also matters for CAM reconciliation. If the current estimate is wrong, the rent roll may overstate or understate cash collection without showing the true annual recovery position.

Check The CAM Recovery Basis

CAM mistakes often hide inside rent roll rows.

For each tenant, confirm the recovery method:

Then compare the rent roll's monthly CAM estimate to the budget, lease abstract, and prior reconciliation. A tenant may be billed the right total monthly charge for the wrong reason. During diligence, that distinction matters.

For example, if a tenant has a cap on controllable CAM but the rent roll simply shows one blended CAM estimate, the reviewer may not be able to see whether the cap has been honored. If an anchor tenant uses a different CAM pool, the rent roll should not imply the same pro rata method as the inline tenants.

Confirm Reimbursement Caps And Exclusions

Reimbursement caps are easy to lose in spreadsheets because they do not always change the monthly invoice immediately.

For each tenant, identify:

If the rent roll includes estimated recoveries, add enough notation to show whether caps or exclusions affect the number. Otherwise, the rent roll may look clean while the annual reconciliation still contains a dispute.

Track Options And Notice Windows

Lease options affect valuation, lender underwriting, sale negotiations, and asset planning. They should not live only in a lease abstract.

For each tenant, verify:

The rent roll should not become a full legal summary, but it should flag material options clearly enough that nobody treats the expiration date as the whole story.

A tenant expiring in 18 months with two five-year renewal options is different from a tenant expiring in 18 months with no option. A tenant with a termination right after a sales threshold miss is different from one with a firm term. The rent roll should make those differences visible.

Verify Deposits, Guarantees, And Credit Support

Security deposits and guarantees are often tracked outside the rent roll, but they become diligence questions quickly.

Confirm:

Then compare the rent roll, accounting ledger, bank record, and lease. If the rent roll says a deposit exists, the backup should prove where it is held and whether it is still valid.

Review Abatements, Credits, And Side Deals

Abatements and credits are common sources of rent roll confusion.

Look for:

Every current or future credit should be tied to an agreement or documented approval. If the credit is temporary, the rent roll should show when it ends. If it affects income during the diligence period, it should not be buried in the ledger.

Tie Tenant Obligations To Operating Risk

NNN diligence is not only about rent. Tenant obligations can affect the property budget and the landlord's exposure.

For each lease, flag who is responsible for:

The rent roll does not need every maintenance clause, but it should identify material obligations that change how the property operates. If a tenant is responsible for HVAC replacement or direct utility service, a buyer or lender may ask for evidence that the obligation is being tracked.

Reconcile The Rent Roll To The Ledger

Once lease terms are verified, compare the rent roll to billing and payment history.

Check:

This step catches a common problem: the lease says one thing, the rent roll says another, and the ledger shows a third. Diligence reviewers will usually follow the inconsistency until someone explains it. Better to find it first.

Prepare The Backup Packet Before It Is Requested

A strong rent roll package includes the spreadsheet, but it does not stop there.

Prepare a folder or data room section with:

The exception log is important. If a tenant is disputing CAM, a deposit is being replenished, or a rent increase is pending notice, name it. Diligence problems get worse when exceptions are hidden and discovered later.

For supporting workflows, see what buyers care about in NNN lease terms, our tenant estoppel certificate guide, and CAM reconciliation backup package.

Use A Row-Level Checklist

For each tenant row, mark these as verified:

1. Tenant name matches active lease documents. 2. Suite and rentable square feet match the lease or latest amendment. 3. Current term and expiration date are correct. 4. Rent commencement date is documented. 5. Current base rent matches the lease schedule. 6. Next escalation date and formula are captured. 7. Free rent, abatements, and credits are identified. 8. CAM recovery method is captured. 9. CAM caps, exclusions, and special pools are noted. 10. Tax, insurance, utility, and other reimbursement treatment is clear. 11. Security deposit and guaranty are verified. 12. Options, ROFR/ROFO, termination rights, and notice windows are flagged. 13. Tenant obligations that affect operating risk are noted. 14. Current charges reconcile to the tenant ledger. 15. Open balances, disputes, and exceptions are logged.

This does not require a complicated process. It requires one source of truth that can tie the rent roll row back to the lease and the accounting record.

How PigJet Fits

PigJet is built for landlords who need the rent roll, lease abstract, CAM rules, tenant obligations, and accounting handoff to stay connected.

For NNN diligence, the point is not to make a prettier spreadsheet. The point is to avoid rebuilding the story tenant by tenant every time a lender, buyer, partner, or asset manager asks a question.

If the rent roll shows current rent, PigJet should help the landlord trace that number back to the rent schedule, amendment, escalation rule, ledger, and supporting documents. If CAM is billed monthly, the recovery method, cap, estimate, and reconciliation trail should not be in a separate workbook that only one person understands.

That is where NNN-specific workflow matters: not because broader commercial systems are incapable, but because private NNN landlords often need less enterprise overhead and more lease-economics clarity in the daily operating record.

For related operating controls, see NNN lease abstraction for CAM billing clauses and NNN lease management software.

Bottom Line

A diligence-ready NNN rent roll proves its own numbers.

The landlord should be able to show the active lease record, current rent schedule, CAM recovery basis, caps and exclusions, deposits, abatements, options, tenant obligations, ledger tie-out, and exception log without rebuilding the file from scratch.

The best time to clean it up is before diligence starts. Once a lender or buyer is asking, the rent roll is no longer just an internal tracking sheet. It is the property's operating evidence.