What Is a Rent Ledger?
A rent ledger is a dated record of every charge and payment for a tenant, netted to a running balance: the single source of truth for who owes what and how they got there.
14-day free trial · No credit card required · All features included
Rent Ledger — Maple Street Duplex, Unit B
Unit B · June
Balance: $0.00
| Date | Entry | Amount | Balance |
|---|---|---|---|
| Jun 1 | Rent Charge | $1,200.00 | $1,200.00 |
| Jun 3 | Received Payment | $700.00 | $500.00 |
| Jun 6 | Late fee Charge | $50.00 | $550.00 |
| Jun 9 | Received Payment | $550.00 | $0.00 |
What a rent ledger tracks
A rent ledger records two kinds of events for a single tenant, in date order: charges (what they owe) and payments (what they paid). The balance is just charges minus payments, at any point in time.
That's it. No formulas, no color-coding, no separate notes for late fees or partial payments. Everything the ledger needs to answer "what does this tenant owe right now" lives in one place, in order.
- Charges: rent, late fees, utility reimbursements, each dated and categorized
- Payments: every amount received, dated and matched against what was owed
- Balance: charges minus payments, always current, never a manual calculation
A rent ledger example
Here is a real month for one tenant, Unit B at a fictional Maple Street Duplex. Rent posts on the 1st, a partial payment arrives on the 3rd, a late fee gets added on the 6th, and the balance is paid off on the 9th.
Four lines, and the whole story is right there: not just that the tenant is paid up, but exactly how. That record holds up in a dispute, at tax time, and two years from now when nobody remembers June.
- Jun 1: rent charge, $1,200.00 (balance $1,200.00)
- Jun 3: payment, $700.00 (balance $500.00)
- Jun 6: late fee charge, $50.00 (balance $550.00)
- Jun 9: payment, $550.00 (balance $0.00)
Rent ledger vs. lease ledger vs. general ledger vs. rent log
These terms get used loosely, and it's easy to assume they mean different things when they mostly don't. A rent ledger, lease ledger, resident ledger, and tenant ledger are usually the same idea: the dated charges-and-payments history tied to one lease. The wording just varies by region and by which software you use. A rent log is typically an informal version of the same thing, often a spreadsheet, before it becomes a proper ledger.
A general ledger is different: it's the complete accounting record for a property or company, covering every account, not just one tenant's rent. TenantLedger keeps a real general ledger with a chart of accounts you control, and every tenant's rent ledger is simply one thread running through it.
Why a spreadsheet isn't a ledger
A spreadsheet can hold a grid of numbers, but rent isn't a grid. It's a ledger. The moment a tenant pays part of what they owe, or a late fee needs adding, a cell can't hold that cleanly without turning into a guess you'll misread later.
Rent ledger checklist
Whatever you use to track rent (spreadsheet, notebook, or software), a real rent ledger needs to capture the same handful of things for every tenant:
- A dated entry for every charge and every payment, never just one running "paid/unpaid" flag
- An amount and a category for each charge (rent, late fee, utility reimbursement, and so on)
- A payment method and date for every amount received
- A running balance that updates automatically, not a formula you maintain by hand
- A history you can hand to a tenant, a court, or your accountant without translating it first
Common questions
What is a rent ledger?
A rent ledger is a dated record of every charge and payment for a single tenant, netted to a running balance. It's how a landlord (or software) always knows exactly what a tenant currently owes and how they got there.
Is a rent ledger the same as a lease ledger?
Yes, essentially. The terms "rent ledger," "lease ledger," "resident ledger," and "tenant ledger" all describe the same charges-and-payments history for one lease. The wording varies by region and by which property management software you use.
How is a rent ledger different from a general ledger?
A general ledger is the full accounting record for a property or company, covering every account, every category. A rent ledger is narrower: just one tenant's charges and payments. TenantLedger keeps both, and every rent ledger is part of the larger general ledger.
Can I keep a rent ledger in a spreadsheet?
You can, and many landlords start there, but spreadsheets struggle with partial payments, late fees, and keeping a clean dated history once a lease has any real activity. See the guide on moving off a spreadsheet below for what that transition actually looks like.
See a real rent ledger for your properties
Add a property, record a payment, and see your own numbers in minutes.
14-day free trial · No credit card required