Property accounting has a reputation for being hard, and it is not because the accounting is exotic. Rent is revenue, a deposit is a liability, a roof is an asset. It is hard because the same small set of entries repeats across hundreds of tenants, dozens of properties and a dozen legal entities every month, and because half of what a lender or an investor asks for (NOI by property, recoveries versus recoverable expenses, occupancy alongside revenue) is not a standard financial statement.

NetSuite is a good place to do it. You manage property accounting in NetSuite by making the property a dimension on every transaction, letting the operating records (leases, invoices, work orders, vendor bills) generate the postings rather than journaling them, and using OneWorld to hold each owning entity as a subsidiary. What NetSuite does not supply is the operating layer that creates those postings; that comes from a property management platform such as RIOO, built on NetSuite, or from custom records.

This post is written for the controller. It walks through one property's monthly P&L line by line and says where each number comes from, then the balance-sheet items that are specific to real estate, then a posting reference, the multi-entity structure and a close that fits in five working days.

How do I manage property accounting in NetSuite?

You manage property accounting in NetSuite in three moves. First, make the property a general-ledger dimension, so every invoice, bill and journal carries it and per-property statements are native reports. Second, drive postings from operating records, so rent, recoveries, deposits and repairs post at the moment they happen with the right account and property already on them. Third, hold each owning LLC as a OneWorld subsidiary and let consolidation, intercompany fees and eliminations run natively.

The order matters. Operators who start with journal entries and try to add the property later spend every close reclassifying. Operators who set the dimension first and let the operating layer post to it spend the close reviewing.

Move one: decide what a property is in the ledger

The owning entity is a subsidiary; the property is a posting dimension; the building and unit are records that do not post. Custom segments are the usual choice for the property dimension, because Location often already means something else and because a segment can be made mandatory on income and expense lines. Class is then free for revenue and expense type (residential, retail, parking), and Department for shared-service teams whose cost is allocated to properties on a driver.

That is the whole design. Entity design across LLCs, funds and joint ventures is in NetSuite multi-entity management for real estate; the reasoning for the property, building and unit hierarchy, including why a unit must never be a dimension, is in the guide to managing multiple properties, buildings and units in NetSuite. Everything below assumes the property segment is on every line.

One property's P&L, line by line

Riverside Commons, 180 units, one month. Figures are illustrative. What matters is the right-hand column: where each line comes from if the system is set up correctly.

Three things about this statement are worth pausing on.

1. Revenue composition was captured at billing time: Rent, parking, pets, utilities and late fees are separate lines on the P&L because they were separate lines on the tenant invoices, each stored with its own account on the lease. Nobody allocated a lump sum at month-end. That is the single biggest difference between property accounting that takes a day and property accounting that takes a week, and it is why the lease record has to carry the account for each charge. The billing side is in NetSuite for property management: features and workflows.

2. Vacancy loss and gross potential rent are not GL accounts in most setups: They are derived from unit records: market rent on every unit gives GPR, market rent on vacant units gives vacancy loss. If market rent does not live on the unit record, this section of the statement is a spreadsheet.

3. Repairs are coded to a unit, not just a property: The vendor bill for a water heater in 4B was matched to the work order for 4B, so the property P&L shows R&M by property, and the unit history shows R&M by unit. Same bill, two views, no extra coding. Vendor bills, purchase orders and the three-way match are covered on the vendor management and accounts payable page.

The balance-sheet items that are specific to property

The P&L is mostly ordinary. The balance sheet is where property accounting gets its own rules.

• Tenant receivables and prepaid rent: Every tenant is a customer, so AR aging by property is a standard report. A tenant who pays ahead creates an unapplied credit on their customer record, which is a liability (prepaid rent), not negative revenue. At month-end, unapplied credits by property should be reviewed and, where material, reclassified to a prepaid rent liability.

• Security deposits: A deposit is the tenant's money. It posts to a liability (2310 Security Deposits Held), never to revenue, and is tracked per lease. Several states require deposits to be held in a separate trust account; in NetSuite that is a dedicated bank account whose balance should equal the liability. At move-out the settlement clears the liability: refund to cash, deductions to recovery income, unpaid rent applied against AR.

• Deferred rent and straight-line revenue: Commercial leases with scheduled step-ups are recognized straight-line under GAAP: total rent over the term divided by the months, so early months recognize more than they bill and later months less. The difference sits in a deferred rent asset or liability. NetSuite's Advanced Revenue Management can hold the schedule; the invoice still bills the contractual amount. The calculation is explained in what straight-line rent is and how to calculate it and the NetSuite mechanics in straight-line rent in NetSuite.

• CAM estimates and the annual true-up: Commercial tenants pay estimated CAM monthly. At year-end, actual recoverable expenses are compared with estimates billed, and the difference is invoiced or credited. For that to work, every expense bill has to be tagged recoverable or non-recoverable when it is entered, and the recoverable pool has to be by property. The reconciliation itself is in CAM reconciliation for commercial leases.

• Fixed assets, improvements and construction in progress: Buildings, roofs, HVAC systems, park-owned homes and tenant improvements are assets in Fixed Assets Management, created from the vendor bill or purchase, depreciated monthly on their own method and life, and disposed of by sale or write-off. A renovation in progress accumulates in a CIP account and is capitalized on completion. The capex-versus-opex decision is made on the bill, using the account, and the asset record inherits the property.

