Rent Ledger Template
A rent ledger tracks every rent payment from every tenant. One record shows who paid, who's late, and what's owed. It's your financial proof for taxes, evictions, and audits.
Download the free Excel template or let LandlordForms automate it entirely.
No sign-up required • 100% free • Instant download
What Your Rent Ledger Must Track
Miss any of these and you won't have a complete financial record. Courts and tax audits require detailed rent tracking.
- Tenant name — Who the payment is from
- Property address — Which unit (if you have multiple properties)
- Payment date — When you received the payment
- Amount paid — Exact dollar amount received
- Payment method — Cash, check, bank transfer, etc.
- Rental period — Which month(s) the payment covers
- Late fees — Any late charges assessed and collected
- Running balance — Current amount owed or overpaid
Important: The IRS requires you to keep rent ledgers for at least 3 years. You'll need them for tax deductions, depreciation calculations, and audits.
4 Rent Tracking Mistakes That Cost You Money
Not tracking partial payments
Tenant pays $800 of $1,200 rent. If you don't log it, you don't know what's still owed. Three months later, you can't remember if they still owe $400 or $800. Money lost.
No late fee documentation
You charge late fees but don't track them separately. Now you can't prove what's rent vs late fees. Courts need itemized records. Your case gets weakened.
Missing payment dates
You know they paid, but not when. Without dates, you can't prove payment was late. Can't enforce late fees. Can't show payment patterns for eviction.
Mixing deposits with rent
Security deposits and rent must be tracked separately. Mixing them creates accounting nightmares and violates state laws in many places. IRS penalties. Lost deposits.
Rent Ledger Example
| Date | Tenant | Period | Charged | Paid | Balance |
|---|---|---|---|---|---|
| 01/01/2025 | John Smith | January | $1,200 | $1,200 | $0 |
| 02/05/2025 | John Smith | February | $1,250 | $1,000 | -$250 |
| 02/12/2025 | John Smith | Late Payment | $0 | $250 | $0 |
This is a simplified example. The automated ledger in LandlordForms calculates balances automatically and generates receipts instantly.
Why Track Rent with a Proper Ledger
Proof for tax deductions
IRS requires detailed rent records. Ledger shows income, timing, and payment methods. Essential for Schedule E. Missing records = denied deductions.
Win eviction cases
Courts need proof of non-payment. Ledger shows exact dates, amounts, and what's owed. Without it, your eviction case is weak. Tenant wins.
Track late patterns
See which tenants always pay late. Identify problem tenants before renewal. Make informed decisions on lease renewals. Avoid chronic late payers.
Calculate actual income
Know your real rent collection rate. Not what's charged — what's actually paid. Essential for refinancing, selling, or understanding cash flow.
Zero Risk. Zero Cost. Zero Obligation.
100% free forever. No account required. No credit card. No email capture. Just generate and download. Used by 10,000+ landlords.
Frequently Asked Questions
Do I legally need to keep a rent ledger?
Not legally required in most states, but essential for taxes, evictions, and audits. The IRS requires rent income documentation for tax deductions. Courts need payment proof for non-payment eviction cases. It's practically mandatory even if not legally.
How long should I keep rent ledgers?
At least 3 years for IRS purposes, 7 years is safer. Some landlords keep them permanently. Digital records make long-term storage easy and searchable.
What if a tenant disputes payment history?
Your ledger is your proof. Shows exact dates, amounts, and payment methods. Without it, you're relying on memory against their word. They win. You lose.
Can I use the same ledger for multiple properties?
Yes, but separate sheets or sections per property keeps it organized. LandlordForms automatically organizes by property and tenant.
What about partial payments?
Log them separately. Show date, amount, and running balance. Never assume a partial payment will be completed — track exactly what was paid and when. Prevent disputes.
How is this different from my bank statement?
Bank statements show money in, not which tenant paid what for which month. Ledger connects payments to specific tenants, units, and rental periods. That's what courts and IRS need.
The Manual Ledger Problem: You're Losing 8.8-35 Hours Per Year
Here's what you're doing now with a spreadsheet. For EACH tenant, EVERY month:
The Hidden Cost of "Free" Spreadsheets:
- Open your spreadsheet (30 seconds)
- Find the right row for this tenant (20 seconds)
- Type in the date, amount, payment method (90 seconds)
- Update the running balance formula (60 seconds)
- Check if payment was late, calculate late fee (45 seconds)
- Save the file (10 seconds)
- Generate a receipt separately — find template, fill fields, save PDF (5 minutes)
- Email receipt to tenant — attach file, write message, send (2 minutes)
- Pray the formula doesn't break. Again. (Priceless stress)
Total: 8 minutes and 45 seconds per tenant per payment
• 5 tenants = 44 minutes per month = 8.8 hours per year
• 10 tenants = 87 minutes per month = 17.5 hours per year
• 20 tenants = 175 minutes per month = 35 hours per year
• At $50/hour, that's $440-$1,750 wasted annually on data entry
Why "Free" Spreadsheets Actually Cost You Money:
- →Forgot to update it. Now you don't know who's paid. Tenant disputes payment. You have no proof.
- →Typed wrong amount. Balance is wrong for 3 months before you notice. Late fees calculated incorrectly. Money lost.
- →Formula broke. Everything shows $0. Have to rebuild it. 2 hours wasted reconstructing data from memory.
- →Forgot to generate receipt. Tenant asks for it 6 months later for taxes. You can't find the template. They're mad. You look unprofessional.
- →IRS audit. Your spreadsheet is a mess. Missing dates, partial entries, no proof of payment methods. Deductions denied. $thousands lost.
The Solution: Record Once, Everything Happens Automatically
Log a payment in 45 seconds. That's it. No spreadsheet formulas. No separate receipts. No email attachments. Everything automated.
- Ledger updates automatically — running balance calculates itself, no broken formulas ever
- Receipt generates automatically — professional PDF created instantly with your branding
- Receipt emails automatically — sent to tenant's email in seconds, not hours
- Late fees calculate automatically — no manual math, no mistakes
- Payment history saved permanently — searchable, filterable, exportable for taxes or evictions
- Works on your phone — log payments while collecting rent, not later at your desk
20 tenants: 15 minutes per month instead of 3 hours. Save 33 hours per year.
At $50/hour, that's $1,650 saved per year in time alone. Plus zero mistakes. Zero forgotten receipts. Zero broken formulas. Zero late fees miscalculated. Pro plan: $19/month = $228/year.
ROI in the first month. Every month after is pure time savings. Stop doing data entry. Let software work for you.
Stop Wrestling with Spreadsheets
The free template is great for getting started. But if you manage more than 2-3 tenants, manual tracking becomes a massive time sink. LandlordForms automates your entire rent tracking process.
Ledgers update themselves. Receipts generate automatically. Late fees calculate on their own. Save 8-35 hours per year.
When you create a free account, you get:
Join 10,000+ landlords who ditched Word documents and spreadsheets. Free forever. Upgrade anytime.