When a tenant says “I paid that,” the conversation goes one of two ways. Either you both open the same page and read down to the line in question, or you each start reconstructing months of texts and bank statements from memory. The page is a tenant ledger, and keeping one takes about two minutes a month.
What a tenant ledger is
One sheet per tenancy. Each line is one event: a charge coming due or a payment arriving. A running balance column shows what the tenant owes after each line. That is the whole idea.
It is not a rent roll. A rent roll shows every unit on a single day. A ledger shows one tenancy over its whole life. You want both, and they answer different questions.
The free tenant ledger template uses these columns:
| Column | What goes in it |
|---|---|
| date | The day the charge came due or the payment arrived |
| description | What the line is, in plain words |
| charge | The amount owed by this line, or blank |
| payment | The amount received on this line, or blank |
| balance | Previous balance, plus the charge, minus the payment |
| method | ACH, check, money order, cash |
| reference | Check number, receipt number, or bank reference |
A line is a charge or a payment, never both.
A filled-in sample
A tenant moves in on September 16, 2026. Rent is $1,800, due on the first. The security deposit is $1,800, paid at signing.
| date | description | charge | payment | balance | method | reference |
|---|---|---|---|---|---|---|
| 2026-09-16 | Rent, Sept 16-30 (15 of 30 days) | 900.00 | 900.00 | |||
| 2026-09-16 | Payment | 900.00 | 0.00 | ACH | Receipt 2001 | |
| 2026-10-01 | October rent | 1,800.00 | 1,800.00 | |||
| 2026-10-02 | Payment | 1,800.00 | 0.00 | Check | Check 1184 | |
| 2026-10-07 | Returned check 1184, insufficient funds | 1,800.00 | 1,800.00 | Bank notice 10/07 | ||
| 2026-10-09 | Payment | 1,800.00 | 0.00 | Cashier’s check | CC 55102 | |
| 2026-11-01 | November rent | 1,800.00 | 1,800.00 | |||
| 2026-11-03 | Payment | 1,800.00 | 0.00 | ACH | Receipt 2014 |
Three things worth noticing.
The first month is its own line. The prorated amount is a charge with the math written into the description, so nobody has to redo it in a year. If you have not worked out a proration method yet, how to prorate the first month’s rent walks through the choices.
The bounced check is not erased. The October 2 payment stays exactly where it is. When the bank returned it, a new line put the $1,800 back on the balance with the bank’s notice as the reference. Anyone reading the ledger later sees what happened and when, which is the point of keeping one. In California, a returned check also opens a specific option: under Civil Code § 1947.3(a)(2), you may require cash for up to three months, but only with a written notice that says the payment was dishonored and attaches a copy of the check.
The deposit is not on it. More on that below.
The habits that keep a ledger honest
Write the line when the event happens. Rent charges post on the due date. Payments post on the day the money arrived, not the day you got around to the spreadsheet. If you deposit a check on the 6th that came in on the 2nd, the ledger says the 2nd.
One event, one line. “October, $1,850 paid” hides a rent charge, a late fee, and possibly two payments. When the tenant disputes the fee, you need to point at the fee.
Fix mistakes with a new line. If you posted $1,080 instead of $1,800, add an adjusting line (“Correction: payment on 10/02 entered as 1,080.00”) rather than typing over the old number. A ledger with edits nobody can see is one a judge has no reason to trust.
Only charge what the lease allows. A late fee goes on the ledger only if the lease provides for it and your state allows that amount. The ledger records a fee. It does not make the fee legal. Late rent fee laws by state covers the limits.
Apply payments in a fixed order. When a payment does not cover everything owed, decide once whether it goes to the oldest charge first or to rent before fees, write that rule down, and use it every time. Should you accept partial rent payments explains why the order matters once a notice is in play.
Give receipts. Put a receipt number in the reference column for every payment, especially cash. In California, Civil Code § 1499 gives anyone who pays an obligation the right to ask for a written receipt, and a few states have specific rent receipt rules, covered in does a landlord have to give rent receipts.
Where the security deposit goes
Keep it off the rent ledger, or in its own section above the lines, outside the running balance. The deposit is not rent and it is not yours yet.
The IRS draws the same line. Publication 527 says a security deposit you plan to return to the tenant at the end of the lease is not income when you receive it. If you keep part of it because the tenant did not meet the lease terms, that part is income in the year you keep it. Advance rent is different: it is income in the year you receive it, whatever period it covers. A ledger that mixes the deposit into the rent balance makes both numbers harder to read at tax time.
At move-out, the deposit’s own record (what you received, what you deducted, what you returned) goes on the itemized deposit statement you send the tenant.
How long to keep it
Keep the ledger for the whole tenancy and after it ends. The IRS generally says to keep records for 3 years from when you file, and longer in some situations. A ledger is also what you will reach for in a deposit dispute or an eviction, so keep it at least as long as you keep the lease.
When the ledger keeps itself
A spreadsheet ledger works fine for a handful of tenancies. It gets harder when rent arrives by four different methods and you are the only one who can update the file. If you collect rent in LeaseRooster on the Solo plan and up, every charge and payment posts to the tenant’s ledger, and the tenant gets a receipt. LeaseRooster does not import payment history, so keep your spreadsheet as the record of the months before you switched.
This is general information, not legal or tax advice. Rules change and local ordinances vary. Confirm current requirements with your city, county, an attorney, or a tax professional before you act.