How to Evaluate Lease Accounting Software for CAM Reconciliation

The decision criterion for lease accounting software isn't "does it produce ASC 842 reports." Every serious product on the market does that. The real question is whether it handles the operational complexity of managing a commercial portfolio — rent escalations, CAM recovery calculations, gross-up mechanics, and cap structures — accurately enough to trust without manual verification.

That's a much higher bar than most buyers apply, and it's where most disappointment happens after go-live.

Why "Lease Accounting Software" Means Different Things to Different Buyers

There are two distinct software categories that both go by the name "lease accounting software":

Category 1: ASC 842 / IFRS 16 compliance tools. These are primarily used by corporate real estate and accounting teams at companies that lease space (the tenants). They track lease liabilities, right-of-use assets, discount rates, and generate the journal entries and disclosures required by accounting standards. They're not designed to manage a landlord's portfolio.

Category 2: Property accounting and lease administration systems. These are used by landlords, property managers, and their accounting teams. They track rent rolls, bill tenants, manage CAM reconciliations, and produce property-level financial statements. They may have some ASC 842 features, but that's not their primary purpose.

If you're a property manager trying to improve CAM reconciliation accuracy, you're in Category 2. Make sure the products you're evaluating are designed for it.

This guide focuses on Category 2 — what landlords and property managers need when evaluating lease accounting and property accounting software for a commercial portfolio.

The Evaluation Framework: Start with CAM

Most software evaluations start with a feature list. That's backwards. Start with your most painful operational problems.

For most commercial property managers, the ranking looks something like this:

1. CAM reconciliation accuracy — Getting the annual statement right without manual spreadsheet work
2. Lease data management — Storing and maintaining all the lease terms that drive billing
3. Critical date management — Not missing renewal notices, option deadlines, or rent escalations
4. Financial reporting — Property-level income statements, budget vs. actual, recovery ratios
5. Compliance reporting — ASC 842, tax, audit support

If you weight these in the wrong order — putting ASC 842 compliance first because it's what your CFO asked about — you'll end up with a system that handles the accounting standards beautifully but still requires someone to manually reconcile CAM in Excel every year.

CAM Reconciliation Capabilities: What to Verify

This is the most important evaluation area and the one where most demos gloss over the details. Demand specifics.

Gross-Up Calculation

Ask to see the gross-up calculation in the system, not in a slide deck. Make the vendor walk you through:

• Where does the occupancy percentage come from? Is it set per lease or globally?
• Which expenses does the system treat as variable (and thus eligible for gross-up)?
• Can you configure which expenses are grossed up on a lease-by-lease basis?
• Does the system show the grossed-up pool separately from the actual pool in reports?

Many systems claim to handle gross-up but store the deemed occupancy percentage as a property-level setting rather than a lease-level setting. That's wrong — different leases in the same building can have different gross-up terms.

For the mechanics of how this should work, see our CAM gross-up calculation guide.

Expense Cap Management

This is where more systems fail than vendors will admit. Ask:

• Does the system support both cumulative and non-cumulative cap structures?
• Can you configure which expense categories are subject to the cap and which are excluded (controllable vs. uncapped)?
• How does the system calculate the base year amount for base-year caps?
• Does the system track cap carryforward for cumulative caps automatically?

If the demo system shows you a single "cap percentage" field without the cumulative/non-cumulative distinction, that's a significant limitation. The difference between these two structures can amount to tens of thousands of dollars per tenant over a 10-year lease.

See CAM cap types for the full explanation of why this matters.

Pro-Rata Share Handling

• Can the system store a variable denominator (one that changes with occupancy) or only a fixed denominator?
• Does it support both formula-based and stated pro-rata shares?
• How does the system handle pro-rata share changes mid-year (expansion, contraction)?

Exclusion Management

• Can you store a custom exclusion list per lease?
• Does the system apply exclusions before calculating allocations?
• Is there an audit trail showing which expenses were excluded and why?

Lease Administration Data Quality

