You know the drill. A T12 shows up with messy labels, mixed casing, and a few made up categories that do not fit your chart of accounts. You spend half an hour reclassing lines so the numbers line up. The work is simple, but it is easy to break. Miss one line or roll something up wrong and your NOI tie fails. Then you are stuck chasing small errors instead of pushing the deal ahead. Underwriting ~5 min to run Map Operating Statements to Chart of Accounts Vic prompt Use Vic to map this operating statement to the standard chart of accounts and return the Excel workbook. Purpose Produces consistent COA-mapped statements ready for DCF or portfolio models without manual reclassification. A task that takes 30 minutes manually completes in about 5 minutes. Inputs Operating Statement Required Property Type Optional Custom Chart Of Accounts Optional Additional Context Optional Outputs An Excel workbook containing the full line-item mapping and a category-level rollup that reconciles to NOI for every period in the statement. Time saved Turns roughly 30 minutes of manual work into about 5 minutes. How it works Upload a T12 or operating statement. You can include a property type, your chart of accounts, and any notes that explain naming quirks. Then run: "Use Vic to map this operating statement to the standard chart of accounts and return the Excel workbook." The task assigns each line item to a COA category for that property type or your custom schema. It returns an Excel workbook with the full line level mapping and a category rollup. The rollup ties to reported NOI for every period, so you can confirm the mapping before it goes into a model. The output is set up for CRE work. Numbers are consistent, categories are clean, and the structure drops into a DCF or portfolio model without another pass. If you provide a custom COA, the mapping follows it so the file fits your templates. This kind of task should not pull attention from underwriting judgment. It is repetitive and easy to get wrong when you are moving fast. Automating the mapping gives you the same result each time and keeps your focus on assumptions, not labels. In practice, this cuts about 30 minutes of manual work to a run that finishes in about 5 minutes. More important, it removes the quiet risk of a broken NOI tie. You get a workbook with the detailed mapping and a rollup that reconciles, which is what you need to trust the numbers. Use it on new deals, on lender packages with odd categories, or when you are standardizing a portfolio for reporting. The input is simple, and the output matches what your model expects.