Period management and role-based approvals in NetSuite
Workflows · Month-End & Consolidation
A close that's mostly review, not reconstruction
When property workflows post to NetSuite as they happen, month-end becomes a review of current records rather than a rebuild from exports. Property P&Ls, receivables and entity consolidation come from the same live data.
Consolidated income · OneWorldReporting in USD
- RIOO Realty US
USD4,812,300 - RIOO Realty Canada
CAD1,204,950 - RIOO Realty UK
GBP842,100 - Eliminations
—(112,400)
Consolidated NOI$6,320,880
Why property close takes so long
The typical property close is a reconciliation project. Export the rent roll, compare it to the ledger, chase unposted payments, re-code repair invoices, build each entity's P&L, then roll them up in a spreadsheet. With many communities in separate LLCs, it can take weeks, and by the time the numbers are agreed they describe a month long gone. The cause is structural: operations and accounting live apart.
What is month-end close for a property portfolio?
Month-end close for a property portfolio is the process of confirming that every rent charge, receipt, vendor bill, accrual and allocation for the period is recorded, reconciled and reviewed, then locking the period and reporting results by property and entity. On RIOO, most of that activity is already in NetSuite before day one of the close.
Property close is harder than a typical company close for three reasons. There are many small cost centres, often one per building, each with its own owner or lender expecting a report. There are many legal entities, frequently one LLC or SPV per asset. And the operational systems that generate transactions, such as leasing, collections and maintenance, have historically lived outside the ledger.
How it works
The steps on RIOO
- 01
During the month
leases, payments, vendor bills and work-order costs post to NetSuite as they happen, with property context.
Real-time GL posting → - 02
Exceptions are cleared continuously
mismatched invoices, unapplied payments and overdue balances.
- 03
- 04
- 05
Depreciation
posts through NetSuite Fixed Asset Management, where your account uses it.
Fixed assets & depreciation → - 06
Review
property P&Ls, receivables aging and budget variance.
- 07
Consolidate
across entities and currencies with NetSuite OneWorld, including intercompany eliminations.
- 08
Checklist
Questions to ask about any property close process
- How many spreadsheets are touched between the rent roll and the trial balance?
- Can a consolidated figure be traced to a lease or invoice in three clicks or fewer?
- Are management fees calculated by rule or by hand each month?
- How are received-not-invoiced maintenance costs identified for accrual?
- Who can post to a closed period, and is every such posting logged?
- How long after period end do owners and lenders receive their reports?
In detail
Controls along the way
Drill-down from consolidated figures to source transactions
Consistent allocation rules
An audit trail on every adjustment
Audit season, easier
Auditors ask for support behind the numbers, often as a prepared-by-client list. When every figure traces to its lease, invoice or work order inside one system, pulling support becomes retrieval, not research.
How it works
How do teams put month-end & consolidation into practice?
Teams put month-end & consolidation into practice by configuring RIOO to their own policies, training each role on real scenarios and starting with one property or workflow before rolling out further. The examples below show how that typically looks, from set-up to day-to-day use, and which team owns each part of the work.
Because RIOO records lease, collection and maintenance activity as it happens, most steps become reviews rather than data gathering.
Fewer imports mean fewer surprises.
- 01
Confirm all rent charges posted for the period.
- 02
Review collections and unapplied cash.
- 03
Review delinquency and bad debt provisions.
- 04
Confirm accruals for received but uninvoiced work.
- 05
Review prepaid rent and deposits.
- 06
Post depreciation.
Fixed assets & depreciation → - 07
Record intercompany charges, such as management fees.
- 08
Run consolidation and eliminations (OneWorld).
- 09
Review budget variance by property.
Budgets & forecasting → - 10
Lock the period and distribute reports.
How it works
How does consolidation work across property entities in NetSuite?
Consolidation across property entities works through NetSuite OneWorld: each property-owning LLC, fund or SPV is a subsidiary with its own books and base currency, and NetSuite rolls them up through the subsidiary hierarchy with currency translation and intercompany eliminations. RIOO tags every property transaction to the right subsidiary at source.
- 01
Structure
Each owning entity is a subsidiary; properties sit beneath via class, department or location segments.
- 02
Tag at source
Leases, charges and vendor bills carry the subsidiary and property, so no re-coding is needed at month-end.
- 03
Intercompany
Management fees and shared-service charges post as intercompany transactions between the manager and owning entities.
- 04
Translate
Foreign-currency subsidiaries, such as a UK or Singapore holding, translate at period rates.
- 05
Eliminate
Intercompany balances eliminate on consolidation.
- 06
Report
Consolidated statements drill down to any subsidiary, property and source transaction.
In detail
Roles involved
Property accountants
clear exceptions and reconcile.
Controllers
review, approve and lock periods.
CFO
consolidated results and commentary.
Asset managers
property and portfolio performance.
Explore by topic
How does close differ for residential and commercial portfolios?
Residential close
Residential close is volume-driven: thousands of small rent charges, late fees, utility recoveries and concessions. The key reviews are delinquency and bad debt reserve, concessions amortisation where applicable, and deposits. RIOO's recurring charge automation means the rent run itself is rarely the bottleneck.
Commercial close
Commercial close is judgement-driven. Straight-line rent adjustments, lease incentives, CAM and service charge accruals against estimates, and percentage rent all need review. See straight-line rent revenue recognition and CAM reconciliation for how RIOO handles them.
Mixed portfolios
Mixed-use assets combine both, often with shared-cost allocations between residential and retail components. Allocation rules run by formula, so each component's P&L and each owner's statement carries its share consistently every month.
Who is RIOO's close workflow NOT for?
RIOO's close workflow is not a fit for organisations that keep their general ledger outside NetSuite. The approach depends on property transactions posting directly to NetSuite, so a business that wants property software feeding a different ERP through monthly journal imports would lose the main benefit and should look at standalone systems with export tools.
It is also not a substitute for close management software where a finance team needs task sign-offs, reconciliation certification and evidence binders across many non-property processes. RIOO makes property data current and traceable; dedicated close tools can sit alongside NetSuite for broader task governance. Confirmany close-management integrations
Month-end & consolidation in practice
An operator with 12 communities, each in its own LLC, used to spend the first weeks of each month rolling up P&Ls by hand. On RIOO, each community's books are current through the month. The close team clears a short exceptions list, posts depreciation and allocations, reviews variance and consolidates in NetSuite. The time goes into analysis instead of assembly. Placeholderapproved customer close-time result
What changes
What changes when month-end & consolidation runs on NetSuite?
When month-end & consolidation 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.
- Shorter, more predictable closes
- Earlier insightinto the month.
- Fewer manual adjustments
- Audit-ready supportfor every number.
Compare
Close calendar on RIOO: who does what, when
Confirmcalendar is not a guaranteed close duration
| Day | Activity | Owner |
|---|---|---|
| Ongoing | Charges, receipts, bills and work-order costs post with property context | System, property accountants |
| Day 1 | Confirm recurring rent run complete; review unapplied cash | Property accountant |
| Day 1–2 | Accrue received-not-invoiced work; review prepaid rent | Property accountant |
| Day 2 | Bank reconciliation by entity | Property accountant |
| Day 2–3 | Allocations, management fees, depreciation | Senior accountant |
| Day 3 | Intercompany and consolidation in OneWorld | Controller |
| Day 3–4 | Variance review by property; commentary | Controller, asset managers |
| Day 4–5 | Lock periods; distribute owner and lender packs | Controller |
In detail
Close exceptions RIOO surfaces before month-end
The fastest closes are the ones with few surprises. These exception queues, reviewed through the month, keep the close list short. Confirmstandard exception reports provided
Unapplied receipts
Payments received but not yet matched to open charges, by property.
01
Unbilled lease charges
Active leases with no charge generated for the period, often after an amendment.
02
Vendor bills on hold
Bills failing a PO or receipt match, or awaiting approval beyond a threshold.
03
Completed work orders without costs
Jobs closed in the field with no bill or time recorded, a common accrual gap.
04
Deposits out of balance
Deposit liability by property that differs from the sum of deposits on active leases.
05
Talk to a specialist
See month-end & consolidation on your own portfolio.
Property P&Ls, receivables and entity consolidation come from the same live data.
Does RIOO replace NetSuite's close tools?
No. RIOO feeds NetSuite's own close tools, such as period management, bank reconciliation, allocations and OneWorld consolidation, with current, property-tagged transactions. Rent charges, receipts, vendor bills and work-order costs are already posted with property and subsidiary context, so the close becomes a review of exceptions rather than a rebuild from exports.
Can each property have its own entity?
Yes. Each property-owning LLC, fund or SPV can be its own NetSuite subsidiary, with its own books, bank accounts and base currency, and consolidation runs through NetSuite OneWorld. RIOO tags leases, charges and vendor bills to the right subsidiary at source, so entity P&Ls need no manual re-coding at month-end.
Can we drill from consolidated results to a single property?
Yes, down to the source transaction. From a consolidated statement you can drill into a subsidiary, then a property, then the individual rent charge, receipt, vendor bill or journal entry behind a balance. Auditors and asset managers can follow the same path, which shortens the time spent answering questions about a number.
How is depreciation handled?
Depreciation runs through NetSuite Fixed Asset Management, where your NetSuite account uses it. Buildings, improvements and park-owned homes are fixed asset records with cost, method and useful life, and the depreciation schedule posts journal entries each period to the correct subsidiary and property. Without that module, depreciation can be posted by journal.
How does RIOO handle management fees between entities?
Management fees can be calculated by rule, such as a percentage of collected rent per property, and posted as intercompany charges from the managing entity to each owning subsidiary. In OneWorld these balances eliminate on consolidation, while each owner's statement still shows the fee charged to that property. Confirmmanagement fee automation scope
Can different subsidiaries close on different schedules?
Yes. NetSuite period management lets you close accounting periods by subsidiary, so an entity that is ready can be locked while another is still being reviewed. Consolidated reporting runs once the required subsidiaries are closed, and any later adjustment needs a role with permission to post to a closed period.
How long should a property month-end close take?
There is no single right answer, because close length depends on the number of entities, property types and manual steps. Many property finance teams aim to close within the first week of the following month. With transactions posting to NetSuite as they happen, the remaining effort is mostly exception review and analysis. Confirmavoid stating a guaranteed close duration
What reports should be ready at the end of the close?
Most portfolios finish the close with a trial balance by entity, property income statements, budget variance with commentary, receivables aging, deposit liability reconciliation and the consolidated statements. Owner and lender packs are built from the same reports, so external figures match the ledger exactly and need no re-keying.
Related
Related to month-end & consolidation
Make month-end the least dramatic week of the month.
