rent-roll-formatter

Standardize rent roll data into a consistent underwriting template.

Updated Apr 1, 2026
One-click install
npx skills add https://github.com/chibus0368-pixel/om-analyzer --skill rent-roll-formatter-chibus0368-pixel
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: rent-roll-formatter
Source: https://github.com/chibus0368-pixel/om-analyzer/tree/main/skills/rent-roll-formatter
Command: npx skills add https://github.com/chibus0368-pixel/om-analyzer --skill rent-roll-formatter-chibus0368-pixel

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Rent rolls come in many formats and are rarely ready for underwriting. This skill standardizes disparate rent roll data into a single, consistent underwriting template, validates key reconciliations (SF and revenue), and outputs derived analytics to support faster, more reliable decisions.

Core Features & Use Cases

  • Standard mapping: converts structured, semi-structured, and unstructured rent rolls into the standard column schema.
  • Data validation: performs SF, revenue, date, and occupancy checks and surfaces clear validation results.
  • Analytics output: computes metrics like WALT, rollover, concentration, and mark-to-market to support underwriting scenarios.
  • Output formatting: exports a standardized template ready for lender packages and internal modeling.

Quick Start

Format a rent roll from any source into the standard underwriting template and run the built-in 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 roll data from Excel and PDF tables for underwriting?

To standardize rent roll data, map structured Excel/CSV files and semi-structured PDF tables into a consistent underwriting column schema. The process enforces data cleaning and validation checks to ensure output formatting meets lender package requirements.

What is the best way to validate rent roll reconciliation gaps for multifamily and office properties?

Validating rent roll reconciliation gaps involves running SF, revenue, date, and occupancy checks across multifamily and office properties. The validation process surfaces clear summaries and dashboards to detect discrepancies before finalizing underwriting models.

Can I compute WALT and mark-to-market analytics from unstructured rent roll data?

You can compute WALT, rollover, concentration, and mark-to-market analytics from unstructured rent roll data. The skill standardizes the input data first, then automatically generates these derived underwriting metrics to support decision-making.

Does rent roll formatting work with retail and industrial property types?

Rent roll formatting works with retail and industrial properties, alongside multifamily and office assets. It applies field mapping to standard columns and occupancy checks regardless of the specific commercial property type.

How do I export a standardized rent roll template for lender packages?

Exporting a standardized rent roll template involves formatting the cleaned and validated data into a consistent schema. This output template is specifically designed to be ready for lender packages and internal modeling scenarios.