NetSuite has no dedicated native rent roll. There is no standard rent roll report or rent roll record in a typical NetSuite account.

You can build something that looks like one, and plenty of property companies do, using custom segments and a saved search over lease data. It works well enough for internal review. It starts failing the moment a lender, an auditor or an investor asks for one, and the failures are specific enough to predict.

This covers how to build it, and the five places the approach breaks.

What a Rent Roll Has to Contain

A rent roll is a point-in-time schedule of every unit in a property and what it earns. The requirements are not a matter of taste. Freddie Mac's Multifamily Seller/Servicer Guide specifies, for each unit: an as-of date stated in the document, tenant names, unit number, unit type, square footage, occupancy status, identification of employee, model, corporate and office units, monthly contract rent, concessions, arrearages, subsidies, rent control status, original occupancy date, lease commencement, lease expiration and renewal options, month-to-month status, security deposit held, and furnished status.

Fannie Mae's Form 4243 covers similar ground and adds a detail worth pausing on. Where a unit is not leased, the tenant name field must read "Vacant," "Model," "Office," "Employee" or "Storage." And the rent column is monthly unfurnished contract rent as stated in the lease, explicitly gross of concessions and subsidies, with those reported separately.

Two properties of those lists matter more than the fields themselves. The document is a snapshot as of a stated date. And it must cover every unit, including units earning nothing. Both of those are where a NetSuite-built rent roll gets into trouble.

How to Build One in NetSuite

The Data Model You Need First

Nothing works without structure, and this is where most attempts go wrong before a single search is written.

You need a way to represent a property and a unit. Most implementations use Location for the property and either a child Location or a custom segment for the unit. Custom segments are usually the better choice, because they travel with every transaction and can be filtered in any report.

You need a place for lease data. NetSuite does not provide a dedicated tenant lease-management record for this purpose, so this is typically represented with a custom record: commencement date, expiry, contractual base rent, escalation terms, deposit amount, option details, square footage. That custom record is the spine of the whole exercise.

You need disciplined item coding, so base rent, CAM, parking, storage and utility recovery are separable rather than arriving as undifferentiated invoice lines.

And you need the tenant represented consistently, normally as a customer record linked to the lease record.

The Saved Search

For a property-specific rent roll, the search should generally run over the lease record rather than directly over transactions. A search over invoices tells you what was billed. A search over lease records tells you what exists, which is what a rent roll is.

Join to the customer for tenant name, to open invoices for arrears, and to the unit segment for square footage. Add formula columns for rent per square foot and months remaining. Filter to leases where commencement is on or before your as-of date and expiry is after it.

SuiteAnalytics Workbook is the better tool if you want pivoting and drill-down rather than a flat export. Our guide to real estate dashboards and KPI reporting covers that reporting layer in more depth.

What This Gets You

A workable internal rent roll. Current tenants, current rents, expiries, arrears, totals by property. For a portfolio manager reviewing performance on a Monday morning, this is genuinely enough, and it is the reason so many teams stop here and assume the problem is solved.

Where It Breaks

Vacant Units Disappear

In a lease-driven search, a vacant unit has no active lease record, so it does not appear.

This is the single biggest failure and it is easy to miss, because a rent roll with no vacancies looks correct. It is not. Occupancy percentage cannot be calculated from a document that only contains occupied units, and both agency formats require occupancy status for every unit, with non-revenue units identified by type.

The fix is a unit master, a record of every unit that exists independent of whether it is leased, with the rent roll built from units and joined to leases rather than the other way round. That is a further custom record, and it has to be maintained as the portfolio changes.

It Is a Snapshot, Not a Period Report

A rent roll is as of a date, and both agencies require that date to be stated inside the document. Saved searches are comfortable with periods and awkward with as-of dates once anything has changed mid-month.

A tenant who moved in on the fourteenth, a rent that escalated on the first, a unit that turned over twice in a quarter: each of these makes "what was the contractual rent on this date" a different question from "what was billed this month," and the search has to be written to answer the first.

Contractual Rent and Billed Rent Are Not the Same Number

Build the rent roll from invoices and a mid-month move-in shows a prorated figure. A tenant with a two-month abatement shows zero. A tenant who paid a catch-up shows double.

None of those is contractual rent. Fannie Mae is explicit that the rent column is monthly contract rent stated in the lease, gross of concessions and subsidies, with the value of any concession reported in its own column. An invoice-derived figure is net of concessions by definition, which is the opposite of what the form asks for.

This is why the search has to run over lease records, and why the lease record has to hold contractual rent as a field rather than inferring it from what was charged.

Escalations Live in the Wrong Place

Rent that escalates annually is usually configured as a billing schedule. That schedule knows what to bill and when.

What it does not readily give you is a queryable answer to "what is the next escalation on this lease, on what date, to what amount." A rent roll needs current rent and next escalation side by side, and reconstructing the second from a billing schedule is not straightforward. Most implementations end up duplicating escalation terms onto the lease custom record, which then has to be kept in step with the billing configuration. Two sources of truth for the same number is a reconciliation problem waiting to happen.

