What is a rent ledger, and why keep one?
A rent ledger is the account statement for a single tenancy. Charges go in one column, payments in another, and a running balance shows what the tenant owes on any date. Bank statements tell you money arrived; a ledger tells you what that money was for and what is still outstanding.
Most landlords start one after a dispute, when they discover that a year of rent spread across bank deposits, payment apps and a few cash envelopes is hard to reconstruct. Kept from day one, a ledger answers the questions that come up in most tenancies: Is the tenant behind? Was the late fee charged or waived? Did the partial payment in March go to rent or to the repair bill? It also makes year-end bookkeeping simpler, because rental income is already listed by date.
What should each ledger entry record?
Every line should stand on its own, so that someone reading it later (a judge, a mediator, the tenant, your accountant) does not need you to explain it. The template above uses these columns:
| Column | What goes in it | Why it matters |
|---|---|---|
| Date | The day the charge was due or the payment was received | Late fees and notices depend on dates |
| Description | Rent charge, payment, late fee, credit or other charge | Separates rent from fees, which some courts and statutes treat differently |
| Charge | The amount added to what the tenant owes | Shows the debt was actually billed |
| Payment or credit | The amount received, or a concession you gave | Credits reduce the balance just as payments do |
| Method | Check, money order, cash, transfer, card, portal | Lets you match each line to a bank record or receipt |
| Reference | Check number, transaction ID, receipt number, or which month the rent covers | Proves the entry and ties it to a period |
| Balance | Calculated: previous balance plus charge minus payment | The single number everyone asks about |
Enter the rent charge on the due date even if the tenant pays early, then enter the payment on the day it arrives. That way the ledger shows both the obligation and its fulfilment, and a missing payment is visible as a balance rather than as an absence. Record waived fees as a charge followed by a credit with a note, not as nothing; a quiet waiver is easy to forget and hard to prove.
The header matters too. Tenant names, unit, lease dates, monthly rent, due day and the security deposit held belong at the top, because the deposit is not rent and should not be mixed into the running balance. Keep it as a separate figure until the tenancy ends.
How do you use this template?
Fill in the tenancy details, choose the first rent month under the ledger, and press "Add 12 months of rent charges". The tool writes a rent charge on the due day of each month (the last day, for months that are shorter), filling blank rows first. Press it again and it continues with the next twelve months. Add payments, fees and credits with "Add row" and the balance updates as you type. Keep rows in date order, because the balance is calculated top to bottom.
When you are done, print it, save it as a PDF, or download a Word copy to keep adding to. Nothing is uploaded, so nothing is saved for you either: keep the file.
How does a ledger help in deposit and court disputes?
Two moments test your records: when the tenant moves out and you keep part of the deposit, and when you go to court for unpaid rent.
For deposits, many states require an itemized statement of deductions within a deadline. California, for example, requires the landlord to furnish the itemized statement and return the rest of the deposit within 21 days after the tenant vacates, and lists unpaid rent among the allowed deductions (Cal. Civ. Code 1950.5). If you deduct unpaid rent, the ledger is the itemization behind that line. Pair it with a dated condition record such as our move-in and move-out checklist for any damage deductions. Deadlines and rules differ widely, so check your state's statute.
In a nonpayment case, expect to be asked how the amount you claim was calculated. A ledger that shows each month's charge, every payment received and a running total is far more persuasive than a single number. Expect it to be checked against the tenant's own receipts and bank records, which is why the method and reference columns matter. Before filing, review it for errors: a missed payment entry undermines the whole document.
Do you have to give tenants receipts?
It depends on your state, and on how the tenant pays. Some examples from statutes we checked:
- New York requires a written receipt when rent is paid in cash or any form other than the tenant's personal check, showing the date, amount, premises and rental period, signed with the title of the person receiving it. Landlords must keep records of cash receipts for at least three years (N.Y. Real Property Law 235-e).
- California has a general rule that a debtor may require a written receipt from the creditor for anything delivered in payment (Cal. Civ. Code 1499). A tenant who asks for a receipt should get one.
Whatever your state requires, giving a numbered receipt for every cash or money order payment and writing that number in the ledger's reference column protects you as much as the tenant. Check your state's landlord-tenant law and any local ordinance for other receipt rules.
How often should you share the ledger with tenants?
No general rule sets a schedule, but a few habits prevent most arguments:
- Send a copy whenever the balance is not zero, before any late fee or notice goes out. Many disputes are simply a payment applied to the wrong month.
- Send one when the tenant asks. Refusing looks worse in a dispute than whatever the ledger shows.
- Send one at lease renewal and at move-out, so both sides agree the balance before the deposit is settled.
Tenants who are unsure what they owe usually call. If those calls arrive after hours, an AI answering line can take the question and email you a summary with the details, so you can reply with the ledger the next morning.
Digital or paper: which is better?
Either works if it is complete and consistent. Digital ledgers, whether this template saved as Word or a spreadsheet, calculate the balance for you and are easy to email. Paper ledgers are hard to alter without it showing, which some small landlords like. The weakness of both is the same: gaps. If you keep paper, write in pen, never erase (strike through and initial corrections), and keep it with copies of receipts. If you keep digital files, save a dated PDF each month so you can show what the ledger said at the time.
Property management software keeps ledgers automatically, but if you manage a handful of units, a monthly-updated file is enough. What matters is that each tenant has one record that matches the money.
A ledger is one of several records worth keeping. Our maintenance request form and work order covers repairs, and the maintenance emergency list covers what needs action tonight.
This page is general information for US landlords, not legal advice. Rent, fee, receipt and deposit rules vary by state and city; check your local law or ask a lawyer before relying on any of it.
Sources
- California Civil Code 1499 (written receipt)
- California Civil Code 1950.5 (security deposits)
- New York Real Property Law 235-e (rent receipts)
- TenantBalance rent ledger template and TenantHub rent ledger template, reviewed for common fields