REIT Coverage

Step 1: Define your REIT universe

0 tickers in coverage
No tickers added yet. Add REIT tickers above.
Saved to browser

RealPage Data Reconciliation

Step 2: Basic Cleaning & MSA Mapping

Raw RealPage Data msaname, erpu, city... Name Translator Dallas-FW Dallas RealPage → GS 79 Market ID Lookup Table Dallas 15 Market Name → ID PROCESSING PIPELINE Remove Invalid Empty & Null ERPU Translate Names → gs_79_market # Assign ID → gs_market_id Complete! Ready to export msaname gs_79_market gs_market_id • • • Mapped 95% Review 5% Property Data Name Translation ID Lookup Output Data Flow
Raw RealPage List
Drop raw-RealPage-list.csv here or click to browse
-
GS-RealPage Mapping List
Drop gs-RealPage-mapping-list.csv here or click to browse
-
All GS Markets
Drop gs-markets.csv here or click to browse
-
Processing data...

Processing Results

-
Original Rows
-
Rows Removed
-
MSAs Mapped
-
MSAs Unmapped
Human-in-the-Loop: Map Missing MSAs
0 unmapped
Resolved: 0
Remaining: 0
Preview (first 10 rows)

CompID Matching

Step 3: Reconcile properties between RealPage and Previous Quarter

RealPage Mapped 📍 The District @ Scotts... 📍 Camden Lake Eola • • • From Step 2 X Previous Quarter Property List District Scottsdale 1234 Camden Lake Eola 5678 • • • With CompIDs MATCHING ENGINE 🏢 Filter by REIT MAA, CPT, EQR... Fuzzy Match Name similarity District @ Scottsdale District Scottsdale 1234 Camden Lake Eola Camden Lake Eola 5678 🔍 New property - needs review ✓ Matched Records District Scottsdale 1234 Camden Lake Eola 5678 • • • ⚠ Needs Review 3 new properties → HIL Matched 92% Review 8% RealPage Data Previous Quarter Property List Fuzzy Matching Reconciled Output Human Review Data Flow
RealPage Mapped GS79 File
Drop CSV from Step 2 here or click to browse
-
Previous Quarter Excel
Drop previous Quarter Excel here
-
Matching CompIDs...

CompID Matching Results

-
RealPage REIT Properties
-
Previous Quarter Records
-
Matched OK
-
Issues to Resolve
Human-in-the-Loop: Reconcile CompID Mismatches
0 issues
Resolved: 0
Remaining: 0
Preview - Reconciled Properties (first 10 rows)

Export to Excel

Step 4: Export Reconciled RealPage Data to Excel Format

Reconciled CSV District Scottsdale 1234 Camden Lake Eola 5678 Avalon Irvine 9012 • • • 150+ rows From Step 3 EXPORT ENGINE Parse CSV Read 23 columns (A-W) Create Excel Single sheet output RealPage_export.xlsx A B C ... W X Dist... MAA PHX ... MKT 123 • • • 150+ rows RealPage Input Download Reconciled Data CSV Parsing Excel Export Columns A-X (23 fields)
RealPage Reconciled CSV
Drop reconciled CSV from Step 3 here or click to browse
-
Exporting data to Excel...

Excel Export Results

-
Source CSV Rows
-
Rows Exported
-
Sheet Name
Preview - Exported Data (first 10 rows)

Green Street RealPage Reconciliation Tool