Home › Templates › Rent Ledger
Rent Ledger & Late Rent Tracker
Know who paid, who owes, and for how long.
Add your tenants once and log payments as they come in. Rent is charged on each due day, late fees follow your rule, and every balance updates by itself.
- Excel
- Google Sheets
- Instant download
$17
Up to 50 units · Automatic rent & late fees · Statements & receipts
Gumroad: secure checkout, instant download link by email. Etsy: download from You › Purchases.
What's inside
- Dashboard: rent due and collected, collection rate, amount owed, who owes the most, leases ending soon, 4 charts
- Tenant ledger: 1,000 rows: payments, credits, other charges and deposits, with a running balance and receipt numbers
- Automatic late fees: grace period, flat fee and/or % of rent, per-tenant overrides, or switch them off
- Rent roll: per month, with a status per unit (Paid, Partial, Late, Due…)
- Balances & aging: 0–30, 31–60, 61–90 and 90+ days
- Printable tenant statements and rent receipts
- Security deposits: received, returned or applied
- To Bookkeeping tab: matches the Income log of our Rental Property Bookkeeping Spreadsheet
You get: The tracker with made-up sample tenants, a blank copy, and an 11-page PDF guide. One file per calendar year, monthly rent.
Works in: Microsoft Excel 2010+ (desktop or web) and Google Sheets.
Screenshots from the real file
Frequently asked questions
How is this different from the Bookkeeping Spreadsheet?
The bookkeeping spreadsheet tracks your own income, expenses, loans and taxes per property. The Rent Ledger tracks what each tenant owes you: rent charged, payments, late fees, aging, statements and receipts. Its To Bookkeeping tab lists payments in the bookkeeping Income log's column order.
Do I have to type the rent every month?
No. Rent is charged automatically on each tenant's due day while the lease runs. You only log what comes in, plus any extra charges or credits.
How are late fees calculated?
If money is still owed when the grace period ends (earlier late fees don't count), a fee of your flat amount plus your % of rent is added the next day. One fee per month at most. You can change the rule per tenant or switch it off.
Can I print a tenant ledger or statement?
Yes. Type a tenant ID on the Statement tab and print it or save it as PDF.
Does it work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets (File › Save as Google Sheets). Formulas, dropdowns and highlights work. Charts may look slightly different, and you may want to re-apply sheet protection (right-click a tab › Protect sheet).
Which version of Excel do I need?
Excel 2010 or newer, on Windows, Mac or the web. There are no macros or add-ons. Apple Numbers is not supported.
How do I get the files?
Right after payment, Gumroad shows a download page and emails you a link. On Etsy, go to You › Purchases and reviews › Download Files.
Can I use another currency?
Yes. Amounts display in $, but the math works for any currency.
Can I get a refund?
Because these are digital downloads, refunds aren't usually offered. If something doesn't work, email us and we'll help you get it working.
Can I share or resell the files?
They're licensed for your personal use with your own properties. Please don't resell or share them.
Record-keeping tool, not legal, tax or financial advice. Late-fee rules depend on your lease and local law; set the rule to match or switch automatic fees off. Personal-use licence; please don't resell or share the files. Made by Spruce Sheets with the help of AI tools; every formula was tested before release.
Related guides
You might also need
Landlord Complete Bundle
Analyse it. Collect the rent. Keep the books through tax time.
3 workbooks · Analyse, collect rent, keep the books · Excel & Google Sheets
$39 $55
Rental Property Bookkeeping Spreadsheet
Know exactly what each rental earns, without accounting software.
Up to 10 properties · Excel & Google Sheets · Instant download
$19
Landlord Bundle
Analyse a rental before you buy. Keep the books once you own it.
2 workbooks · Analyse deals, then keep the books · Excel & Google Sheets
$29 $38