The best CAM calculation engine in the world fails if the lease data feeding it is wrong. Evaluate how the system handles lease data:

Data Capture Completeness

Run through the fields from our lease abstract template guide and verify the system has fields for all of them. At minimum:

• Gross-up provision (occupancy %, applicable expense categories)
• Cap structure (type, percentage, cumulative/non-cumulative, controllable expense definition)
• Full exclusion list storage
• Pro-rata share formula and denominator definition
• Critical dates with alert functionality

Systems that store only basic lease information (term, rent, RSF) and handle CAM through manual overrides are not lease administration systems — they're rent roll trackers.

Amendment Tracking

Does the system maintain a full history of lease changes? Can you see what a field contained before an amendment? This matters for audit defense.

Data Import

If you're migrating from Yardi, MRI, or spreadsheets, how does the import process work? What data mappings are required? Can you import lease abstracts or do you have to re-enter everything manually?

See /resources/data-migration-off-excel for what to expect in a data migration.

The Major Product Categories and Their CAM Tradeoffs

Rather than reviewing specific vendors (pricing and capabilities change quarterly), here's how the categories compare on CAM-specific functionality:

Enterprise Property Management Platforms (Yardi Voyager, MRI Software)

CAM strengths: Battle-tested CAM reconciliation modules with support for gross-up, caps, and complex allocation structures. Large support ecosystems and training resources. Integrates with AP and GL naturally.

CAM weaknesses: Configuration complexity is high. Getting gross-up and cap structures set up correctly often requires a consultant. The reconciliation module can produce incorrect results if the lease setup is wrong, and the system won't tell you it's wrong. Annual reconciliation is often still partially manual despite the software.

Best for: Portfolios of 200+ units with dedicated property accounting staff and budget for implementation.

CAM-specific note: These systems are capable but not forgiving. They require correct lease setup to produce correct results. Many firms running Yardi or MRI still reconcile CAM in spreadsheets because the system configuration is too complex to maintain accurately.

Mid-Market Property Management Software (AppFolio, Buildium, Propertyware)

CAM strengths: Much lower implementation complexity than enterprise platforms. Good for standard recoveries.

CAM weaknesses: Limited support for complex CAM structures — non-cumulative caps, per-lease gross-up settings, multi-tier exclusion lists. These systems are designed for residential and simple commercial. If your leases have negotiated CAM provisions, you'll run into limitations quickly.

Best for: Smaller commercial portfolios with straightforward NNN leases, or mixed residential/commercial portfolios where CAM complexity is low.

Dedicated Lease Administration Systems (LeaseQuery, CoStar Real Estate Manager, Visual Lease)

CAM strengths: Strong lease data management with good field coverage for complex lease terms. ASC 842/IFRS 16 compliance built in.

CAM weaknesses: These are primarily lessee-focused platforms. CAM billing and reconciliation is not their core use case. If you're a landlord, verify carefully whether the system handles lessor-side CAM reconciliation or primarily handles tenant-side lease accounting.

Best for: Corporate real estate teams managing lease portfolios as lessees. Not typically the right choice for landlords.

Dedicated CAM Reconciliation Tools (CapVeri)

CAM strengths: Purpose-built for the reconciliation workflow. Handles gross-up, caps, exclusions, and pro-rata share with lease-level configuration. Produces audit-ready statements. Can work alongside existing property management systems rather than replacing them.

CAM weaknesses: Not a full property management system. If you need AP, maintenance management, and tenant portal in addition to CAM reconciliation, you'll still need a core PM platform.

Best for: Property managers who need accurate CAM reconciliation without a full platform replacement. Particularly effective for portfolios using Yardi or MRI who are frustrated with the reconciliation module complexity.

For a side-by-side comparison of CAM-specific software options, see /blog/cam-reconciliation-software-comparison-2026.

ASC 842 Features: What Actually Matters for Property Managers

Most landlords and property managers don't need deep ASC 842 functionality. Here's what's actually relevant:

What you probably need:

