Tenant Ledger Template (Free): Filled Example + Excel Download
A tenant ledger is a running record of every charge and every payment on one tenant’s account, with the balance after each entry. It shows at a glance what the tenant owed, what they paid, when they paid it, and what is still due. Below is a filled in tenant ledger example, what it must include, and a free tenant ledger template for Excel and Google Sheets.
Want more forms? Join our email list and get the free Landlord Starter Kit: the filled in example ledger, the Quick Start guide and 5 printable forms.
In this article
- What is a tenant ledger?
- What should a tenant ledger include?
- Tenant ledger example (filled in)
- What is the difference between a tenant ledger, a rent ledger and a rent receipt?
- How do you make a tenant ledger in Excel or Google Sheets?
- What mistakes make a tenant ledger hard to trust?
- How do you send a tenant ledger to a tenant, court or housing agency?
- Frequently asked questions
What is a tenant ledger?
Tenant ledger meaning: the complete payment history of one tenant’s account. It lists every charge (rent, late fees, other fees), every payment, and the balance after each line. Think of it as a bank statement for one rental.
A tenant ledger (also called a rent ledger, rent payment record or tenant account statement) is the payment history for one rental unit. Each line is either a charge, such as monthly rent or a late fee, or a payment, such as a check or bank transfer. A running balance after every line shows exactly where the account stands.
Landlords are usually asked for one in three situations: a tenant wants proof of their payment history for a new apartment or a mortgage, a housing authority needs it for a voucher tenant, or a court asks for it in a rent dispute. In Washington, DC, for example, a court rule requires the landlord to bring copies of all rent ledgers to every hearing in a landlord and tenant case (D.C. Superior Court Landlord and Tenant Rule 10(b)(1)).
What should a tenant ledger include?
- Tenant name and rental address, including the unit number.
- Lease start date, monthly rent and due day.
- Every charge with its date: rent, and late fees only if your lease allows them.
- Every payment with the date received, amount and method (check number, Zelle, cash receipt number).
- A running balance after each line, so anyone can see what was owed on any date.
- The security deposit, listed separately. A deposit is not rent, so it should not reduce the balance.
Tenant ledger example (filled in)
Here is a real looking example for one tenant over four months. Rent is $1,350, due on the 1st, with a 5 day grace period and a $50 late fee in the lease.
| Date | Description | Charge | Payment | Balance |
|---|---|---|---|---|
| 07/01/2026 | July rent | $1,350.00 | $1,350.00 | |
| 07/03/2026 | Payment, check #214 | $1,350.00 | $0.00 | |
| 08/01/2026 | August rent | $1,350.00 | $1,350.00 | |
| 08/07/2026 | Late fee (paid after grace period) | $50.00 | $1,400.00 | |
| 08/10/2026 | Payment, Zelle | $1,400.00 | $0.00 | |
| 09/01/2026 | September rent | $1,350.00 | $1,350.00 | |
| 09/02/2026 | Partial payment, Zelle | $900.00 | $450.00 | |
| 09/04/2026 | Payment of remaining balance, Zelle | $450.00 | $0.00 | |
| 10/01/2026 | October rent | $1,350.00 | $1,350.00 | |
| 10/01/2026 | Payment, ACH | $1,350.00 | $0.00 |
Notice that the late fee is its own line, the partial payment shows the $450 still owed, and every row ends with the balance. That is what makes a ledger easy to read for a tenant, a judge or a caseworker.
What is the difference between a tenant ledger, a rent ledger and a rent receipt?
| Document | What it covers | Who uses it |
|---|---|---|
| Tenant ledger | Full history of one tenant: all charges, payments and balance | Tenants, courts, housing agencies |
| Rent ledger | Often the same thing, or the landlord’s log of rent for all units | Landlords, tax preparers |
| Rent receipt | Proof of one single payment | Tenants paying by cash or check |
In practice most people use “tenant ledger” and “rent ledger” for the same document. A receipt proves one payment; the ledger proves the whole account.
How do you make a tenant ledger in Excel or Google Sheets?
You can build one by hand with five columns (date, description, charge, payment, balance) where the balance formula is the previous balance plus the charge minus the payment. Or you can use our free template, which builds it for you:
- Download the free rent ledger template and open it in Excel or Google Sheets.
- Add the tenant on the Tenants tab: unit name, rent, lease dates and deposit.
- Log each month on the Rent Log tab: due date, unit, rent due, any late fee, and what was paid.
- Open the Tenant Ledger tab and pick the unit from the yellow box.
- Print or save as PDF. The full history and current balance appear on one page.
What mistakes make a tenant ledger hard to trust?
- Starting the ledger only when there is a problem. Update it every month, even for tenants who always pay on time.
- Mixing in other money. Keep deposits, repair charges and utilities clearly labeled, or separate.
- Adding late fees the lease does not allow. Only charge what your signed lease says.
- Applying a payment to the wrong month. Note which charge each payment covers, oldest balance first.
- No backup. Keep bank records, check copies or receipts that match each payment line.
How do you send a tenant ledger to a tenant, court or housing agency?
Check every line against your bank records first. Then export a PDF (in Excel: File, Save As, PDF; in Google Sheets: File, Download, PDF) and send it by email or print it. Keep a copy of exactly what you sent and the date you sent it.
Note: Rules on late fees, partial payments and what a court needs vary by state and city. Check your local rules or ask a local attorney if you are heading to court.
Have more than one unit? See how to keep a rent ledger for a duplex or triplex in one file.
New to tracking rent? Read our guide on how to track rent payments.
Prefer an app to a spreadsheet? Our Stessa vs TurboTenant vs Baselane comparison looks at three popular landlord apps side by side.
Frequently asked questions
Is a tenant ledger a legal document?
It is a business record. It is not a contract, but courts and housing agencies often accept it as evidence of what was charged and paid, especially when it matches your bank records.
How far back should a tenant ledger go?
Ideally from the start of the lease. If someone asks for a set period, such as the last 12 months, start with the balance carried in from before that period.
Should the security deposit be on the tenant ledger?
List it, but separately. A deposit is held money, not a rent payment, so it should not lower the rent balance.
Can a tenant ask the landlord for a ledger?
Tenants often do, for example when applying for a new rental or a mortgage. Some states and cities also set rules about providing payment records, so check your local law.
Is there a free tenant ledger template?
Yes. Our free rent ledger template includes a Tenant Ledger tab that builds one tenant’s full history with a running balance, in Excel and Google Sheets. If you prefer a PDF, there is also a fillable one page rent ledger (PDF or Word) with a row for each month. Type into it on your computer or print it.
Is a tenant ledger the same as a rent payment record?
Yes, for most landlords. A rent payment record lists every rent charge and payment for one tenant, with dates and a running balance, which is what a tenant ledger does. A rent receipt covers only one payment.
What is the difference between a tenant ledger and a rent roll?
A tenant ledger is one tenant’s payment history over time. A rent roll is a one page snapshot of all your units on one date: who lives there, the rent, the deposit and any balance. Many landlords use both: a ledger for each tenant and a rent roll once a month.
