You open a new deal and the rent roll looks familiar in the worst way. Columns are inconsistent, unit types have three different names, and half the rows need cleanup before you can start. That step is a drag. It is repetitive, easy to mess up, and it pushes back the part that matters, which is underwriting and making a call. Underwriting ~5 min to run Parse Multifamily Rent Roll Vic prompt Use Vic to parse and standardize this multifamily rent roll from Excel and return the two-tab workbook. Purpose Produces consistent data ready for underwriting models and reporting. Replaces 30 minutes of manual cleanup with a 5-minute process. Inputs Rent Roll File Required Include Future Residents Optional Additional Context Optional Outputs A two-tab Excel file: one tab with the rent roll on a standard schema and one tab with unit mix roll-ups including occupancy, average SF, and average rents. Time saved Replaces about 30 minutes of manual cleanup with a ~5 minute run. How it works Upload the rent roll as you got it. Excel, CSV, or PDF all work. If you have a preference for how to treat future residents, flag it. You can also pass context that helps interpret odd labels or notes. Run one command: "Use Vic to parse and standardize this multifamily rent roll from Excel and return the two-tab workbook." Vic reads the file, maps fields to a consistent schema, and returns a clean Excel file. The workbook has two tabs. The first is one row per unit, standardized so it drops into your underwriting model without more reshaping. The second is a unit mix summary with counts, occupancy, average square footage, and average rents by unit type and size range. The value is consistency. Every deal starts from the same structure. Your formulas behave, your comps line up, and your reporting is comparable across assets. If you have had to reconcile why a 1x1 shows up as "A1", "1BR", and "One Bed" in the same file, you know the pain. This also cuts small errors that add up. Manual cleanup leads to off by one mistakes, missed rows, and accidental overwrites. A standardized pass removes that variability and gives you a repeatable starting point. For acquisitions and underwriting teams, the time savings are immediate. What used to take about 30 minutes drops to roughly 5 minutes. More important, those 25 minutes are not scattered across the day. You get a clean file and move on to rent assumptions, loss to lease, and sensitivity work. Asset managers get the same benefit on reporting. When every rent roll lands in the same format, unit mix and occupancy summaries match across properties. Portfolio views become straightforward aggregation instead of a stitching exercise. Keep it simple. Treat the rent roll as raw input, not something to fix by hand. Hand it off, get back a standardized workbook, and spend your time on decisions instead of formatting.