Good Columns
Shop all

Products / Free Rent Payment Tracker

Log the rent due and the rent paid, and see who is late.

Free

Excel .xlsx, instant download

Get it free on Gumroad

Type one row for each unit and month: what was due, what arrived and when. The due date, a Late? flag and the balance owed fill themselves, and a monthly summary adds up what was due, collected and still owed.

Who it's for

Landlords with up to 10 units who want a simple log of rent due and rent received, month by month.

It records what you type and adds it up. It sends no reminders, charges no late fees and applies no state rule: the grace days are yours to set.

Try the free prorated rent calculator

For income and expenses sorted under the Schedule E line labels, see the Schedule E Rent Ledger.

A look at the actual file

Rent log with three example units over ten months, flagging late, short and overdue rent
Screenshot of the Rent log tab with the example data that ships in the file.
Monthly summary of rent due and rent collected by unit and month, from the example rent log
Screenshot of the Monthly summary tab with the example data that ships in the file.

What's inside

Three tabs, in this order. A two-page Quick Start PDF is in the zip.

TabWhat it does
Start hereFive setup steps, a colour key, the disclaimer and a checks line.
Rent logOne row for each unit and month: Unit, Tenant label, Rent month, Due day, Amount due, Date paid, Amount paid, Method and Notes. Due date, Late? (Late, Short or Overdue) and Balance owed fill themselves. Room for 150 rows.
Monthly summarySet the year, the grace days and an optional check date, and list up to 10 units. Tables of rent due, rent collected and rent still owed for each unit and month, with year totals, the percent collected and a count of late, short or overdue rows. A check line says if a Rent log row is not being counted.

A look at the file

Rent log tab: four of the example rowsExample data from the file. Grace days 3, check date 8 Oct 2026
UnitRent monthDue dayAmount dueDate paidAmount paidLate?Balance owed
Unit 1 (example)1 Oct 202611,200.002 Oct 20261,200.00–
Unit 2 (example)1 Aug 20261950.0014 Aug 2026950.00Late–
Unit 2 (example)1 Sep 20261950.001 Sep 2026800.00Short150.00
Unit 2 (example)1 Oct 20261950.00Overdue950.00

Late? and Balance owed fill themselves. Unit 2 paid on 14 Aug, after the due date plus three grace days. In October nothing has been paid and the check date is past the due date plus grace days, so the row reads Overdue.

Format

File
1 Excel workbook (.xlsx), 3 tabs, and a Quick Start PDF
Software
Microsoft Excel. Designed to open in Google Sheets.
Limits
Up to 10 units, 12 months of one year at a time, and 150 Rent log rows. Three example units are included, marked (example), and step 1 on the Start here tab clears them.
Delivery
Instant download after purchase. Nothing is shipped.
Price
Free. No subscription.

What it does not do

  • It does not send reminders, charge late fees or apply any state rule.
  • It does not track expenses or tax lines. The Schedule E Rent Ledger does that.
  • It does not connect to a bank or a payment service. You type each payment.

Questions

Which version of Excel do I need?

Excel 2010 or later on Windows, Excel 2016 or later on Mac, or Excel for the web. We checked every formula in this workbook against the version of Excel that first supported it: the newest thing it uses arrived in Excel 2007, so it needs no Microsoft 365 subscription. There is nothing in it that only newer Excel can run, such as XLOOKUP, LET, IFS or TEXTJOIN, and there are no macros or add-ons. Excel 2003 and earlier are not supported.

The totals look blank when I open it. What is wrong?

Nothing. Excel opens a downloaded file in Protected View and does not calculate until you click Enable Editing. The figures appear as soon as you do.

Does it work on a Mac?

Yes, in Excel for Mac. There are no macros, so nothing in the file is Windows-only. It is also designed to open in Google Sheets in a browser.

Can I use it in Google Sheets?

The workbook is made in Excel and designed to open in Google Sheets: upload it to Drive and open it with Google Sheets. It uses no macros, scripts or add-ons. If something does not work as described there, email hello@goodcolumns.com and we fix it or refund you.

What if I want a refund?

No change-of-mind refunds on digital files. If a file is faulty or not as described, email hello@goodcolumns.com within 30 days and we fix it or refund you.

Is this tax, legal or financial advice?

No. It records the rent you type and adds it up. It sends no reminders, charges no late fees and applies no state rule on grace periods or notices. Check your local law or ask a local attorney.

The small print

Good Columns templates help you organise records. They are not tax, legal, accounting or financial advice, are not endorsed by the IRS or any government body, and may not suit your situation. You are responsible for the figures you enter.

Licence: use within your own business; no resale or redistribution.

No change-of-mind refunds on digital files. If a file is faulty or not as described, we fix it or refund you.

Full terms: Terms and refunds.