rent roll software in Kenya turns a pile of leases into one table that shows every unit, every tenant, every rent and every balance due. A landlord in Kilimani with forty units can answer “what is this building earning?” in under a minute.
The rent roll is the single most requested document in property management, and it is also the one most often assembled by hand. That mismatch explains a great deal of avoidable confusion.
What a Rent Roll Actually Measures
A rent roll is a snapshot, not a history. It describes the position on a chosen date: who occupies each unit, what they pay, when the lease ends and what they owe.
rent roll software in Kenya fixes that snapshot to a specific date so comparisons between months remain honest.
The document answers questions that owners, lenders and buyers all ask in slightly different words. How much income is contracted? How much is actually collected? How much space is empty?
Most confusion comes from mixing contracted rent with collected rent. Both numbers matter, but only one pays the mortgage.
rent roll software in Kenya keeps the two side by side so nobody has to choose which to present.
A rent roll that hides arrears is not a rent roll. It is a marketing document, and lenders learn to spot the difference quickly.
The date on a rent roll matters as much as the figures inside it. A roll dated the first of the month and one dated the last describe different realities in the same building.
Readers should also know what is excluded. A roll that leaves out service charge or parking understates income and invites the wrong conclusion about yield.
The Unit Inventory Behind Every Roll
You cannot report on a unit that does not exist in the system, and you cannot trust a report where the same unit exists twice.
rent roll software in Kenya begins with a clean inventory: block, floor, unit number, bedrooms, size and parking.
Duplicate entries usually appear after a renovation or a subdivision. The old unit lingers, the new one is created, and the totals quietly inflate.
rent roll software in Kenya requires a unit to be retired rather than deleted, which preserves the history without distorting the present.
Size matters more than most managers admit. Service charge allocation, market rent comparisons and valuation per square metre all depend on it.
Unit type should be recorded in a way that allows grouping. Studios, one bedrooms and three bedrooms behave differently in the market and in a report.
rent roll software in Kenya groups the inventory so vacancy and rent per unit type can be reviewed without exporting anything.
An inventory that is accurate to the bay and the meter becomes the foundation for every other record in the building.
Floor plans and numbering conventions should match the physical building. When the system says Unit B4 and the corridor says B3, every inspection turns into a debate.
A short annual walk-through against the register catches changes nobody recorded, from a converted store to two bedsitters quietly merged into one.
Reading a Roll Line by Line
Each line of a rent roll should tell a complete short story about one tenancy. Tenant name, unit, start date, end date, rent, deposit and balance are the minimum.
rent roll software in Kenya presents those fields in a fixed order so a reader does not have to hunt for them on every line.
Status is the field most often missing. A unit can be occupied, vacant, under notice or reserved, and each status changes what the income figure means.
rent roll software in Kenya records status alongside the lease so a vacant unit never appears occupied by accident.
Comments should be short and factual. “Tenant promised to clear by 15th” is useful, while a paragraph of speculation is not.
Totals should be computed by the system rather than typed at the bottom of a spreadsheet. Manual totals are where most rent rolls quietly break.
A reader should be able to find any unit in seconds, which means the sort order should follow the building rather than the alphabet.
Columns nobody uses should be removed. A wide sheet with eighteen fields trains the eye to skip all of them, including the ones that matter.
Rent, Service Charge and Other Income
Rent is rarely the only line in a tenancy. Service charge, parking, water, security and sometimes furniture all add to the monthly figure.
rent roll software in Kenya separates each income line so the owner can see which components are growing and which are stable.
Service charge should be shown as a distinct stream. It belongs to the building’s operations, and treating it as landlord income flatters the yield.
Parking charges are small individually and significant in aggregate. A block with sixty bays at a modest monthly fee is collecting real money that is often unbilled.
rent roll software in Kenya attaches those ancillary charges to the unit so they appear on the invoice automatically.
Utility recoveries need a stated method. Whether they are metered or apportioned, the rent roll should show the figure and the basis behind it.
rent roll software in Kenya records the basis once and applies it consistently across every unit.
Where a landlord offers a rent-free period, it should appear as a concession rather than a lower rent. The distinction matters at review time.
Billing frequency should be recorded per tenancy. A commercial tenant paying quarterly is not late in month two, and a roll that ignores this chases the wrong people.
Escalation clauses should show the next increase date and the formula applied, so the invoice changes at the right moment without an argument.
Deposits and Their Treatment
A deposit is not income, and a rent roll that counts it as income is misleading. The money is held, not earned.
rent roll software in Kenya tracks deposits in a separate account within the tenancy record so the rent roll stays clean.
The deposit figure should match what is actually held in the bank. A record that says one thing and a statement that says another is a reconciliation problem waiting to surface.
rent roll software in Kenya makes the deposit balance visible on the same screen as the rent, which encourages the comparison.
Interest on deposits is rarely an issue in Kenya at small scale, but commercial tenancies sometimes address it in the lease. The record should follow whatever the lease says.
Deductions at move-out should reduce the held deposit and never the rent line. Mixing the two creates a set of accounts nobody can explain at year end.
Where a deposit is held by an agent rather than the landlord, the record should name the holder. Responsibility shared vaguely is responsibility that disappears.
A deposit ledger that ages alongside the tenancy makes handover straightforward, because the incoming manager can see what is held and for whom.
Vacancy Loss and the Cost of Delay
Vacancy is not a single number. It is the rent that would have been earned if the unit had been occupied, and that figure is what owners actually feel.
rent roll software in Kenya calculates lost rent from the date the unit became vacant rather than from the end of the month.
Days vacant is the most useful operational metric in a rent roll. It converts a vague concern about marketing into a specific number that can be managed.
rent roll software in Kenya shows days vacant by unit so the manager can see which properties need attention first.
A unit vacant for ninety days in a competitive area usually has a pricing problem. A unit vacant for ninety days after a refurbishment has a handover problem.
rent roll software in Kenya keeps the vacancy history so the reason can be traced rather than guessed.
Lost rent should be compared against the cost of the remedy. A modest rent reduction that lets a unit in three weeks often beats holding out for two months.
Marketing spend should be recorded against vacant units. It rarely changes the outcome on its own, but it shows whether the effort matches the loss.
A unit that is vacant and also under repair should carry both statuses. Reporting it as available while the floor is still wet misleads everybody.
Arrears Ageing on the Roll
Arrears belong on the rent roll because the roll is where a reader looks for the truth about income. Hiding them in a separate schedule defeats the purpose.
rent roll software in Kenya ages every balance into current, thirty, sixty and ninety-plus days.
A single tenant with a large balance can distort an otherwise healthy building. The ageing view makes that concentration obvious.
rent roll software in Kenya shows the arrears by tenant and by unit so the risk can be discussed with specifics.
Part payments should be applied to the oldest invoice first unless the tenant specifies otherwise. That convention keeps the ageing credible.
The convention applies automatically, and any exception is recorded.
Disputed amounts need their own flag. An amount in dispute is different from an amount that is simply unpaid, and the follow-up differs too.
Ageing should be calculated from the invoice date rather than the month end. That small choice determines whether a tenant at day thirty-one appears in the right bucket.
A tenant who has always paid on time deserves a different first reminder from one with a long history of arrears. The record should make that distinction easy.
Lease Dates and Expiry Clusters
A rent roll without dates is a list, not a plan. Expiry dates determine when income is at risk and when negotiations must begin.
rent roll software in Kenya tracks the start date, the end date and the notice period for every tenancy.
Expiry clusters are the hidden risk in many buildings. Six leases ending in the same month can wipe out a quarter’s income if the market turns.
rent roll software in Kenya charts expiries by month so the manager can stagger renewals where possible.
Notice periods should be calculated rather than remembered. A lease requiring sixty days means the conversation starts two months before the end date.
rent roll software in Kenya raises a reminder at the correct point using the lease terms themselves.
Options to renew should be recorded too. A tenant with a contractual right to extend is a very different prospect from one without.
Break clauses matter as much as end dates. A lease that can be terminated at twelve months carries more risk than its headline term suggests.
Where a lease has not been signed but the tenant has moved in, the roll should show the gap plainly rather than assuming the terms.
Market Rent Against Contracted Rent
Contracted rent is what the lease says. Market rent is what a new tenant would pay today. The gap between them is the owner’s opportunity or problem.
rent roll software in Kenya stores both figures so the comparison is visible on the same line.
A portfolio where contracted rent sits well below market looks stable until renewal season, when the correction arrives all at once.
rent roll software in Kenya highlights units where the gap exceeds a threshold the manager sets.
Comparable evidence should be recorded, not assumed. Three recent lettings in the same area are more persuasive than a general impression of the market.
rent roll software in Kenya attaches those comparables to the review so the number has a foundation.
Reviews should be gradual where the market allows. Small annual adjustments are easier for tenants to absorb than a large correction every three years.
The gap between contracted and market rent is not automatically a gain. Closing it may require a refurbishment that eats the difference for two years.
A unit priced above market should be flagged as clearly as one priced below. The first is a vacancy risk, the second a revenue risk.
Market evidence should be refreshed at least twice a year. Rents move quickly in Nairobi’s newer suburbs, and a figure from eighteen months ago is an opinion.
Tenant Mix and Concentration Risk
A rent roll reveals more than income. It shows whether one tenant provides half the building’s revenue, which is a risk nobody discusses until it materialises.
rent roll software in Kenya calculates each tenant’s share of total rent so concentration is visible.
Commercial blocks are especially exposed. A single anchor tenant leaving can turn a profitable building into a problem in one quarter.
rent roll software in Kenya shows the tenancy mix by unit type and by lease size.
Diversification is not always possible in a small block, but it should at least be known. Owners make better decisions when the exposure is explicit.
Residential blocks carry a different risk: too many short tenancies means constant turnover and higher costs.
rent roll software in Kenya shows average tenancy length so the manager can see whether the building is stable or churning.
Concentration should be measured on collected rent as well as contracted rent. A large tenant who pays late is a bigger problem than the schedule implies.
Diversity of use matters in mixed buildings. A ground floor let to a bar can affect the residential floors above it in ways the roll never records.
Tenant quality should be assessed with evidence rather than instinct. Payment history, references and the length of previous tenancies all belong in the file.
A building with one difficult tenant and nine good ones is manageable. The same ratio inverted is a portfolio problem hiding inside a single address.
Reconciliation With the Bank
A rent roll that does not reconcile to the bank is a wish list. The two records must meet, and the meeting point should be documented.
rent roll software in Kenya compares expected receipts against actual bank credits and flags the difference.
M-PESA payments make reconciliation harder and faster at the same time. Each transaction carries a reference, but only if the tenant was given one.
rent roll software in Kenya issues a unique reference per unit so the payment finds its home without manual matching.
Unmatched receipts should be listed daily, not monthly. A payment sitting in suspense for three weeks is a complaint waiting to happen.
rent roll software in Kenya presents the unmatched list with likely candidates for quick resolution.
Bank charges, reversals and bounced cheques all need a place in the record. Silent adjustments make the roll impossible to audit.
Reconciliation should be signed off monthly by someone other than the person who posted the receipts. That single control prevents most quiet losses.
A reconciliation that is always “nearly done” is a warning sign. Either the volume is too high for the process or the process is not being followed.
Cut-off matters at month end. A payment received on the last day but credited on the first belongs in one month, and the roll should say which.
Comparing the bank balance to the roll’s closing position is a quick sanity check. If the two drift apart, the cause is usually an unrecorded refund or a duplicate receipt.
Rolling Forward Month by Month
A rent roll is most useful when it can be compared with its own past. A single snapshot tells you where you are, while a rolling series tells you where you are going.
rent roll software in Kenya stores each month’s roll so trends can be reviewed without rebuilding old files.
Rent growth, vacancy and arrears should all be visible as a short series. Three months of data is enough to spot a direction.
rent roll software in Kenya presents those series in one view for the owner’s monthly pack.
Reasons for movement should be recorded, not just the movement itself. A drop in income caused by one departure is a different story from a gradual decline.
rent roll software in Kenya allows a short note against each month so the explanation survives staff changes.
Rolling forward should not mean copying forward. Each month should be generated from the leases, not from last month’s file.
A roll that is only produced when someone asks is a roll that is always out of date. Monthly generation keeps the number trustworthy.
Comparisons across a year reveal seasonality that a single month hides, especially in student housing and short-let buildings.
A rolling series also exposes slow leaks. A five per cent decline in collected rent over six months is invisible in any single report and obvious in a chart.
Trend notes should be written in plain language. The owner wants to know what changed and why, not a commentary on the arithmetic.
Reporting a Roll to Owners and Lenders
Owners want a summary. Lenders want detail. The same underlying data should serve both without two separate exercises.
rent roll software in Kenya produces an owner summary of contracted rent, collected rent, vacancy and arrears.
Lenders typically ask for the full schedule with lease dates and deposits. That version should be one export away, not a week of work.
rent roll software in Kenya generates the detailed schedule with the fields a credit team expects to see.
Consistency between reports matters more than polish. A lender who receives three different formats will ask uncomfortable questions about the records.
One template keeps every report looking the same each month.
Notes on unusual items should accompany any report. A single large arrears balance explained in advance is far less alarming than one discovered on review.
Reports should be dated and versioned. An owner comparing two files with the same name needs to know which one is current.
The best report is short enough to read on a phone and detailed enough to answer the second question. That balance is worth designing deliberately.
Valuing a Block From the Roll
Valuers work from income, and the rent roll is the evidence behind that income. A clean roll supports a higher valuation with less argument.
rent roll software in Kenya shows contracted rent, market rent and vacancy in the format a valuer can use directly.
Capitalisation depends on confidence in the income stream. Gaps in the record translate into a risk premium that reduces the price.
rent roll software in Kenya keeps the history that lets a valuer see stability rather than a single good month.
Service charge accounts should be separated from rent so the valuer can assess the building’s operating cost independently.
rent roll software in Kenya produces that separation without a manual rebuild.
A sale process that begins with good records usually closes faster, and speed itself has a price.
Valuers also look at lease quality. Long tenancies with credible tenants support a lower capitalisation rate than a set of monthly arrangements.
The roll should therefore show lease term alongside rent. Income that could disappear in thirty days is worth less than income secured for three years.
Budgeting From Actual Income
Budgets built on hope fail quietly. Budgets built on the rent roll fail visibly, which is far more useful.
rent roll software in Kenya feeds contracted rent into the budget so the income line starts from evidence.
Vacancy should be budgeted as a percentage based on history, not assumed to be zero. Every building has some turnover.
rent roll software in Kenya shows the vacancy trend so the assumption has a basis.
Costs should be budgeted per unit as well as in total. A per-unit figure makes comparisons between buildings meaningful.
Cost per unit can then be calculated from the recorded expenditure.
When actuals diverge from budget, the roll should show where. A variance that cannot be traced to a line is a variance nobody can fix.
Budgeting should start two months before the year begins, using the roll as it stands rather than last year’s assumptions.
Owners should approve the assumptions, not only the totals. A budget agreed on stated vacancy and growth figures is much harder to reopen later.
Common Errors That Distort a Roll
Most bad rent rolls fail for the same handful of reasons, and all of them are preventable.
rent roll software in Kenya prevents the most common error by generating totals rather than accepting typed ones.
Double-counting is the next. A unit listed under two tenants, or a charge entered twice, inflates income in a way that only reconciliation catches.
rent roll software in Kenya enforces one active tenancy per unit at a time.
Stale data is the quietest error. A tenant who left in March but still appears in June makes every total wrong.
rent roll software in Kenya requires a move-out date before a tenancy can be closed.
Deposits counted as income is the error lenders notice first, because it flatters the yield in a way that does not survive scrutiny.
rent roll software in Kenya keeps deposits outside the income lines by design.
Rounding errors look trivial until a building has two hundred units. The totals should come from unrounded figures and be rounded only for presentation.
Finally, the roll should be checked by someone who did not prepare it. A second pair of eyes finds the duplicated unit that the author cannot see.
Currency is rarely an issue in residential lettings, but commercial leases sometimes price in dollars. Each line should state its currency rather than assume one.
Controls, Access and Audit Trail
A rent roll is a financial document, and financial documents need controls. The size of the building does not change that principle.
rent roll software in Kenya records who changed a rent, when, and from what figure to what figure.
Approval should be required for any change to a lease term or a rent amount. Verbal instructions are how disputes begin.
rent roll software in Kenya routes changes through an approval step so the record shows consent.
Access should be role-based. A caretaker needs to see units and repairs, while a landlord needs to see income and arrears.
Those views should be separated without maintaining two sets of data.
The audit trail should be readable by a non-accountant. A log that only a developer can interpret provides no real protection.
Exports should be controlled as tightly as edits. A downloaded rent roll contains tenant names, phone numbers and balances, and it travels easily.
Backups should be tested rather than assumed. A backup that has never been restored is a hope, not a control.
Training should cover the exceptions, not only the routine. Most damage happens when someone improvises a workaround for a lease that does not fit the standard form.
The person who approves a change should not be the person who benefits from it. That principle is simple, and it prevents most of the arguments that reach a lawyer.
Where several staff share a login, the audit trail becomes decorative. Named accounts cost nothing and turn a helpful feature into an actual control.
A monthly review of the change log takes ten minutes and catches most irregularities early, long before they become a reconciliation problem.
Managers who keep the log tidy also find handover easier, because the story of each change is already written down when the next person arrives.
Where Rent Roll Practice Is Heading
Kenyan property is becoming more professional, and the rent roll is moving from a monthly spreadsheet to a live record.
rent roll software in Kenya makes the roll a working document that updates as payments arrive and leases change.
Lenders and buyers are asking sharper questions than they did five years ago. A manager who can answer them quickly wins the mandate.
rent roll software in Kenya provides the answers from the same dataset that runs the building day to day.
Tenants benefit too, because a clean roll means accurate invoices and fewer arguments about what was paid.
rent roll software in Kenya keeps the tenant’s view consistent with the owner’s view.
The buildings that age well are the ones where the paperwork was never allowed to drift. The rent roll is where that discipline shows first.
rent roll software in Kenya is simply the tool that makes the discipline repeatable across every unit and every month.
Small landlords sometimes assume this is a problem for institutions. In practice, a six-unit block benefits most, because there is no clerk to hold the details in their head.
The rent roll is unglamorous work that decides whether a property is an asset or an argument. Doing it properly is the whole job in miniature.
