Ask three property people how they manage tenants, leases and rent in NetSuite and you will get three different answers, because NetSuite gives you one of the three and not the other two. It has a customer record, which is most of a tenant. It has no lease record at all. And rent is whatever the lease generates, so without a lease, rent is a recurring invoice someone remembers to raise.
The short version: a tenant is a NetSuite customer record extended with occupancy and portal access; a lease is a record NetSuite does not ship, which has to be added and which links the customer to a unit, a term and a set of charges; and rent is the stream of invoices, payments and fees that the lease record generates and the customer record carries. A property management layer such as RIOO, built on NetSuite, supplies the lease record and the workflows around it, so all three live in the same database as the ledger.
Rather than describe that in the abstract, this post follows one tenancy for twelve months, from application to deposit refund, and shows what each record holds, what each invoice looks like and where every dollar posts. The numbers are illustrative; the mechanics are exactly what a controller and a property manager should expect to see.
The tenancy we will follow
Unit 4B at Riverside Commons, a 180-unit community owned by Riverside Commons LLC, a OneWorld subsidiary. The tenant is M. Alvarez. The lease terms:
| Term | Value |
|---|---|
| Move-in date | March 12 |
| Lease term | 12 months, ending March 11 the following year |
| Base rent | $1,850 per month |
| Reserved parking | $75 per month |
| Pet rent | $35 per month |
| Water | Submetered, billed monthly in arrears |
| Security deposit | $1,850, due at move-in |
| Late fee | 5% of base rent after a 5-day grace period |
| Renewal escalation | 4%, with 60 days' notice |
Everything that follows is what happens to those terms inside NetSuite.
How do I manage tenants in NetSuite?
A tenant in NetSuite is a customer record. That gives you, out of the box, everything a receivable needs: a balance, an aging, statements, payment methods on file, dunning history, and a subsidiary that determines which entity's books the tenant sits in. What the customer record does not know is that M. Alvarez lives in Unit 4B, moved in on March 12, has a guarantor, or should be able to log in and pay.
So the tenant record is a customer record plus an occupancy layer. In practice that layer holds:
- The link to the unit and the lease: A tenant can have more than one lease over time (a transfer from 4B to 7A) and a unit has more than one tenant over time; the customer record is the constant, the lease is what changes.
- Co-tenants and guarantors: Two names on one lease should share one ledger, not have two customer records with half a balance each. A guarantor is a related party on the lease, not a customer in their own right, unless they are ever billed.
- Status driven by events: Applicant, approved, current, on notice, past, evicted. The status should change because a lease event happened, not because someone edited a dropdown.
- Portal access: The tenant needs to see their own ledger, pay, and raise a request, which means a login tied to the customer record and scoped to it.
- Communication history: Notices, renewal offers, late notices and inspection reports attached to the tenant, so anyone can answer "what did we send and when."
For a commercial tenant the same record carries more: a legal entity name, a billing contact separate from the site contact, the suite and square footage, an estimated-CAM figure that changes each year, and sometimes a letter of credit instead of a cash deposit. The record type is the same; the fields are richer.
In the Alvarez example, on the day the application is approved, the customer record is created under the Riverside Commons LLC subsidiary with a zero balance, portal access is issued, and the record is linked to the lease that is about to be signed. Nothing has posted to the ledger yet.
How do I manage leases in NetSuite?
Here is the honest part: NetSuite has no lease record. You can approximate one with a custom record type, you can stretch a SuiteBilling subscription to behave like one, or you can use an application that ships a lease record. Whichever you choose, the lease has to carry the same things.
Anatomy of a lease record
| Field group | What it holds | Why it matters |
|---|---|---|
| Parties | Tenant (customer), co-tenants, guarantor | One ledger for the tenancy |
| Premises | Property, building, unit; square footage for commercial | Rent roll and occupancy come from this link |
| Term | Start, end, move-in date, notice period, options | Drives proration, renewal timing and expiry reports |
| Charge lines | Base rent, parking, pet, storage, utilities, CAM, custom | Each line has its own amount, frequency and revenue account |
| Escalation | Type (fixed, percentage, CPI), rate, effective date, notice required | Applies on its date without editing the rent roll |
| Deposit | Amount, date received, account held in, refund status | A liability, never revenue |
| Late fee rule | Grace days, fee basis, cap | Generated as an invoice line when triggered |
| Documents | Signed lease, addenda, inspection reports | Audit trail on the record itself |
| Status | Draft, active, on notice, expired, terminated | Set by events |
Why a SuiteBilling subscription is an imperfect stand-in: SuiteBilling was built for software subscriptions. It handles recurring charges, proration on change orders, and a percentage uplift at renewal, which covers simple monthly rent. But a subscription has no unit, no deposit, no notice period, no guarantor, and no idea that the tenant is leaving on the 11th. Operators who try it end up with the lease's real terms in a spreadsheet next to the subscription, which defeats the point.
One clarification that saves a lot of confusion: NetSuite does have a Lease Accounting module, inside Fixed Assets Management, and it is lessee-only. It books the leases you pay (your head office, your equipment) under ASC 842 and IFRS 16 as right-of-use assets and liabilities. It does nothing for the leases you collect. Landlord-side accounting for the Alvarez lease is receivables and revenue, covered in NetSuite lease accounting for ASC 842 and IFRS 16 and, for commercial straight-lining, straight-line rent in NetSuite.
The Alvarez lease through the year
| Date | Lease event | What changes on the record |
|---|---|---|
| March 5 | Lease signed electronically | Status draft → active; charge lines and deposit set; unit 4B status → pre-leased |
| March 12 | Move-in | Move-in inspection attached; deposit received; unit → occupied; first prorated invoice generated |
| April 1 onward | Monthly billing | Invoice generated from the charge lines on the 1st; water added from the meter read |
| January 10 | Renewal offer | 60-day notice; proposed rent $1,924 (4%) with effective date March 12 |
| January 24 | Offer accepted | Escalation line committed; nothing changes on the rent roll until the effective date |
| March 12 (year 2) | New rate applies | Billing run picks up $1,924 automatically |
Had the offer been declined, the lease would have moved to "on notice," the unit to "on notice" with an availability date, and the leasing team would have seen it in the vacancy pipeline the same day. Renewal, escalation and termination mechanics in more depth are in NetSuite lease management: renewals, escalations and terminations, and the escalation types themselves in rent escalation clauses: CPI, fixed and percentage.
How do I manage rent in NetSuite?
Rent is what the lease generates. Once the lease record exists, managing rent is four recurring things: generating the invoice, applying the payment, handling what goes wrong, and keeping the rent roll tied to the ledger. This is the part NetSuite is strong at, provided the lease is feeding it.
The first invoice: proration
Alvarez moves in on March 12. March has 31 days, so the first invoice covers 20 days at 20/31 of each monthly line. Water is billed in arrears from the meter, so it does not appear until April.
| Invoice line (March 12–31) | Calculation | Amount | Posts to |
|---|---|---|---|
| Base rent, prorated | $1,850 × 20/31 | $1,193.55 | 4010 Rental Income – Residential |
| Reserved parking, prorated | $75 × 20/31 | $48.39 | 4020 Parking Income |
| Pet rent, prorated | $35 × 20/31 | $22.58 | 4030 Pet Income |
| Invoice total | $1,264.52 | Debit 1200 Accounts Receivable |
Nobody typed those amounts. The proration rule on the lease did the arithmetic from the move-in date, and each line landed in its own revenue account because the account is stored on the charge line, not chosen at invoice time.
The deposit is not on the invoice. It is received separately and posts to a liability, because it is the tenant's money.
A normal month: April 1
| Invoice line (April) | Amount | Posts to |
|---|---|---|
| Base rent | $1,850.00 | 4010 Rental Income – Residential |
| Reserved parking | $75.00 | 4020 Parking Income |
| Pet rent | $35.00 | 4030 Pet Income |
| Water, submetered (March 12–31, 640 gal) | $42.60 | 4050 Utility Recovery – Water |
| Invoice total | $2,002.60 | Debit 1200 Accounts Receivable |
The same invoice runs on the 1st of every month for the rest of the term, with only the water line changing. That is what "managing rent" should feel like: a run, not a task.
Payment, and what happens when it does not arrive
Alvarez pays $2,002.60 through the portal on April 3. NetSuite's own payment stack handles the rest: card or bank payment with the method on file, ACH through Electronic Bank Payments, the payment applied to the open invoice, and the deposit matched against the bank feed. The customer balance returns to zero.
Suppose instead the payment had not arrived by April 6, the end of the 5-day grace period. The late fee rule on the lease generates a new invoice line: 5% of base rent, $92.50, to 4070 Late Fee Income. The unpaid April invoice starts aging. NetSuite's Dunning Letters escalate notices by days and amount overdue, and the tenant's status can move to delinquent, which in a well-designed setup blocks a renewal offer until the balance clears. The collections record and the accounting record are the same record, so nobody reconciles the two.
Every posting in the tenancy, in one place
| Event | Debit | Credit |
|---|---|---|
| Deposit received (March 12) | 1000 Cash $1,850.00 | 2310 Security Deposits Held $1,850.00 |
| Prorated first invoice | 1200 AR $1,264.52 | 4010 / 4020 / 4030 revenue $1,264.52 |
| Monthly invoice (April) | 1200 AR $2,002.60 | 4010 / 4020 / 4030 / 4050 revenue $2,002.60 |
| Payment applied | 1000 Cash $2,002.60 | 1200 AR $2,002.60 |
| Late fee (if triggered) | 1200 AR $92.50 | 4070 Late Fee Income $92.50 |
| Rent increase effective (year 2) | 1200 AR $1,924.00 | 4010 Rental Income $1,924.00 |
| Move-out settlement: $150 cleaning deducted | 2310 Security Deposits Held $1,850.00 | 1000 Cash $1,700.00; 4080 Damage & Cleaning Recovery $150.00 |
Every row is a standard NetSuite transaction. What made them correct without manual work is that the lease record supplied the amounts, the dates and the accounts. The month-end mechanics of the billing run, including how to schedule it and handle exceptions, are in automating rent collection and lease renewals in NetSuite.
The rent roll is the lease records, not a report someone builds
At any point in the year, the rent roll for Riverside Commons is a list of active lease records: unit, tenant, term dates, current charges, deposit held, balance. Because the invoices were generated from those same records, rent billed by property in the rent roll equals rent revenue by property in the general ledger. That tie-out is the single best test of whether tenants, leases and rent are being managed in NetSuite properly. If the two numbers differ, something was typed.
The same logic scales across entities. Riverside Commons LLC is one subsidiary; the rent roll for the whole portfolio is the same list filtered to all subsidiaries, and consolidation is OneWorld doing its normal job. Entity structure is covered in NetSuite for multi-entity real estate.
What is different for a commercial tenant
The tenancy above is residential. A commercial tenant in Suite 300 follows the same records with heavier charge lines: base rent with a scheduled step-up every 12 months, a monthly CAM estimate reconciled to actual expenses once a year, property tax and insurance recoveries, sometimes percentage rent on reported sales. The deposit may be a letter of credit, tracked on the lease but not posted as cash. And for GAAP the base rent is straight-lined over the term, so the revenue posting and the invoice amount differ by a deferred rent entry each month. Same tenant record, same lease record, same billing run; more lines, more schedules.
Where RIOO fits
The tenant record, the lease record and the rent run described above are what RIOO adds to NetSuite. RIOO is a property management platform built on NetSuite: the tenant is a NetSuite customer with occupancy, co-tenants, status and a tenant portal on top; the lease is a native record in leasing management carrying unit, term, charge lines, escalation, deposit and late-fee rule; renewals and effective-dated increases run through contracts and renewals; move-ins and move-outs handle inspections and deposit settlement; and rent collection applies portal payments straight to the customer ledger. Every invoice in the tables above is a NetSuite invoice created inside NetSuite, which is why the rent roll and the ledger cannot drift.
RIOO collects $160M+ in monthly rent for 400K+ tenants and occupants this way. To see a tenancy run from application to move-out in your own NetSuite account, book a demo.
Frequently asked questions
Q1. How do I manage tenants in NetSuite?
A tenant in NetSuite is a customer record, which provides the balance, aging, statements, payment methods and dunning history. The occupancy layer that NetSuite does not include, meaning the link to a unit and lease, co-tenants, guarantors, event-driven status and portal access, has to be added on top of the customer record by a property management layer.
Q2. How do I manage leases in NetSuite?
NetSuite has no lease record, so one has to be added as a custom record or through a property management application. The lease links the tenant to a unit and carries the term, charge lines with their revenue accounts, escalation terms with effective dates, deposit, late-fee rule and documents. Every invoice, renewal and move-out is then driven from it.
Q3. How do I manage rent in NetSuite?
Rent is generated from the lease record on a schedule: one invoice per tenant per period with each charge on its own line posting to its own revenue account, prorated from the lease dates. Payments apply to the open invoice through NetSuite's payment stack, late fees generate as invoice lines after the grace period, and unpaid rent ages in standard AR.
Q4. Can SuiteBilling be used for lease billing?
For simple flat monthly rent, partly. SuiteBilling handles recurring charges, proration on change orders and a percentage uplift at renewal, but a subscription has no unit, deposit, notice period, guarantor or move-out date, and its uplift applies only at renewal, not mid-term. Most operators find the lease's real terms end up in a spreadsheet beside the subscription.
Q5. Does NetSuite Lease Accounting handle the leases I collect from tenants?
No. NetSuite's Lease Accounting module, inside Fixed Assets Management, is lessee-only: it books leases you pay as right-of-use assets and liabilities under ASC 842 and IFRS 16. Leases you collect are receivables and revenue, handled through invoicing, and for commercial leases through straight-line rent schedules.
Q6. Where should security deposits post in NetSuite?
To a liability account, never to revenue, because the deposit is the tenant's money held by the landlord. It is received separately from the rent invoice, tracked on the lease, and at move-out is refunded, applied to unpaid charges, or partly retained for damage, with each portion posting to cash, receivables or recovery income. RIOO runs that settlement as part of the move-out workflow on NetSuite.
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.
.svg)
.svg)
.svg)
