Skip to main content

New: go annual on Pro and we build your first document for you. Limited offer. See what's included

Free rent roll template for Google Docs

A schedule of units, tenants, rents and lease dates with totals, generated per property or portfolio from your tenancy data.

Free to copy Google Docs PDF export No watermark
Automate this template Copy to my Google Docs How to use it

Free to copy, no sign-up: the file opens in your own Google Drive. Updated November 13, 2026.

The actual template Free rent roll template for Google Docs: preview of the first page

What’s in the rent roll template

Every block has a placeholder showing where your details go. Type over them by hand, or bind each one to a field in your data and let it fill itself.

  • Header with the property and reporting date {{property.name}} · {{as_of}}
  • Owner and managing agent block {{owner.name}} · {{manager.name}}
  • Unit schedule, one row per tenancy loop: {{units}}
  • Lease start, end and review dates per unit {{unit.lease_start}} · {{unit.lease_end}}
  • Occupancy, arrears and vacancy summary {{summary.occupancy}} · {{summary.arrears}}
  • Monthly and annualised rent totals {{totals.monthly}} · {{totals.annual}}

How to use this rent roll template in Google Docs

  1. 01

    Copy the template to your Google Drive

    Press "Copy to my Google Docs". Google asks to make a copy, and the copy is yours to edit; the original is never changed. All you need is a free Google account.

  2. 02

    Replace the placeholders with your details

    Text in double braces, like {{property.name}}, marks where your own values go. Work down the page: header with the property and reporting date; owner and managing agent block; unit schedule, one row per tenancy, and so on.

  3. 03

    Make it match your brand

    Swap the logo, colours and fonts in Google Docs as you would in any document. The layout is built to hold when the text changes.

  4. 04

    Download it as a PDF, or share the link

    File, then Download, then PDF Document gives you a file to send or print. Download as Word (.docx) works too if someone needs it.

  5. 05

    Making these regularly? Fill it from your data

    Connect Airtable, Google Sheets or a CSV to SourceToDocs and it fills a copy of this template for every row, so you stop retyping.

A rent roll is the schedule a landlord, lender or buyer asks for first: every unit in a property, who occupies it, what they pay, and when the lease starts and ends, totalled at the bottom. It is a working table rather than a designed page, and its length changes with the portfolio, which is why it belongs in Google Docs where the table grows and the pages break themselves.

Deciding what a row is

Most rent roll problems are definition problems. A vacant unit still needs a row, or the occupancy figure is meaningless. A unit re-let mid-month has two tenancies and one row unless you say otherwise. Fix the as-at date in the data and filter tenancies against it, so the document reports a position on a day rather than whatever the table happened to contain when someone ran it. Totals should be computed where the tenancies live, not in the layout, so the same figure appears in the rent roll and in your accounts.

Fill this rent roll template from Airtable, Google Sheets or a CSV

Connect an Airtable base, a Google Sheets spreadsheet or a CSV file, map each field to a placeholder, and generate. One run can produce a single document or one per matching row, delivered to your Google Drive.

Real estate: A schedule of units, tenants, rents and lease dates with totals, generated per property or portfolio from your tenancy data.

Tenancies · Google Sheets

UnitTenantMonthly rent
Flat 1AR. Whitfield£1,150
Flat 1BVacant—
Flat 2AK. Nowak£1,295

Template: Google Slides or Docs

{{property.name}}

Rent roll as at {{as_of}}

loop: {{units}} → row

{{summary.occupancy}} occupied

{{totals.monthly}} per month

one rent roll per property; the table repeats a row per tenancy

Generated output

DocsPDF

Weaver Court

Rent roll as at 1 Sep 2026

24 units listed

22 of 24 occupied

£27,480 per month

Start automating

Who uses this rent roll template

Letting agents and property managers

Send each landlord a current schedule of their units without rebuilding a table per property.

Read the guide

Landlords with multiple properties

Keep one rent roll per building from the tenancy records you already maintain.

Read the guide

Asset and investment managers

Produce a dated rent roll for lenders and investors on the same cycle every month.

Read the guide

Related templates

All real estate →
Comparative market analysis template: the actual Google Docs template Google Docs

Comparative market analysis template

A priced comparison of a subject property against recent comparable sales, generated per property from your sales data.

View template
Real estate brochure template: the actual Google Slides template Google Slides

Real estate brochure template

A buyer-facing brochure for a single listing, generated one per property from your listings data.

View template
Statement of account template: the actual Google Docs template Google Docs

Statement of account template

A period summary of a customer's invoices, credits and payments with a running balance, generated one per account from your ledger data.

View template
Listing presentation template: the actual Google Slides template Google Slides

Listing presentation template

The pitch deck an agent shows a seller to win the instruction, generated one per appointment from your listings and sales data.

View template

Common questions, answered

Why is a rent roll a Google Doc rather than a slide? +
Because the length is set by the portfolio, not the designer. A six-unit house and a two-hundred-unit block use the same template, the table repeats a row per tenancy and pages break where they need to. On a slide you would be resizing text to make the units fit.
Where do the tenancies and rents come from? +
From your system of record: Airtable, Google Sheets or a CSV export. The document places the rents, lease dates and arrears you already hold, so the schedule and your records cannot drift apart.
Can I use our own rent roll layout? +
Yes. Build the master in Google Docs with your column order, headings and letterhead, mark the unit fields as a repeating row and the totals as placeholders, and generate against that. Lenders and owners often specify a format, and this way you keep theirs.
Can I produce a rent roll for every property at once? +
Yes. Group the tenancy data by property and one scheduled run produces a dated rent roll per building, each listing only its own units and totals. Landlords with several buildings can have one document per property rather than a shared spreadsheet, and the whole set is regenerated on the same day each month.
Is this rent roll template free? +
Yes. Copy it to your own Google Drive at no cost and with no sign-up, then edit it like any Google Docs file. You only need SourceToDocs if you want it filled from your data automatically, and that has a free plan too.
Can I download this rent roll template as a PDF or Word file? +
Yes. Open your copy in Google Docs and choose File, Download. PDF Document gives a print-ready file; Microsoft Word (.docx) gives an editable one for people who do not use Google Docs.

Generate this document from your data

Start on the free plan, connect Airtable, Google Sheets or a CSV, and export a real Google Docs file. No watermark, no credit card.

Start automating See pricing