Skip to content
Workflow · Finance close · Opening soon

CAM reconciliation

Export your tenant, expense, and payment data to Excel, then upload the file. The workflow totals 2026 common area expenses, prepares tenant areas, adds estimated payments, and calculates each tenant’s CAM balance.

Early access opens shortly. Check back soon.

Someone typed

“reconcile each tenant’s year-end cam: prorate the common area expenses by leased sf, compare to estimated cam paid, and show the balance owed or refunded with status Agrees, Bill tenant, or Refund tenant under $250”

The agent read it as

Reconcile each tenant’s year-end cam: prorate Common Area Expenses by Tenants leased sf, compare to Estimated CAM Payments, and show the balance owed or refunded with status Agrees, Bill tenant, or Refund tenant under $250, using 2026 expenses only and with balances within $250 counting as Agrees.

What the agent built

5 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Tenants
    CSV export · 8 rows
  2. File
    Common Area Expenses
    CSV export · 15 rows
  3. File
    Estimated CAM Payments
    CSV export · 8 rows
  4. Step
    Prepare tenant areas
    Step 2
  5. Step
    Total 2026 expenses
    Step 1
  6. Join
    Add expense total
    8 of 8 paired
  7. Join
    Add estimated payments
    8 of 8 paired
  8. Step
    Calculate CAM balances
    Step 5
  9. Result
    Year-End CAM Reconciliation
    8 rows · 8 flagged
  10. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 8 rows came out, and the join paired 8 of 8 rows; the join paired 8 of 8 rows.

What you get back

The result of that run, the rows to look at first.

Year-End CAM ReconciliationSample data8 rows
4 bill tenant4 refund tenant
TenantCAM balanceStatusCAM allocationEstimated CAM paid
Aster Home Goods-1,180Refund tenant29,82031,000
Bluebird Market1,730Bill tenant44,73043,000
Crescent Fitness275Bill tenant37,27537,000
Dahlia Pets-1,150Refund tenant24,85026,000
Elm Cafe790Bill tenant34,79034,000
Fjord Books-1,635Refund tenant22,36524,000
Grove Kids335Bill tenant27,33527,000
Harbor Tech-665Refund tenant27,33528,000
8 rows in the result. Sample data: illustrative figures, not business results.

How it works

How to use the Year-End CAM Reconciliation workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Year-End CAM Reconciliation: questions

How do you do CAM reconciliation?
Export your tenant, expense, and payment data to Excel, then upload the file. The workflow totals 2026 common area expenses, prepares tenant areas, adds estimated payments, and calculates each tenant’s CAM balance. It marks each row as Agrees, Bill tenant, or Refund tenant, with balances within $250 treated as Agrees.
What export should I use?
Use the Excel export that includes tenant names, leased square feet, common area expenses, and estimated CAM payments. If your export uses different column names, you can map them to the fields the workflow needs.
What happens to rows that do not match?
Rows that do not have the needed values, or that do not match the expected rules, stay separate from the reconciled results. You can review them and fix the source data before running the workflow again.
How do I change the rules?
You can change the rules in plain words, for example by changing the year, the dollar threshold, the expense fields, or how you want the balance labeled. Then rerun the workflow on the updated export.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →