The general ledger records what happened. The lease defines what should have happened. The lease-to-GL reconciliation is the process of comparing the two and identifying the difference.
Most property managers reconcile bank accounts, credit cards, and intercompany accounts. They do not reconcile the lease to the GL. The lease sits in a file. The GL sits in the accounting system. The two are never compared until an auditor or a tenant dispute forces the comparison.
This article explains what a lease-to-GL reconciliation is, why it matters, and how to implement it.
What Is a Lease-to-GL Reconciliation?
A lease-to-GL reconciliation compares the contractual obligations in the lease to the actual entries in the general ledger.
The lease says:
- Base rent is $5,000 per month
- Escalation is 3% annually on January 1
- CAM cap is 5% non-cumulative, base year 2024
- Pro-rata share is 12.5%
- Taxes are recoverable over base year 2024
- Insurance is recoverable over base year 2024
The GL shows:
- Rent income: $5,000 per month, no escalation applied in year 2
- CAM recovery: $8,200 for the year, no cap applied
- Tax recovery: $4,100, base year amount used was wrong
- Insurance recovery: $1,800, allocated to wrong period
The reconciliation identifies the difference between what the lease requires and what the GL shows.
Why It Matters
Revenue Protection
If the lease requires an escalation and the GL does not reflect it, the property is losing revenue. The loss is invisible because the GL looks correct — it shows the rent that was billed. It does not show the rent that should have been billed.
Compliance
The lease is a contract. The property is obligated to bill correctly. If the GL does not reflect the lease, the property is in breach. The tenant can audit and recover the overbilling.
Audit Readiness
When an auditor reviews the property, the first question is: does the GL reflect the lease? If the answer is "we don't know," the audit becomes a forensic exercise.
The Four Reconciliation Points
1. Rent and Escalations
Lease: Base rent, escalation rate, escalation date, escalation base.
GL: Rent income by tenant by month.
Reconciliation: Does the GL rent match the lease schedule? Was the escalation applied on the correct date? Was the correct rate used?
2. CAM and Expense Recovery
Lease: CAM inclusions, exclusions, caps, pro-rata share, gross-up.
GL: CAM expense pool, tenant recovery income, cap application.
Reconciliation: Does the CAM pool include only the expenses the lease allows? Is the cap applied? Is the pro-rata share correct?
3. Tax and Insurance Recovery
Lease: Recovery method (full pass-through, base year, cap), base year amount, pro-rata share.
GL: Tax expense, insurance expense, tenant recovery income.
Reconciliation: Is the recovery calculated against the correct base year? Is the cap applied? Is the allocation correct?
4. Security Deposits and Prepaid Items
Lease: Security deposit amount, interest requirements, application terms.
GL: Security deposit liability, interest income/expense, deposit applications.
Reconciliation: Is the deposit liability correct? Is interest calculated and paid if required? Are applications documented?
The Manual Process
A manual lease-to-GL reconciliation requires:
- Reading the lease and extracting the financial terms
- Exporting the GL activity for the period
- Comparing each lease term to the GL entries
- Identifying variances
- Investigating and resolving variances
- Documenting the reconciliation
For a single tenant, this takes 2 to 4 hours. For a property with 20 tenants, it takes 40 to 80 hours. For a portfolio of 10 properties, it takes 400 to 800 hours.
The manual process is done annually, if at all. The errors accumulate for 12 months before they are found.
The Automated Alternative
Lease terms are structured data. The lease is read. The financial terms are extracted and stored as rules, not as text.
GL activity is matched to the rules. Every rent charge, every CAM recovery, every tax allocation is compared to the lease rule automatically.
The reconciliation is documented. Every comparison is logged with the lease clause, the GL entry, the variance amount, and the resolution.
The process scales. 20 tenants or 200 tenants, the reconciliation runs at the same speed. The portfolio grows without adding reconciliation hours.
Conclusion
The lease-to-GL reconciliation is the control that connects the contract to the accounting. Without it, the property does not know if it is billing correctly. The GL shows what was billed. The lease shows what should have been billed. The difference is the leakage.
Komod.ai is an AI-native operating layer for the commercial real estate back office. The platform reads leases, invoices, and bank activity; performs deterministic calculations; and stages completed work for human approval. Nothing posts without you.