Editorial illustration for 14 Easily Editable Rent Roll Templates (MS WORD)

10 Easily Editable Rent Roll Templates (MS WORD)

A rent roll is a dated schedule of a property’s rental position. It brings units, tenants, agreed rents, vacancies, and related charges into one view so a manager, owner, or reviewer can understand the portfolio without opening every lease. It is not proof that a particular payment was received. That distinction matters: an occupied unit with rent due can look productive on a schedule while its collections tell a different story.

Keep the Easily Editable Car Sale Contract Templates in MS WORD handy for a related task, and see the Easily Customizable Family Tree Templates or the Editable Motorcycle Bill of Sale Templates if the format differs.

Set the reporting date and unit coverage first

Give the rent roll an “as of” date and identify the property or portfolio covered. Decide whether it shows current lease terms, a historical month-end position, or a forecast. Label that basis prominently. A list mixing next month’s rents with today’s occupancy is difficult to interpret even when every individual figure is accurate.

Use a stable identifier for each unit. Include vacant units rather than omitting them, and distinguish rentable space from units unavailable because of repairs or another restriction. For a portfolio, include the property name as well as the unit number; several buildings may each contain a Unit 1. State the currency and rental frequency so figures can be compared sensibly.

Match the preview to the reporting audience

The samples include apartment, commercial, bank-oriented, and certified-style layouts. Look at the preview’s column space, room for lease dates, and accommodation for charges or notes. A commercial schedule may require different explanations from a small residential list. The label alone does not show whether the layout has enough space for your particular units.

A certification area should be completed only by someone able to confirm the stated information and its basis. Downloading a sample does not verify the figures. Inspect the downloaded document before use; no automatic calculations or linked totals are assumed here. If you add a total, calculate it by hand or check how the sheet is set up and verify the result independently.

Download the FREE Rent Roll Templates

Simple Rent Roll Template

File Size: 28 KB

Certified Rent Roll Word Template

File Size: 26 KB

Bank’s Rent Roll Form Template

File Size: 12 KB

Practical Rent Roll Template in MS WORD

File Size: 17 KB

Apartment Rent Roll Template

File Size: 05 KB

Free Printable Rent Roll Example

File Size: 11 KB

Project Rent Roll Template in MS WORD

File Size: 04 KB

Customizable Rent Roll Form Template

File Size: 37 KB

Property Rent Roll Template Free Download

File Size: 12 KB

Standard Rent Roll Template Word

File Size: 15 KB

Build each row from the underlying lease record

Start with unit identification, tenant name, lease commencement, lease expiry, and current base rent. Record renewal or break information in a clearly defined note or column if needed. Copy the effective terms, including signed amendments, rather than relying on the original lease when later changes have taken effect.

Keep base rent, recurring service charges, parking, and other amounts distinguishable. State whether a figure is monthly, annual, or another period. If you convert annual rent to a monthly equivalent for comparison, label the conversion and retain the original basis in your working records. Never mix converted and unconverted amounts in an unlabeled total.

Expose vacancies, concessions, and arrears separately

A vacant unit should show its vacancy status, not a tenant name copied from an expired tenancy. If an asking rent is included, label it as an asking figure rather than contracted income. Likewise, mark a signed future lease separately from a tenant who has already taken possession.

Rent-free periods and concessions can make the contractual rate different from the amount currently payable. Explain the treatment instead of choosing whichever number looks stronger. If arrears appear, specify their date and whether they include charges other than rent. Do not subtract deposits from arrears without an appropriate basis; deposits and earned rent represent different things.

Consider two units with the same stated monthly rent: one is occupied and paying normally, while the other is vacant and advertised at that rate. They should not contribute equally to a column labeled contracted rent. Separate columns or clear status notes let the reviewer see that difference without having to reconstruct it from scattered comments.

Reconcile the schedule before sharing a version

Compare unit counts with the property register and lease dates with the signed records. Check that occupied and vacant categories account for the intended coverage. Reconcile figures with the relevant rent ledger, remembering that a schedule of amounts payable is not automatically the same as cash collected during the month.

Add totals only for compatible columns and clearly defined periods. Manually check any calculation or inspect the sheet’s setup; a formatted row does not prove that a sum updates itself. Note exceptions that could materially change interpretation, such as disputed charges or an unconfirmed renewal. Keep the source documents available for authorized review while limiting the personal information included in widely circulated copies.

Questions about a rent roll’s reporting basis

How should a mid-month rent increase be shown?

State the effective date and distinguish the ongoing rate from any part-month amount due. Choose a consistent reporting basis for the schedule and explain it. A single unlabeled figure can otherwise be mistaken for either a full month’s rent or the actual charge for that month.

Where do I place a unit occupied by the owner?

Give it a separate occupancy status rather than recording it as a paying tenancy or silently leaving it out. Explain whether it is included in the total unit count and excluded from contracted rental income. That keeps coverage and income measures intelligible.

What if two properties use different currencies?

Keep original-currency amounts identifiable. If a consolidated reporting currency is necessary, record the conversion date, rate source, and method in the accompanying notes. Avoid adding unlike currencies directly or presenting a converted figure as though it were the amount specified in the lease.