CAM reconciliation software: what to check before you buy

If you own or manage a handful of NNN properties, CAM reconciliation software usually comes in one of three shapes. It can be a module inside a full property management suite. It can be a stand-alone tool built for lease administration. Or it can be a smaller tool that does one job: take the year's expenses and the lease terms, and produce each tenant's true-up and letter.

Which one fits depends on how many properties you run and how your books are kept. This guide is a checklist for comparing them, written from the point of view of a landlord or property accountant who does the yearly reconciliation and wants it to stop eating the first quarter.

Start with the job, not the feature list

A CAM reconciliation has five parts: sorting the ledger into pools, finding each tenant's share, applying each lease's exceptions, trueing up against the estimates billed, and producing the letter with backup. Software that handles only the third part, for example, leaves you doing the rest in a workbook.

Write down which of the five parts you want out of your hands. Then test any tool against your actual messiest lease, not its demo data.

The checklist

Use these questions in a demo or a trial. Each one points at a place where a tool commonly leaves work for you.

Does it take your ledger as it is?

Most small landlords keep books in QuickBooks, a property management system or a bookkeeper's workbook. Find out whether the tool needs a direct connection to your accounting system, or whether it reads a general ledger detail report exported as CSV or Excel. A file import has no connection to set up and no credentials to hand over. A direct connection may save the export step but ties you to specific systems.

Then ask what happens to the account mapping. The first import should ask you to assign each ledger account to a pool. The second year should not.

Can it model the terms in your leases?

List the terms your leases actually use, and check each one:

• Share by square feet, a stated denominator, or a fixed percentage
• Excluded accounts, lease by lease
• A base year or expense stop
• A cap on controllable expenses, and which kind: non-cumulative, cumulative, or compounding
• Gross-up of variable expenses to an occupancy level
• An administrative fee, and whether it falls inside the cap
• A tenant who moved in or out during the year

If your portfolio has a term the tool does not support, ask how you would handle it. A workable answer is a fixed share or an excluded account. A bad answer is "manually adjust the output," because then you are back in the workbook.

Does it show its math?

This is the single most useful question. A tenant who disputes a bill will ask how the number was reached. If the software shows only a total, you have to rebuild the logic to answer. Ask to see a single tenant's reconciliation and check whether every step is a visible line: pool totals, exclusions, gross-up, share, cap, administrative fee, base year, estimates, and the final true-up.

Then check a few by hand. A tool you can verify is a tool you can trust.

Who approves the numbers?

Software should produce a draft you review, not letters that go out on their own. Look for a review step before anything is final, and for the ability to open any tenant's figures down to the ledger lines behind each pool.

What does the letter look like, and what comes with it?

Ask for a sample letter and sample backup. The letter should state the period, the share and how it was found, each pool, any cap or gross-up applied, the estimates billed and the balance due or credit. The backup should let a tenant or auditor trace each pool to its ledger detail.

Ask also whether the tool sends the letters for you. Some do. Some leave delivery to you. Either can be right, depending on whether you want your own email to carry the letters.

Does it help during the year?

CAM trouble often starts when monthly estimates are set too low and a large balance lands on the tenant at year-end. Some tools let you upload the year-to-date ledger and project each tenant's true-up, so you can adjust the estimates before the gap grows. If your tenants have complained about surprise bills, this is worth weighing.

Does it read your leases?

Some tools read lease PDFs and suggest terms. That can save typing, but treat it as a suggestion. Check that you see the text it found each term in, that nothing is used until you confirm it, and that scanned leases are handled or at least clearly flagged as unsupported.

What does it cost to start?

Look at the minimum monthly price, any onboarding fee, any contract length, and whether the CAM module is on every plan or only a higher one. Compare that with what the reconciliation costs you now, in your own hours or in a bookkeeper's invoice. Tools priced for large portfolios can cost more per month than a small landlord's whole reconciliation work costs per year, so run that division before you commit.

A short comparison table

Where CAM Rec fits

CAM Rec is the small, single-job kind. You upload a general ledger export and a rent roll as CSV or Excel, assign accounts to pools once, and enter each lease's terms once. It handles share by square feet, a stated denominator or a fixed percent, exclusions, a base year or expense stop, non-cumulative, cumulative and compounding caps, gross-up, administrative fees and partial years. It shows every calculation line, holds each property's reconciliation as a draft until you approve it, and then produces a letter PDF per tenant and a backup ZIP per property. It does not send the letters, connect to your accounting system or interpret your leases. Shares based on occupied area, and caps on taxes or insurance, are not handled yet.

The sample runs the real engine on a fictional six-tenant strip center, with no sign-up, so you can test it against the checklist above before you decide anything.

Related: CAM reconciliation spreadsheet vs CAM Rec for when a workbook is still enough, the CAM reconciliation template if you stay with one, and the CAM reconciliation process any tool has to follow.

This is general information, not legal or accounting advice.