CAM reconciliation errors by property management software
Your CAM reconciliation is a data export from a property management system. Most of the time, that system is Yardi, MRI, or AppFolio. Understanding how these systems generate errors — not fraud, systematic errors from software configuration and data entry — explains a large portion of the 40% material error rate (Tango Analytics, 2023) in commercial CAM reconciliations.
This is useful to know not because the software is at fault, but because understanding the error source tells you where to look. Errors that come from account coding decisions are different from errors that come from cap configuration failures, which are different from errors that come from manual invoice entry. Each has a specific signature in the reconciliation statement.
Error types by platform
| Error Type | Yardi | MRI | AppFolio | Root Cause |
|---|---|---|---|---|
| Account coding (CapEx coded as OpEx) | Common | Common | Common | Manual coding decision |
| Gross-up on fixed expenses | Common | Moderate | Manual | Misconfigured module |
| Wrong pro-rata denominator | Moderate | Common | Manual | Default vs. lease setting |
| CAM cap not enforced | Common | Moderate | Rare | Complex logic not configured |
| Lease-type mismatch (gross in NNN building) | Moderate | Common | Rare | Recovery pool config error |
| Manual invoice entry error | 1–5% | 1–5% | 1–5% |
The fundamental problem: lease vs. system configuration
CAM exclusions are drafted by attorneys. The system configuration that enforces those exclusions is set up by IT and accounting teams. These groups don't usually talk to each other directly, and that gap is where most software-generated errors originate.
A lease might say: "Operating Expenses shall exclude all costs classified as capital expenditures under GAAP." Someone at the property management company has to configure Yardi, MRI, or AppFolio to keep capital expenditure accounts out of the recoverable CAM pool. If that configuration step is skipped, misconfigured, or not updated when the software is upgraded, capital expenditures flow into the CAM pool automatically.
Manual processes carry a baseline error rate of 1–5% on invoice entry and account coding (PredictAP, 2024–2026 research). On a $1,000,000 annual CAM pool, a 2% error rate produces $20,000 in incorrectly coded expenses — split across tenants at their pro-rata shares.
Yardi-specific error patterns
Yardi Voyager and Yardi Breeze are the dominant property management platforms for commercial real estate. Yardi uses an account numbering system where accounts in the 7000-series are supposed to contain operating expenses and accounts in the 8000-series are supposed to contain capital items.
Account coding errors
When a contractor invoices for what the landlord's team calls "parking lot maintenance," the accounting staff assigns an account code. If the work was actually a full repaving (capital expenditure), it should go to an 8000-series account. If it's miscoded to a 7000-series operating expense account, it flows directly into the CAM pool.
This error is common because:
- Property managers use inconsistent terminology ("repaving" vs. "asphalt maintenance" vs. "parking lot repair")
- Junior accounting staff making routine coding decisions may not have the context to distinguish a $5,000 pothole fill from a $75,000 full repaving
- The software doesn't prevent 8000-series items from flowing to recoverable pools if the initial account setup is misconfigured
Dollar impact: A $200,000 parking lot repaving coded as an operating expense costs a 10% tenant $20,000 in that year instead of roughly $1,900 (amortized over 15 years).
Gross-up configuration
Yardi's gross-up module requires manual configuration to specify which expense categories should be grossed up (variable expenses) and which should not (fixed expenses). This configuration is done once when the lease is set up in the system.
If the initial configuration applies gross-up to all expenses rather than only variable expenses, every year's reconciliation will incorrectly gross up fixed costs like property insurance and security contracts. The error doesn't announce itself — the reconciliation statement shows the grossed-up total, not the pre-gross-up amounts.
Dollar impact: At 70% occupancy, grossing up a $150,000 insurance premium adds $64,286 to the building's CAM pool — $6,429 for a 10% tenant per year.
Custom cap logic limitations
Yardi's standard CAM cap enforcement works for simple percentage caps. It struggles with:
- Compounded vs. cumulative caps (where unused cap room carries forward)
- Per-tenant cap schedules (when different tenants have different caps)
- Caps that apply to specific expense subcategories but not others
When the cap logic is complex and Yardi isn't properly configured, the system defaults to charging actual costs — no cap applied. Cap violations appear in 15–25% of audited leases that have cap provisions. Most of those violations trace back to software configuration, not intentional landlord action.
MRI Software error patterns
MRI Software (used primarily by larger commercial landlords) has similar structural weaknesses, though its account architecture differs from Yardi's.
Tenant recovery pool configuration
MRI requires explicit configuration of which expense pools are recoverable by which tenants. When a new lease type is added to a building — a gross lease tenant in what was previously an all-NNN building — the recovery pool configuration needs to be updated to exclude that tenant from CAM billing.
If the update isn't made, a gross lease tenant continues to receive CAM bills even though their lease structure doesn't permit it. This is Yardi Rule 1 error type (gross lease charges) generated entirely by a configuration miss.
Occupancy-based denominator updates
MRI calculates pro-rata shares dynamically based on current occupancy. The lease may specify the denominator as the total gross leasable area of the property. MRI's default may use currently occupied area. If the system isn't configured to use GLA as the denominator, tenants in a partially vacant building automatically pay inflated shares.
Dollar impact: 100,000 SF building at 80% occupancy — if MRI uses occupied area as denominator, a 7,500 SF tenant's share goes from 7.5% to 9.375%. Overcharge: $18,750/year on $1,000,000 in building CAM.
Integration errors from accounting system imports
Large landlords often run both MRI and a general accounting system (SAP, Oracle, QuickBooks). Expenses originate in the general accounting system and are imported into MRI for CAM allocation. When the GL account mapping between the two systems isn't maintained — an account gets renamed, a new account is added, the mapping isn't updated — expenses from excluded categories can flow into the CAM pool.
Integration errors are particularly hard to detect from the reconciliation statement because the line item description reflects the MRI category, not the original GL code.
AppFolio error patterns
AppFolio is more common in smaller commercial properties and mixed-use buildings. Its CAM reconciliation module is less sophisticated than Yardi or MRI, which creates different error types.
Limited exclusion configuration
AppFolio's expense exclusion configuration is less granular than Yardi or MRI. Where Yardi can enforce exclusions at the account code level, AppFolio typically requires manual line-item exclusion during the reconciliation process. This manual step — someone reviewing each line item and marking it excluded — creates opportunities for miss.
Common misses in AppFolio: Depreciation entries, interest expense, landlord's personal property expenses. These appear in the property's P&L imported into AppFolio and require manual exclusion each year.
No automated cap enforcement
AppFolio's standard CAM module does not automatically enforce CAM caps. Cap calculation is either done manually (in spreadsheets alongside the system) or not done at all. For smaller landlords without sophisticated accounting staff, CAM caps in tenant leases are frequently ignored simply because the system doesn't enforce them.
OCR and manual entry errors
Beyond software configuration, the invoice ingestion process creates its own error layer.
Vendor invoices come into property management systems through two channels: manual entry and OCR scanning. Both have documented error rates.
Manual entry: A 1–5% error rate on amounts and account codes is the industry standard for high-volume manual processing. At $2,000,000 in annual building expenses, 2% error = $40,000 in incorrectly entered data. Most errors are small rounding or transposition errors; some are misclassification errors (entering an amount into the wrong account).
OCR failures: When invoices are scanned rather than entered manually, OCR software misreads amounts, tax IDs, and line item descriptions. The misread invoice amount gets entered into whatever account the operator assigned manually, often without catching the OCR error against the physical invoice.
Both error types compound across a multi-tenant building: each coding error affects every tenant's bill at their pro-rata share, every year, until an audit catches it.
What this means for your reconciliation review
Software configuration errors are systematic — they appear in every year's reconciliation once introduced. If you find a gross-up error on a fixed expense in Year 3, the same error almost certainly exists in Year 1 and Year 2. That turns a $6,000 single-year overcharge into an $18,000 three-year recovery.
The most productive starting points when reviewing a Yardi or MRI-generated reconciliation:
- Identify any single line items above $50,000 and ask whether they're operating or capital expenditures
- Compare the gross-up calculation to the prior year to see if methodology changed
- Verify the pro-rata share percentage against the denominator definition in your lease
- Check the management fee rate against the lease cap and confirm the base calculation
- Check whether a CAM cap applies and whether it was applied
These aren't legal arguments — they're arithmetic checks. A correctly configured system produces a correct reconciliation. When the system is misconfigured or the data entry is wrong, the math is simply wrong, and tenants can document that independently of whether the landlord intended any error.
Frequently Asked Questions
How do Yardi account codes relate to CAM errors?
Yardi uses a numbered account system where 7000-series accounts typically contain operating expenses and 8000-series accounts contain capital expenditures. When a capital expense (like a roof replacement) is coded to a 7000-series operating account, it flows into the CAM recovery pool automatically. The tenant's reconciliation statement shows the charge as an operating expense because that's the account it's in — there's no flag indicating it was miscoded. Identifying these errors requires comparing line items against capitalization thresholds and the useful life of the work performed.
Do property managers intentionally misconfigure software to generate overcharges?
Most CAM errors from software are configuration errors and coding mistakes, not deliberate manipulation. The Tango Analytics 40% error rate reflects structural breakdowns in the gap between lease language and software setup, not a pervasive pattern of fraud. That said, it doesn't matter for recovery purposes — the tenant is owed a correction regardless of whether the error was intentional. Some patterns (consistently grossing up fixed costs, consistently ignoring a documented CAM cap) can become harder to explain as innocent mistakes over multiple years.
What is the manual invoice entry error rate in commercial property management?
PredictAP's 2024–2026 research documents a 1–5% error rate in manual invoice processing across commercial real estate. On a $1,000,000 annual CAM pool, a 2% error rate produces $20,000 in incorrectly entered data. Not all of these errors favor the landlord — some are overcredits, underbills, or duplicate entries. But the cumulative effect on a large portfolio is significant, and systematic errors (miscoded account, incorrect denominator) tend to consistently favor the landlord by pushing costs into the recoverable pool.
Can I get the landlord's property management software reports as part of a CAM audit?
What you're entitled to depends on your lease's audit clause and applicable state law. The general ledger detail (the underlying account-level data that feeds the reconciliation) is what shows account codes and amounts. Most leases that grant audit rights include the right to review general ledger data and supporting invoices. Without an express audit clause, implied rights (from PV Properties, Maryland 1988) get you itemized documentation but may not get you raw GL access without litigation.
What if the same error appears in multiple years of my reconciliation?
That's actually the most valuable audit finding. A configuration error or systematic coding mistake applied to every year produces a compounding overcharge. Most leases and state statutes permit a 24–36 month lookback for disputed charges. If you find a management fee calculated on the wrong base in the current year, check whether the same error appears in the prior two years as well. Three years of recovery at $6,000/year = $18,000 in recoverable overcharges from a single finding.
For the formulas used to detect software-generated errors systematically, see CAM Overcharge Detection Formulas. For how to read the output of Yardi and MRI reconciliation statements, see How to Read a Yardi CAM Reconciliation and How to Read an MRI CAM Reconciliation. Run a free CAM scan to apply all 12 detection rules to your reconciliation automatically.