• Leases you pay, not leases you collect: NetSuite's Lease Accounting module, inside Fixed Assets Management, is lessee-only. It handles the ground lease on which your community sits and your head-office lease, as right-of-use assets and liabilities. Tenant leases are receivables and revenue, not this module. The distinction is covered in NetSuite lease accounting for ASC 842 and IFRS 16.

• Intercompany balances: The management company invoices each property LLC for its fee; the parent funds a property's capital call; a shared maintenance team's cost is pushed to the properties it served. Each creates a due-to/due-from between subsidiaries that must net to zero on consolidation.

Posting reference: the entries that recur every month

The "generated by" column is the point of the table. In a well-set-up NetSuite account, only two of these twelve entries are journals (straight-line and the prepaid reclass), and both come from schedules. Everything else is a transaction created by an operating event.

Multi-entity: where NetSuite earns its keep

Most portfolios hold each property in its own LLC, often because a lender requires it. In NetSuite OneWorld, each LLC is a subsidiary with its own ledger, bank accounts and tax identity; the management company is another subsidiary; the fund or parent sits above them. Consolidation is real-time, and Automated Intercompany Management generates the elimination entries at period close so the management fee that is income in one entity and expense in another nets to zero at the top.

Two practices keep this clean. The management fee should be computed from actual collections by property and raised as an intercompany invoice, not a journal, so the property LLC's AP and the management company's AR agree by construction. And every property should map to exactly one subsidiary, so a property P&L is a subsidiary-filtered or segment-filtered report, never a manual roll-up.

If the portfolio reports under more than one basis (GAAP for investors, tax for the K-1s, or a lender's covenant definition), Multi-Book Accounting runs each as a separate ledger from the same transactions, with its own depreciation method and revenue rule. Depreciation is the usual reason: straight-line for the books, accelerated for tax, both from the same asset record.

The close, in five working days

The day-5 tie-out is the test of the whole setup. Rent billed on the rent roll, which is a list of lease records, must equal rental income in the ledger by property, because both came from the same invoices. If they differ, something was journaled or typed, and that is where to look. Reporting runs on SuiteAnalytics: Financial Report Builder for the statements by subsidiary and segment, saved searches for the rent roll and aging, dashboards for occupancy alongside revenue.

Notice what is missing from the five days: no export from a property system, no import into accounting, no reconciliation between the two. That is the case for doing property accounting in NetSuite in the first place, and the wider argument is made in NetSuite real estate accounting.

Where RIOO fits

The postings in this post are only automatic if something creates them. RIOO is the property management platform built on NetSuite that does: lease records carry the revenue account on every charge line, so the billing run produces the P&L composition above; deposits post to the liability at move-in and settle at move-out; work orders link vendor bills to units and to fixed assets; utility reads and RUBS allocations become invoice lines; and every property maps to its OneWorld subsidiary so intercompany fees and consolidation run natively. The finance side of the platform is described on the property accounting on NetSuite and income and expense management pages, with scheduled owner and lender packages from dashboards and reports.

RIOO runs this for 180k+ units and $160M+ in monthly rent across the US and Canada. To see a property close run inside your NetSuite account, book a demo.

Frequently asked questions

Q1. How do I manage property accounting in NetSuite?

Make the property a general-ledger dimension on every transaction, drive postings from operating records such as leases, invoices, work orders and vendor bills rather than journal entries, and hold each owning LLC as a OneWorld subsidiary. Per-property P&L, NOI and consolidated statements then run as native reports, and the close becomes a review rather than a rebuild.

Q2. How should I structure the chart of accounts for multiple properties in NetSuite?

Use one chart of accounts for the whole portfolio and put the property on a custom segment rather than in the account number. Subsidiary holds the owning entity, class holds revenue and expense type, department holds shared-service teams. This keeps the chart short and makes property P&L a filter rather than a separate set of accounts.

Q3. How are security deposits handled in NetSuite?

A deposit posts to a liability account, never revenue, and is tracked per lease. Where state law requires a trust account, it is a dedicated bank account whose balance should equal the liability. At move-out the liability is cleared by refunding cash, applying the deposit to unpaid rent in AR, or retaining deductions as recovery income.

Q4. How does NetSuite produce NOI by property?

NOI by property is a Financial Report Builder statement filtered by the property segment or subsidiary, showing revenue lines from tenant invoices and operating expense lines from vendor bills, payroll and accruals coded to that property, before depreciation and interest. Gross potential rent and vacancy loss come from unit records, so market rent must be stored on each unit.

Q5. How does NetSuite consolidate property LLCs?

Each LLC is a OneWorld subsidiary with its own ledger; the parent consolidates them in real time. Automated Intercompany Management generates elimination entries at period close, so management fees, capital calls and shared-service charges between entities net to zero in the consolidated statements. Multi-Book Accounting can run GAAP and tax ledgers from the same transactions.

Q6. Does NetSuite need a property management application for property accounting?

NetSuite provides the ledger, dimensions, AR, AP, fixed assets, revenue schedules and consolidation. It does not create rent invoices from leases, post deposits from move-ins or link repair bills to units, because it has no lease, unit or work-order records. Those come from a property management layer such as RIOO, built on NetSuite, or from custom records built in-house.

RIOO is a property management platform built natively on Oracle NetSuite, used by residential, commercial and manufactured housing operators to manage properties, units, tenants, leases, rent billing, maintenance and multi-entity accounting in one system.