CAM Reconciliation Review Checklist for Bookkeepers
The first time most bookkeepers see a CAM reconciliation statement, they are not sure what they are looking at. A two-page PDF arrives from the landlord, the client forwards it with a note that says "please review," and the bookkeeper has to decide what counts as review. Tying out the math? Comparing to prior year? Reading the lease? All of the above? Most engagement letters do not specify, and the answer depends on what the firm wants the bookkeeper to do versus what they want to escalate.
This checklist defines the bookkeeper's first-pass review. It is not a full audit; that is a separate scope and a separate deliverable. It is the structured 20-to-30-minute review that catches the obvious errors, surfaces the items that need senior review, and produces a workpaper trail showing what was checked.
I built CAMAudit to do the deeper detection layer that goes beyond a bookkeeper checklist. The checklist is the upstream filter. When the checklist surfaces enough flags, the deeper review becomes a scoped engagement. When it does not, the routine review is enough.
Bookkeeper-Level CAM Review: A structured first-pass review of a landlord CAM reconciliation statement performed by a bookkeeper or staff accountant within a defined time budget (typically 20 to 30 minutes). The review verifies math, compares to prior year, checks for high-level lease compliance issues, and surfaces items requiring senior accountant or partner judgment. The deliverable is a checklist with notes and a flag list, not an opinion on whether to pay or dispute.
Where the checklist sits in the engagement
The bookkeeper-level review is not the same as a formal CAM audit. The boundary matters because mixing the two scopes is how engagements lose money or miss material errors.
The bookkeeper-level review answers four questions. Does the math on the statement tie? How does the statement compare to the prior year? Are there any obvious red flags (missing detail, unusual categories, math errors)? Is the variance to the firm's accrual within the expected range?
The bookkeeper-level review does not answer whether each charge is permitted under the lease, whether the management fee base is correctly computed, whether the gross-up calculation follows industry standards, or whether the pro-rata share denominator reflects the actual occupied square footage. Those are senior-accountant or formal-audit questions.
When the bookkeeper checklist surfaces enough flags to warrant the deeper analysis, the partner scopes a formal reconciliation review as a separate engagement. The bookkeeper checklist is the trigger; it is not the audit.
The checklist itself
Twelve items, organized by section.
Math verification
| # | Item |
|---|---|
| 1 | Sum of expense categories ties to total operating expenses |
| 2 | Pro-rata share percentage applied correctly to total expenses |
| 3 | Tenant share less estimates billed equals the true-up amount |
| 4 | Any caps or stops applied correctly per lease |
Prior-year comparison
| # | Item |
|---|---|
| 5 | Total CAM compared to prior year, variance noted |
| 6 | Major categories (insurance, taxes, repairs) compared to prior year |
| 7 | Pro-rata share percentage matches prior year (or change explained) |
| 8 | Categories present this year but not prior year flagged |
Compliance flags
| # | Item |
|---|---|
| 9 | Capital expenditures recovered through CAM flagged for senior review |
| 10 | Categories that look like landlord overhead flagged for senior review |
| 11 | Management fee computed on operating expenses (not total revenue) |
| 12 | Property tax and insurance billed once, not duplicated in CAM |
Each item gets a check, a note, or an escalation flag. The checklist takes about 25 minutes for a clean reconciliation; longer if items escalate.
How the comparison to prior year works
Prior-year comparison is the highest-yield section of the checklist because it surfaces anomalies without requiring the bookkeeper to interpret the lease.
The mechanic:
Pull last year's reconciliation. It should be in the prior-year close workpapers. If it is not, that is itself a flag (the firm did not retain prior-year backup).
Build a side-by-side. Total CAM, then each major category, then pro-rata share, then tenant share, then estimates billed, then true-up.
Compute year-over-year change. Percentage change for each line. Flag anything outside the firm's expected band.
Note explanations where available. If the landlord included a narrative or footnote explaining a change, capture it. If not, flag the change for senior review.
A typical CAM line might grow 4 to 8 percent year over year for inflation alone. Insurance might grow more during a hard market. Property taxes might jump after a reassessment. Categories like landscaping or janitorial should grow modestly unless there was a contract change. Repairs and maintenance is the most variable line and benefits from multi-year context.
After testing reconciliation samples through CAMAudit, the patterns the prior-year comparison catches most reliably are pro-rata share denominators that shrunk (which raises the tenant percentage and tenant share) and capital recovery items that appeared in the current year but not prior years. Both are flags for senior review even if the bookkeeper cannot determine the cause.
When the math does not tie
If step one through four of the checklist produce a math error, the review stops. The bookkeeper does not try to figure out the correct number. The bookkeeper documents the error and escalates.
Examples of math errors:
Sum of categories does not equal total. Often a transcription error; sometimes a category was excluded from the total but included in the tenant share calculation.
Pro-rata share computation is wrong. Tenant share divided by total does not equal the stated pro-rata percentage.
True-up arithmetic is wrong. Tenant share less estimates billed produces a different number than the stated true-up.
Math errors require the landlord to issue a corrected statement. The firm sends a request for a corrected reconciliation; the client should not pay the original until the math ties.
"The fastest way to lose a CAM dispute is to pay a statement that has a math error and then try to dispute it months later. The math check is the lowest-effort, highest-protection step in the review." — Angel Campa, Founder of CAMAudit
When categories do not match prior year
New categories on a current-year statement are one of the most reliable flags. A few common scenarios:
A capital expenditure shows up. The landlord bought a new HVAC system and is recovering the cost through CAM. Whether this is permitted depends on the lease, the type of capital expenditure, and any specific exclusions. Bookkeeper escalates; senior or partner reviews against the lease.
A new fee appears. A "common area administration fee" or "operations supervisor allocation" shows up where prior years had only a management fee. This may be double-billing for landlord overhead. Bookkeeper escalates.
A reclassified category. What was "repairs and maintenance" last year is now split into "preventive maintenance" and "corrective maintenance." The total may be the same; the structure changed. Bookkeeper notes; senior reviews.
A prior-year adjustment. The current-year statement includes an adjustment for a prior year. This may be legitimate (a true-up to a prior reconciliation) or may be a bookkeeping error. Bookkeeper escalates because prior-year adjustments often fall outside the lease audit window.
What gets documented
Every checklist run produces a workpaper. The workpaper has five components:
- The completed checklist with notes on each line.
- A copy of the reconciliation statement received.
- A copy of the prior-year reconciliation used for comparison.
- The lease abstract referenced (or a note that no abstract was on file).
- A summary of flags escalated to senior accountant or partner.
The workpaper goes in the close file for the period the reconciliation covers. If the reconciliation covers a prior period, it goes in that period's file with a cross-reference in the current period.
Documentation matters because reconciliation reviews recur. Next year's bookkeeper may not be this year's bookkeeper. The workpaper is what makes the review transferable across team members and across years.
What the partner sees
The partner does not run the checklist. The partner sees the escalation list. A few patterns trigger partner attention:
Variance above the firm threshold. Typically 15 to 20 percent above the firm's estimated true-up, or above a defined dollar threshold like $5,000. The partner decides whether to scope a formal reconciliation review.
New cost categories. Categories that appeared this year but not in prior years. The partner decides whether to request landlord backup or escalate to a formal review.
Math errors. The partner directs the firm to request a corrected statement before payment.
Repeat exceptions. When the same flag shows up in three consecutive years, the partner intervenes either with the landlord directly or by scoping a deeper structural review.
The bookkeeper checklist is the routine control. The partner escalation is the judgment layer. Keeping them separate prevents the routine review from drifting into ad-hoc opinions and keeps the engagement scope clean.
A bookkeeper-level CAM reconciliation review is one of the most leveraged 25 minutes a firm spends on a tenant client. The math errors it catches save real money. The escalations it surfaces feed the higher-margin advisory work. The workpaper it produces makes the engagement defensible to the next reviewer. It is not glamorous, and it is not the deep audit work, but without it the deeper work has nothing to escalate from.