Free Rent Ledger Template
Add each rent charge and each payment. The balance updates as you go, and you can download the ledger as a PDF or as a spreadsheet for Excel.
No entries yet. Add the first rent charge, then the payment you received.
- Total charged
- $0.00
- Total paid
- $0.00
- Paid up
- $0.00
Keep your own copy
This ledger is saved in this browser only. Browsers can erase saved data on their own (Safari does after about a week without a visit), so download the Excel (.csv) file each time you update the ledger. You can load that file back in here at any time.
Free. No sign-up. Nothing is uploaded. Only for real tenancies and real payments.
How to keep a rent ledger
One ledger per tenant, one line per event.
1. Add what was owed
Add a rent charge on the day rent is due each month. Late fees and other charges get their own line.
2. Add what was paid
Add a payment on the day you actually received it, for the amount you actually received, even if it was only part of the rent.
3. Read the balance
The last balance is what your records show the tenant owes. Download the PDF whenever you or the tenant need a copy.
What a rent ledger should show
A rent ledger is the full payment history for one tenant in one place. A receipt proves a single payment; the ledger shows how every charge and payment adds up.
Tenant, landlord and address
Who the ledger is for and which unit it covers. Keep a separate ledger for each tenancy.
The date of every entry
For charges, the day the money became due. For payments, the day you received it.
A plain description
"Rent for October 2026", "Payment received", "Late fee". Anyone reading it later should understand each line without asking.
Charges and payments in separate columns
Keeping money owed and money paid apart makes it easy to total each one and to spot a missed month.
A running balance
The amount owed after each line. A balance of zero means the tenant is paid up; a negative balance means they have a credit.
An opening balance
If you start the ledger partway through a tenancy, enter what was already owed so the totals are right from the first line.
Rent ledger questions
Short answers for landlords and tenants.
More free tools for landlords
Everything runs in your browser. No account, nothing uploaded.
- Rent receipt generatorFill in a rent receipt and download it as a PDF, or print a blank template.
- Rent increase letterWrite a clear notice of a rent increase with the new amount and start date.
- Proof of rent payment letterConfirm in writing what a tenant has paid over a period of time.
- Landlord reference letterGive a past or current tenant a reference for their next rental.
- How to fill out a rent receiptA filled-in example with every line of the receipt explained.