Collections
It shows exactly which charges are unpaid and how old they are.
Resources · Glossary
What is a tenant ledger?
A tenant ledger is the running record of every charge, payment, credit and adjustment for a tenant on a lease, showing the balance after each entry. It is the source of truth for what a tenant owes or has prepaid, and it supports collections, deposit returns, disputes and court filings.
Tenant ledger · Unit 4B
| Day | Item | Charge | Balance |
|---|---|---|---|
| Day 1 | Rent | $1,850 | $1,850 |
| Day 3 | Payment | −$1,850 | $0 |
| Day 15 | Late fee | $50 | $50 |
What does a tenant ledger include?
A complete tenant ledger lists each transaction with its date, description, charge type, amount and running balance. Typical entries include monthly rent, utility charges, late fees, pet or parking fees, payments received, payment reversals such as returned cheques, credits and concessions, and deposit applications at move-out.
A good ledger also shows the lease and unit it belongs to, so entries can be traced to their cause. Read more in our guide to tenant ledger definition and importance.
Compare
What does a tenant ledger look like?
A tenant ledger looks like a bank statement for one lease: each row is a dated charge, payment or credit, and the final column shows the running balance. The ledger below covers two months for one residential tenant, including parking, a late fee and a partial payment that leaves a balance.
The balance of 500.00 is what the tenant owes after the day 8 payment in month 2.
| Day | Description | Charge | Payment | Balance |
|---|---|---|---|---|
| M1 · day 1 | Rent, month 1 | 1,450.00 | 1,450.00 | |
| M1 · day 1 | Parking | 75.00 | 1,525.00 | |
| M1 · day 3 | Online payment | 1,525.00 | 0.00 | |
| M2 · day 1 | Rent, month 2 | 1,450.00 | 1,450.00 | |
| M2 · day 6 | Late fee | 50.00 | 1,500.00 | |
| M2 · day 8 | Payment | 1,000.00 | 500.00 |
How is a tenant ledger different from a rent roll?
A tenant ledger is the transaction history for one tenant. A rent roll is a snapshot across all units at a date, showing who occupies each unit, lease terms, rent and current balance. The rent roll's balance column should equal the ending balance on each tenant's ledger.
In detail
Why does the tenant ledger matter?
The tenant ledger matters because collections, disputes, accounting and audits all depend on it. It is the evidence of what a tenant owes and why, and the sum of all tenant ledgers should equal accounts receivable in the general ledger, so an error in one place shows up everywhere.
Disputes and courts
Eviction filings and deposit disputes rely on an accurate ledger.
Accounting
The sum of tenant ledgers should equal accounts receivable in the general ledger.
Audits
Auditors test receivables by tracing ledger entries to invoices and receipts.
How does RIOO handle tenant ledgers?
In RIOO, the tenant ledger is the tenant's NetSuite customer record with its invoices, payments and credits. That means the tenant ledger and the general ledger cannot drift apart: the receivable a property manager sees is the receivable the controller reports. See what NetSuite-native property management means.
In detail
How do landlords keep tenant ledgers accurate?
Landlords keep tenant ledgers accurate by posting charges from the lease automatically, applying payments the day they arrive and reviewing exceptions before any notice goes out. Accuracy comes from fewer manual steps, a clear reason on every adjustment and one system holding both the tenant view and the accounting entries.
Automate recurring charges
Post rent and fees from the lease schedule, not by hand.
Apply cash daily
Match bank receipts to tenants as soon as they clear.
Require reasons
Every credit or correction carries a note and an approver.
Review before notices
Run an exception report before late fees or notices.
Reconcile monthly
Confirm tenant balances agree with receivables in the ledger.
Compare
Which entries appear on a tenant ledger?
A tenant ledger records a small set of entry types, each with a date, description, amount and running balance. Knowing the types helps staff read ledgers consistently and spot errors, such as a fee charged twice or a payment applied to the wrong lease.
| Entry type | Effect on balance | Example |
|---|---|---|
| Charge | Increases | Monthly rent, parking, utilities |
| Payment | Decreases | Card, bank transfer or cheque receipt |
| Credit | Decreases | Concession, goodwill credit |
| Adjustment | Either | Correction of a miskeyed charge |
| Reversal | Increases | Returned or bounced payment |
| Deposit movement | Separate line | Deposit received, applied or refunded |
How it works
How do you read a tenant ledger correctly?
Read a tenant ledger from the oldest open item to the newest, checking that each payment was applied to the charges it was meant to cover. The closing balance alone can hide problems, so look at the age of unpaid charges and at any reversals, credits or adjustments that changed the balance.
- 01
Check the period and lease
Confirm the ledger is for the right unit and dates.
- 02
Scan the charges
Compare them with the lease terms and fee schedule.
- 03
Match payments
See which charges each payment settled.
- 04
Review adjustments
Every credit or correction should have a reason.
- 05
Age the balance
Note how much is current, 30, 60 or 90 days old.
In detail
What are common tenant ledger errors?
Common tenant ledger errors include duplicate charges, payments posted to the wrong tenant, late fees applied during a grace period and reversals that were never re-charged. Each one distorts the balance and can lead to wrongful late notices, so most landlords review exception reports before running reminders or notices.
Duplicates
The same recurring charge posted twice in a month.
Misapplied payments
Cash posted to a former tenant at the same unit.
Early late fees
Fees triggered before the grace period ended.
Unrecorded concessions
Agreed credits that never reached the ledger.
Deposit confusion
Deposits mixed into the rent balance.
How does a tenant ledger connect to the general ledger?
A tenant ledger connects to the general ledger because every charge and payment on it should also appear as an accounting entry in accounts receivable, revenue and cash. In separate systems those entries are synced in batches, so the two can drift. In RIOO the tenant ledger is built on NetSuite receivables, so they are the same records.
That means the aged receivables report finance reviews at month end is built from the same lines a leasing agent sees on the tenant's account, with no reconciliation between them.
Who uses the tenant ledger, and for what?
Several roles rely on the tenant ledger every day, each for a different decision about collections, month-end close or a resident's question. Giving them all the same live record avoids the common situation where leasing, finance and the resident each hold a different idea of the balance.
Property managers
Check balances before renewals, notices and move-outs.
Accounts receivable
Apply payments, chase arrears and post adjustments.
Residents and tenants
See charges and payments in the tenant portal.
Auditors
Test charges against leases and payments against bank records.
In detail
Which related terms should you know?
Several terms sit close to the tenant ledger and are often confused with it. Knowing the difference helps staff use the right report for each question, whether a resident is querying a charge, an auditor is testing revenue or an owner wants to know what the property should collect each month.
Read the guide to collecting rent payments for the next step in the rent cycle, and see how property accounting in NetSuite keeps these records in one place.
Rent roll
A snapshot of every unit, lease, rent and balance at one date, across a property.
Aged receivables
Open balances grouped by how long they have been unpaid.
Security deposit ledger
A separate record of deposits held, applied and refunded.
General ledger
The accounting record of every entry across all accounts and entities.
Tenant statement
The summary of the ledger sent to the tenant for a period.
Talk to a specialist
See glossary: tenant ledger on your own portfolio.
It is the source of truth for what a tenant owes or has prepaid, and it supports collections, deposit returns, disputes and court filings.
Can a tenant request a copy of their ledger?
In many jurisdictions tenants can request a statement of their account, and providing one promptly helps resolve disputes. In RIOO, tenants can see their balance and transaction history in the tenant portal. Property managers can also share a dated statement drawn from the same record, so both sides work from identical figures.
What is the difference between a tenant ledger and a resident ledger?
They are the same thing. Residential operators often say resident ledger, while commercial landlords say tenant ledger. Both record charges, payments and the running balance for a lease. In RIOO the ledger sits on the tenant's NetSuite customer record, so whichever name your team uses, the figures are the same ones finance reports.
How should partial payments be applied on a tenant ledger?
Follow your lease and local law, which may set an order, such as oldest charges first or rent before fees. Apply payments consistently and record the allocation so the ledger shows what remains unpaid. Explain the order in your lease or resident handbook too, so tenants understand why a fee may remain after a payment.
Why doesn't my rent roll match my general ledger?
Usually because the property system and the accounting system are separate and something was missed in the sync, such as a reversal or adjustment. When tenant ledgers live in the general ledger, as they do in RIOO, the two match by design.
How long should tenant ledgers be kept?
Keep tenant ledgers for at least as long as local tax and landlord laws require, which is often several years after a lease ends. Ledgers support tax filings, deposit disputes and legal claims, so many landlords keep them for the full retention period of their accounting records. Confirmretention guidance by market
Can a tenant ledger show a credit balance?
Yes. A credit balance means the tenant has paid more than they owe, for example through an overpayment or an agreed concession. The credit can be applied to the next charge or refunded under your policy, and it should never be confused with the security deposit, which is held separately.
What is the difference between a tenant ledger and a tenant statement?
A tenant ledger is the landlord's complete internal record of every entry on a lease, while a tenant statement is a summary sent to the tenant for a period. The statement shows charges, payments and the balance due, but usually leaves out internal notes, approvals and any adjustments still under review.
Who can correct an entry on a tenant ledger?
Corrections should be made only by staff with the right permission, usually accounts receivable or a property accountant, and never by deleting the original entry. In RIOO a correction is posted as an adjustment or reversal with a reason, so the ledger keeps a complete audit trail of what changed, when and by whom.
Related
Related to glossary
