Skip to content
Rent Receipt cover: a sample sheet with rent due, collected and still owed and a bar chart, beside the Summary, Payments and Receipt tabs

Rent Receipt

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 Rent Receipt workbook suits landlords and small property managers who collect rent from several units. The Payments tab is a ledger with one row for each monthly payment, including the rent due, the amount paid, the date, the method and a balance. The Summary tab totals rent due, collected and still owed, shows late payments, and breaks rent down by unit and by payment method. The Receipt tab works as a printable form for the tenant, property, period, charges and the amount paid today.

The sample rows cover three months for four units, including a part payment and a late one, so the balances and statuses are easy to follow. Keep unit names the same on every row so the breakdown adds up. Save a PDF of each receipt and file it with the lease. Check your local rules on the records you must keep and on how late rent must be raised.

Useful for

  • Issuing a receipt to a tenant after each rent payment
  • Keeping one ledger of rent for every unit
  • Spotting part payments and late rent before they grow

What's included

  • 4 tabs: Summary, Payments, Receipt, How to use
  • Summary: a dashboard with 4 summary figures
  • Payments: a table
  • Receipt: a ready-to-fill form
  • 2 charts 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 Payments 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

What should a rent receipt include?

Include the landlord or agent, the tenant's name, the property address, the period the payment covers, the date, the method and the amount paid. The Receipt tab has a line for each of these. Save a copy of each receipt you hand over.

How do I issue a receipt when a tenant pays less than the full amount?

Type what you actually collected under Paid, and the difference stays as the balance. Set Status to Partial. When the rest arrives, update Paid so the Balance falls to zero, then change Status to Paid.

Can I print a receipt for a month that is already paid?

Yes. Enter the payment details and the amount on the Receipt tab, then print it or save the tab as a PDF. The receipt does not change the Payments ledger, so make sure the payment is logged there too.

  • #receipt
  • #rent-receipt
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More receipt templates

See all 10

Also in Finance

All finance templates
Get this template

Preparing your template…