Skip to content
Landlord Rent Ledger cover: a sample sheet with rent received, costs paid and net income and a bar chart, beside the Dashboard, Units and Ledger tabs

Landlord Rent Ledger

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Landlord Rent Ledger is for a landlord who rents out a few units in one building and wants each unit's income and costs side by side. The Units tab lists each unit with its tenant, monthly rent, lease end date and deposit. The Ledger tab records every rent payment and cost with its unit, type and amount, and the Dashboard shows rent received, costs, net income, the monthly rent roll and a breakdown by unit.

The sample covers September and October 2026 for four units and the building, including a shared insurance payment and a few repairs, so the building line shows a negative net. Replace the units and tenants with your own. Record each cost as soon as you pay it, and keep the receipt with the ledger for each one.

Useful for

  • Comparing the income from each unit in one building
  • Totalling repairs and insurance for an annual review
  • Checking the monthly rent roll against rent received

What's included

  • 4 tabs: Dashboard, Units, Ledger, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Units: a table
  • Ledger: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Units tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I record a cost that covers the whole building?

Choose Building in the Unit column. Shared costs such as insurance, common-area utilities and gutter cleaning go there, and the Dashboard shows them as their own line, separate from the individual units.

Can I use the ledger for tax records?

The ledger keeps dates and amounts by unit, which helps when you prepare a return. It does not decide what is deductible or how repairs and improvements are treated. Ask a tax adviser, and keep the receipts.

What if a tenant pays only part of the rent?

Record the amount actually received as Rent received on the day it arrives, and add a note saying the balance is owed. The Dashboard then shows the income you really have, while the Units tab still shows the full monthly rent.

  • #bill-tracker
  • #landlord-rent-ledger
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More bill tracker templates

See all 8

Also in Finance

All finance templates
Get this template

Preparing your template…