What is tenant ledger reconciliation?
A tenant ledger is one tenant account’s transaction history — charges, payments, credits, adjustments and the remaining balance — and reconciliation checks that the history is complete, correctly applied and supported. It is a tenant-account control rather than a substitute for bank or trust reconciliation: a bank account can reconcile perfectly while a payment sits on the wrong tenant.
A tenant ledger is the transaction history for a tenant account: charges, payments, credits, adjustments and the balance that remains. Reconciliation checks whether that history is complete, correctly applied and supported by the lease and source records. It helps property managers resolve discrepancies before they flow into receivables aging, owner reports or tenant communications. For shared utility charges, also reconcile the original invoice and allocation report to the tenant utility billback workflow.
This is a tenant-account control, not a substitute for bank or trust reconciliation. A bank account can reconcile while a payment is assigned to the wrong tenant, and a tenant ledger can appear reasonable while a cash deposit is missing from the bank records. Use the checks together as part of a consistent close process, supported by the property management month-end close checklist.
1. Confirm the tenant, lease and period
Before reviewing a balance, confirm the correct property, unit, tenant, lease term and date range. Check for transfers between units, lease renewals, changes in rent or concessions, move-ins and move-outs. A report that combines the wrong date range or an inactive lease can create a misleading balance even when individual transactions were entered correctly.
- Confirm the tenant and property identifiers against the active lease record.
- Check lease start and end dates and any approved amendments.
- Confirm the ledger period, opening balance and report filters.
- Identify prior-period corrections and transactions posted after the original close.
2. Verify charges against lease terms
Compare recurring rent and other charges with the lease schedule and documented changes. Review prorated rent, concessions, late fees, utility charges, parking or other recurring items only where the agreement and applicable rules support them. Confirm the effective date and calculation for each material change.
- Match recurring charges to the agreed amount and due date.
- Check proration calculations for partial periods and lease changes.
- Confirm credits or concessions have approval and the correct effective period.
- Look for duplicate charges, omitted charges or charges posted to the wrong unit.
Do not add a fee simply because it appears in a standard system template. The lease, local requirements and the property manager’s approved process should support the charge.
3. Trace receipts to the correct tenant account
Match recorded receipts to payment confirmations, deposit records or other reliable source evidence. Verify the amount, date, tenant and property allocation. For a combined deposit covering multiple tenants or properties, ensure the accounting detail allocates the total to the correct individual accounts without duplicating the cash transaction.
- Find payments in the tenant ledger and the corresponding deposit or receipt record.
- Check unapplied cash and undeposited receipts for items that need resolution.
- Review partial payments and confirm how the remaining balance is presented.
- Investigate duplicate receipts, reversals, returned payments and misapplied amounts.
Do not assume an amount is settled merely because a payment was entered. Confirm the status using the system’s available evidence and established procedures.
4. Review credits, adjustments and reversals
Credits may result from approved concessions, corrections, refunds or other account changes. Each material adjustment should have a clear reason, supporting record, date and appropriate approval. When an error is reversed, confirm that the reversal references the original entry and does not leave both the original and corrected amount affecting the balance.
- Review manual journal entries and manual tenant-ledger adjustments.
- Check credit memos, payment reversals and returned-payment fees.
- Confirm that the same correction has not been posted twice.
- Keep a record of the reason, evidence, preparer and approver for material adjustments.
5. Keep security deposits separate from rent receivables
A refundable tenant security deposit is generally tracked separately from rent income and rent receivable. The exact account setup and permitted handling depend on the lease, entity, jurisdiction and accounting policy. Review the deposit ledger and related liability separately; do not net a deposit against overdue rent without a properly supported and permitted transaction.
For deposit receipts, balances and move-out activity, use the security deposit accounting workflow. Where funds are held in trust or another restricted arrangement, include the relevant account and ledger controls in the wider reconciliation process.
6. Investigate open balances and unusual activity
Review tenant balances by age and transaction type rather than relying on the total alone. A balance may reflect genuine unpaid rent, a payment awaiting application, an unprocessed credit, a timing difference or an incorrect opening balance. Document the explanation and next action rather than making an unsupported adjustment to force the ledger to zero.
- Compare the ledger with receivables aging and relevant payment records.
- Identify credit balances and confirm whether they are valid and correctly assigned.
- Review old unapplied receipts, negative balances and unusual manual entries.
- Assign unresolved items to a responsible person with a due date.
- Escalate disputed or legally sensitive items through the approved process.
7. Tie tenant-level detail to property accounting reports
After individual accounts have been reviewed, compare the tenant-ledger totals with the relevant receivable control account and property-level reports. The totals should reconcile under the accounting system’s structure and reporting basis. Investigate differences caused by filters, posting dates, inactive accounts, control-account mappings or entries made directly to the general ledger.
This step is distinct from checking the bank balance. Use the bank reconciliation workflow to validate cash activity, and the trust-account reconciliation guide when owner or tenant funds are held in trust arrangements.
After validating individual tenant transactions, review the portfolio-level receivables aging reconciliation guide to tie outstanding balances to the general ledger and document older exceptions.
8. Protect the review trail and tenant information
Keep source records and exception notes in approved systems with access limited to people who need them. Tenant ledgers can contain personal and financial information, so avoid sending unnecessary details through unapproved channels. Record the reporting date, reviewer, material exceptions and resolution evidence according to the organization’s retention and security policies.
Tenant ledger reconciliation checklist
- Correct property, tenant, lease and reporting period confirmed.
- Opening balance agrees with the prior reviewed period or documented migration record.
- Rent and other charges agree with lease terms and approved changes.
- Receipts are supported and applied to the correct tenant and property.
- Credits, reversals and adjustments have explanations and required approvals.
- Security deposits are tracked separately from ordinary rent receivables.
- Open, aged and unusual balances have documented next steps.
- Tenant-ledger totals tie to the appropriate receivable and property reports.
- Material exceptions are reviewed before reports or account communications are finalized.
Using property management software
Buildium, AppFolio and Yardi configurations vary by product, permissions and accounting setup. Use the relevant tenant ledger, lease, receipt, aging and general-ledger reports available in the client’s system. Confirm filters and report dates before comparing totals, and preserve enough source detail to trace material exceptions. A report export is a starting point for review, not evidence that every underlying transaction is correct.
Frequently asked questions
What is a tenant ledger reconciliation?
It is a review of tenant-level charges, payments, credits and balances against supporting lease records, receipts, deposits and the property accounting ledger. The purpose is to identify missing, duplicated, misapplied or unexplained activity.
Is tenant ledger reconciliation the same as bank reconciliation?
No. Bank reconciliation compares recorded cash activity with the bank statement. Tenant ledger reconciliation reviews each tenant account and the application of charges, payments and credits. Both checks can be needed because a bank balance can agree while an individual tenant balance is still wrong.
How often should tenant ledgers be reviewed?
Set a recurring cadence that fits transaction volume and reporting deadlines. Many property managers review tenant ledgers during monthly close and investigate exceptions sooner when payments, move-ins, move-outs or disputes require timely action.
Should a tenant security deposit reduce rent due?
Do not net a refundable security deposit against rent receivable by default. Track the deposit and its related liability separately and follow the lease, applicable law and the organization’s accounting policy for any permitted application or refund.