Commercial Tenant Ledger: What It Is and How to Read One
A tenant ledger is the financial backbone of any commercial tenancy. Here is what it contains, how to read it, and what to do if your agent will not give you one.
A tenant ledger is a transaction-by-transaction financial record for a single tenancy. It captures every charge raised against the tenant and every payment received, producing a running balance that tells you precisely whether the tenant is paid up, behind, or in credit at any point in time.
In a commercial context, the ledger tracks more than base rent. Outgoings estimates, outgoings reconciliation adjustments, car parking charges, storage levies, and any make-good deposits all appear on the same ledger. A well-maintained ledger is the primary document used in any rent arrears dispute, NCAT proceeding, or end-of-lease reconciliation.
12+
Line items a typical commercial ledger tracks monthly
3
Years minimum ledger retention required under NSW law
30d
Typical agent obligation to provide ledger on written request
What the ledger records
Base rent per the lease schedule, including any CPI or fixed percentage increases
Outgoings estimates billed in advance, usually monthly or quarterly
Outgoings reconciliation adjustments when actual costs differ from estimates
Tenant receipts with the date banked, not the date received
Late payment fees if the lease permits them
Reversals and credits with the reason noted
GST itemised on every charge line
Reading the ledgerReal-time tenant ledgers are the foundation of every actively managed commercial portfolio.
How to read a commercial tenant ledger
Most Australian property management platforms generate ledgers in a consistent format. The columns you will see on every ledger are:
Date: the period the charge relates to, or the date the payment cleared
Description: the charge type (Rent, Outgoings, Receipt)
Debit: amounts owed by the tenant
Credit: payments or adjustments reducing the balance
Balance: the running total. A positive balance means money is owed. A negative balance means the tenant is in credit.
Key check: The opening balance on any ledger period should match the closing balance on the prior period. If they do not match, ask your agent for an explanation before accepting the ledger as accurate.
What "arrears" looks like on the ledger
If a tenant is in arrears, the balance column carries a positive number that grows with each new charge and shrinks only when payments are received. The number of days in arrears is calculated from the due date of the oldest unpaid charge, not from the current period's due date.
Under a typical commercial lease in NSW, rent is due in advance on the first day of each month. If a ledger shows rent posted on 1 June but no receipt until 15 June, the tenant was 14 days in arrears at the time of payment. That fact is preserved in the ledger permanently.
Outgoings on the ledger
Outgoings estimates appear as monthly debit lines. At year-end, your agent reconciles actual council rates, water, insurance, and strata levies against those estimates. If actuals exceeded estimates, the tenant owes the difference. If actuals were lower, the tenant receives a credit. Both adjustments post to the same ledger as a single reconciliation line.
Ledger versions
Current ledger vs previous ledger
Most property management software lets agents export two ledger types: the current ledger, which shows transactions from lease commencement to today, and a period ledger, which filters to a specific date range.
Always request the full current ledger when reviewing a tenancy. Period ledgers can mask historic arrears that were brought current, then allowed to fall behind again. A pattern of recurring short-term arrears across multiple periods is a much stronger indicator of credit risk than a single snapshot showing a zero balance.
What to check when reviewing ledger history
Does the tenant consistently pay within the grace period, or is payment erratic?
Are there unexplained reversals or write-offs that reduced the stated arrears?
Did outgoings reconciliation adjustments ever go uncollected?
Does the ledger balance match the rental statement that was sent to you each month?
Are there any credits sitting unapplied that should have been allocated to arrears?
Tip: Cross-reference the ledger against your own bank statements. Every receipt on the ledger should correspond to a deposit you can locate. Missing deposits or amounts that do not match are grounds to ask your agent for a formal reconciliation.
Your rights
What if your agent will not give you the tenant ledger?
Under the Property and Stock Agents Act 2002 (NSW), a licensed agent managing property on your behalf is required to keep accurate trust accounting records and provide you with statements of those records on request. The tenant ledger is part of those records.
If your agent delays, provides incomplete information, or refuses entirely, you have four options in order of escalation:
Written request with 7-day deadline. Email the principal of the agency, not just your property manager. State that you require the full tenant ledger for the current tenancy within 7 business days.
NSW Fair Trading complaint. Fair Trading administers the licensing regime for real estate agents. A complaint triggers a formal investigation and gives the agent a further deadline to respond.
Property Services Commissioner. The Commissioner receives escalated disputes and has powers of audit across trust accounts.
Termination for cause. Persistent failure to provide financial records is grounds to terminate your management agreement without penalty. Review your agreement's termination clause before acting.
Any agency worth engaging will have your ledger available on request within 24 hours through their client portal. If access requires chasing, that tells you something about how the property is being managed day-to-day.
Free resource
Get a free commercial tenant ledger template
If you manage a small portfolio yourself or want to verify your agent's figures against your own records, a simple ledger template in Excel format gives you a clean starting point. Track rent, outgoings, receipts, and the running balance across multiple tenancies in one workbook.
Contact the BLOX team and we will send the template across, along with a brief explanation of how to adapt it to your lease terms.
Every property BLOX manages comes with a real-time tenant ledger
BLOX Commercial uses PropertyMe as its trust accounting platform. Every landlord receives portal access with a live view of their tenant ledger, rental statements, and outgoings reconciliation records. Nothing requires chasing.
We manage commercial, industrial, retail, and strata properties across Sydney. If your current agent is making basic record access difficult, that is worth addressing before a rent arrears or end-of-lease dispute makes it worse.
