You just closed on a new acquisition, and the seller’s income statement lands in your inbox. The line items don’t match your Chart of Accounts. “Janitorial” is lumped into “Building Maintenance.” “Parking Income” is buried inside “Other Revenue.” Every property owner formats their P&L differently, and every one of them thinks their way makes sense. You know the mapping needs to happen before the numbers mean anything in your model. But sitting down to manually reclassify 30, 40, 50 line items into your standardized COA, then building the rollup, then double-checking that NOI ties out: that’s 20 minutes per property if you’re fast, and you’ve got six more statements waiting. That’s exactly what this task is built to fix. underwriting 10 min Map Income Statement to Standard Chart of Accounts Map a property income statement to a standardized Chart of Accounts based on property type, calculate NOI, and deliver a formatted Excel file with detailed line-item mappings (user-editable) and a category rollup. Who It’s For CRE professionals who need to reclassify property income statements into a standardized Chart of Accounts for underwriting, reporting, or portfolio analysis. What You Get Back A formatted Excel file with every line item mapped to your COA, a SUMIF-driven category rollup, and a verified NOI calculation. Why It Matters Compress a 20-minute manual mapping exercise into 10 minutes, with built-in error checking and a user-editable output you can adjust on the fly. Task Inputs Property Type Required Select the property type to determine which Chart of Accounts standard is used for mapping. Property Income Statement (Annual) Required The operating statement (income statement) for a property with annual values. Skills Used Excel Document Style Guide Chart of Accounts - Multifamily Chart of Accounts - Office Chart of Accounts - Retail Chart of Accounts - Industrial Chart of Accounts - Hotel Chart of Accounts - General What This Task Does You provide two things: the property type (multifamily, office, retail, industrial, hotel, or other) and the property’s annual income statement. The income statement can be an Excel file or PDF with line-item revenue and expense data. The Real Estate Analyst (with Memory) takes it from there. It reads every line item above NOI in your income statement, maps each one to the appropriate category in your property-type-specific Chart of Accounts, and builds a formatted Excel workbook with two sections: a detailed mapping (every line item with its amount and assigned COA category) and a category rollup driven by SUMIF formulas. It then cross-checks the calculated NOI against the source statement to catch any mapping errors before delivering the file. The whole process takes roughly 10 minutes of your time. The AI does the rest. Who This Task Is For Every property income statement tells the same story, just in a different language. Before you can underwrite, benchmark, or report on a property, you need its financials translated into your Chart of Accounts. That translation step is where time disappears. This task is built for: Acquisitions analysts who need to reclassify seller-provided P&Ls into a standardized format before modeling Asset managers who track operating performance across a portfolio and need consistent line-item categories Underwriters who receive income statements in dozens of different formats and need to normalize them fast Fund accountants and controllers who consolidate property-level financials into a single reporting structure In short: if you already have the income statement, this task gives you the standardized mapping. Why It Matters Every seller, every property manager, every broker formats their income statement a little differently. “R&M” versus “Repairs and Maintenance.” “Miscellaneous Income” versus “Other Revenue.” The labels change, but the underlying economics don’t. Your job is to see through the formatting to the actual numbers, and that starts with mapping everything to a consistent Chart of Accounts. You already know this. Anyone who has underwritten more than a handful of deals has built their own COA crosswalk at some point, probably in a spreadsheet they’ve been copying and tweaking for years. The problem isn’t that you don’t know how to do it. The problem is that it takes 20 minutes per property, and you’ve got a pipeline full of statements that all need the same treatment. So the mapping gets rushed, or it gets skipped on the early-stage deals, or it gets handed to someone who doesn’t know which line items roll into which categories. This task does the mapping in 10 minutes, with property-type-specific COA standards, SUMIF-driven rollups that update automatically when you adjust a category, and a built-in NOI reconciliation that catches errors before they reach