Products / Free Rent Payment Tracker
Log the rent due and the rent paid, and see who is late.
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


What's inside
Three tabs, in this order. A two-page Quick Start PDF is in the zip.
| Tab | What it does |
|---|---|
| Start here | Five setup steps, a colour key, the disclaimer and a checks line. |
| Rent log | One 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 summary | Set 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
| Unit | Rent month | Due day | Amount due | Date paid | Amount paid | Late? | Balance owed |
|---|---|---|---|---|---|---|---|
| Unit 1 (example) | 1 Oct 2026 | 1 | 1,200.00 | 2 Oct 2026 | 1,200.00 | – | |
| Unit 2 (example) | 1 Aug 2026 | 1 | 950.00 | 14 Aug 2026 | 950.00 | Late | – |
| Unit 2 (example) | 1 Sep 2026 | 1 | 950.00 | 1 Sep 2026 | 800.00 | Short | 150.00 |
| Unit 2 (example) | 1 Oct 2026 | 1 | 950.00 | Overdue | 950.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.