How to Keep a Rent Roll Updated: 4 Steps Every Landlord Needs

TL;DR: A rent roll lists every unit, tenant name, lease start and end dates, monthly rent, deposit amount, and rent-paid status. Update it every time a tenant moves, a lease renews, or rent changes — not just annually. Store it in a spreadsheet or property app, back it up monthly, and reconcile it against bank deposits quarterly to catch missing payments or manual errors before they compound.

_Last reviewed: July 2026 · 6 min read_

Most landlords start a rent roll when they buy a property or inherit tenants, then only touch it when someone moves out. The problem: rents change mid-term, leases auto-renew at old rates, and deposit accounting drifts out of sync with reality. By the time you notice a $50 rent hike was never logged or a departing tenant's deposit was never returned in your records, you've lost the paper trail. A current rent roll prevents that — it's the single document that tells you who owes what, when they owe it, and whether you've been paid.

Okoniq Property Hub keeps your rent roll current automatically: every rent payment you log updates the tenant ledger in real time, lease-end dates trigger reminders to renew or update terms, and you can pull a snapshot for your tax preparer or lender without hunting through bank statements.

What information belongs in a rent roll?

At minimum: property address, unit number (if multi-family), tenant full name, lease start date, lease end date, monthly rent amount, security deposit held, and a paid/unpaid flag for the current month. Optional but useful: tenant phone and email, move-in date (distinct from lease start if the tenant was month-to-month first), prorated amounts for partial months, pet deposits, parking fees, and notes about rent increases agreed upon. If you manage multiple properties, add a property column so you can filter by building. Some landlords include utility responsibility (tenant-paid vs. landlord-paid) in a notes column to avoid confusion during turnovers. The goal is that anyone looking at the roll — you, a CPA, a buyer during due diligence — can see the full rent picture without asking follow-up questions.

Never store payment history in the rent roll itself; that belongs in a separate tenant ledger or accounting log. The rent roll is a snapshot of the agreement — who's supposed to pay what — not a transactional record. If you need to prove payment, that's a bank statement or receipt match, not a spreadsheet edit. Keep the two functions separate to avoid overwriting data when you update current-month status.

How often should a landlord update a rent roll?

Update it every time a triggering event happens: a tenant moves in, a tenant moves out, a lease renews, rent increases per the lease or local law, or a deposit is applied toward damage and the held amount changes. For most owner-operators, that means 2-4 updates per unit per year — move-in/move-out cycles plus annual renewals. If you have month-to-month tenants, update when you send a rent-change notice that takes effect. Don't wait for the end of the year; by then you've forgotten which tenant got the February hike and which one you agreed to hold flat because they signed a two-year term.

Set a monthly reminder to reconcile the paid/unpaid column against your bank deposits. Mark each unit as paid for the month when rent clears. If a tenant pays late, note the date in a separate column or comment so you have a record if nonpayment becomes an eviction issue. This monthly check catches missed ACH transactions, bounced checks, or tenants who short-paid without you noticing until the next month. A quarterly deep-check — matching total collected rent to the roll's expected income — ensures no formula errors or missed updates have compounded. Many landlords discover during tax season that they collected $14,400 but the rent roll claims $15,000 annual income; by then, finding the missing payment is archaeology.

Where should you store and back up a rent roll?

A cloud spreadsheet (Google Sheets, Excel Online) is the simplest: automatic saves, version history, and accessible from your phone when a tenant texts about move-out. If you use property-management software or an app like Okoniq Property Hub, the rent roll lives inside the tenant module and updates when you log payments or edit lease terms. Either way, the file must be backed up off your local machine — hard drives fail, laptops get stolen. If you're still using a desktop Excel file, set a monthly calendar event to upload a copy to Dropbox, Google Drive, or a password-protected folder on an external drive.

Never store the rent roll in email drafts or a notes app; those aren't searchable by unit or date, and you'll lose edits if you accidentally delete the message. Some landlords print a quarterly snapshot and file it with tax docs; that's fine as a backup, but paper can't be filtered or summed, so keep a digital master. If you have a business partner or property manager, grant them view-only or edit access depending on role — one person should own the file to prevent conflicting updates. Version-control features in Google Sheets or SharePoint let you roll back if someone accidentally sorts the sheet without selecting all columns and scrambles tenant-unit pairings.

What mistakes cause rent rolls to drift out of date?

