Free Templates

Free Rent Ledger Template

A rent ledger is the running record of every charge and payment on a lease — the document that settles disputes, backs up an eviction filing, and proves rental income to the IRS or a lender. Print the template below or rebuild it in a spreadsheet, free.

What a Rent Ledger Should Track

One ledger per lease. Each row is one rent period (or one payment event), and each column answers a question someone will eventually ask:

Date due — The date rent was due under the lease — anchors late fees and grace periods.
Date received — The day the payment actually arrived. The gap between these two columns is your late-payment history.
Amount due — Rent plus any other charges for the period (late fee, utilities, pet rent) — itemize in Notes.
Amount paid — What was actually received. Partial payments make this column differ from Amount due.
Payment method — Cash, check (with number), money order, or electronic — matters when tracing a disputed payment.
Late fee — Any late fee charged for the period, kept separate from base rent.
Running balance — What the tenant owes after this row. Zero when current; positive when behind. The single most important column.
Notes — NSF checks, partial-payment agreements, what a charge covers — anything a judge or accountant would ask about.

The Template

Print this page for a paper ledger, or copy the headers into a spreadsheet. Start a fresh sheet for each lease.

Rent Ledger

Property / unit: ____________________________

Tenant(s): ____________________________

Lease term: ______________ to ______________

Monthly rent: $__________ Due day: _____

Security deposit held: $__________

Late fee policy: ____________________________

Date due	Date received	Amount due	Amount paid	Method / Check #	Late fee	Balance	Notes

How to Keep It (So It Holds Up)

Record when the money moves. A ledger written the day each payment lands is evidence; one reconstructed the week before a court date is a story.
Never leave the balance column blank. The running balance is what a judge, an accountant, and a tenant all actually want to know.
Log partial payments as their own row with the shortfall reflected in the balance — and pair each with a rent receipt that states the remaining amount.
Keep charges itemized. Base rent, late fees, and other charges in separate columns/notes — lumping them together is how ledgers get picked apart.
Retain for 7 years after move-out. Covers IRS look-back windows and most state statutes of limitation on lease disputes.

Frequently Asked Questions

What is a rent ledger?

A rent ledger (also called a rent payment ledger or lease ledger) is a running record of every rent charge and payment for a tenancy: what was due, what was paid, when, how, and the balance after each entry. Landlords keep one per lease. It's the document you reach for in an eviction filing, at tax time, in a deposit dispute, or when a lender asks to verify rental income.

Can a rent ledger be used as evidence in court?

Yes. In a nonpayment eviction, the rent ledger is usually the landlord's core exhibit — most courts expect one showing the charges, payments, and running balance. A ledger kept contemporaneously (entries made when the money moved, not reconstructed later) carries far more weight. Bank statements and rent receipts back it up.

Do lenders accept a rent ledger as proof of rental income?

Often, yes. For mortgages and refinancing on investment property, underwriters commonly accept a 12-24 month rent ledger alongside bank statements or tax returns to document rental income. Tenants are sometimes asked for a ledger too — a clean payment history from a prior landlord can support a rental or mortgage application.

How long should landlords keep rent records?

Keep ledgers at least as long as your tax and legal exposure: the IRS can generally look back 3 years (6 in some cases), and state statutes of limitation on lease disputes often run 3-6 years. A common rule of thumb is to keep rent records for 7 years after a tenancy ends. Digital records make this easy — there's no reason to throw them away.

Is a spreadsheet good enough for a rent ledger?

For a small number of units, yes — a spreadsheet with the right columns (this template's) does the job if you update it every time money moves. The failure mode is discipline: missed entries, broken formulas, and versions scattered across devices. Rent collection software removes that risk by generating the ledger automatically from actual payments.

This template and guide are general information, not legal or tax advice. Record-keeping requirements vary by state — consult an attorney or accountant for your situation.

Or Let the Ledger Write Itself

When rent is collected online through Kelpic®, every charge and payment is recorded automatically — date, amount, method, and running balance, per tenant, always current. The ledger is just there when you need it.

Start Your Free Trial

No credit card required