RIOO Home and RIOO Professional capabilities in one environment
Rioo Professional · Mixed Portfolios
Residential and commercial, finally in one system
Run apartments, offices, retail and industrial in one environment, each with its own workflows, while finance gets one set of books and one consolidated view. Confirm"Mixed portfolios" as a named solution
Harbor Square · mixed-use
| Unit | Type | Rent | Status |
|---|---|---|---|
| Res 4B | Residential | $1,850 | Current |
| Retail 2 | Retail | $7,900 | Current |
| Office 3 | Office | $11,200 | CAM due |
Two systems is one too many
Many operators hold both residential and commercial assets, and a growing number own mixed-use buildings with retail at street level, offices above and homes on top. The usual answer is two property systems, one for each, reconciled into a single ledger. That means two sets of training, two data models and a monthly reconciliation that exists only because the software is split.
RIOO supports both from one platform. Residential and commercial processes can coexist, each configured for its own needs, writing to the same NetSuite records.
Why one platform matters here
With separate systems for each segment, allocations and consolidated reporting become a spreadsheet exercise every month.
What is mixed-use property management?
Mixed-use property management is the operation of buildings or portfolios that combine residential, retail, office or other uses, each with its own lease types, tenant expectations and regulations, while sharing structure, services and often ownership. RIOO manages every use on one platform in NetSuite, with costs shared by rule and results reported by segment.
The challenge is that each use pulls the building in a different direction. Residents expect quiet, security and fast repairs; retailers want footfall, signage and long trading hours; office tenants want reliable services and clear service charges. The landlord has to balance those interests physically and financially, which means knowing exactly what each segment earns and costs.
How RIOO helps
Separate workflows, same platform. Workflows are configurable at property or community level, so a residential renewal and a commercial lease approval follow different chains simultaneously.
Clean cost splits in mixed-use buildings. Expenses can be tagged and split by property segment, tenant type or category, so residential and commercial portions report separately.
One leasing engine, two styles. High-volume residential leasing and complex commercial leasing run on the same engine.
One ledger, many entities. Each property or segment can sit in its own entity, with consolidation through NetSuite OneWorld.
One portfolio view. Occupancy, income and expenses across every asset class in the same dashboards.
Workflows & customization →Financial & operational expenses →Leasing management →Multi-entity & OneWorld →Dashboards & reports →
How it works
How does mixed portfolios work in RIOO?
Mixed portfolios in RIOO runs inside Oracle NetSuite. The properties, units, leases, tenants and vendors it uses are native NetSuite records, so each step updates the same data finance reports on. There is no separate system to sync, and every action keeps an audit trail. The steps below show how the work flows.
- 01
Model
each property and, in mixed-use buildings, each segment.
- 02
Configure
workflows, charges and approvals per segment.
- 03
Allocate
shared building costs across segments by rule.
- 04
Operate
leasing, collections and maintenance in one system.
- 05
Report
by segment, entity or the whole portfolio.
Compare
How are shared building costs allocated between segments?
Shared building costs are allocated between segments using a documented basis for each cost pool, most often floor area, but sometimes usage, headcount or a fixed percentage set in leases. RIOO applies the basis by rule each month, so the residential, retail and office shares post to their own accounts and recovery pools in NetSuite. Confirmallocation engine configuration
| Shared cost | Common allocation basis | Who ultimately pays |
|---|---|---|
| Lifts and escalators | Floor area of segments served | Recovered from commercial; residential via service charge or owner |
| Security and concierge | Agreed percentage or area | Split per lease and owner policy |
| Building insurance | Reinstatement value or area | Recovered where leases allow |
| Roof and structure repairs | Area, or capital reserve | Often owner or reserve fund |
| Utilities for common areas | Sub-meter or area | Recovered by segment |
| Car park | Spaces allocated per segment | Charged as parking income or recovery |
How it works
How does a mixed-use acquisition get onboarded?
A mixed-use acquisition gets onboarded by modelling the building and its segments, loading leases by type, setting allocation rules for shared costs, and creating or attaching the owning entity in NetSuite. Doing this in a consistent order means the first month's reporting already splits income and costs correctly by use.
- 01
Model the building
Create the property, segments and every unit, shop and office suite.
- 02
Set up the entity
Add the owning company as a subsidiary or link it to an existing one.
- 03
Load leases
Residential tenancies and commercial leases with their charge schedules and deposits.
- 04
Define cost pools
Shared services, their allocation bases and recovery rules.
- 05
Open balances
Load arrears, deposits and prepaid amounts reconciled to the vendor's records.
- 06
Report
Run segment and consolidated reports for the first period and compare with the business plan.
In detail
What can RIOO do for mixed portfolios?
RIOO handles mixed portfolios with capabilities built on NetSuite records rather than a separate database. Each capability below works with the same properties, leases, tenants and ledger, so operations and finance see one version of the data. Capabilities are configured to your policies during implementation, without custom code for routine changes.
Property-level workflow configuration
Segment-level expense tagging and allocation
Unified tenant and resident profiles across asset types
Consolidated and segment reporting on NetSuite
Explore by topic
How do mixed-use leases differ across segments?
Residential above
Residential units carry shorter tenancies, deposits, and statutory rules on notice, repairs and rent increases. Service charges, where they apply, are usually simple and often capped by law or practice. High volumes of small transactions dominate.
Retail at street level
Retail leases often include turnover rent, service charges or CAM, marketing contributions, trading-hour obligations and exclusive-use clauses. Shop frontage and signage matter, and retailers expect detailed reconciliation of recoverable costs each year.
Offices in between
Office leases typically run for several years with rent reviews, break options, service charges and fit-out incentives. Tenants scrutinise service charge budgets and expect clear apportionment of shared building services.
Who is RIOO for mixed-use property NOT for?
RIOO for mixed-use property is not aimed at owners whose mixed-use assets are managed entirely by third-party agents who report only monthly totals. Without tenant-level leases and transactions in-house, there is little for RIOO to manage; a summary journal per building in NetSuite may serve better.
It is also not designed for hotel components within mixed-use schemes. Hotel rooms sold by the night need a hospitality property management system with channel and housekeeping functions. RIOO can record the hotel operator's lease or management agreement, but not run the hotel itself.
Mixed portfolios in practice
A mixed-use building's annual elevator contract is split by rule between retail, office and residential segments. The retail share flows into recoverable expenses, the office share into the office recovery pool and the residential share into operating costs. The asset manager sees a single building P&L with three clean segment views, with no spreadsheet in sight.
What changes
What changes when mixed portfolios runs on NetSuite?
When mixed portfolios runs on NetSuite through RIOO, operational work and accounting stop being two separate jobs. Transactions post to the general ledger as they happen, reports use the same records as daily work, and controls come from NetSuite roles and approvals. The changes below are the ones teams usually notice first.
- One system to train, secure and maintain
- No inter-system reconciliation
- Clean segment reportingfor owners and lenders.
- Flexibilityto acquire any asset class.
Mixed-use example
Consider a building with ground-floor retail, two office floors and apartments above. Retail tenants pay base rent plus percentage rent and CAM. Confirmpercentage rent Office tenants pay escalating base rent and recoveries. Residents pay monthly rent and utilities via RUBS.
In RIOO, each space is a unit on the same property with the right lease type. Shared costs, such as security, elevators and roof repairs, are allocated across segments by rule. Reporting splits NOI by segment while rolling up to the building and the entity.
In detail
Mixed-use reporting owners and lenders ask for
Mixed-use assets attract lenders and investors who want to see each use's performance separately. RIOO's segment tagging supports these views from the same ledger.
NOI by segment
Residential, retail and office income and expenses, with shared costs allocated consistently.
01
Occupancy by use
Units, shops and office floors measured on their own terms.
02
Lease expiry by segment
Commercial income at risk shown separately from residential turnover.
03
Recovery rate
Recoverable costs billed back as a share of costs incurred, by segment.
04
Arrears by tenant type
Retail, office and residential arrears trends compared.
05
Checklist
Mixed-use setup checklist
- Define segments for every use in the building and agree their boundaries.
- Record floor areas and their measurement basis for each segment and unit.
- Document the allocation basis for every shared cost pool.
- Check commercial leases for caps, exclusions and recovery percentages.
- Decide whether each segment sits in its own entity or a shared one.
- Agree segment reporting formats with owners and lenders before go-live.
Talk to a specialist
See mixed portfolios on your own portfolio.
Run apartments, offices, retail and industrial in one environment, each with its own workflows, while finance gets one set of books and one consolidated view.
Can residential and commercial processes really coexist?
Yes. Workflows are configured per property or community and can run side by side, so a residential renewal within policy passes quickly while a commercial lease approval follows a longer chain. Both write to the same NetSuite records, which means finance sees one ledger and one consolidated view across every asset class.
How are shared costs in a mixed-use building handled?
Shared costs are tagged and split by segment, tenant type or category using a documented allocation basis, most often floor area. RIOO applies the rule each period, so residential, retail and office shares post to their own accounts and recovery pools, and each segment's NOI reflects its fair share of building costs.
Do we need two systems?
No. Mixed portfolios run RIOO Home and RIOO Professional capabilities in one environment on one NetSuite account, so there is no second system to secure, administer or reconcile. Residential and commercial leases keep their own workflows and reports, while finance closes one set of books for the whole portfolio.
Can each segment be its own entity?
Yes, using NetSuite's multi-entity capabilities. Residential, retail and office components can each sit in their own subsidiary with separate books and bank accounts, while the building is managed as one property in RIOO. Consolidation through OneWorld combines them for owner and lender reporting whenever a whole-building view is needed.
Can residential and retail tenants share one service charge budget?
They can, but most landlords split the budget into schedules so each use pays only for services it receives. Residents rarely benefit from mall marketing, and retailers do not use residential lifts. RIOO supports separate schedules per segment, with shared items apportioned by an agreed basis and documented for tenants. Confirmservice charge schedules
Can one building be owned by several entities?
Yes. Where different companies own the residential and commercial parts, each can be a separate NetSuite subsidiary with its own books, while the building is managed as one property in RIOO. Shared costs are allocated across the entities by rule, and consolidated reporting shows the whole building when needed. Confirmcross-entity allocation
Related
Related to mixed portfolios
Manage every asset class on one record.