The most common error: updating the lease-end date but forgetting to update the rent amount when a renewal includes a rent increase. The tenant signs a new lease at $1,250/month, you enter the new end date of December 2025, but the rent column still shows $1,200. Six months later, you're under-collecting $50/month and the tenant has proof via the old lease line-item that you never corrected. Always edit both fields in the same session, or use a property app that forces you to confirm rent amount when renewing a lease.

Second mistake: not logging mid-lease rent increases allowed by statute. If your state permits annual CPI adjustments with 60 days' notice, and you send the notice, update the roll the day the notice is delivered — not the day the increase takes effect. That way, your reminder to expect the higher payment is already in place. Third mistake: deleting a row when a tenant moves out. Mark the lease as ended and move the row to an "Archived Tenants" tab or sheet; you may need the deposit or move-out date for a tax question or small-claims case months later. If you delete the row, that history is gone unless you remember to check an old backup.

Finally: rounding errors in prorated rent. If a tenant moves in on March 15 and you charge them half-rent, log the March amount as the prorated figure and add a note that April is the first full month at $X. Don't try to adjust the "monthly rent" field to show the proration; it confuses your annual income sum and makes the roll misleading to a lender reviewing it for a refinance.

How does a rent roll help during tax season or a property sale?

Your CPA needs total rent collected by year, plus any mid-year changes that explain why collected income doesn't equal (months × stated rent). A current rent roll lets them spot uncollected amounts that should be written off or pursued, and it documents lease terms if the IRS asks why your Schedule E shows $14,200 when leases claim $15,000. If you collected a deposit mid-year, the roll confirms it's held, not income. During a sale, the buyer's lender will require a rent roll as part of underwriting — they want proof that the rents you claim on the pro forma match signed leases. If your roll is six months stale or shows units vacant that you verbally say are occupied, expect a delay while you scramble to update and provide new leases.

For multi-family owners, the roll becomes the income exhibit in the purchase contract. A buyer will compare it to your bank statements; if three tenants paid late and you didn't note it, the buyer assumes cash-flow risk and may renegotiate price. Keeping the roll current means you can pull it on demand without last-minute edits that look suspicious. Some buyers request a roll dated within 30 days of offer; if yours is current, you email it same-day and avoid signaling that your records are loose.

FAQ

How do I handle a tenant who pays rent late every month?

Mark the unit as paid the day the payment clears, and note the cleared date in a comment or adjacent column. Some landlords add a "Payment History" note (e.g., "habitually late, averages 5th of month") so they remember to charge late fees or decline renewal. Don't adjust the rent amount in the roll to reflect fees; log fees as separate line items in your ledger to keep the base rent clean.

Should I include utilities or HOA fees in the rent roll?

Only if the tenant reimburses you directly for them and you count that as rental income. If the tenant pays the electric company directly, leave it off. If you pay HOA and the tenant's lease says "rent includes HOA," you can note "$1,200 rent (includes $150 HOA)" in a comments column, but the rent amount should be the total the tenant pays you. The goal is clarity about cash you collect.

What's the difference between a rent roll and a lease abstract?

A rent roll is a one-line-per-unit snapshot of current terms. A lease abstract summarizes every clause in a lease (renewal options, maintenance duties, pet policy). Use the rent roll for financial tracking; pull the full lease or abstract when you need to enforce or interpret a specific clause.

Can I use the rent roll as proof of income for a mortgage application?

Yes, lenders accept a current rent roll plus 12 months of bank statements showing deposits that match it. They want to see consistency: if the roll says $1,200/month and your statements show $1,150 some months, they'll ask why. A clean roll with notes explaining any prorations or vacancies speeds underwriting.

How do I track rent increases that phase in mid-year?

Add an "Effective Date" column. Example: unit 2B shows $1,100 rent effective January 1, then $1,150 effective July 1. Log both rows or use a comment: "$1,100 Jan-Jun, $1,150 Jul-Dec per lease amendment." When you pull the roll for year-end, you'll see why the total collected doesn't equal 12 × $1,150. If your property app doesn't support date-effective changes, maintain a separate "Rate Changes" tab with unit, old rate, new rate, and effective date.

This is educational information, not accounting or legal advice. Consult a CPA for tax treatment of rental income and deposits, and review your state's landlord-tenant statutes for record-retention requirements.