All AI Use CasesAI Use Case · Property Management

CAM Reconciliation With Claude Cowork: One Folder, Four Questions, a Four-Tab Workbook

The PLOT Daily editorial desk at AI for CRE Collective ran a 2025 CAM reconciliation for an 85,000-square-foot business park in Claude Cowork. Claude asked four questions before it calculated anything, built a four-tab Excel workbook, and the reviewed workbook became a reusable skill.

By CRE AI Studio Editorial · Nov 16, 2026 · 5 min readAI-assisted draft, checked against the creator's original post.
Short answer: To run a CAM reconciliation with Claude Cowork, put the operating-expense statement and each tenant's CAM lease abstract in one folder. Have Claude ask for what the documents don't show (each tenant's pro rata share, amounts already billed, how to apply the admin fee, the deliverable format) before it calculates. It then builds a workbook with a tenant summary, the CAM pool and gross-up, a tenant-detail schedule and a flags tab. Check it against the leases and your receivables ledger before any tenant sees a true-up.
Workflow by the PLOT Daily editorial desk, shared by @jbrenizer: five-step diagram for a CAM reconciliation in Claude Cowork. Step 1, one folder with the operating-expense statement and each tenant's CAM lease abstract. Step 2, Claude asks four questions first: pro rata shares, amounts billed, the admin fee, and the deliverable format. Step 3, Claude builds a four-tab Excel workbook: tenant summary, CAM pool with a 95% gross-up, tenant detail, assumptions and flags. Step 4, review the workbook in Excel. Step 5, save it as a Claude skill that stops and names any missing document.
Workflow by the PLOT Daily editorial desk (AI for CRE Collective), summarized from a public post by @jbrenizer on X (Nov 9, 2026).

Use case credit

Jason Brenizer @jbrenizer

Jason Brenizer (@jbrenizer) shared this CAM reconciliation run in a post on X on Nov 9, 2026. The workflow comes from the PLOT Daily editorial desk at AI for CRE Collective.

What PLOT Daily Did: A CAM Reconciliation in Claude Cowork

Jason Brenizer's post opens with a line most commercial owners will recognize: "the annual CAM reconciliation is the spreadsheet nobody wants to open." One operating-expense statement, a stack of tenant lease abstracts, and every tenant's pro rata share waiting to be checked by hand.

The workflow he shares comes from the PLOT Daily editorial desk at AI for CRE Collective. They ran a 2025 CAM reconciliation for an 85,000-square-foot business park in Claude Cowork, Anthropic's desktop agent that works on files in a folder you give it. The input was one folder holding the operating-expense statement and each tenant's CAM lease abstract.

CAM Reconciliation Step 1: Claude Asks Four Questions First

"Before Claude calculated a single number, Claude asked four questions the documents didn't answer":

  • Each tenant's pro rata share
  • The amounts already billed
  • How to apply the administrative fee
  • What format the deliverable should take

CAM Reconciliation Step 2: A Four-Tab Excel Workbook

Then Claude built a four-tab Excel workbook:

  • Tenant summary
  • CAM pool build-up with a 95% gross-up
  • Tenant-detail schedule
  • Assumptions and flags

CAM Reconciliation Step 3: Review in Excel, Then Save a Skill

After a review in Excel, the workbook became the template for a Claude skill "that stops and names the missing document instead of inventing a value." Next year, the new statement and lease abstracts go into the same Cowork folder, someone answers Claude's questions, and the output is a workbook the team already knows how to check.

Why Asking First Makes an AI CAM Reconciliation Safer

The four questions are the inputs that drive every tenant's true-up, and none of them sit in the expense statement. If a model fills those gaps with assumptions, the workbook still looks finished, and the error shows up only when a tenant disputes the bill. Making Claude ask first puts each of those inputs in front of a person.

The tab layout does the same job for review. The CAM pool tab shows how the expense pool was built and grossed up. The tenant-detail schedule shows each tenant's math. The assumptions and flags tab lists what Claude was told and what it couldn't confirm. A reviewer can check each part on its own.

Saving the reviewed workbook as a skill matters because a CAM reconciliation repeats every year with the same leases and mostly the same structure. A skill that stops on a missing document is easier to trust year to year than a prompt rewritten from memory.

The Source's Own CAM Reconciliation Caveat

The post includes one caveat worth repeating in full: PLOT Daily "used each tenant's estimated monthly CAM charge times 12 as the amount paid." In a real reconciliation, pull the actual accounts-receivable ledger, "and confirm caps, exclusions, gross-ups, and administrative fees against the governing leases before any tenant sees a true-up statement."

How to Try It: A CAM Reconciliation Prompt for Claude Cowork

You need Claude Cowork, one folder with the year's operating-expense statement and a CAM abstract for each tenant, and your receivables ledger for the year. The post links to a prompt hosted on a third-party site; we haven't reproduced it. The prompt below is CRE AI Studio's, written from the steps in the post.

[CRE AI Studio prompt, written for this article from the steps in the post]
This folder holds the [year] operating-expense statement for [property] and a CAM lease abstract for each tenant. We are preparing the annual CAM reconciliation.

Before you calculate anything:
1. List every input you need that these documents don't answer. At minimum ask me for each tenant's pro rata share, the amounts already billed or paid (I'll give you the receivables ledger), how to apply the administrative fee, and the format I want. Wait for my answers.
2. If a lease abstract is missing or doesn't cover caps, exclusions, gross-up or the admin fee, stop and name the missing document. Do not invent a value.

Then build an Excel workbook with four tabs:
- Tenant summary: share of expenses, amount paid, balance due or credit
- CAM pool build-up, with the gross-up percentage I confirm, showing which expenses are grossed up
- Tenant-detail schedule showing each tenant's math, including caps, exclusions and admin fee
- Assumptions and flags: every input I gave you, its source, and anything you couldn't confirm

Use formulas, not typed values, so I can trace each number.

Once the workbook has been reviewed, ask Claude to save the process as a skill so next year's run starts from it.

What to Check Before You Send a CAM Reconciliation

  • Amounts paid. Use the receivables ledger, not estimated monthly charges times 12. This is the shortcut the source itself flags.
  • Pro rata shares. Confirm each share against the lease and the current rentable area. Shares should add up to the whole building or note why not.
  • Caps and exclusions. Read each lease's cap (cumulative or not, controllable expenses only or all) and excluded expense categories against the tenant-detail tab.
  • Gross-up. Check that the lease allows a gross-up, at what occupancy, and that it applies only to expenses that vary with occupancy.
  • Administrative fee. Confirm the rate, and whether it applies before or after caps, and to which expenses.
  • Missing-document stops. If the skill names a missing document, get the document. Don't answer with a guess to keep it moving.
  • Confidentiality. Make sure your leases and your firm's AI policy allow these files in the tool you use.

FAQ: CAM Reconciliation With Claude

What is a CAM reconciliation?

A CAM reconciliation is the annual true-up of common area maintenance charges. The landlord compares what each tenant paid in estimated CAM during the year with that tenant's share of the actual operating expenses under its lease, then bills or credits the difference. Lease terms such as pro rata share, caps, exclusions, gross-ups and admin fees decide the math.

Can Claude do a CAM reconciliation?

It can build a draft. The PLOT Daily editorial desk ran a 2025 CAM reconciliation for an 85,000-square-foot business park in Claude Cowork from one folder holding the operating-expense statement and each tenant's CAM lease abstract. Claude asked four questions first, then built a four-tab Excel workbook. A person still has to check it against the leases and the receivables ledger.

What does Claude ask before a CAM reconciliation?

In this run, four things the documents didn't answer: each tenant's pro rata share, the amounts already billed, how to apply the administrative fee, and what format the deliverable should take. Answer them from the leases and your ledger rather than letting the model assume.

Can a CAM reconciliation workflow be reused next year?

That was the point of the last step. After a review in Excel, the workbook became the template for a Claude skill that stops and names the missing document instead of inventing a value. Next year you drop the new statement and abstracts into the same folder and answer its questions.

Want more AI workflows for CRE?

Join hundreds of CRE professionals learning AI through weekly lessons, live Q&A, and 24/7 founder access.

Cancel anytime.