• Understanding that your tenants' ASC 842 reporting may affect how they want to structure leases (shorter terms, more variable payments)
• Ability to produce the supporting schedules that tenants need for their ASC 842 analysis (detailed rent and CAM schedules)
• If you lease corporate office space yourself (not from you, but that you occupy), ASC 842 compliance for your own leases

What you probably don't need (unless you have external reporting requirements):

• Right-of-use asset amortization schedules
• Lease liability rollforward reports
• IFRS 16 dual reporting

If a vendor is spending 60% of your demo on ASC 842 features and 20% on CAM reconciliation, ask yourself which problem you're actually trying to solve.

Integration Requirements

Before finalizing a vendor, map out your integration requirements:

The most important integration is usually the GL import — getting actual expense data from your accounting system into the CAM pool without manual re-entry. Verify that the import handles account mapping flexibility (your chart of accounts won't match the vendor's default mapping).

If you're running Yardi or MRI and evaluating whether to add a dedicated reconciliation tool, see /blog/cam-software-works-with-yardi for how that integration typically works.

Pricing and TCO

The sticker price is rarely the full cost. Factor in:

Implementation: Enterprise platforms often cost 50-100% of first-year licensing just for implementation. Mid-market tools are lower. Purpose-built reconciliation tools are typically lower still — under $5,000 for a portfolio of 50 properties.

Data migration: If you're moving from spreadsheets or a legacy system, someone has to clean and migrate your lease data. This takes more time than vendors typically quote.

Training: How long before your team is self-sufficient? Enterprise platforms typically require 3-6 months of active training. Purpose-built tools designed around the reconciliation workflow are typically operational within weeks.

Annual increases: SaaS pricing typically increases 5-15% annually. Get multi-year pricing locked if you can.

Per-property vs. per-unit pricing: Understand the scaling model before you sign. A $500/month tool that charges per unit might be fine at 50 units and expensive at 500.

Evaluation Process Recommendation

Here's a practical evaluation process that surfaces CAM capability gaps before you sign:

1. Define your must-haves from the CAM section above. For each must-have, write a specific test scenario.

2. Run a scripted demo using your actual lease data. Don't let vendors demo with their sample data — use a real lease from your portfolio with a non-standard gross-up or cap structure.

3. Ask for customer references at similar portfolio size and complexity. Specifically ask those references about CAM reconciliation accuracy and the annual reconciliation process.

4. Request a pilot on 2-3 properties before full commitment. Most vendors will accommodate this for qualified buyers.

5. Evaluate the audit trail: Run a reconciliation and then ask "if a tenant audited this statement, what documentation does the system produce to support it?"

For a downloadable version of evaluation criteria with scoring guidance, see our CAM software evaluation checklist.

The Build vs. Buy Question

For some firms — particularly those with complex portfolio structures or very specific workflow requirements — custom-built reconciliation tools are on the table. This is rarely the right answer, but it's worth acknowledging.

The case for buying: maintaining custom software requires dedicated engineering resources; product vendors have invested years of domain expertise in edge cases you haven't encountered yet; support and bug fixes are included in the subscription.

The case for building: very specific integration requirements; unique portfolio structure that off-the-shelf software can't handle; internal technical capability.

For a realistic assessment of this decision, see /resources/cam-build-vs-buy and /blog/cam-build-vs-buy.

Bottom Line

The right lease accounting software for a property manager is the one that gets CAM reconciliation right — not the one with the most impressive ASC 842 compliance deck.

Evaluate gross-up mechanics, cap structure handling, and exclusion list flexibility before you evaluate anything else. Use scripted demos with your actual lease data. Ask for references who have audited their reconciliations.

If you're running more than 30 leases and still doing CAM reconciliation in Excel, you have a real cost and risk exposure from errors. See /blog/death-of-spreadsheet-cam for what that exposure typically looks like.

And if you're unsure what your current reconciliation process is missing, start with the audit risk quiz — it takes 5 minutes and surfaces the most common gaps.