Skip to content
Rent Payment Tracker cover: a sample sheet with rent due so far, paid so far and still owed and a doughnut chart, beside the Dashboard and Payments tabs

Rent Payment Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

The Rent Payment Tracker is a simple log for renters who pay monthly and want proof of every payment made. The Payments tab lists the due date, rent due, date paid, amount paid, method, days late and still owed for each month. The Dashboard totals the rent due and paid, shows the balance owed, the share of payments made on time and the average days late, and charts payments by method.

The sample covers January to October 2026, including one late payment, one partial payment and a balance still owed, so you can watch how the sheet reacts. Overwrite the sample rent and dates with real figures. Hold on to the bank record or receipt for each payment with the file, since this log is a summary and not proof of payment.

Useful for

  • Keeping a record of rent payments for a lease year
  • Showing a landlord a clear payment history
  • Tracking a partial payment until the balance is cleared

What's included

  • 3 tabs: Dashboard, Payments, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Payments: 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 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

How are the days late worked out?

If you enter a date paid, the sheet counts the days after the due date, with zero for a payment on time. With no date paid entered, the sheet measures from the due date up to today, so unpaid rent keeps showing as late until you record it.

What does the still owed column show?

It subtracts the amount paid from the rent due for each month. Any figure above zero is still owed and turns red. To clear it, enter the extra payment on the same row and the balance drops to zero.

Does a late payment count against me?

This sheet only records dates, amounts and days late. Whether a late payment brings a fee or affects your lease depends on your agreement and local rules. Read your lease, and ask a housing adviser if you are unsure.

  • #bill-tracker
  • #rent-payment-tracker
  • #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…