Retail CAM Reconciliation & Recovery Analyst
Rebuild a retail center’s recoverable expense pool lease by lease and test the underwritten recoveries.
★ 105 on GitHub0 downloads on LenderSkills
Install it in one line — paste a single command into Claude, ChatGPT or Cursor and it writes the skill into your project.
Free, and about thirty seconds: a work email and a six-digit code.
Downloading shares your name, firm, role, and email with Avi Hacker, J.D.. That introduction is what keeps every skill here free.
What this skill does
Rebuild a retail center’s recoverable expense pool lease by lease and test the underwritten recoveries.
When to use it
Use this skill during acquisition diligence, refinancing, annual reconciliation season, or asset review when recovery income needs to be rebuilt from the leases instead of trended from the operating statement, or when a reconciliation is late, unsupported, or disputed. This is educational decision support for U.
What to have ready
- Rent roll with GLA by suite, occupancy dates, and recovery method by tenant; leases, amendments, side letters, and any anchor supplemental agreements
- Recorded REA / OEA / ECR and any operator budget, reconciliation, and audit correspondence
- Operating statements (T-12 and two prior calendar years) at the general ledger account level
- Prior CAM, tax, and insurance reconciliation statements as delivered to tenants, with backup
- Current year budget, monthly estimated billings, and the aged receivable for recovery charges
- Capital ledger with placed-in-service dates, useful lives, and amortization already inside CAM; property management agreement showing the fee base and rate
- …and a few more items the skill will ask for as it goes
How to use it
- Download it with the button above. You'll sign in with a work email — that's how the creator knows who is using their skill.
- Copy the install prompt from the "Run it in Claude" box, and paste it into Claude along with the file. Claude installs the skill, fills in your firm's details where the file has
[BRACKETED]placeholders, and runs a quick test with you. - Then just ask in plain English. Claude picks the skill up on its own when a request matches it. Anything it still needs, it asks you for — it won't invent a number.
"Use the Retail CAM Reconciliation & Recovery Analyst skill — I've got the rent roll with gla by suite, occupancy dates."
What you get back
A structured report covering recovery structure by gla, recoverable pool build, denominator and occupancy, reconciliation test results, recovery ratio and leakage, and issues. You get it as readable analysis plus the underlying data, so it can feed straight into a memo or another skill.
Good to know
- Output quality tracks input quality. A missing figure is flagged as missing — it is never estimated to fill a gap.
- Every draft is a starting point for your own review, not a finished decision.
- Runs anywhere Claude does: the Claude app, Claude Desktop, or Claude Code.
Legal disclaimer
This skill drafts; it does not decide. Its output is not legal, tax, accounting, appraisal, or investment advice, and using it creates no attorney-client, fiduciary, or advisory relationship. Nothing it produces is a commitment to lend or an offer to sell a security. Verify every number, date, citation, and conclusion against the source documents, and have a qualified professional licensed in the relevant jurisdiction review the work before you rely on it or send it to a borrower, investor, counterparty, or regulator. Laws, rates, and market data change. The final work product is yours.
Inside this skill
The actual file you get. Members can read it in full before saving it.
Retail CAM Reconciliation and Recovery Analyst
Rebuild a U.S. retail center's recoverable expense pool lease by lease, test prior CAM reconciliations, and reconcile recovery income to underwriting.
When to Use This Skill
Use this skill during acquisition diligence, refinancing, annual reconciliation season, or asset review when recovery income needs to be rebuilt from the leases instead of trended from the operating statement, or when a reconciliation is late, unsupported, or disputed. This is educational decision support for U.S. retail assets, not legal, tax, investment, accounting, or financing advice. A billing error, a cap interpretation, or an audit claim is a contract question that belongs with counsel and with the property's lease administration record before it is asserted to a tenant.
What You'll Need to Provide
- Rent roll with GLA by suite, occupancy dates, and recovery method by tenant; leases, amendments, side letters, and any anchor supplemental agreements
- Recorded REA / OEA / ECR and any operator budget, reconciliation, and audit correspondence
- Operating statements (T-12 and two prior calendar years) at the general ledger account level
- Prior CAM, tax, and insurance reconciliation statements as delivered to tenants, with backup
- Current year budget, monthly estimated billings, and the aged receivable for recovery charges
- Capital ledger with placed-in-service dates, useful lives, and amortization already inside CAM; property management agreement showing the fee base and rate
- The underwriting model's recovery line, occupancy assumption, and expense pool
- Business question: acquisition underwriting, lender sizing, reconciliation defense, audit response, or recapture
Mission
Reading the full skill counts as a download. The contributor receives your name, company, and email.
Ratings & reviews
No written reviews yet. If you run this on a live file, say how it went. The next lender reading this page is deciding whether to trust it.
Examination record
Run it in Claude
- Copy the install command above
- Paste it into Claude, ChatGPT or Cursor
- It writes the skill in, fills in your firm’s details, and test-runs it with you
Prefer the file? The prompt above is for a package you already downloaded.
Details
More from Avi Hacker, J.D.
Imported from their public repository with attribution. Their other skills, and where to find the original, are on their contributor page.