Step-by-Step CAM Statement Review for Bookkeepers

Step-by-Step CAM Statement Review for Bookkeepers

The annual CAM reconciliation statement is one of the highest-leverage documents that crosses a bookkeeper''s desk. Done well, the review takes a few hours, surfaces real overcharges, and gives the client a defensible record of what was paid and why. Done poorly, the statement gets coded straight into the books and an overcharge of several thousand dollars survives into the next year''s baseline. I built CAMAudit because the manual review is repetitive, technical, and prone to fatigue errors, and bookkeepers deserve a process that makes the work faster and more reliable. The steps below are the workflow we recommend for any bookkeeper handling commercial lease reconciliations.

CAM Reconciliation Statement Review: The structured comparison of a year-end CAM reconciliation statement against the executed lease and the year''s estimate payments. The review verifies that the landlord''s reconciliation accurately reflects the lease provisions, that the categories billed are within the CAM definition, that the pro-rata calculation uses the correct denominator, and that any caps, base year adjustments, or gross-up provisions in the lease have been applied correctly. The output is a findings list with documented lease citations and dollar variances.

Step 1: Document intake

Before any analysis begins, gather the document set.

• Executed lease and all amendments
• Year-end CAM reconciliation statement
• Prior year reconciliation statement if available
• Estimate billings for the reconciliation year (monthly or quarterly invoices)
• Any prior correspondence with the landlord about CAM

Confirm that the lease is the executed copy with amendments, not a draft or a redline. The CAM provisions, exclusions list, and pro-rata definition often live in different sections, so a complete document is essential. If amendments modified the CAM definition or the exclusion list, those modifications govern the review.

Step 2: Tie the estimate payments to the reconciliation

Sum the estimate payments made during the year. Compare the total to the estimate column on the reconciliation statement. They should match within the variance allowed by accrual timing. A discrepancy here typically signals one of three issues:

A landlord billing error in the estimate column. The reconciliation may have understated what was paid, which inflates the true-up amount the tenant owes. A timing difference between when payments were issued and when the landlord recorded them. A missed payment or a duplicate payment from the tenant''s side.

This is the estimated payment true-up verification check, and it''s the simplest review step that often surfaces the cleanest finding.

Step 3: Verify the pro-rata share calculation

The reconciliation should state the tenant''s pro-rata share as a percentage. Verify this percentage against the lease.

Read the lease''s pro-rata definition. The lease specifies what square footage is the numerator (typically the tenant''s leased premises) and what is the denominator (total building rentable area, total occupied area, or total leased area, depending on the lease). Confirm that the percentage on the reconciliation matches the lease definition applied to the building''s current configuration.

The most common error is a denominator mismatch. The lease specifies total rentable area, but the landlord uses total occupied area, which is smaller and inflates the tenant''s share. Or the lease specifies total occupied area, but vacant space has been moved out of the denominator entirely, again inflating the tenant''s share. A 1% pro-rata error on a $400,000 CAM expense pool is $4,000 of overcharge.

Step 4: Check the operating expense categories

Compare each line on the reconciliation against the CAM definition and the exclusions list in the lease.

For each expense line ask: is this category included in CAM under the lease? If yes, proceed. If no, document the line as a potential exclusion finding. Common exclusions that often appear in reconciliations include capital improvements, landlord overhead and corporate administration, leasing commissions, marketing and promotional expenses, and roof replacement.

Pay particular attention to:

• Roof and HVAC repairs that may be capital under the lease
• Parking lot resurfacing that may be excluded or required to be amortized
• Property management costs that include landlord overhead
• Utility charges that may be metered separately

Each finding should reference the specific lease section that excludes the category.

Step 5: Verify the management fee calculation

The lease defines the management fee, typically as a percentage of CAM expenses with specific exclusions from the fee base. Replicate the calculation.

Identify the management fee percentage in the lease (commonly 3% to 5%). Identify the fee base definition: which CAM categories are included in the base, and which are excluded. Common exclusions include real estate taxes, insurance, utilities billed at cost, and management fees themselves. Apply the percentage to the correct base and compare to the landlord''s billed fee.

The most common management fee overcharge error is a fee base that includes categories the lease excludes. The error is straightforward to detect once the lease language and the reconciliation are aligned side by side.

Step 6: Check caps, base year, and gross-up

For leases with controllable expense caps, compare the year-over-year change in controllable expenses against the cap percentage. If the lease caps controllable expense growth at 5% per year and the controllable expenses on the reconciliation grew 8% over the prior year, the cap has been exceeded. Document the variance.

