How to Detect CapEx in a GL Export Before It Becomes a CAM Dispute
Five signals to screen your GL export for capital expenditures before they flow into the recoverable CAM pool.
Quick Answer
Capital expenditures coded to operating GL accounts are one of the leading causes of CAM overbilling. Before running a CAM reconciliation, screen your GL export for vendor names, transaction sizes, and account codes that indicate capital projects. A pre-reconciliation review takes less time than responding to a tenant audit demand.
Why Capital Expenditures End Up in Operating Accounts
CapEx miscoding is not usually intentional — it is the predictable result of four structural pressures in property accounting:
Rushed GL coding at month-end
A $40,000 contractor invoice arrives on the 28th. The property accountant codes it to the closest matching operating account to close the month — "Building Maintenance," "Repairs," or "Common Area Expenses" — with the intention of reclassifying later. Later rarely comes.
Vendor invoices that straddle the repair/replace line
A roofing contractor replaces a 3,000 square foot section of membrane (clearly capital) but also performs repairs on two other sections (potentially operating). The single invoice covers both. The property manager codes the whole amount to maintenance rather than splitting it between capital and operating accounts.
Property manager discretion in repair vs. replacement calls
When an HVAC unit fails and the property manager replaces it with a comparable unit, is it a repair (restoring function) or a replacement (capital asset)? Most accounting standards and lease language treat equipment replacement as capital. But many property managers code these events to operating accounts because "it is just replacing what was there before."
ERP account code design
Older Yardi and MRI chart-of-accounts configurations sometimes use a single account for both repair and replacement work on a given building system. The system architecture does not enforce the capital vs. operating distinction — the accountant must apply it manually on each transaction.
Five Detection Signals in a GL Export
Apply these five screens to your GL export before running the reconciliation. Each one targets a distinct CapEx miscoding pattern.
High-value single transactions in maintenance or repair accounts
Any transaction above $10,000 in accounts coded as maintenance, repairs, or building services warrants a manual review of the supporting invoice. A $12,500 HVAC repair could be a large but legitimate service call, or it could be the first invoice on a phased equipment replacement that should be capitalized. Flag every transaction above this threshold and verify the underlying invoice before including the line in the reconciliation.
Contractor and vendor names associated with major building systems
Vendor names are a high-signal indicator. HVAC manufacturers and their authorized dealers (Carrier, Trane, Johnson Controls), roofing contractors, elevator maintenance companies (Otis, KONE, Schindler), and parking structure specialists rarely appear for routine operating maintenance. When these vendor names appear in operating GL accounts, the transaction almost always requires review. Build a standing list of capital-associated vendor names and screen every GL export against it.
Description keywords indicating replacement, installation, or construction
The invoice description field in a GL export is often the fastest classification signal. Keywords like "replacement," "install," "upgrade," "new," "construction," "retrofit," and "overhaul" in a transaction description indicate the work may be capital in nature. Contrast with operating descriptors like "service," "maintenance," "inspection," "repair," and "cleaning." A systematic keyword scan of the description field catches miscoded items that dollar-value thresholds alone miss.
GL accounts that mix repair and replacement
Older chart-of-accounts designs — common in Yardi and MRI implementations that pre-date FASB ASC 840 clarity — sometimes route both repair and replacement costs to the same GL account (e.g., a single "HVAC — Maintenance & Repair" account). When an account has historically received only small transactions and then receives a $75,000 entry in the current year, the account code alone does not distinguish operating from capital. These mixed-use accounts require line-by-line review.
Same vendor with multiple invoices summing to a capital threshold
A capital project billed in phases can appear as multiple smaller transactions that individually fall below a CapEx detection threshold. A roofing contractor might issue three invoices of $28,000 each over a 90-day period for what is effectively a $84,000 roof replacement project. Grouping transactions by vendor within a period and reviewing the total — not just individual transactions — catches this pattern. In Yardi, this is visible by filtering the GL export by vendor and sorting by date.
The IRS Useful-Life Test as a Practical Guide
When you flag a transaction for manual review, the IRS useful-life test provides a defensible classification standard: if the resulting asset or improvement has a useful life of one year or more, it is a capital expenditure.
In practice, this means:
| Work Type | IRS Classification | CAM Treatment |
|---|---|---|
| HVAC filter replacement | Operating (consumable) | Recoverable |
| HVAC preventive maintenance contract | Operating | Recoverable |
| HVAC rooftop unit replacement | Capital (15–20 yr useful life) | Not recoverable (unless amortized per lease) |
| Roof membrane patching (<5% of area) | Operating repair | Recoverable |
| Roof section replacement (≥5% of area) | Capital (20–27.5 yr useful life) | Not recoverable (unless amortized) |
| Parking lot crack sealing | Operating repair | Recoverable |
| Parking lot full resurfacing | Capital (15 yr useful life) | Not recoverable (unless amortized) |
| LED lighting retrofit / full replacement | Capital (improvement) | Not recoverable (unless amortized) |
| LED bulb replacement | Operating (consumable) | Recoverable |
The IRS MACRS depreciation schedule provides specific useful-life guidance for building components. IRS Publication 946 classifies nonresidential real property components at 15 years (land improvements) and 39 years (building structure). When in doubt, verify against the specific asset category in MACRS.
Building a Pre-Reconciliation GL Review Checklist
Formalize the CapEx detection process as a standing checklist run before every reconciliation cycle. A practical checklist for a mid-size commercial portfolio:
- Export the full-year GL to a spreadsheet. Include: account code, account name, transaction date, vendor name, description, and amount.
- Filter to operating expense accounts (CAM-eligible account range in your COA). Exclude accounts already designated as capital or reserve accounts.
- Sort by transaction amount, descending. Flag all transactions above $10,000 for manual invoice review.
- Run a keyword search on the Description column for: replacement, install, installed, upgrade, new, construction, retrofit, overhaul, demolish, demolition. Flag all matches.
- Filter by Vendor Name and compare against your capital-vendor watchlist (major HVAC OEMs, roofing contractors, elevator companies, structural engineers). Flag any appearance of these vendors in operating accounts.
- Group by Vendor and sum transactions within the fiscal year. Flag any vendor where cumulative transactions exceed $20,000 — review for phased capital billing.
- For all flagged transactions: pull the underlying invoice and apply the IRS useful-life test. Recode capital items to a capital account before running the reconciliation.
What Can Go Wrong
HVAC equipment replacement billed as maintenance — repeatedly
A portfolio replaces 3–4 rooftop HVAC units per year across its properties, each unit costing $18,000–$25,000. All are coded to the "HVAC Maintenance" account. Over five years, $400,000+ in capital equipment flows into the CAM pool. When a sophisticated retail tenant audits, they recover credits plus interest going back three to five years — the full audit rights window.
Phased capital project billed across multiple invoice lines
A parking lot resurfacing project totaling $120,000 is invoiced in four installments of $30,000 each over three months. Each individual invoice falls below any single-transaction threshold. No individual line flags as unusual. But the cumulative vendor total — only visible by grouping — reveals the capital project. Without the vendor-grouping check, all $120,000 flows into the recoverable CAM pool.
Tenant improvement costs coded to common area accounts
Buildout costs for a new tenant — flooring, partitions, HVAC tie-ins — are coded to general building accounts rather than a tenant-specific capital account. These costs are both non-recoverable (as capital) and tenant-specific (excluded from the CAM pool). They require a separate account structure to prevent them from flowing into other tenants' CAM bills.
Frequently Asked Questions
Why does CapEx appear in operating GL accounts?
The most common causes are rushed month-end coding, vendor invoices that straddle the repair/replace line, property manager discretion, and ERP account designs that co-mingle repair and replacement in a single account.
What is the IRS useful-life test?
An expenditure is capital if the resulting asset has a useful life of one year or more. This test provides a consistent classification standard for borderline repair vs. replacement decisions. IRS Publication 946 and MACRS schedules list specific useful lives for common building components.
What dollar threshold should I use for GL review?
$10,000 per transaction is a practical starting threshold for most commercial portfolios. Higher-risk account codes (HVAC, roofing, structural) may warrant a lower threshold of $5,000. The threshold should be reviewed annually — replace costs change with inflation, and a threshold set in 2018 may miss items that would have been flagged then.
Can this GL review process be automated?
Yes. All five detection signals are rule-based and can be applied programmatically to a GL export. CAM reconciliation software can run these screens automatically and surface flagged items for human review before any reconciliation calculation runs.
Related Resources
CapEx vs. OpEx in CAM
Framework for classifying capital vs. operating expenses
Capital Expenditures Recoverable in CAM
When amortized capital recovery is permitted by lease
GL Export QA for CAM
Quality assurance checklist for GL exports before reconciliation
Recoverable vs. Non-Recoverable CAM
Which operating costs can be passed through to tenants
CAM Reconciliation Software
Automate CapEx detection and GL screening before reconciliation
Screen Every GL Line Before It Reaches Tenants
CapVeri runs automated CapEx detection on your GL export — flagging high-value transactions, capital vendor names, and description keywords before the reconciliation calculation runs.
Get Started Free