Free rent ledger template that maps to your Schedule E

A rent ledger and a rent roll are different documents, and the difference matters the day someone else asks for one. The ledger is per-tenant: every charge and every payment for one tenancy, in date order, from move-in to today. The roll is a portfolio snapshot, one line per unit as of right now. Courts ask for the ledger. Lenders and buyers ask for the roll. If you need the roll, use the rent roll template; this page is the ledger.

A ledger gets read by exactly two audiences besides you: a judge in a nonpayment case, and your CPA in April. Most free templates serve neither; they track money in without saying where it lands on the return. This one carries a Schedule E note on every row, so the year-end totals fall onto the right line.

The template

Copy it into a spreadsheet (the pipes split cleanly into columns with one text-to-columns pass) or keep it as a document, one ledger per tenant. The header block comes straight from the lease, so every number on a row traces back to a clause.

How the rows land on Schedule E

Rents received is line 3 of Schedule E (Form 1040), and it is hungrier than it looks. Rent counts. Late fees count, as rental income rather than a separate category. Prorated rent, pet rent, and parking charges paid to you count. The one big item that does not count is the security deposit, which is not income while you hold it; it becomes income only in the year you keep some or all of it.

Say a tenant pays $1,450 a month for twelve months and pays late twice, eating a $50 fee each time. Line 3 for that tenancy is $17,400 in rent plus $100 in fees, $17,500 total. The $1,450 deposit sitting in your account appears nowhere on the return. A ledger with a type column makes that split automatic; a bank statement makes it a forensic exercise. The full line-by-line walk is in Schedule E for small landlords.

How to keep it so it holds up

• Record the day money arrives. Date received, method, and a reference (check number, confirmation code) take fifteen seconds in the moment and are unrecoverable six months later.
• One row per event, including the ugly ones. A bounced check gets a reversal row, not an edit. Never overwrite history; add a correcting row with a note.
• Write down partial-payment terms. If you accept $1,000 against $1,450, the notes column says what was agreed and by when, because that balance row is the first thing a judge will ask about.
• Issue receipts for cash and log the receipt number. The rent receipt template pairs with this ledger.
• Let the lease set the clock. Due day, grace period, and late fee live in the header with their lease section numbers, so a disputed fee points to a clause, not your memory.

Collection method matters less than people think; what matters is that whatever arrives (check, Zelle, money order) lands in the ledger the same day. Methods, raises, and the late-rent escalation are covered in how to collect rent as a small landlord.

The ledger in eviction court

When a nonpayment case gets filed, the payment history is usually the first exhibit. A ledger kept contemporaneously, in date order, with references and a running balance, reads like a business record. A spreadsheet reconstructed the weekend before the hearing reads like a story. Bring the ledger, the lease it points to, and copies of every notice you served; the late rent notice template covers the escalation paper. Notice periods, filing steps, and what counts as proper service vary by state, so read your state's statute before you file. A ledger is cheap to keep and expensive to need.

Mistakes that surface in April or in court

• Counting the deposit as rent. It overstates line 3 and taxes you on money you may owe back at move-out.
• Charging a late fee and never logging it. Charged means income; waived means a logged waiver. A gap between the lease and the ledger invites questions from both audiences.
• Keeping one ledger for the whole building. The per-tenant structure is the point. A building-wide list of deposits is a bank statement with extra steps.
• Reconstructing at year-end. Twelve months of Zelle screenshots and memory produce a ledger that neither you nor a judge can fully trust.

Where software takes over

I self-manage a small portfolio from two time zones away and close the books on the 5th of each month, and the spreadsheet version of this ledger is what kept dropping things, which is why I built rents.ai. Recording a payment on its rent roll writes the per-tenant ledger entry and the Schedule E line 3 rollup in the same motion, and a CSV export hands the spreadsheet back to anyone who wants it. It does not collect rent: there is no tenant portal and no bank feed, so you still type in each payment yourself, the same as the template above. The difference is that the ledger, the roll, and the tax totals stop being three documents kept in sync by hand.