For office leases with base year mechanics, verify that the base year amount is correctly carried forward and that the current year''s excess is calculated against the correct base. Base year errors compound: a $5,000 error in the base year produces a $5,000 overstatement of the excess every year for the rest of the lease term.

For leases with gross-up provisions, verify that variable expenses (utilities, janitorial, supplies) are grossed up to the lease''s assumed occupancy level (typically 95%) and that fixed expenses are not grossed up. The most common gross-up violation is grossing up fixed costs along with variable costs, which inflates the expense pool.

Step 7: Document each finding

For every potential issue surfaced in steps 2 through 6, record:

• The reconciliation line item
• The dollar amount as billed
• The lease provision that governs the item (section number, page reference)
• The corrected amount if the finding is material
• The variance in dollars
• The bookkeeper''s confidence level and recommended next step

This documentation is what becomes the working paper for the engagement and what the controller or partner uses to decide whether to escalate.

The bookkeepers who do CAM review best run the same seven steps in the same order on every reconciliation. The discipline is what produces consistent quality. CAMAudit replicates this exact process automatically: tie the estimates, verify the pro-rata, check the categories against the lease, replicate the management fee, check the caps and base year, and produce a structured findings list. The bookkeeper''s job becomes validation and client communication, not manual line-by-line comparison.

Step 8: Communicate findings to the client

The client communication should be clear and structured. State each finding with the dollar variance, the lease citation, and a recommended action (accept, dispute, request landlord support documents). The client decides whether to push back. The bookkeeper''s role is to provide the analysis, not to make the dispute decision.

For findings the client wants to dispute, the firm escalates to the controller or partner for a formal response or, if the engagement is scoped that way, drafts the dispute correspondence directly.

Step 9: File working papers and close the engagement

The working papers should include the documents reviewed, the analysis output (CAMAudit findings report or manual review notes), the client communication, and the resolution of each finding. The file is the firm''s record that the review was done, what was found, and what was recommended.

For firms running CAMAudit, the platform produces a downloadable findings PDF that becomes the working paper artifact directly. For firms doing manual review, the working paper is whatever spreadsheet or memo the bookkeeper produced.

Step 10: Calendar the next reconciliation

Note the date of the next anticipated reconciliation in the firm''s engagement calendar. CAM reconciliations typically arrive 60 to 120 days after year-end. Knowing when to expect the next one lets the firm plan the engagement and communicate the upcoming work to the client.

The full review, run consistently across every commercial lease in a client portfolio, is one of the highest-value services an accounting firm can deliver. It catches overcharges that would otherwise survive, protects the books from compounding error, and produces a documented audit trail for every landlord assessment. See the white-label partner program for pricing tiers designed for accounting firms with varying engagement volumes.

Frequently Asked Questions

What documents does a bookkeeper need to review a CAM reconciliation statement?

The minimum document set is the executed lease with all amendments, the year-end CAM reconciliation statement, the prior year reconciliation if available, and the year's CAM estimate billings (the monthly or quarterly invoices that were paid throughout the year). With these four documents the bookkeeper can verify that the estimate payments tie to the reconciliation true-up, that the reconciliation references the correct lease provisions, and that the year-over-year trend is consistent.

What are the most common errors a bookkeeper finds in a CAM reconciliation?

The most common findings are pro-rata share denominator mismatches, management fee calculations that include excluded categories, controllable expense increases that exceed the cap, and operating expenses that the lease excludes from CAM. Less common but more material findings involve base year errors that compound year over year, gross-up calculations that overstate occupancy adjustments, and capital items billed as current-period operating expense.

How long should a bookkeeper spend on a single CAM reconciliation review?

A manual review of a single reconciliation against the lease takes 2 to 6 hours depending on lease complexity and statement detail. Office leases with gross-up provisions and base year mechanics tend to take longer than retail leases with simple pro-rata pass-through. With CAMAudit the analytical portion of the review runs in minutes; the bookkeeper's remaining time is spent validating findings, drafting client communications, and documenting working papers.

What should the bookkeeper escalate to the controller or partner?

Anything material relative to the lease, anything where the landlord's position differs from the firm's reading of the lease, anything that involves multiple years of compounding error, and any finding the bookkeeper is not confident about. The escalation should include the documentation: the lease provision, the landlord's billed amount, the firm's calculated amount, and the dollar variance. Clear escalation documentation lets the controller or partner make the decision quickly.

How does a bookkeeper document the review for the client file?

The working papers should include the documents reviewed, the date of review, the bookkeeper's name, a summary of each finding with lease citation and dollar variance, any communications with the client or landlord, and the recommended next step (accept, dispute, escalate). The documentation protects the firm in the event the issue resurfaces in a future engagement and gives the client a clean record of what was reviewed and what was found.