The accounting problems that slow a growing property portfolio tend to be the same ten. They are a long close, spreadsheet consolidation, intercompany mismatches, late CAM and lease accounting off system. Then come deposit and trust errors, slow owner packs, manual bank matching, unclear approvals and a thin audit trail. Each one gets worse with every entity you add. The fix order matters. Clean up the data and the close calendar first, then automate, then change systems if the platform is still the limit.
I work with finance teams on close and audit. This is the list I use when a controller asks why the team works late every month. A fictional hours estimate shows where the time goes.
Where the hours go: a worked month
A fictional finance team runs 11 entities and about 2,400 units. Here is a month end before any fixes, in team hours.
| Task | Hours a month | Main cause |
|---|---|---|
| Consolidation in a spreadsheet | 46 | Entities in separate books |
| Intercompany tie out | 22 | Fees booked at different times on each side |
| Bank matching | 38 | Rent deposits batched differently by each bank |
| CAM estimates and true ups | 18 | Pools not tied to expense accounts |
| ASC 842 schedules | 12 | Leases kept in a workbook |
| Owner and investor packs | 30 | Built by copying from reports |
| Total | 166 | About one full time person |
None of these is a people problem. They come from how data flows between systems. That is why a new hire tends to buy only a month or two.
The ten challenges
1. The close runs past day seven
Steps run in sequence and wait on each other. Publish a close calendar with owners and cut off times. Our month end close checklist is a starting point.
2. Consolidation lives in a spreadsheet
Every export is a chance to drop a row. Consolidation belongs in the ledger, with entities and eliminations defined once.
3. Intercompany balances do not match
Management fees and cost sharing are booked at different times on each side. Book both sides from one entry and reconcile weekly, not at month end.
4. Bank matching is manual
Rent arrives in batches that do not match tenant lines. Set matching rules by bank and entity. See automated bank reconciliation for multiple entities.
5. CAM runs months behind
Recoverable expenses are tagged after the fact. Tag them when the bill is entered, so the true up becomes a report you run.
6. Lease accounting sits off system
A lease change in operations does not reach the ASC 842 workbook. Generate schedules from the lease record so one change updates both.
7. Deposits and trust funds get mixed
Deposits are a liability, and some states require them in a separate account. Keep them on their own ledger lines by property.
8. Owner and investor packs are slow
The pack is rebuilt by hand each month. Build it once from the same data as the GL, then schedule it. A quarterly owner report template helps.
9. Approvals are unclear
Invoices and journal entries are approved in email. Put approval limits in the system so the record shows who approved what.
10. The audit trail is thin
Auditors ask for support and the team rebuilds it. Keep the source document attached to the entry when it is posted.
Fix order that works
- Month 1. Close calendar, owners and cut off times. Chart of accounts and entity list cleaned up.
- Month 2. Bank rules, intercompany booking rule, CAM tagging at entry.
- Month 3. Owner pack built once and scheduled. Approval limits in the system.
- Month 4 onward. If consolidation and lease accounting still need spreadsheets, the platform is the limit. That is when to start a system review.
In the worked month, months 1 to 3 would typically take bank matching, CAM and the owner pack down first. Consolidation and ASC 842 hours usually need a system change. Our guide on how to choose property management accounting software covers that step.
Where RIOO fits
RIOO runs leasing, tenant ledgers, deposits, CAM and lease accounting inside NetSuite. Entities consolidate in one ledger with NetSuite OneWorld, and lease changes reach the GL as they are posted. It is built for teams that run NetSuite or plan to. See CAM reconciliation in RIOO.
FAQ
What is the hardest part of property management accounting?
For a growing portfolio, it is usually consolidation across entities and keeping leases, tenant ledgers and the GL in step.
How long should a property management month end close take?
Many multi entity teams aim for five to seven business days. The calendar and data flow matter more than the target.
Should we hire or change systems first?
Fix the close calendar and data rules first. If spreadsheets still carry consolidation or lease accounting after that, look at systems before hiring again.
