What a tenant ledger is and how to keep one
A tenant ledger is a running list of everything a tenant has been charged and everything they have paid, with a balance after every line. Keep one per lease, enter each charge on the day it is due and each payment on the day the money lands in your bank, and never edit an old line: fix a mistake with a new line that reverses it.
What is a tenant ledger?
A tenant ledger is the account history of one tenant on one lease. Think of a bank statement for the tenant's rent: charges add to the balance, payments and credits subtract from it. When a tenant says "I paid in March", the ledger is where you look first, and when a court, a buyer or a lender asks what a tenant owes, it is the document you hand over.
It is different from a rent roll. The rent roll is one line per unit on one date. The ledger is many lines for one tenant over time. The rent roll's "balance owed" column should equal the last line of each ledger.
Which columns should it have?
| Column | What goes in it | Why it matters |
|---|---|---|
| Date | The day the charge was due or the money arrived. | Late fees and notices depend on the exact day. |
| Description | Rent for March, late fee, pet rent, payment by bank transfer. | Anyone reading the line should understand it without asking you. |
| Charge | Amounts the tenant owes. | Adds to the balance. |
| Payment or credit | Amounts received or forgiven. | Subtracts from the balance. |
| Balance | Running total after the line. | Shows at a glance when the tenant first fell behind. |
| Reference | Bank transaction, memo, check number or work order. | Lets you trace the line back to proof. |
Keep the security deposit off the rent balance. A deposit is money you hold for the tenant, not income, so it belongs on its own deposit ledger. The deposit accounting guide explains why.
How do I enter rent, late fees and partial payments?
- On the due date, post the month's charges: rent, plus any recurring pet rent or parking.
- When a payment lands in your bank, post it on the day it arrived, not the day the tenant says they sent it.
- If the payment is short, record the real amount. The rest stays open on the balance.
- If your lease and your state allow a late fee, post it as its own charge on the day it becomes due, never inside the rent line.
- If you agree to waive something, post a credit with a note saying why, so the waiver is visible later.
Example a made-up tenant owes $1,200 rent on the 1st. They pay $900 on the 3rd. The ledger shows a $1,200 charge (balance $1,200), a $900 payment (balance $300), and, if the lease allows one, a $50 late fee after the grace period (balance $350). On the 10th they pay $350 and the balance returns to $0.
When one payment covers several things, the lease should say which comes first. Many leases apply money to the oldest charge first. See how to apply payments.
How do I fix a mistake without erasing history?
Do not overwrite or delete a line. Add a correcting line: a credit that reverses the wrong charge, then the right charge if one is needed, each with a note. An edited history looks like tampering if the ledger is ever shown to a judge, an insurer or a buyer, while a visible correction looks like careful bookkeeping.
Do the same with a bounced payment. The original payment line stays, a reversal line follows it, and a returned-payment fee goes in only if your lease and state allow one.
How long should I keep ledgers?
The IRS says to keep records until the period of limitations for the return runs out, and Publication 583 lists the periods: generally 3 years, 6 years if you leave out more than 25 percent of the gross income on the return, and with no limit for a fraudulent return or no return. Rental ledgers support the income on your return, so keep them at least that long. Some states set their own record rules for deposits and eviction cases, and you should keep the ledger of a former tenant through any dispute about their deposit.
How DoorKeeping handles it
DoorKeeping keeps a tenant ledger for every lease. Incoming bank deposits are matched to the tenant by the memo (for example 12B SMITH) and the exact amount, you confirm the unclear ones, and the match posts the payment on the day the deposit arrived. Late fees post within your state's cap. You can ask Claude or ChatGPT "show the ledger for unit 12B" and it reads the same ledger. Rent and payments stay in your own bank accounts. DoorKeeping never holds your money and sends a payment only when you approve it.
Sources
- IRS Publication 583: Starting a Business and Keeping Records, read Oct 30, 2026
- IRS Publication 527: Residential Rental Property, read Oct 30, 2026
- DoorKeeping: Connect Claude or ChatGPT (steps and tools list), read Oct 30, 2026
Questions
- What is the difference between a tenant ledger and a rent roll?
- A rent roll shows every unit on one date. A tenant ledger shows every charge and payment for one tenant across time. The last ledger balance should match the rent roll.
- Can I keep a tenant ledger in a spreadsheet?
- Yes, for a few units. Use the same columns, never overwrite old lines, and keep a backup. Software that matches bank deposits saves the typing as you grow.
- Should the security deposit appear on the tenant ledger?
- Keep it on a separate deposit ledger, because it is money held for the tenant and not rent income. Show the tenant both when they ask.
- Who is allowed to see a tenant ledger?
- The tenant on that lease, you, your accountant and anyone you are legally required to show it to. Do not share one tenant's ledger with another tenant.