Tenant Ledger: Definition, Example, and Reconciliation
A tenant ledger is a dated account record. It lists charges, payments, credits, and the balance. Commercial entries can include base rent and estimates for common area maintenance (CAM). They may also include utilities and other lease charges. Each line needs to explain the event and its effect on the amount owed.
As a subledger, it provides the detail behind the general ledger, or GL. Staff use it to answer invoice questions from tenants. Finance checks the total balances against the accounts receivable control account.
Each ledger entry needs a clear source that another person can follow. Link a charge to its lease terms, a receipt to bank evidence, and a correction to the approval for that change. These links help staff check the balance and explain it to the tenant. They also provide a consistent basis for repeating the month-end review.
Anatomy of a Commercial Tenant Ledger
The ledger should identify its tenant, legal entity, property, unit, lease, and currency. One business may rent several units. It may also hold leases with different owners. Staff need more than the tenant name to choose the right account. They also need to identify the lease supporting the entry.
For each entry, keep its amount, charge type, and source reference. Record the service period, due date, document number, and posting date too. Receipts also need a bank reference and payment method. Add notes for items under review. Use a separate status to show that a dispute remains open.
Debits: Charges to the Tenant
Charges increase the receivable balance. Common commercial charges include base rent and rent steps. Utility bills, percentage rent, and monthly CAM estimates can appear too. Add a late fee only if the lease and applicable rules permit that charge.
Give each type of charge a distinct code. A long note should not be needed to tell base rent from a CAM estimate. Record the service period separately from the posting date. For example, a January posting for electricity can relate to consumption in December.
A rent step alters the charge on its effective date. For an index-linked increase, check the index and formula. Check its reference period and any floor or cap too. Store the approved calculation with the bill. Users should not need to remember the lease terms to explain the new amount.
Credits: Payments and Approved Adjustments
Recording a payment on the tenant account reduces its balance. An approved CAM adjustment may also reduce the amount owed through a credit memo. Preserve the reason and link to the document so staff can later explain the reduction.
Recording cash and applying it are separate actions. A tenant can send the full amount but identify only one invoice. Part of the receipt may remain unapplied after it is recorded. The receipt alone does not prove that the open invoice is right. Staff must also check how the cash was applied.
Money paid to a tenant is not always a rent credit. A tenant improvement allowance can require its own approval and accounting treatment. Reduce rent receivable only when the agreement and approved entry support doing so. Otherwise, record the payment in the appropriate separate account.
Security Deposits Need Their Own Record
A refundable security deposit does not become ordinary rent income on receipt. Keep its balance and related liability separate from current rent receivable. Link it to the tenant so staff can see the deposit without reducing the amount shown as rent due.
When an approved deposit application pays a final rent balance, record both effects. Use approved entries to reduce the deposit liability. Apply the amount to the tenant receivable through the approved process. Keep the supporting records and reason. The contract and applicable rules determine whether deposit interest must be paid.
Running Balance
For the landlord, closing balance equals opening balance plus charges minus payments and credits. A positive result is money the tenant owes. A negative result may represent an overpayment or an available credit for later use.
Explain the signs used on the report. The reader needs to know how they affect the balance. Some systems display payment amounts as negative figures. Others use a credit column containing positive numbers. Either method can give the right balance. Mixing them can cause the same payment to be taken off twice.
Realistic Commercial Tenant Ledger Example
This US-dollar example starts with a zero rent balance for one office tenant. The credit column shows payments and credits as positive amounts. Each is deducted once when calculating the running balance.
The first column combines the transaction date and description for readability. In a live ledger, give each row its own document number. Show its service period too.
Date and transaction | Charge | Payment or credit | Balance due |
Jan. 1: January base rent | $15,000.00 | — | $15,000.00 |
Jan. 1: January CAM estimate | $2,500.00 | — | $17,500.00 |
Jan. 5: ACH receipt | — | $17,500.00 | $0.00 |
Jan. 15: December electricity | $1,240.50 | — | $1,240.50 |
Jan. 20: Utility payment | — | $1,240.50 | $0.00 |
Feb. 1: February base rent | $15,000.00 | — | $15,000.00 |
Feb. 1: February CAM estimate | $2,500.00 | — | $17,500.00 |
Feb. 10: Partial receipt | — | $17,000.00 | $500.00 |
Feb. 15: Approved prior-year CAM credit | — | $300.00 | $200.00 |
Charges total $36,240.50, against payments and credits of $36,040.50. The $200.00 closing balance agrees with the final row: $500.00 minus a $300.00 credit. The remaining $200.00 still needs collection or another valid form of settlement.
Suppose this tenant also holds a refundable deposit of $30,000. Record it on the deposit schedule with a liability of $30,000. Do not deduct it from current rent. The deposit cannot clear open invoices without an approved basis for using it.
Invoice status is another lesson from the example. Before the CAM credit, the partial payment of $17,000 leaves $500 open. Apply both receipt and credit to the proper items. The net account balance can be correct while the invoice aging remains wrong.
4 Steps to Reconcile Commercial Tenant Ledgers
A reconciliation tests several relationships. Lease and billing records must support the tenant ledger. Bank evidence must support receipts. The total tenant subledger must agree with GL receivables. Each check is related to the others but can reveal a different kind of error.
1. Match Tenant Cash Receipts Against Open Invoices
Set one cutoff date for the review. Run or export tenant balances and open items for that date. Keep the entity, currency, and other filters consistent. An all-tenant report will not agree with a GL account for one property unless both cover the same scope.
Match receipts to remittance advice and bank evidence. Check tenant, date, amount, and invoice references. Review returned and partial payments. Check unapplied cash and receipts put in the wrong tenant account. Use batch details when one bank deposit represents several receipts.
Check how each receipt closes open entries. A tenant may specify an invoice instead of intending to pay the oldest charge. Retain its remittance advice and investigate references that are unclear. Test matching rules with overpayments and partial receipts. Give staff a way to review and resolve any exceptions.
2. Verify Rent Steps and Submetered Utility Charges
Compare billed charges with the signed lease and subsequent amendments. Check unit changes, effective dates, and rent steps. Also check free-rent periods and the basis for each index review. Before seeking payment, trace any changed charge back to its approved source.
For utilities, verify the meter link, unit, multiplier, rate, and reading period. Missing readings or an incorrect meter link can create a bill that looks reasonable but is wrong. Identify estimates separately from actual readings. Check how a move during the period affects the charge.
Keep a traceable route from the reading to its unit and bill. Verify use of the approved tariff and proper consumption period. If a source file changes after billing, keep both versions. Explain any adjustment made as a result. Check unusual charges before sending them to the tenant.
3. Process CAM True-Ups and Review Deposit Interest
An annual CAM true-up checks the tenant's approved share of actual recoverable costs. Compare that share with estimates billed for the same period. First check the lease's cost pool, exclusions, and caps. Check the allocation basis and other terms too.
For example, an approved annual share of $28,800 against estimates billed of $30,000 produces a credit of $1,200. A share of $31,200 instead produces a charge of $1,200. Make the debit or credit sign clear. Keep the statement that supports the adjustment.
Test the entire annual review before the first true-up. Check that the statement explains estimates, final costs, and the balance arising. Reconcile deposits on a separate schedule and include interest where required. Interest should not be posted automatically for every tenant.
4. Tie Reconciled Tenant Balances to the General Ledger
Total the tenant receivables included in the review. Compare that amount with the GL receivables control balance at the same date. Check posting groups, currencies, and credit balances. Confirm that the report includes the relevant documents and customers.
Trace any difference to the entry that created it. The cause may be different date filters or a direct GL posting. An opening balance loaded to only one record can also create a gap. Correct the source through an approved entry. Adding a number simply to force agreement can conceal the error.
Keep posting under control. This applies whether the ledger and GL share a platform or use an interface. Check for duplicates and failed transfers between systems. After corrections, demonstrate agreement between the balances. Keep the reports and approval that substantiate the final tie-out.
A Practical Reconciliation Flow
Follow a repeatable sequence so reviewers understand what each earlier step established. Date the reports and keep a record of unresolved issues alongside them.
Stage | Check | Evidence to retain |
1. Fix the scope | Entity, currency, property, and cutoff | Report filters and opening balances |
2. Check billing | Charges agree with approved terms | Lease, amendment, and calculation |
3. Check cash | Receipts agree with bank evidence | Bank record and payment application |
4. Check balances | Subledger total agrees with GL | Tie-out and explained differences |
5. Sign off | Corrections and open items have owners | Approval and follow-up dates |
Month-end approval must not conceal a known dispute. Show its reason, amount, owner, and next action. A ledger can accurately record a balance that the tenant contests. Accuracy and agreement by the tenant are separate questions.
Ledger Discrepancy Action Matrix
Fix differences at their source. A credit memo may correct an erroneous charge. It cannot explain why a receipt was posted to another tenant account.
Difference | First check | Usual next action |
Tenant says payment is missing | Bank, reference, and receipt batch | Locate and apply the receipt, or investigate the bank item |
Balance is right but invoice remains open | Receipt and credit application | Apply entries to the correct documents |
Rent charge differs from lease | Effective date and amendment | Correct the bill with approval |
Utility amount looks high | Meter link, unit, and period | Validate source data before adjustment |
Subledger does not tie to GL | Scope and direct GL entries | Trace the difference and correct its source |
Deposit differs from liability | Deposit schedule and applications | Reconcile deposit entries on both sides |
Keep the Close Process Consistent
Enter routine receipts and charges as they arise. Review exceptions before month-end sign-off. Assign the tie-out to one person and its review to another. Keep dated evidence of the work and approval, including any matters still open.
Keep the report version used at close. Later postings and corrections can change a live report. Follow the approved close policy for entries affecting an earlier period. Keep the history of each change. The original evidence should not be replaced without a record.
Test the opening detail rather than check only its grand total. Confirm invoice numbers and due dates, unapplied receipts, credit balances, and refundable deposits. A migration may match the GL total but lose useful detail. Staff still need that detail to collect debt and answer tenant questions. Test a complete billing and receipt cycle before relying on the migrated ledger.
Make the Tenant Statement Easy to Check
The tenant statement should show an opening balance and new charges. Include payments, credits, and the closing amount. Use clear service periods and document numbers, and maintain current payment instructions. If an entry is disputed, explain how to raise a query. Keep the posted record intact.
Before sending the statement, confirm that it agrees with the ledger at the date shown on the report. A later receipt may change the live account balance. Keep the statement date clear to explain that difference. Retain a copy of the version sent. Staff can then answer later queries using the same record the tenant received.
Streamlining Accounting with SOFT4Spaces
SOFT4Spaces helps when accounting checks and tenant queries rely on shared property records. Its platform brings together billing, payments, debts, due invoices, and lease details. Staff have a clearer route from the question to the document that explains the entry.
Lease contract tools hold service prices, reminders, dates, and linked documents. Invoices can be prepared for a whole property or a chosen unit, tenant, or service. Teams can use that property structure to create clear charges. Each bill can show its items.
Consider an illustrative office portfolio where a tenant disputes a utility bill. The property accountant reviews the unit-to-meter link, reading period, and charge. Staff record an approved adjustment if needed, then check open items. Staff can trace the query through the accounts. They do not have to search separate spreadsheets to find its history.
Where included, the tenant portal provides contract details, invoice downloads, and payment history. Both sides can start a query from the same record. This may reduce simple requests for copies of documents. Test access and report layout with a sample tenant before launching it.
The official plan comparison puts meter readings and the portal in selected plans. Confirm licensing and the complete setup scope. If needed, demonstrate payment matching, late-fee rules, and exception handling. Their precise behavior must suit the configured solution.
How does SOFT4Spaces support reconciliation and ERP posting?
It holds tenant, invoice, lease, payment, and financial records on Business Central. The underlying customer payment application workflow applies payments to open entries. It also supports credit memos. Test the configured rules and review exceptions. At the same cutoff, prove that the subledger agrees with the GL.
Frequently Asked Questions
What is a tenant ledger in commercial property management?
It is a dated record of the balances, charges, payments, and credits on a tenant account. Teams use it to collect debts and answer tenant questions. They also use it to tie receivables to the general ledger.
How does it differ from a residential rent ledger?
What charges appear on a commercial tenant ledger?
How often should property accountants reconcile tenant ledgers?
What if the tenant ledger does not match GL receivables?
Related articles
Tenant Ledger: Definition, Example, and Reconciliation
A tenant ledger is a dated account record. It lists charges, payments, credits, and the balance. Commercial entries can include base rent and estimates for common area maintenance (CAM). They may also include utilities and other lease charges. Each line needs to explain the event and its effect on the amount owed.
As a subledger, it provides the detail behind the general ledger, or GL. Staff use it to answer invoice questions from tenants. Finance checks the total balances against the accounts receivable control account.
Each ledger entry needs a clear source that another person can follow. Link a charge to its lease terms, a receipt to bank evidence, and a correction to the approval for that change. These links help staff check the balance and explain it to the tenant. They also provide a consistent basis for repeating the month-end review.
Anatomy of a Commercial Tenant Ledger
The ledger should identify its tenant, legal entity, property, unit, lease, and currency. One business may rent several units. It may also hold leases with different owners. Staff need more than the tenant name to choose the right account. They also need to identify the lease supporting the entry.
For each entry, keep its amount, charge type, and source reference. Record the service period, due date, document number, and posting date too. Receipts also need a bank reference and payment method. Add notes for items under review. Use a separate status to show that a dispute remains open.
Debits: Charges to the Tenant
Charges increase the receivable balance. Common commercial charges include base rent and rent steps. Utility bills, percentage rent, and monthly CAM estimates can appear too. Add a late fee only if the lease and applicable rules permit that charge.
Give each type of charge a distinct code. A long note should not be needed to tell base rent from a CAM estimate. Record the service period separately from the posting date. For example, a January posting for electricity can relate to consumption in December.
A rent step alters the charge on its effective date. For an index-linked increase, check the index and formula. Check its reference period and any floor or cap too. Store the approved calculation with the bill. Users should not need to remember the lease terms to explain the new amount.
Credits: Payments and Approved Adjustments
Recording a payment on the tenant account reduces its balance. An approved CAM adjustment may also reduce the amount owed through a credit memo. Preserve the reason and link to the document so staff can later explain the reduction.
Recording cash and applying it are separate actions. A tenant can send the full amount but identify only one invoice. Part of the receipt may remain unapplied after it is recorded. The receipt alone does not prove that the open invoice is right. Staff must also check how the cash was applied.
Money paid to a tenant is not always a rent credit. A tenant improvement allowance can require its own approval and accounting treatment. Reduce rent receivable only when the agreement and approved entry support doing so. Otherwise, record the payment in the appropriate separate account.
Security Deposits Need Their Own Record
A refundable security deposit does not become ordinary rent income on receipt. Keep its balance and related liability separate from current rent receivable. Link it to the tenant so staff can see the deposit without reducing the amount shown as rent due.
When an approved deposit application pays a final rent balance, record both effects. Use approved entries to reduce the deposit liability. Apply the amount to the tenant receivable through the approved process. Keep the supporting records and reason. The contract and applicable rules determine whether deposit interest must be paid.
Running Balance
For the landlord, closing balance equals opening balance plus charges minus payments and credits. A positive result is money the tenant owes. A negative result may represent an overpayment or an available credit for later use.
Explain the signs used on the report. The reader needs to know how they affect the balance. Some systems display payment amounts as negative figures. Others use a credit column containing positive numbers. Either method can give the right balance. Mixing them can cause the same payment to be taken off twice.
Realistic Commercial Tenant Ledger Example
This US-dollar example starts with a zero rent balance for one office tenant. The credit column shows payments and credits as positive amounts. Each is deducted once when calculating the running balance.
The first column combines the transaction date and description for readability. In a live ledger, give each row its own document number. Show its service period too.
Date and transaction | Charge | Payment or credit | Balance due |
Jan. 1: January base rent | $15,000.00 | — | $15,000.00 |
Jan. 1: January CAM estimate | $2,500.00 | — | $17,500.00 |
Jan. 5: ACH receipt | — | $17,500.00 | $0.00 |
Jan. 15: December electricity | $1,240.50 | — | $1,240.50 |
Jan. 20: Utility payment | — | $1,240.50 | $0.00 |
Feb. 1: February base rent | $15,000.00 | — | $15,000.00 |
Feb. 1: February CAM estimate | $2,500.00 | — | $17,500.00 |
Feb. 10: Partial receipt | — | $17,000.00 | $500.00 |
Feb. 15: Approved prior-year CAM credit | — | $300.00 | $200.00 |
Charges total $36,240.50, against payments and credits of $36,040.50. The $200.00 closing balance agrees with the final row: $500.00 minus a $300.00 credit. The remaining $200.00 still needs collection or another valid form of settlement.
Suppose this tenant also holds a refundable deposit of $30,000. Record it on the deposit schedule with a liability of $30,000. Do not deduct it from current rent. The deposit cannot clear open invoices without an approved basis for using it.
Invoice status is another lesson from the example. Before the CAM credit, the partial payment of $17,000 leaves $500 open. Apply both receipt and credit to the proper items. The net account balance can be correct while the invoice aging remains wrong.
4 Steps to Reconcile Commercial Tenant Ledgers
A reconciliation tests several relationships. Lease and billing records must support the tenant ledger. Bank evidence must support receipts. The total tenant subledger must agree with GL receivables. Each check is related to the others but can reveal a different kind of error.
1. Match Tenant Cash Receipts Against Open Invoices
Set one cutoff date for the review. Run or export tenant balances and open items for that date. Keep the entity, currency, and other filters consistent. An all-tenant report will not agree with a GL account for one property unless both cover the same scope.
Match receipts to remittance advice and bank evidence. Check tenant, date, amount, and invoice references. Review returned and partial payments. Check unapplied cash and receipts put in the wrong tenant account. Use batch details when one bank deposit represents several receipts.
Check how each receipt closes open entries. A tenant may specify an invoice instead of intending to pay the oldest charge. Retain its remittance advice and investigate references that are unclear. Test matching rules with overpayments and partial receipts. Give staff a way to review and resolve any exceptions.
2. Verify Rent Steps and Submetered Utility Charges
Compare billed charges with the signed lease and subsequent amendments. Check unit changes, effective dates, and rent steps. Also check free-rent periods and the basis for each index review. Before seeking payment, trace any changed charge back to its approved source.
For utilities, verify the meter link, unit, multiplier, rate, and reading period. Missing readings or an incorrect meter link can create a bill that looks reasonable but is wrong. Identify estimates separately from actual readings. Check how a move during the period affects the charge.
Keep a traceable route from the reading to its unit and bill. Verify use of the approved tariff and proper consumption period. If a source file changes after billing, keep both versions. Explain any adjustment made as a result. Check unusual charges before sending them to the tenant.
3. Process CAM True-Ups and Review Deposit Interest
An annual CAM true-up checks the tenant's approved share of actual recoverable costs. Compare that share with estimates billed for the same period. First check the lease's cost pool, exclusions, and caps. Check the allocation basis and other terms too.
For example, an approved annual share of $28,800 against estimates billed of $30,000 produces a credit of $1,200. A share of $31,200 instead produces a charge of $1,200. Make the debit or credit sign clear. Keep the statement that supports the adjustment.
Test the entire annual review before the first true-up. Check that the statement explains estimates, final costs, and the balance arising. Reconcile deposits on a separate schedule and include interest where required. Interest should not be posted automatically for every tenant.
4. Tie Reconciled Tenant Balances to the General Ledger
Total the tenant receivables included in the review. Compare that amount with the GL receivables control balance at the same date. Check posting groups, currencies, and credit balances. Confirm that the report includes the relevant documents and customers.
Trace any difference to the entry that created it. The cause may be different date filters or a direct GL posting. An opening balance loaded to only one record can also create a gap. Correct the source through an approved entry. Adding a number simply to force agreement can conceal the error.
Keep posting under control. This applies whether the ledger and GL share a platform or use an interface. Check for duplicates and failed transfers between systems. After corrections, demonstrate agreement between the balances. Keep the reports and approval that substantiate the final tie-out.
A Practical Reconciliation Flow
Follow a repeatable sequence so reviewers understand what each earlier step established. Date the reports and keep a record of unresolved issues alongside them.
Stage | Check | Evidence to retain |
1. Fix the scope | Entity, currency, property, and cutoff | Report filters and opening balances |
2. Check billing | Charges agree with approved terms | Lease, amendment, and calculation |
3. Check cash | Receipts agree with bank evidence | Bank record and payment application |
4. Check balances | Subledger total agrees with GL | Tie-out and explained differences |
5. Sign off | Corrections and open items have owners | Approval and follow-up dates |
Month-end approval must not conceal a known dispute. Show its reason, amount, owner, and next action. A ledger can accurately record a balance that the tenant contests. Accuracy and agreement by the tenant are separate questions.
Ledger Discrepancy Action Matrix
Fix differences at their source. A credit memo may correct an erroneous charge. It cannot explain why a receipt was posted to another tenant account.
Difference | First check | Usual next action |
Tenant says payment is missing | Bank, reference, and receipt batch | Locate and apply the receipt, or investigate the bank item |
Balance is right but invoice remains open | Receipt and credit application | Apply entries to the correct documents |
Rent charge differs from lease | Effective date and amendment | Correct the bill with approval |
Utility amount looks high | Meter link, unit, and period | Validate source data before adjustment |
Subledger does not tie to GL | Scope and direct GL entries | Trace the difference and correct its source |
Deposit differs from liability | Deposit schedule and applications | Reconcile deposit entries on both sides |
Keep the Close Process Consistent
Enter routine receipts and charges as they arise. Review exceptions before month-end sign-off. Assign the tie-out to one person and its review to another. Keep dated evidence of the work and approval, including any matters still open.
Keep the report version used at close. Later postings and corrections can change a live report. Follow the approved close policy for entries affecting an earlier period. Keep the history of each change. The original evidence should not be replaced without a record.
Test the opening detail rather than check only its grand total. Confirm invoice numbers and due dates, unapplied receipts, credit balances, and refundable deposits. A migration may match the GL total but lose useful detail. Staff still need that detail to collect debt and answer tenant questions. Test a complete billing and receipt cycle before relying on the migrated ledger.
Make the Tenant Statement Easy to Check
The tenant statement should show an opening balance and new charges. Include payments, credits, and the closing amount. Use clear service periods and document numbers, and maintain current payment instructions. If an entry is disputed, explain how to raise a query. Keep the posted record intact.
Before sending the statement, confirm that it agrees with the ledger at the date shown on the report. A later receipt may change the live account balance. Keep the statement date clear to explain that difference. Retain a copy of the version sent. Staff can then answer later queries using the same record the tenant received.
Streamlining Accounting with SOFT4Spaces
SOFT4Spaces helps when accounting checks and tenant queries rely on shared property records. Its platform brings together billing, payments, debts, due invoices, and lease details. Staff have a clearer route from the question to the document that explains the entry.
Lease contract tools hold service prices, reminders, dates, and linked documents. Invoices can be prepared for a whole property or a chosen unit, tenant, or service. Teams can use that property structure to create clear charges. Each bill can show its items.
Consider an illustrative office portfolio where a tenant disputes a utility bill. The property accountant reviews the unit-to-meter link, reading period, and charge. Staff record an approved adjustment if needed, then check open items. Staff can trace the query through the accounts. They do not have to search separate spreadsheets to find its history.
Where included, the tenant portal provides contract details, invoice downloads, and payment history. Both sides can start a query from the same record. This may reduce simple requests for copies of documents. Test access and report layout with a sample tenant before launching it.
The official plan comparison puts meter readings and the portal in selected plans. Confirm licensing and the complete setup scope. If needed, demonstrate payment matching, late-fee rules, and exception handling. Their precise behavior must suit the configured solution.
How does SOFT4Spaces support reconciliation and ERP posting?
It holds tenant, invoice, lease, payment, and financial records on Business Central. The underlying customer payment application workflow applies payments to open entries. It also supports credit memos. Test the configured rules and review exceptions. At the same cutoff, prove that the subledger agrees with the GL.
Frequently Asked Questions
What is a tenant ledger in commercial property management?
It is a dated record of the balances, charges, payments, and credits on a tenant account. Teams use it to collect debts and answer tenant questions. They also use it to tie receivables to the general ledger.
How does it differ from a residential rent ledger?
What charges appear on a commercial tenant ledger?
How often should property accountants reconcile tenant ledgers?
What if the tenant ledger does not match GL receivables?