Rent Roll Formatter
Standardizes rent roll data from any source format into a consistent underwriting template, validates data integrity (SF reconciliation, revenue reconciliation, date consistency, rent reasonableness), and calculates derived analytics (WALT, rollover, concentration, mark-to-market).
What this skill does
Rent Roll Formatter is an A.CRE Intelligence Hub skill that gives your AI agent the analyst-grade workflow a senior commercial real estate professional would run. Standardizes rent roll data from any source format into a consistent underwriting template, validates data integrity (SF reconciliation, revenue reconciliation, date consistency, rent reasonableness), and calculates derived analytics (WALT, rollover, concentration, mark-to-market). Standardizes rent roll data from any source format into a consistent underwriting template, validates data integrity SF reconciliation, revenue reconciliation, date consistency, rent reasonableness , and calculates derived analytics WALT, rollover, concentration, mark-to-market . Activate it inside ChatGPT, Claude, Manus, or OpenClaw by saying something like "Use the Rent Roll Formatter skill" — the Hub routes the request to this skill and the underlying primary-source CRE data feeds backends automatically. Built and maintained by Mario Urquia, with live primary-source data so the numbers your AI returns are the numbers a real CRE analyst would use.
How you'll use it
Say something like this to your AI agent in the Hub, Claude, or ChatGPT to activate this skill.
Skill activation rules
Detailed routing logic, prompts the skill responds to, and operational guardrails as documented by the author.
Standardizes rent roll data from any source format into a consistent underwriting template, validates data integrity (SF reconciliation, revenue reconciliation, date consistency, rent reasonableness), and calculates derived analytics (WALT, rollover, concentration, mark-to-market).
What's inside
Rent Roll Formatter
You are a rent roll standardization and validation engine. Given rent roll data in any format (PDF, Excel, CSV, text), you map fields to a standard underwriting template, clean and normalize data, validate integrity through multiple reconciliation checks,…
Show full previewShow less
Rent Roll Formatter
You are a rent roll standardization and validation engine. Given rent roll data in any format (PDF, Excel, CSV, text), you map fields to a standard underwriting template, clean and normalize data, validate integrity through multiple reconciliation checks, and calculate derived analytics. This is the single most repetitive task in acquisitions -- every deal starts here. The real value is in validation: catching the rent roll that does not reconcile to reported revenue or the expired lease still showing as occupied.
When to Activate
Trigger on any of these signals:
- Explicit: "format this rent roll", "standardize rent roll", "clean up this rent roll data", "rent roll for underwriting"
- Implicit: user provides rent roll data in any format; user asks about tenant occupancy data; user mentions a broker package or OM with rent data
- Context-driven: new deal inflow, refinancing (lender submission), portfolio review for comparison
Full instructions and any reference files ship in the .skill bundle.
rent-roll-formatter/
├── SKILL.md # Required: instructions + metadata
└── references/ # Optional: documentation
├── standard-columns.yaml # 13.2 KB
└── validation-rules.md # 9.4 KB
How to run it
Not in the Hub? Download the .skill bundle above and follow the A.CRE skills install guide → to load it into Claude Desktop, ChatGPT, Cursor, or any other agent that supports skills.
Already in the Hub. If you're an AI.Edge Pro or A.CRE Accelerator member, this skill is bundled into the A.CRE Intelligence Hub direct connector (MCP server) — just ask your agent.