What Is a Tenant Ledger? How to Read One and Why It Matters in Diligence

A tenant ledger is the transaction-by-transaction record of everything a tenant has been charged and everything it has paid, with a running balance updated line by line. Every entry is a charge, such as base rent, CAM, taxes, or a late fee, or a payment or credit, and the running balance shows what the tenant owes at each moment. It is the source document behind the rent roll: where the roll summarizes the current rent and balance, the ledger proves how that balance was reached, which is why a buyer trusts a rent roll only after checking the ledgers behind it.

Last updated July 2026.

In commercial real estate the rent roll gets all the attention, but the tenant ledger is where the truth lives. The roll tells you what a tenant is supposed to pay; the ledger tells you what actually happened, and the gap between the two is where risk hides. Whether you are underwriting an acquisition, auditing reported income, or just managing a portfolio, knowing how to read a ledger is a core skill. Here is what it contains and how to work through one.

What is a tenant ledger?

A tenant ledger, sometimes called a rent ledger or resident ledger, is the running account a landlord or property manager keeps for each tenant. It lists every charge posted to the tenant and every payment or credit received, in date order, and carries a balance forward after each line. Property management systems like Yardi, MRI, AppFolio, and RealPage generate it automatically; smaller landlords may keep it in QuickBooks or a spreadsheet. The ledger is the detailed history that a rent roll compresses into a single current figure, and it is the document an auditor or buyer asks for when they want to verify that the rent a seller claims was actually collected.

What is on a tenant ledger?

A ledger has three kinds of lines and a few key fields. The charges are amounts billed to the tenant, usually tagged by a charge code that separates base rent from CAM, taxes, insurance, and one-time items. The payments and credits are what the tenant paid and any concessions applied against the charges. The running balance is the cumulative amount owed after each transaction. Alongside those, a good ledger shows late fees and interest, prepaid rent and the security deposit held as credits, and often an aging summary that splits the balance into current, 30, 60, 90, and 90-plus days past due. Together those fields tell you not just what is owed but how the tenant behaves.

How do you read a tenant ledger?

Read it by separating the three kinds of lines and then following the running balance to the bottom. Start with the recurring charges and confirm they match the lease and the rent roll, so you know the tenant is being billed correctly. Scan the payment column for gaps, partial payments, or long delays. Watch for late fees, because a tenant that always pays but always pays late is a credit risk the balance alone will not reveal. Then finish on the current balance and, critically, how old any arrears are. A ledger that returns to zero every month is a strong tenant; one carrying a growing 60- or 90-day balance is a warning the rent roll will not show you.

What is the difference between a tenant ledger and a rent roll?

A rent roll is a point-in-time summary of every tenant, its current rent, term, and outstanding balance, while a tenant ledger is the full transaction history for a single tenant showing how that balance was built.

The roll is the overview and the ledger is the proof. Reading a roll well is its own skill, covered in the guide to how to read a rent roll; the ledger is what you check it against.

What does the running balance mean?

The running balance is the cumulative amount the tenant owes after each transaction, carried forward line by line, so a charge increases it and a payment reduces it. A zero balance means the tenant is current; a positive balance means it is behind; a negative balance means it has prepaid or holds a credit. The final running balance is the single number most of diligence cares about, because it states, as of the ledger date, whether the tenant owes money and how much. But the balance alone is incomplete without the aging: a $10,000 balance that is 15 days late is a very different risk from the same balance sitting 90 days past due.

Why does a tenant ledger matter in due diligence?

Because the rent roll can be optimistic and the ledger cannot. The ledger is the actual record of collections, and it exposes tenants that pay late, carry stale balances, or lean on concessions the roll does not show. A buyer underwriting a property uses the ledgers to verify that the rent the seller reports was really collected and to age the receivables that were not; an auditor uses them to test reported income against source records. A stack of ledgers that all reconcile cleanly supports the valuation, while a few showing mounting arrears can change the price. Pulling the balances and aging out of ledgers exported from different systems is slow by hand, which is why tenant ledger abstraction turns them into one comparable schedule, and when a tenant's payments come in as PDF bank records you can convert the statement to a spreadsheet to match them against the ledger.

The bottom line

A tenant ledger is the transaction history behind every number a rent roll reports, and it is where a tenant's real payment behavior shows. Read it by separating charges from payments, following the running balance to a current figure, watching for late fees, and checking how old any arrears are. In diligence and audit the ledger is the evidence, not the summary, which is why serious buyers and auditors go straight to it. To pull the charges, payments, balance, and aging out of a portfolio of ledgers into clean, reconciled data, use tenant ledger abstraction.