Free Rent Ledger Template
A rent ledger, also called a rental ledger or a tenant ledger, records every charge and every payment for each tenant, with the balance after each one. It shows who has paid, who is late and exactly what is owed: the record a tax return, an eviction filing or a tenant's rent verification depends on.
Download the free Excel template, which keeps a separate running balance for each tenant, or let LandlordForms keep the ledger for you.
- Cost
- Free
- Account
- Not required
- Output
- PDF, ready to serve
The file downloads straight away. We send one email to confirm the address.
Free · Instant download
What a Rental Ledger Must Track
These are the columns in the template. Miss any of them and the ledger stops being proof: courts and tax audits want each charge and payment itemized and dated.
- DateThe day the charge was made or the money arrived, typed as a fixed date
- Tenant nameWho the line belongs to, spelled the same way every time
- Property or unitWhich unit, so one sheet can cover several properties
- Rental periodWhich month the charge or payment is for
- DescriptionRent, late fee, utilities, partial payment or credit
- Charged and paidTwo columns, both positive numbers, never netted together
- Payment methodCheck number, bank transfer, cash, money order
- Tenant balanceWhat that tenant owes after this line. The template calculates it
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.
Tenant Ledger Example
| Date | Description | Charged | Paid | Balance |
|---|---|---|---|---|
| 01/01/2025 | January rent | $1,200.00 | $1,200.00 | |
| 01/03/2025 | Payment, bank transfer | $1,200.00 | $0.00 | |
| 02/01/2025 | February rent | $1,200.00 | $1,200.00 | |
| 02/06/2025 | Late fee | $60.00 | $1,260.00 | |
| 02/09/2025 | Partial payment, check #1042 | $1,000.00 | $260.00 |
These are the example rows in the download. A tenant ledger is this view for one tenant: in the template, filter the Tenant Name column and print. The balance column keeps a separate running total for each tenant at each property, so several tenants can share one sheet.
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.
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)
Total8 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 Landlord 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.
Questions about the Rent Ledger
What's the difference between a rent ledger, a rental ledger and a tenant ledger?
They are the same record under different names. "Rent ledger" and "rental ledger" usually mean the landlord's record across every tenant. "Tenant ledger" usually means one tenant's history, which is the version a tenant, a new landlord or a court asks for. This template does both: keep every tenant on one sheet, and filter to one name when you need a single tenant's ledger.
Is this rent ledger template free?
Yes. It is an Excel (.xlsx) file with three sheets: instructions, the ledger, and a summary with totals and a balance for each tenant. You enter an email address and it downloads immediately, with no account, no card and no watermark.
How do I keep a running balance for each tenant in Excel?
Add up that tenant's charges so far and subtract their payments so far. With tenant names in column B, charges in F and payments in G, row 2 is =SUMIFS($F$2:F2,$B$2:B2,B2)-SUMIFS($G$2:G2,$B$2:B2,B2), filled down. A plain previous-row-plus-charge-minus-payment formula only works for one tenant: with two tenants on the sheet, their balances run together. The template already has the per-tenant version.
How do I give a tenant a copy of their ledger?
Filter the Tenant Name column to that tenant and print it or save it as a PDF. Tenants ask for this for rental applications, rent verification and disputes. If a new landlord wants proof of on-time payment, a rent verification letter alongside the ledger is the usual pairing.
Is a tenant ledger the same as a rent roll?
No. A rent roll is a snapshot of every unit on one date: unit, tenant, rent, lease dates and current balance, the document a lender or buyer asks for. A ledger is the transaction history behind each balance. You can build a rent roll from a ledger, but not the other way round.
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.
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.