Rent ledger vs tenant ledger: what to track and why
By Anthony Basile -
A tenant ledger is the running record of one tenant's account: every charge, every payment or credit, and the balance after each one. A rent ledger is a record of rent charged and collected. Some property owners use the two names for the same document, and others keep a rent ledger for the whole property, with one line per unit each month.
Both answer the question that comes up most in a rental business: who owes what, and how did that balance get there? This guide explains what goes on each one, walks through filled-in examples for an invented triplex, and gives you a free rent ledger template (CSV) that opens in Excel, Google Sheets or Numbers.
What is a tenant ledger?
A tenant ledger, sometimes called a lease ledger, follows one lease from move-in to move-out. Each line is dated and is either a charge or a payment, and the balance carries forward from line to line.
Charges usually include:
- Rent, including a prorated first or last month.
- Recurring fees the lease sets, such as pet rent, parking or storage.
- One-time charges the lease allows, such as a utility bill passed through to the tenant.
Payments and credits include:
- Payments, with the date and the method (ACH, card, check).
- Credits, such as a concession you agreed to or a repair the tenant paid for with your approval.
The security deposit gets its own line or its own column, apart from the rent balance. You hold it on the tenant's behalf, so mixing it into the running balance makes the account look paid when it is not.
A tenant ledger example
J. Rivera leases unit 1 at the invented Cedar Court triplex starting August 18, 2026, at $1,550 a month. Rivera signs a pet addendum for $35 a month starting in September. The deposit of $1,550 is recorded separately.
August has 31 days, so the first month is prorated: $1,550 / 31 = $50 a day, times 14 days (August 18 through 31) = $700. The prorated rent calculator does this math for any move-in date.
| Date | Description | Charge | Payment or credit | Balance |
|---|---|---|---|---|
| 8/18/2026 | Rent, Aug 18-31 (14 days) | $700.00 | $700.00 | |
| 8/18/2026 | Payment, ACH | $700.00 | $0.00 | |
| 9/1/2026 | September rent | $1,550.00 | $1,550.00 | |
| 9/1/2026 | September pet rent | $35.00 | $1,585.00 | |
| 9/2/2026 | Payment, ACH | $1,585.00 | $0.00 | |
| 10/1/2026 | October rent | $1,550.00 | $1,550.00 | |
| 10/1/2026 | October pet rent | $35.00 | $1,585.00 | |
| 10/5/2026 | Payment, card | $1,000.00 | $585.00 | |
| 10/7/2026 | Credit, approved faucet repair paid by tenant | $85.00 | $500.00 | |
| Total | $3,870.00 | $3,370.00 | $500.00 |
Reading it from the top, you can see that Rivera paid August and September in full and on time, that October was paid in part, and that the $85 credit for the faucet repair is backed by a receipt. The $500 balance is the difference between $3,870 of charges and $3,370 of payments and credits, and every dollar of it traces to a dated line.
What is a rent ledger?
The term is used in two ways:
- One tenant's rent history. Many owners and templates call the tenant ledger above a rent ledger. If someone asks you for a rent ledger for one tenant, this is usually what they mean.
- A property's rent log. Owners with several units often keep one rent ledger per property, with a line for each unit each month: rent charged, payments and credits received, and the balance left.
Here is October at Cedar Court as a property rent ledger, as of October 10:
| Unit | Tenant | Charged | Paid or credited | Balance |
|---|---|---|---|---|
| 1 | J. Rivera | $1,585 | $1,085 | $500 |
| 2 | A. Brooks | $1,500 | $1,500 | $0 |
| 3 | - | $0 | $0 | $0 |
| Total | $3,085 | $2,585 | $500 |
Unit 3 is between tenants, so nothing was charged. The property collected $2,585 of $3,085 charged, an 83.8% collection rate so far this month, and the whole $500 open balance sits with one tenant. Rivera's tenant ledger explains it line by line.
Rent ledger vs tenant ledger at a glance
| Tenant ledger | Property rent ledger | |
|---|---|---|
| Covers | One tenant, one lease | Every unit in a property |
| Time span | Move-in to move-out | Usually one month per page |
| Shows | Each charge, payment, credit and the running balance | Rent charged, collected and owed per unit |
| Answers | How did this tenant's balance get here? | Which units are paid, and what is outstanding? |
The two work together. The property rent ledger flags the unit with a balance, and the tenant ledger shows how it built up. A rent roll is a third view: a snapshot of every unit's lease, rent and status on one date.
Why keeping a ledger matters
- Questions about a balance. When a tenant asks why they owe $500, you can walk through the dated lines together instead of searching bank statements.
- Move-out. When a tenant leaves, the ledger shows any rent or charges still open, separate from the deposit you hold.
- Lenders and buyers. A lender reviewing a refinance, or a buyer reviewing a property, may ask for rent ledgers to confirm that tenants actually pay what the leases say.
- Your books. Payments on the ledgers should match the deposits in your bank account. If they do, your rental income is right. The monthly totals also feed straight into a rental cash flow calculator when you want to see what the property earns after expenses.
How to keep a rent ledger
- Download the template. The rent ledger template (CSV) has the Cedar Court example rows and blank rows below them. Keep one sheet per tenant, or one sheet per property with the unit in each row.
- Start at move-in. Enter the first rent charge, prorated if the lease starts mid-month, and record the security deposit apart from the rent balance.
- Post charges on the due date. Add rent and any recurring fees on the day they are due, whether or not the tenant has paid yet.
- Post payments the day they arrive. Record the date, the amount and the method, and keep the receipt or confirmation.
- Explain every credit. Write down why you gave it and save the paperwork, such as the repair receipt.
- Carry the balance forward. Each line's balance is the previous balance plus the charge, minus the payment or credit.
- Reconcile monthly. Compare the payments on your ledgers with your bank deposits for the month, and fix any gaps while they are fresh.
Frequently asked questions
Is a rent ledger the same as a tenant ledger?
Often, yes. Many owners and templates use both names for the record of one tenant's charges, payments and balance. Some owners also keep a property-level rent ledger with one line per unit each month. Use whichever setup makes it easy to answer who owes what.
What is the difference between a rent ledger and a rent roll?
A rent ledger is a history: charges and payments over time, with a running balance. A rent roll is a snapshot of every unit's lease, rent and status on one date. The balance column on a rent roll comes from the ledgers.
Should a tenant ledger include the security deposit?
Record it, and keep it out of the rent balance. Most ledgers give the deposit its own line or column, because you hold it for the tenant and it is accounted for separately when they move out.
How long should I keep tenant ledgers?
Keep each ledger for at least as long as you keep the lease and your tax records for that property. Ask your accountant or attorney how long that should be for your situation.
Can a tenant ask for a copy of their ledger?
Many tenants do, especially when they apply for a new home or have a question about a balance. Sharing a clean ledger answers the question quickly and keeps everyone working from the same numbers.
Keep the numbers current
A spreadsheet ledger works as long as someone posts every charge and payment on time. KeyRing records each tenant's lease, rent charges and payments as they happen, and each lease keeps a deposit ledger with the balance held, so the details a ledger needs live in one place for every property you own. See what KeyRing does or how plans are priced.