Step-by-step CAM statement review for bookkeepers
The yearly CAM reconciliation is a high-value document. CAM means common area maintenance. It is one of the most useful papers on a bookkeeper''s desk. Done well, the review takes a few hours. It surfaces real overcharges. It gives the client a defensible record of what was paid and why. Done poorly, the statement gets coded straight into the books. Then an overcharge of several thousand dollars survives into next year''s baseline. I built CAMAudit because the manual review is repetitive and technical. It is easy to make a tired mistake. Bookkeepers deserve a faster, steadier process. The steps below are the workflow we recommend for any commercial lease reconciliation.
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: Gather the documents
Before any analysis, 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 landlord correspondence about CAM
Confirm the lease is the executed copy with amendments. It should not be a draft or a redline. The key terms often sit in different sections. That includes the CAM provisions, the exclusions list, and the pro-rata definition. Pro-rata share is the tenant''s percentage of the shared costs. So you need the full document. An amendment may have changed the CAM definition or the exclusion list. If so, that amendment governs the review.
Step 2: Tie the estimates to the reconciliation
Sum the estimate payments made during the year. Compare the total to the estimate column on the statement. They should match within normal accrual timing. A gap usually points to one of three issues.
The first is a landlord billing error in the estimate column. The reconciliation may understate what was paid. That inflates the true-up the tenant owes. The true-up is the year-end adjustment between estimates and actual cost. The second is a timing gap. Payments went out at one time. The landlord recorded them at another. The third is a missed or duplicate payment on the tenant''s side.
This is the estimated payment true-up verification check. It is the simplest step. It often surfaces the cleanest finding.
Step 3: Verify the pro-rata share
The reconciliation should state the tenant''s pro-rata share as a percentage. Verify it against the lease.
Read the lease''s pro-rata definition. The lease names the numerator. That is usually the tenant''s leased space. It also names the denominator. The denominator can be the total rentable area. It can be the total occupied area. It can be the total leased area. It depends on the lease. Confirm the percentage on the statement matches the lease applied to the building today.
The most common error is a denominator mismatch. The lease may say total rentable area. The landlord may use total occupied area instead. That number is smaller. It inflates the tenant''s share. Or the lease says total occupied area. But vacant space gets pulled out of the denominator. That inflates the share again. Take a $400,000 CAM pool. A 1% pro-rata error on it is $4,000 of overcharge.
Step 4: Check the expense categories
Compare each line on the reconciliation against the lease. Check it against the CAM definition and the exclusions list.
For each line, ask one question. Is this category in CAM under the lease? If yes, move on. If no, log the line as a possible exclusion finding. Common exclusions show up often. They include capital improvements and leasing commissions. They include landlord overhead and corporate admin. They include marketing and roof replacement.
Watch these closely:
- 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 cite the lease section that excludes the category.
Step 5: Verify the management fee
The lease defines the management fee. It is usually a percentage of CAM expenses. Some categories are excluded from the fee base. Replicate the calculation.
First find the management fee percentage in the lease. It is commonly 3% to 5%. Then find the fee base definition. That tells you which CAM categories are in the base and which are out. Common exclusions are real estate taxes and insurance. They also include utilities billed at cost and the management fee itself. Apply the percentage to the right base. Compare it to the landlord''s billed fee.
The most common management fee overcharge is a fee base that includes excluded categories. It is easy to catch. Just line up the lease language and the reconciliation side by side.
Step 6: Check caps, base year, and gross-up
Some leases have a controllable expense cap. That cap limits how fast controllable costs can grow. Compare the year-over-year change against the cap percentage. Say the lease caps growth at 5% per year. The controllable expenses grew 8%. The cap has been exceeded. Document the variance.
Some office leases use a base year. The base year is the cost year the lease measures growth against. Verify the base year amount carries forward correctly. Verify the current year''s excess is figured against the right base. Base year errors compound. Say the base year is off by $5,000. That overstates the excess by $5,000 every year. It runs for the rest of the term.
Some leases have a gross-up provision. Gross-up adjusts variable costs as if the building were near full. Verify variable expenses get grossed up to the lease''s assumed level. Those are costs like utilities, janitorial, and supplies. The assumed level is often 95%. Verify fixed expenses do not get grossed up. The most common gross-up violation is one mistake. It is grossing up fixed costs with the variable ones. That inflates the pool.
Step 7: Document each finding
For every issue from 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 becomes the working paper for the engagement. The controller or partner uses it to decide whether to escalate.
The best CAM reviewers run the same seven steps every time. They run them in the same order. That habit is what keeps quality steady. CAMAudit runs this exact process for you. It ties the estimates. It verifies the pro-rata. It checks the categories against the lease. It replicates the management fee. It checks the caps and base year. Then it produces a structured findings list. Your job becomes validation and client communication. It is no longer a line-by-line slog.
Step 8: Share findings with the client
The client memo should be clear and structured. State each finding with the dollar variance and the lease citation. Add a recommended action. The options are accept, dispute, or request landlord support documents. The client decides whether to push back. Your role is to provide the analysis. The dispute call is theirs.
When the client wants to dispute, the firm escalates the finding. It goes to the controller or partner for a formal response. The engagement may be scoped to go further. If so, the firm drafts the dispute letter directly.
Step 9: File the working papers
The working papers should include the documents reviewed. They should include the analysis output. That is the CAMAudit findings report or your manual review notes. They should also include the client memo and the resolution of each finding. The file proves the review was done. It shows what was found and what was recommended.
For firms running CAMAudit, the platform produces a downloadable findings PDF. That PDF becomes the working paper directly. For firms doing manual review, the working paper is your own work. It is whatever spreadsheet or memo you produced.
Step 10: Calendar the next reconciliation
Note the next expected reconciliation date in the firm''s calendar. CAM reconciliations usually arrive 60 to 150 days after year-end. Knowing when the next one lands helps you plan the engagement. It also helps you tell the client what is coming.
Run this full review across every commercial lease in a client portfolio. It is one of the highest-value services a firm can deliver. It catches overcharges that would otherwise survive. It protects the books from compounding error. It produces a documented trail for every landlord assessment. See the white-label partner program for pricing tiers. The tiers fit accounting firms at different 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.