The same issue affects fields the agencies require but few NetSuite configurations carry anywhere: renewal options, month-to-month status, and original occupancy date as distinct from lease commencement.

Our guide to automating rent billing and renewals in NetSuite covers the billing side of this in detail.

You Cannot Reproduce Last Quarter's Rent Roll

Lenders ask for rent rolls as of prior dates. Auditors ask what the rent roll showed at year end.

A saved search reflects the data as it is now. NetSuite does retain change history in System Notes, but that is not the same as preserving a point-in-time rent roll. Unless someone was snapshotting rent rolls monthly and storing them, prior-period rent rolls cannot be reliably reproduced from the saved search alone.

Most teams discover this during their first audit or refinancing, which is the worst possible moment.

The Lender Problem

For many property owners, the rent roll becomes a lender document before it becomes anything else. It supports underwriting and debt service coverage, and it recurs. Fannie Mae's Form 4243 is used at multiple points in a multifamily loan's life. Its instructions list submission with the loan application, mortgage purchase, assumption requests, partial releases, the annual inspection report and 45-day delinquency reporting, among others.

Three things about the agency requirements change how you should think about producing one.

It has a short shelf life. Freddie Mac requires the rent roll to be dated within 30 days of underwriting package submission, with the as-of date stated inside the document itself.

It is certified by more than one party. Fannie Mae's Form 4243 is certified in Part A by the mortgagor and the management agent, and in Part B by the lender, signed by an officer. Freddie Mac requires certification through Form 1112.

It gets audited against your lease records. Before signing Part B, the lender reviews 25 percent of written leases for projects of 100 units or fewer, or 10 percent for larger ones, against the rent roll, and physically inspects a sample of units. Discrepancies are described in an attached narrative, and material ones trigger expanded sampling until none remain.

That last requirement is the one that matters technically. The rent roll is not just a report you produce. It is a document a third party reconciles line by line against your underlying lease agreements. A rent roll assembled from a saved search and then manually patched to add vacancies is harder to substantiate under those conditions, because the final document no longer comes directly from a controlled underlying record set, and the next one has to be assembled the same way.

That is the practical test of whether your approach works. Can you produce an as-of-date rent roll covering every unit, reconcilable to your lease records, on request, repeatably, without manual assembly. Most configurations built from segments and saved searches cannot.

What Closes the Gap

Three paths, in ascending order of investment.

1. Extend the configuration. Build the unit master, hold contractual rent and escalation terms on the lease record, snapshot the rent roll monthly to a saved record so history exists. This works. It is real development effort and it becomes your team's to maintain.

2. Bring in a reporting tool over NetSuite data. Solves presentation, does nothing about the underlying data model, so vacant units are still missing because they were never recorded.

3. Use a property platform that has a unit and lease model natively, so a rent roll is a standard report rather than a build. Because NetSuite has no property management module, this means either an external platform integrated with NetSuite or one built inside it.

Where RIOO Fits

RIOO is a property management platform built directly on NetSuite. It carries the records this article has described as missing: a unit master independent of occupancy, a tenant lease record with contractual rent, escalation rules and expiry dates, and occupancy status maintained as units turn over.

That makes the rent roll a report rather than a project. Vacant units appear because they exist as records. Contractual rent is a field rather than an inference from billing. And because the operational records live in the same NetSuite account as the financials, arrears on the rent roll are the same figures your finance team sees in AR.

Book a RIOO Demo

If you are building rent rolls out of saved searches and adding vacancies by hand, a demo will show you the difference in about ten minutes. Book a RIOO demo.

Frequently Asked Questions

1. Does NetSuite have a rent roll report?
No. There is no dedicated rent roll report, record or template in a standard NetSuite account. A rent roll can be built using custom records for units and leases, custom segments for property and unit, and a saved search or SuiteAnalytics workbook over that structure.

2. How do you create a rent roll in NetSuite?
Build a custom lease record holding contractual rent, commencement, expiry and escalation terms, represent properties and units through custom segments, then run a saved search over the lease records filtered to your as-of date, joined to customers for tenant names and to open invoices for arrears.

3. Why does my NetSuite rent roll not show vacant units?
Because it is almost certainly built over lease or transaction records, and a vacant unit has no active lease or rental transaction. Agency rent roll formats require occupancy status for every unit, with employee, model, corporate and office units identified by type, so showing vacancies requires a unit master record that exists independently of occupancy.

4. Can NetSuite produce a rent roll for a past date?
Not reliably. Saved searches reflect current data, and while System Notes track changes to a record, historical reconstruction requires more than the saved search itself. Reproducing prior-period rent rolls means snapshotting the report to a stored record each period, which has to be set up before you need it.

5. What is a certified rent roll?
A rent roll formally certified as accurate as of a stated date. Fannie Mae's Form 4243 is certified by the mortgagor and the management agent, then by the lender, whose officer signs after reviewing a sample of written leases against the rent roll and inspecting units. Freddie Mac requires certification via Form 1112 and a rent roll dated within 30 days of underwriting package submission.