A rental ledger is the record of every rent charge and payment for one tenancy, in date order, with the balance after each line: each charge raised under the lease, and each payment recorded against it. It answers how a resident's balance got to where it is. Keep one per lease, enter each charge and payment the day it happens, give every exception its own line and reason, and tie the open balances to the receivables each month.
You can say what any resident owes today: the roll carries the number, and the number is right. The question that comes back is a different one. A resident disputes a late fee, an owner asks why one unit is still open, a court asks for the payment history, and each of them is asking how the balance got there, not what it is. A balance with no history behind it is an assertion. The ledger is the history.
This is a spoke of Automated Rent Collection: From Charge to Cleared Payment, which covers the whole cycle. This one covers the ledger alone: what it records, how it differs from the rent roll and the aging report, a worked example, how it ties to the books, how to keep it accurate, and how Scaalr keeps it.
What a rental ledger records
A rental ledger (also called a rent ledger, a tenant ledger, or a lease ledger) is the account of one tenancy: a header that says whose rent it is and what the lease sets, then one line for every event that changes what is owed, in date order, with the balance after each. Rent for a period, a payment with its method, a late fee the lease allows, a returned payment and its reversal, a waiver, a write-off, and a refund are each a line, the last three with their reasons. The balance at the bottom is never typed in; it is what the lines add up to. In an eviction case over unpaid rent, the ledger is the exhibit a court reads first, which is why every line carries its date.
The table lists the fields and what each is for.
| Field | What goes in it | What it is for |
|---|---|---|
| Header | Property and unit, the residents on the lease, the rent amount, the billing frequency, the due day, and the deposit held | Says whose ledger this is and what the lease set |
| Date | The day the charge fell due or the payment arrived | Order is the ledger; a line out of order is a balance you cannot explain |
| Entry | What happened: rent for a period, a fee, a payment, a returned payment, a waiver, a write-off, a refund | One line per event, never one line per month |
| Charged and paid | The amount the entry added to what is owed, or the amount received with its method | The debit and credit sides of the tenancy, and the proof the resident will ask for |
| Recorded by and reference | Who entered the line, and the receipt, confirmation, or journal number behind it | The line a court or an auditor reads first |
| Balance | What is owed after this line | The number everyone asks for, carried rather than remembered |
The deposit sits in the header as an amount held and nowhere in the balance: it is the resident's money until the lease says otherwise, and its entries are in Security Deposit Accounting for Property Managers.
The ledger, the rent roll, and the aging report answer different questions
The difference between a rental ledger and a rent roll is scope. A rental ledger is one tenancy's history; the rent roll is the portfolio's list for this cycle: every tenancy, what it owes, and where each charge stands. The A/R aging report is every unpaid amount the books carry as of one date, by how long it has been owed. All three are built from the same charges and payments, and they disagree only when a charge or a payment reached one and not the others.
| Question | Rental ledger | Rent roll | A/R aging report |
|---|---|---|---|
| What it covers | One tenancy, from its first charge to today | Every tenancy, this cycle | Every unpaid amount in the books, as of a date |
| What it answers | How did this balance get here? | What is due this month, and from whom? | How long has each balance been owed? |
| One line is | One charge or one payment | One tenancy's rent | One unpaid item |
| Who asks for it | The resident, an owner, a court | An owner, a lender, a buyer | An owner, the accountant, whoever is chasing |
| Built from | The lease's charges and payments | The leases | The posted receivables |
Keeping the roll right as the portfolio grows is covered in How to Keep Your Rent Roll Accurate as Your Portfolio Grows, and reading the aging every week in A/R Aging Report for Property Managers: How to Read It. The ledger is what both point back to when a number needs explaining.
A worked rental ledger example: one tenancy over four months
The rental ledger example below is one tenancy with monthly rent of $1,850 due on the 1st, a lease that allows a $50 late fee once rent is five days late, and an increase to $1,895 effective April 1 after proper notice. Every event is its own line; the balance column is read, never typed.
| Date | Entry | Charged | Paid | Balance |
|---|---|---|---|---|
| Jan 1 | Rent, January | $1,850.00 | $1,850.00 | |
| Jan 1 | Payment, bank transfer | $1,850.00 | $0.00 | |
| Feb 1 | Rent, February | $1,850.00 | $1,850.00 | |
| Feb 3 | Payment, card, partial | $1,000.00 | $850.00 | |
| Feb 7 | Late fee under the lease, February rent | $50.00 | $900.00 | |
| Feb 19 | Payment, bank transfer | $900.00 | $0.00 | |
| Mar 1 | Rent, March | $1,850.00 | $1,850.00 | |
| Mar 2 | Payment, check | $1,850.00 | $0.00 | |
| Mar 9 | Payment of March 2 returned by the bank | $1,850.00 | $1,850.00 | |
| Mar 12 | Payment, bank transfer | $1,850.00 | $0.00 | |
| Apr 1 | Rent, April, at the increased amount | $1,895.00 | $1,895.00 | |
| Apr 1 | Payment, bank transfer | $1,850.00 | $45.00 |
Read down the balance column and the tenancy explains itself. The $900 in February is a partial payment plus the fee the lease allows. The returned check in March stays on the record as a payment that was made and then came back, so the balance reopened on its own line. The $45 at the bottom is the kind of balance a roll shows as Partially Paid and cannot explain: the resident paid the old rent on the day the new one took effect.
The same layout is a spreadsheet you can keep per lease, with the balance column calculated for you: download the rental ledger template (Excel), a blank ledger with the header fields above and this example on a second sheet.
How the ledger ties to the books
In double-entry books, a rental ledger is a subsidiary ledger: the detail behind one control account, Accounts Receivable. A rent charge debits receivables and credits rent income; a payment debits the bank and credits receivables; a late fee debits receivables and credits fee income; a waiver or a write-off credits receivables against revenue or bad debt expense, the entries Should I Write Off Unpaid Rent From a Former Tenant? sets out. Add up the open balance on every tenancy's ledger and, when the books are right, the total is the receivables account's balance on the same date; the A/R aging report is that total listed item by item. When the two disagree, the difference is a charge raised in one place and not the other, a payment recorded against the wrong charge, or a balance edited instead of reversed, and the ledger is where you find which. The accounting spine behind all of it is in Property Management Accounting: The Complete Guide.
How to create a rental ledger and keep it accurate, step by step
Creating a rental ledger and keeping it accurate is eight habits.
- Open one ledger per lease, not per resident or per unit, with the header filled in first: property, unit, the residents on the lease, the rent amount, the billing frequency, the due day, and the deposit held. A lease with two residents has one ledger; a resident who moves units gets a new lease and a new ledger, and the old one closes at zero or at a documented ending.
- Raise every charge from the lease on its due date: the rent, at the amount and frequency the lease sets, and only the fees the lease allows, each as its own line.
- Record each payment against the charge it pays, on the day it arrives, with the amount, the method, and who took it.
- Give every exception its own line and its reason: a partial payment, a late fee, a returned payment, a waiver, a write-off, a refund. A wrong line is reversed by a new line, never edited, so the record shows what happened and what corrected it.
- Carry the balance after every line, and read it before you answer anyone about what is owed.
- Change the rent on the lease, never on the ledger. An increase arrives as a new charge amount from its effective date, with the notice on file, and nothing earlier changes.
- Tie the ledgers to the books at month end: the open balances across every ledger add up to the receivables account, and the aging report lists each one by age. Find the difference before the month closes, a step on the Month-End Close Checklist for Property Managers.
- Keep it in the form you would hand over to the resident who asks, the owner who wants to know, or the court that requires it.
How Scaalr keeps the record charge by charge
In Scaalr the rental ledger is kept charge by charge, from the lease outward. Every night a background service raises the next rent charge for every active lease due that day, inheriting the lease's amount, currency, and residents, and generation is duplicate-proof. Each charge's Payments tab lists every payment recorded against it, with the date, amount, method, note, and the staff member who recorded it, under a header that totals what has been paid and what is outstanding; a toggle shows the journal entry, account, and debit or credit behind each payment, and a late fee entered with a payment posts as its own line to Late Fee Income. The lease's own page carries a Rent tab listing every charge raised under it, with its due date, amount, status, and the date it was paid, each opening to its charge, so a tenancy reads from its lease.
Each move posts a balanced journal entry tagged to the charge, so the books carry the same history. The Accounts Receivable aging report lists every open item as of a date, with its original amount, payments, outstanding balance, days outstanding, and bucket, each line opening the charge it came from; the General Ledger report for the receivables account shows every posting in order with a running balance and a link to its source; and the Subledger Reconciliation report ties the receivables control account to the total of its open items on one date. Waive, Write Off, and Refund each ask for a reason that is written onto the entry they post. Rent collection, the journal, and the reports are part of every plan, including Starter.
Key questions
What is a lease ledger?
A lease ledger is the same record under another name: one tenancy's charges and payments, kept against the lease rather than the person, in date order with a running balance. Property management software favors the term because charges attach to the lease, so a lease with two residents still has one ledger. The name also belongs to software that accounts for a company's own leases, which is a different thing.
Is a rental ledger the same as a rent ledger or a tenant ledger?
Yes. Rental ledger, rent ledger, tenant ledger, and lease ledger all name one tenancy's record of charges and payments with a running balance. The names differ by what the record is filed under and by region: rental ledger is the usual term in some markets and tenant ledger in others. Pick one name for your office and keep the record the same way under all of them.
What should a rental ledger include?
A header naming the property and unit, the residents on the lease, the rent amount, the billing frequency, and the due day; then one line per event with its date, what it was (rent for a period, a fee, a payment, a returned payment, a waiver, a write-off, a refund), the amount charged or paid, the method, who recorded it, any reference, and the balance after it. The deposit is shown as held and stays out of the balance.
Is there a rental ledger template I can download?
Yes. The rental ledger template is an Excel workbook: a blank ledger with the header fields, 60 entry rows, and a balance column that calculates itself, with this article's worked example on a second sheet. Download the rental ledger template (Excel) from this page and keep one copy per lease.
Can a tenant ask for a copy of their rental ledger?
Yes, and give it. A resident usually asks because they are applying for their next home or for assistance, or want to check a balance, and the ledger is their payment history as much as yours. Some markets require a landlord or agent to provide a copy within a set time of a written request; a ledger kept per lease, line by line, is ready the day it is asked for.
How long should I keep a rental ledger?
For as long as the tax return it supports can still be questioned, and then for as long as the balance could be pursued or disputed. The IRS's page on how long to keep records keeps them until the period of limitations runs out: 3 years in the ordinary case, and 7 years for a return that claims a bad debt deduction. The CRA's guidance on keeping records says six years from the end of the last tax year they relate to. Ask your accountant.
Which Scaalr plan keeps a rental ledger?
Every plan, including Starter, keeps the records a rental ledger is read from: the lease's Rent tab listing every charge raised under it, each charge's Payments tab with its total paid and outstanding balance, the journal entry behind every move, and the receivables aging and general ledger reports. Starter is free for the first 5 units, then $0.99 a unit a month. Growth is $99 a month for the first 50 units, then $1.49 per additional unit, and adds invoicing and online card payment.