Rent Ledger vs. Rent Roll — and What Actually Belongs in Each
A rent ledger is a chronological transaction record for one tenancy — every charge and every payment, in date order, with a running balance. A rent roll is a portfolio-level snapshot: every unit, its tenant, lease dates, rent, deposit and current status, as at a date.
You need both, but you should only maintain one. Keep the ledger by hand and let the rent roll be calculated from it — a rent roll typed independently of the transactions it summarizes goes wrong within a quarter.
The short version
- Ledger = one tenancy, over time. Rent roll = all tenancies, at a moment.
- Record payments as dated rows, never as amounts typed into a month grid.
- Every payment row needs the month it applies to — that is what makes catch-up payments land correctly.
- A mid-lease rent increase is a change to the charge schedule, not an edit to past rows.
- Accepting a partial payment can affect legal remedies in some states — record it accurately and check local rules before relying on it.
The two words get used interchangeably, and the confusion causes real bookkeeping problems. They are different documents with different jobs.
The rent ledger: one tenancy, over time
A ledger is the transaction history for a single tenancy. Charges go on one side, payments on the other, in date order, with a balance that carries forward. It answers "what happened, and what is owed today?"
| Column | Why |
|---|---|
| Date of transaction | The spine of the record |
| Type | Rent charge, payment, late fee, credit, deposit |
| Period it applies to | Makes catch-up payments land in the right month |
| Amount charged / amount paid | Separate columns, never one signed column |
| Method & reference | Check number, transfer reference, app ID |
| Running balance | What is actually owed after this row |
| Note | "Partial — balance promised on the 20th" |
The rent roll: all tenancies, at a moment
A rent roll is the snapshot a lender, insurer, accountant or prospective buyer asks for. One row per unit: unit identifier, tenant name, lease start and end, monthly rent, deposit held, paid-through date, current balance, and status (occupied, vacant, notice given). Add a date at the top — a rent roll without an "as at" date is a fiction.
Small-portfolio landlords also use a hybrid view that gets called a rent roll: units down the side, months across the top, color-coded green for paid, amber for partial, red for missed, gray for vacant. It is genuinely useful — provided it is calculated, not typed.
The one rule that makes both work
Record payments as dated transaction rows, then calculate the grid. Do not type amounts into a month grid.
This is not a stylistic preference. Everything awkward about rent tracking is awkward only in the grid version:
- Partial payments. $600 on the 3rd and $550 on the 28th is two rows summing to $1,150 against $1,150 due. In a grid it is one cell that has to be overwritten twice and remembers nothing.
- Catch-up payments. A May payment for April's rent carries "applies to: April". April stops showing as missed; May does not show a surplus.
- Late flags. Compare the payment date against the due date plus your grace period. The row knows; you don't have to.
- Disputes. A dated list with references and a running balance is boring, and boring is what ends arguments.
The files that do this for you
The Landlord Ledger Toolkit is 4 Excel/Google Sheets workbooks, 3 editable Word templates and a printable PDF — rent tracking, Schedule E expense logging, maintenance, key dates, move-in/move-out, notices and screening. Built for 2–10 units. One payment, no subscription.
Mid-lease rent increases
Handle an increase as a change to the charge schedule, effective from a date, not as an edit to what came before. The ledger keeps charging $1,150 through June and $1,200 from July, and every historic row stays exactly as it was. If your system requires you to retype rent into twelve cells, an increase means twelve chances to make an error — and the record of what was actually charged in March quietly changes, which is the opposite of what a ledger is for.
Recording a partial payment properly
Record it exactly: the amount received, the date, the period it applies to, and the balance remaining. Do not round it up, and do not mark the month paid because the rest was promised.
Will a court or a lender accept a spreadsheet?
Generally yes, in the sense that a ledger's credibility comes from its consistency and its supporting evidence rather than from the software that produced it. A ledger maintained contemporaneously, agreeing with bank deposits, with references that can be traced to actual transactions, is a serious document. One assembled the week before a hearing, with numbers that don't tie to the bank, is not — and that is equally true in expensive property-management software.
Six numbers worth having on top
Once the transactions exist, a dashboard is arithmetic: collected year-to-date against scheduled, collection rate, outstanding balances by unit, occupancy rate, days vacant year to date, and late payments to date. That last one is the early-warning light — a tenant drifting from the 1st to the 9th is telling you something months before they miss. For more on the design, see the rent tracker spreadsheet that actually works.
Start with the free one-pager
The Landlord Tax Deductions Cheat Sheet puts every Schedule E line, the repairs-vs-improvements trap and the most-missed write-offs on a single printable page. Free — no card, no payment details.
Questions landlords ask about this
What is the difference between a rent ledger and a rent roll?
A rent ledger is the dated transaction history for one tenancy, showing charges, payments and a running balance over time. A rent roll is a portfolio snapshot as at a date, with one row per unit showing tenant, lease dates, rent, deposit held and current status.
What columns does a rent ledger need?
Date, transaction type, the period the transaction applies to, amount charged and amount paid in separate columns, payment method and reference, a running balance, and a free-text note.
How do I record a partial or late payment correctly?
Enter it as its own dated row for the exact amount received, tagged to the period it applies to, leaving the remaining balance outstanding. Do not mark the month paid because the rest was promised. Note that in some states accepting a partial payment can affect a non-payment process already under way, so check local rules before accepting.
How do I handle a mid-lease rent increase in the same ledger?
Treat it as a change to the charge schedule effective from a date, so historic rows are never edited. The ledger charges the old amount up to the effective date and the new amount afterwards, and the record of what was actually charged in each earlier month stays intact.
Will a court or lender accept a spreadsheet rent ledger?
Credibility comes from consistency and corroboration rather than from the software. A ledger kept contemporaneously, agreeing with bank deposits and with traceable payment references, is a serious record; one assembled shortly before a hearing is not, whatever produced it.
Educational information, not legal advice. Landlord–tenant rules vary by state and city and change over time — check your local rules, and take real disputes to a local attorney.