Skip to content

From General Ledger to Tenant Invoice: How Commercial Property Revenue Gets Lost

Follow one dollar through the commercial property accounting system. Identify where recoverable revenue disappears between the lease, the GL, and the tenant invoice.

Revenue leakage in commercial real estate is not a single event. It is a series of small gaps between what the lease allows, what the ledger records, and what the tenant is billed. Each gap is small. The cumulative effect is material.

This article follows one dollar through the property accounting system and identifies where it disappears.

The Path of One Dollar

A recoverable expense dollar should follow this path:

Lease → Expense Pool → General Ledger → Tenant Invoice → Cash Collection

At each step, the dollar can be lost, misclassified, or delayed. The loss is not visible until the path is traced end to end.

Gap 1: Lease to Expense Pool

The dollar: A $500 landscaping invoice arrives. The lease allows recovery of landscaping as a CAM expense.

Where it is lost: The invoice is coded to "Grounds Maintenance — Non-Recoverable." The lease says landscaping is recoverable. The coding is wrong. The dollar never enters the CAM pool.

Why it happens: The person coding the invoice does not have the lease. The chart of accounts has two similar accounts. The default is the non-recoverable account.

The loss: $500 per month. $6,000 per year. Permanent.

Gap 2: Expense Pool to General Ledger

The dollar: The $500 landscaping invoice is correctly coded as recoverable. It enters the CAM pool.

Where it is lost: The CAM pool is calculated in a spreadsheet. The spreadsheet formula references the wrong cell range. The $500 is in the pool but not in the total. The GL shows the expense. The tenant billing does not.

Why it happens: The spreadsheet was built years ago. A row was inserted. The formula was not updated. The error is invisible until someone traces the formula.

The loss: $500 per month. $6,000 per year. Permanent.

Gap 3: General Ledger to Tenant Invoice

The dollar: The $500 is in the CAM pool and in the GL. The tenant's pro-rata share is 12.5%. The tenant should be billed $62.50.

Where it is lost: The tenant's pro-rata percentage in the billing system is 10.8%. The lease was amended two years ago. The billing system was not updated. The tenant is billed $54.00 instead of $62.50.

Why it happens: The amendment is filed but not entered. The billing system and the lease file are not connected. The percentage is set once and never verified.

The loss: $8.50 per month. $102 per year. Multiplied across 20 tenants with the same issue, the annual loss is $2,040. Permanent.

Gap 4: Tenant Invoice to Cash Collection

The dollar: The tenant is billed correctly at $62.50. The invoice is sent.

Where it is lost: The invoice is not tracked. The tenant does not pay. The aging report is not reviewed. The receivable is written off as uncollectible after 90 days.

Why it happens: The collections process is manual. The aging report is generated monthly, not reviewed daily. The follow-up is not systematic.

The loss: $62.50. Multiplied across 5% of invoices, the annual loss is material. Permanent.

The Cumulative Effect

GapMonthly LossAnnual Loss5-Year Loss
Lease to Pool$500$6,000$30,000
Pool to GL$500$6,000$30,000
GL to Invoice$102$1,224$6,120
Invoice to Cash$62$750$3,750
Total per property$1,164$13,974$69,870

A single property with these four gaps loses $70,000 over five years. A 50-property portfolio loses $3.5 million.

Why the Gaps Are Invisible

The gaps are invisible because each step is handled by a different person, using a different system, at a different time:

  • The lease is managed by the property manager or lease administrator
  • The expense pool is maintained by the property accountant
  • The general ledger is managed by the controller
  • The tenant invoice is generated by the billing system
  • Cash collection is tracked by the accounts receivable clerk

No single person sees the full path. No single system connects the steps. The error is discovered only when someone traces the dollar end to end.

The Connected Alternative

Komod.ai closes the gaps by connecting the steps:

Lease to pool. The lease is read. The recovery rules are extracted. Every expense is classified against the rules at entry.

Pool to GL. The CAM pool is calculated by the system, not by a spreadsheet. The formula is in the code, not in a cell reference.

GL to invoice. The tenant's pro-rata share is stored as structured data. The billing system uses the current percentage, not a stale entry.

End to end. The path is visible. Every dollar is traced from lease to cash. Every gap is flagged before it becomes permanent.

Conclusion

Revenue leakage in commercial real estate is not a single large error. It is a series of small gaps between systems that do not communicate. Each gap is invisible to the person managing that step. The cumulative loss is material.

The fix is not better training or more review. It is a system that connects the lease, the ledger, the invoice, and the cash collection into a single monitored path.

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.

All guides and posts

From General Ledger to Tenant Invoice: How Commercial Property Revenue Gets Lost — Komod.ai