A rent ledger is a running record of what one tenant was charged, what they paid and the balance after each entry. It is also called a tenant ledger or a lease ledger. Build one below, then download a spreadsheet with live formulas or print a clean copy, free and with no sign-up.
Free rent ledger builder
The example below is a made-up tenant with one split payment and one short month. Change anything and the balance follows. Blank rows and typos count as zero rather than breaking the math, and an overpayment shows as a credit.
Rent ledger builder
| Date | Description | Charge | Payment | Balance | Remove |
|---|---|---|---|---|---|
| $1,800.00 | |||||
| $0.00 | |||||
| $1,800.00 | |||||
| $600.00 | |||||
| $675.00 | |||||
| $0.00 | |||||
| $1,800.00 | |||||
| $0.00 | |||||
| $1,800.00 | |||||
| $800.00 |
Runs in your browser. Nothing you type is stored or sent, so download or print before you leave the page. The tenant, the rent and the 75 dollar late fee are sample figures: use your own lease and your state's late fee limit.
Key takeaways
- The formula is one line: new balance equals last balance, plus the charge, minus the payment.
- In the example, 7,275 dollars charged minus 6,475 dollars paid leaves 800 dollars owed.
- A rent ledger shows one account over time. A rent roll shows every unit at one moment.
- In D.C. nonpayment cases, court rule requires landlords to bring existing ledgers to every hearing.
| Record | What it covers | Answers | Weak spot |
|---|---|---|---|
| Rent ledger (tenant or lease ledger) | One tenant, every charge and payment | What is owed, and how it got there | Only as good as its entries |
| Rent receipt | One payment | Did this payment happen | Says nothing about the balance |
| Bank statement | Money that moved through an account | Did the money arrive | Does not show charges or what a deposit was for |
| Rent roll | All units at one point in time | What is this building collecting | No payment history |
What goes in a tenant ledger or lease ledger?
A tenant ledger holds the tenant and unit at the top, then one line per event: the date, a description, the charge or the payment, and the balance after it. Charges include rent, late fees and anything else the lease allows. Payments carry a method, so you can match them to a deposit later. Rent ledger, tenant ledger and lease ledger all describe this same record, and the name mostly depends on your software.
- Each charge on its own line. Rent on the 1st and a late fee on the 6th are two events, with two dates.
- Each payment on the date you received it. Partial payments get their own line too.
- Credits as payments. If you waive a fee, enter it as a credit with the reason in the description, rather than deleting the fee.
- One ledger per tenancy. A new tenant in the same unit starts a new one.
A rent ledger template is a fine start, and most of those on the first page of results are PDFs to fill in by hand. The builder here does the arithmetic for you, and the CSV holds a formula in each balance cell, plus 24 spare rows for the months ahead.
How to read a rent ledger, line by line
Read a rent ledger from the top, following the balance. It should drop to zero whenever the tenant is paid up, and every rise should have a charge beside it. Here is the example from the builder, for a tenant at 1,800 dollars a month. The late fee is a sample figure, so check your own state's limit in the guide to collecting rent and late fees.
| Date | Entry | Charge | Payment | Balance |
|---|---|---|---|---|
| Aug 1, 2026 | Rent | $1,800 | $1,800 | |
| Aug 1, 2026 | Bank transfer | $1,800 | $0 | |
| Sep 1, 2026 | Rent | $1,800 | $1,800 | |
| Sep 3, 2026 | Partial, check | $1,200 | $600 | |
| Sep 6, 2026 | Late fee | $75 | $675 | |
| Sep 15, 2026 | Bank transfer | $675 | $0 | |
| Oct 1, 2026 | Rent | $1,800 | $1,800 | |
| Oct 2, 2026 | Bank transfer | $1,800 | $0 | |
| Nov 1, 2026 | Rent | $1,800 | $1,800 | |
| Nov 2, 2026 | Partial, card | $1,000 | $800 |
Two things stand out once it is laid out this way. September took three payments' worth of attention, and you can see exactly why 75 dollars was added. November's 800 dollars is entirely new, because the account was at zero on October 2. The builder shows that date as "Last at zero". When a tenant says "I don't owe that much", it is where the conversation starts, and it saves going back through a year of bank statements.
How to enter the awkward ones
Awkward entries belong on the ledger as their own lines, each with a date and a reason, so the balance stays honest and the history stays readable. Most ledgers go wrong here rather than on a normal month. A tenant moves in on the 20th, a check bounces, or someone pays two months at once. These are our suggestions, so follow your lease where it says otherwise.
| What happened | How to enter it | Effect on the balance |
|---|---|---|
| Partial payment | A payment line for the amount actually received | Falls by that amount, and the rest stays owed |
| Bounced check | Leave the original payment, then add a charge line for the same amount, "returned payment" | Goes back up, and the history shows why |
| Mid-month move-in | A rent line for the prorated amount, per your lease | Rises by the prorated rent only |
| Paid two months at once | One payment line for the full amount | Shows a credit until next month's rent is charged |
| Waived late fee | Keep the fee, then add a credit line with the reason | Falls, with the waiver on the record |
| Security deposit | Keep it off the rent balance, on its own line or record | None |
Proration is simple arithmetic unless your lease says otherwise: monthly rent, divided by the days in that month, times the days occupied. A tenant at 1,800 dollars who moves in on November 20 occupies 11 of 30 days, so that first line is 660 dollars. The deposit stays separate for a tax reason too. IRS Publication 527 says a deposit you plan to return is not income, while any part you keep for damage or unpaid rent is.
To work with the file in Excel or Google Sheets, download the CSV and open or import it. Add new entries in the spare rows, in the date, description, charge and payment columns. The balance column, the totals and the amount owed recalculate on their own. Save your copy as a spreadsheet file so the formulas and any formatting stay put. Keep one file per tenancy, named for the unit and the tenant.
How do courts use a rent ledger?
Courts use a rent ledger to see how much is owed and how the balance built up, but the rules vary by court and a ledger is not automatically accepted as correct. We found one court rule that addresses ledgers directly, and it is a useful model even outside its jurisdiction. Your own court may work differently.
Rule 10 of D.C. Superior Court's Landlord and Tenant Branch says that in a nonpayment case, the landlord must bring copies of existing ledgers to every hearing, including mediation. They must reach back to the last time the balance was zero. A landlord without a ledger brings other records, such as bank statements and receipts, and the rule does not require anyone to create a ledger that does not exist.
One Florida landlord firm, Andrew Douglas, P.A., writes that judges there use the ledger to check the amount owed, partial payments and whether the eviction notice matches the balance. That is one firm's account of its own practice, and it represents landlords. Read it as a checklist rather than a statement of law.
How do applicants use a rent ledger?
Renters can use a ledger from a past landlord to show a record of on-time payments when they apply for another rental or a mortgage. How much it counts is up to whoever reviews it. TurboTenant suggests applicants use prior ledgers to speed approval, which is a vendor recommendation and not a screening rule.
Mortgages have a firmer source. Fannie Mae's Selling Guide, in its section on nontraditional credit, accepts canceled checks, bank statements or direct verification from a landlord to document 12 straight months of housing payments. It does not name a ledger. But a landlord with a clean one can answer a verification request in a few minutes, and that is a small favor a good tenant will remember.
How do you keep a rent ledger that holds up?
A rent ledger holds up when every line traces to something else: a lease clause, a bank deposit or a receipt. Enter things when they happen, and never overwrite. If you made a mistake, add a correcting line and say why. A ledger that visibly fixes its errors is more believable than one with none.
- Match it to the bank. Check it against your deposits once a month.
- Do not net payments. A 1,200 dollar payment is one line, even if a fee came out of it later.
- Be careful with advance rent. IRS Publication 527 counts it as income in the year you receive it, whatever period it covers.
- Hand over copies freely. Most balance disputes end when both sides are reading the same page.
The ledger is the bookkeeping half of the job. The other half is the phone, because a tenant who wants to pay at 8pm or argue about a late fee will call. callflo.ai for property managers is an AI receptionist that answers those calls and logs each one with a summary and transcript. On VIP it can also take a card payment through Stripe on the call. It does not keep your ledger. You still enter payments here or in your property software. If you already use software that keeps a ledger for you, use that, and skip the spreadsheet.
For the rest of the routine, see how to be a landlord. callflo.ai's Starter plan is 39 dollars a month on annual billing or 49 dollars monthly, with 120 minutes and 98 cents for each extra minute.
Hear it take a tenant's call
Call callflo.ai's own AI agent and ask it anything about your business. When you are ready, pick a plan: no setup fee, no contract, and you do not pay unless you are satisfied.
Starter is $39 a month on annual billing. Live on your line about 5 minutes after you sign up.
When the ledger shows a balance, the past due rent notice generator writes the reminder.