Issue
A commercial real estate management company’s accounting department was struggling to produce accurate, timely annual operating expense true-up billings — the yearly reconciliation that compares tenants’ monthly estimated payments against their actual pro-rata share of building operating expenses under each lease. As the portfolio grew and staff turned over, the reconciliation process — built entirely on manually maintained spreadsheets — became increasingly difficult to sustain, putting both billing accuracy and tenant relationships at risk.
Findings
A closer look at the process surfaced the root causes behind the breakdown:
- Chronic delays. For more than a decade, annual reconciliation statements had not gone out to tenants on schedule, driven largely by repeated staff turnover and the loss of institutional knowledge each time a new employee inherited the process.
- Manual, error-prone workflows. The reconciliation relied heavily on standalone spreadsheets rather than the recovery and reconciliation tools already available in the company’s property management software. This made the process labor-intensive and highly susceptible to human error.
- High likelihood of spreadsheet errors carrying over each year. Lease-specific terms — including base years, and expense caps and floors — were in some cases misapplied or carried forward incorrectly from one year to the next. Once introduced, these errors often went undetected and continued into subsequent reconciliations until someone happened to catch them.
- Inconsistent use of expense captions. Expense captions were not applied consistently throughout the year, so operating and non-operating expenses were routinely posted under the same captions. This made it difficult to isolate the true recoverable expense pool and increased the risk of misallocated or unrecoverable charges during reconciliation.
- Downstream cost to the business. Late and inaccurate billings strained tenant-landlord relationships. Once statements finally went out, staff spent significant additional time fielding and researching tenant disputes and questions — time that could have been spent on higher-value work.
Solution
The company engaged outside operating expense reconciliation experts to assess the process and guide a targeted turnaround:
- Diagnosed the gaps. Consultants worked directly with the accounting team to pinpoint where the process broke down — from data entry and lease-term application to statement delivery.
- Unlocked existing tools instead of buying new ones. Specialized reconciliation software was evaluated as an alternative to the spreadsheets in use, but rather than adopting a new system, the accounting department achieved results by better utilizing the reconciliation and recovery features already built into its existing property management platform — reducing the need for parallel manual tracking.
- Resolved a major dispute. In the course of the engagement, a significant tenant billing dispute was resolved once the underlying reconciliation mechanics were corrected and verified.
- Benchmarked performance. Operating expenses per square foot were compared against comparable buildings in the market, giving the company a data-driven basis for keeping its expense recoveries competitive.
Results: Every tenant reconciliation was delivered on time and with a materially higher degree of accuracy — strengthening tenant trust, reducing dispute-driven rework, and improving cash flow.