The rent roll is the business: property management software that earns its keep
A property portfolio is a machine for converting occupancy into cash flow, and the rent roll is its dashboard. When the roll lives in a spreadsheet, the machine runs on memory.
Strip a property business to its skeleton and one document remains: the rent roll — every unit, its occupant, its lease terms, what is due, what has arrived, what is late. Everything else (maintenance, marketing, financing) exists to keep that document healthy. Which makes it strange that in most small and mid-size portfolios, the roll is a spreadsheet updated from memory.
How the spreadsheet roll rots
- Occupancy drifts: a unit is "vacant" in the sheet, occupied in reality, because the handover happened on WhatsApp.
- Escalations are forgotten: the 10% step in year two of a lease nobody reread — recurring, silent revenue loss.
- Backdated receipts land on today: paid-on-the-1st recorded on the 9th quietly rewrites arrears history.
- Expiries surprise: a strong tenant's lease lapses into month-to-month because no one was watching the date.
- Deposits blur: held money mixed with income until a move-out demands a number nobody has.
What to demand from property software
- 1One property spine — property → unit → lease → tenant — where a unit's status has a single writer, not three screens that can disagree.
- 2Money on the same spine: rent due generated FROM lease terms; receipts posting to real books, on the date they actually occurred.
- 3Derived truth: overdue and expiring-soon computed from dates every time they are displayed — a stored "overdue" flag is stale by definition.
- 4Instalment sales beside leases, if you sell: bookings, plans and collections are half the business in this region's market.
- 5The roll as a live view — filterable by property, exportable the day a bank or a buyer asks.
This is the architecture behind Ofivio Real Estate: properties and units on one spine, tenants and buyers, leases generating the rent roll, sale bookings with instalment plans — and rent and instalments posting straight to the same double-entry books the rest of Ofivio keeps. Occupancy has one writer; overdue and expiring are computed, never stored; the roll is a view of the truth rather than a document beside it.
A rent roll that cannot drift from reality — properties, leases and books on one spine.
See Ofivio Real EstateRelated reading
What is Ofivio? One spine, six products, explained in five minutes
Ofivio (that's O-F-I-V-I-O — not "oficio") is a software platform for project-driven businesses, built in Pakistan and used by design practices, contractors and the firms around them. This is the five-minute map of what it is and how the pieces fit.
Double-entry for builders: construction accounting without the mystery
A construction firm that only tracks cash knows what it spent but never what a project actually cost or earned. Double-entry is the 500-year-old fix — and it maps onto site life better than most builders expect.