rent-roll-formatter

Standardize and validate rent rolls into a unified underwriting template.

43|13|Updated Mar 17, 2026
One-click install
npx skills add https://github.com/mariourquia/cre-skills-plugin --skill rent-roll-formatter
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: rent-roll-formatter
Source: https://github.com/mariourquia/cre-skills-plugin/tree/main/skills/rent-roll-formatter
Command: npx skills add https://github.com/mariourquia/cre-skills-plugin --skill rent-roll-formatter

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Rent rolls come in varied formats and poor data quality hinders underwriting. This skill standardizes data into a single underwriting template, validates data integrity, and derives analytics to support reliable decision-making.

Core Features & Use Cases

  • Source format detection and parsing across structured, semi-structured, and unstructured rent rolls.
  • Field mapping to standard rent roll columns.
  • Data cleaning, normalization, and validation checks for consistency and accuracy.
  • Derived analytics and occupancy/rollover/concentration metrics to inform risk and pricing.
  • Outputting a standardized rent roll plus a validation summary suitable for lender and investor communications.

Quick Start

Format the rent roll into the standard underwriting template and run the validations.

Frequently Asked Questions about rent-roll-formatter

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I standardize rent rolls for underwriting?

Standardize rent rolls by parsing source formats, mapping fields to a template, and running validation checks for SF reconciliation, revenue consistency, and date accuracy to output reliable underwriting data.

What is rent roll validation and why does it matter?

Rent roll validation checks data integrity by reconciling square footage and revenue, verifying date consistency, testing rent reasonableness, and detecting missing data to ensure reliable underwriting decisions.

Can I clean rent roll data for different property types like office and retail?

Yes, rent roll cleaning applies to multifamily, office, retail, and industrial properties, handling occupied, vacant, month-to-month, and expiring leases with normalization and reconciliation checks.

How do you calculate WALT and concentration metrics from a rent roll?

WALT and concentration metrics are derived analytics calculated from standardized lease data, measuring rollover risk and tenant concentration to inform pricing and risk assessments during underwriting.

What's the best way to handle missing or inconsistent data in a rent roll?

Handle missing or inconsistent rent roll data through automated detection and normalization, applying reconciliation checks for SF and revenue alongside date consistency rules to produce a validated template.

Does rent roll formatting work with unstructured data formats?

Rent roll formatting supports structured, semi-structured, and unstructured formats by detecting the source layout, parsing the data, and mapping it to standardized underwriting columns for validation.