Free Rent Ledger Template for Landlords
Create a free landlord rent ledger to track rent due, payments received, payment dates, and running balances. Download a blank template below, or use the rental ledger generator online and export as PDF, Excel, or CSV — no signup required.
Free • No signup • PDF + Excel
Works in Excel and Google Sheets. The Excel template keeps its formulas and updates balances automatically.
Ledger created
Balances use the payments you record. Until you complete a month, “Unrecorded” counts as $0 paid.
TenantHub records rent payments automatically and keeps each tenant’s ledger up to date.
No subscription required. Autopay optional.
What is a rent ledger?
A rent ledger is a record of all rent payments for a specific tenant or property. It shows each month's payment status, the amount paid, the date received, and any balance due. Landlords use ledgers to track payment history, prepare for tax season, and resolve disputes about whether rent was paid.
Why keep a rent ledger?
A rent ledger is a useful part of professional property management. It gives you a clear picture of each tenant's payment history at a glance and helps you identify patterns — like tenants who consistently pay late. It can also support tax preparation and help organize records for a dispute.
For a practical monthly workflow, read our guide on how to keep track of rent payments.
- Track payment history across months and years
- Easily identify late payments and missed payments
- Essential for tax records and financial reporting
- Provides clear documentation for dispute resolution
What should be included in a rent ledger?
- Tenant name and property address
- Monthly rent amount
- Payment due date for each month
- Date payment was received
- Amount paid, including partial payments
- Running balance and status (paid, partial, unpaid, or upcoming)
Rent Payment Ledger Example
| Month | Rent Due | Amount Paid | Payment Date | Balance |
|---|---|---|---|---|
| January | $1,800 | $1,800 | Jan 1 | $0 |
| February | $1,800 | $1,800 | Feb 3 | $0 |
| March | $1,800 | $1,400 | Mar 1 | $400 |
| April | $1,800 | $2,200 | Apr 2 | $0 |
This example shows a full payment in January, a late payment in February, and a partial payment in March. The $400 unpaid balance carries forward, so April's $2,200 payment covers both April rent and the remaining March balance.
Rent Ledger vs. Rental Ledger vs. Tenant Ledger
Rent ledger and rental ledger usually refer to the same record: a history of rent charges, payments, dates, and balances for a rental property. A tenant ledger may be broader and can also include other tenant charges, credits, or fees, such as utilities or repairs. For rent collection, the important part is maintaining a clear rent payment ledger showing what was due, what was paid, when each payment arrived, and any remaining balance. Whatever name you use, keeping the record consistent makes it easier to answer payment questions, prepare financial records, and document partial or late payments.
TenantHub tracks rent payments automatically. Every payment is recorded in your dashboard. No manual entries needed.
Track Rent Free →Why manual ledgers are painful
Keeping a rent ledger by hand — whether in a notebook, spreadsheet, or Word document — is tedious and error-prone. You have to remember to update it every month, keep it organized across multiple tenants, and make sure the math adds up. One mistake can lead to disputes with tenants.
A rent ledger generator makes it easy to create a clean, accurate record. Fill in the basic details, and the ledger is generated instantly. But for long-term rental management, automated tracking through TenantHub is far more reliable.
How TenantHub automates rent ledgers
When you collect rent through TenantHub, every payment is automatically recorded in your dashboard. Each tenant has a complete payment history with receipts, dates, and payment methods. You can view the ledger anytime, export it for tax purposes, and share it with tenants. No manual data entry required.
- Payments recorded automatically with date and method
- Complete payment history for each tenant and property
- Export ledgers for tax or legal purposes
- Tenants can view their own payment history
Frequently Asked Questions
Is a rent ledger legally required?
Requirements vary by jurisdiction and situation. A well-kept ledger may be useful as part of your rental records, but it does not replace jurisdiction-specific notices or legal advice.
Is this rent ledger template fillable?
Yes. The Excel and Google Sheets versions are editable — enter each payment and the running balance, status, and totals update by formula. The online generator is fillable in your browser and exports to PDF, Excel, or CSV. The blank PDF is designed to print and complete by hand.
What is the difference between a rent ledger and a rent receipt?
A rent ledger tracks charges, payments, and balances across many months. A rent receipt confirms one payment. If you need proof of an individual payment, use our free rent receipt generator.
Can a rent ledger show unpaid rent or partial payments?
Yes. Enter the amount received for each month. The tool labels a short payment as Partial, carries the remaining amount into the running balance, and labels a past-due month with no recorded payment as Unpaid.
Can I use a rent ledger in court?
A rent ledger may be useful as part of your rental records, but evidentiary requirements vary by jurisdiction. Consult a qualified attorney regarding a specific dispute.
Should security deposits appear on a rent ledger?
Usually, rent and security-deposit records are kept separately because a deposit is not ordinary rental income. Follow your lease and local recordkeeping rules.
Can I use this ledger for tax purposes?
Yes. The generated ledger shows a clear record of rental income by month, which is useful for tax preparation. For more detailed tax reporting, TenantHub provides exportable financial records.
Does this tool store my data?
No. This tool runs entirely in your browser. We don't store any tenant or payment data. Copy the ledger text and save it wherever you keep your records.
Does TenantHub include a rent ledger?
Yes. Every TenantHub account includes an automatic rent ledger. Payments are recorded as they happen, and you can view payment history for any tenant at any time. Free to use.
More landlord tools
Your rent ledger should update itself.
TenantHub tracks every payment automatically. No manual entries, no spreadsheets, no math mistakes.