You know the drill. A folder of PDFs, each with its own quirks, and a blank spreadsheet that has to turn into a clean rent roll. You copy dates, check rent steps, confirm expense structures, and hope you did not miss an option or a deposit. The hour adds up, and the risk hides in small details. One wrong term date or a missed escalation can flow through underwriting and reporting. This task replaces the manual build with a rent roll you can rely on. Underwriting ~10 min to run Build Commercial Rent Roll from Leases Vic prompt Use Vic to build a commercial rent roll from the leases for my property. Purpose A clean rent roll is the foundation for underwriting, valuations, and cash-flow models. The task reduces the time to compile and check the data from roughly 60 minutes to about 10 minutes. Inputs Commercial Leases Required As Of Date Optional Building Sf Or Suite Map Optional Outputs A single-worksheet Excel file with one row per suite or tenant, a bold totals row, and an on-sheet summary block. Every figure traces back to the source leases. Time saved Turns roughly an hour of manual work into about ten minutes. How it works You hand Vic your commercial leases. Include an as of date if you want the roll fixed to a point in time, and a building SF or suite map if you have one. Then run: "Use Vic to build a commercial rent roll from the leases for my property." Vic reads each lease and puts the key fields into one worksheet. Each row is a suite or tenant. You get leased square footage, term start and end, in place base rent, expense responsibility, escalation structure, options, and security deposit. The sheet uses a consistent Excel format so it drops into your model without cleanup. At the bottom, a bold totals row lets you check rollups fast. On the same sheet, a summary block shows occupancy, total base rent, weighted average lease term, and expirations by year. You can read the health of the roll without building extra pivots or tabs. Traceability is built in. Every figure ties back to the source leases. If something looks off, go straight to the document and confirm. That matters when you are defending numbers in an investment memo or answering a lender. The output is a single worksheet Excel file. No extra tabs, no formatting surprises. It is ready for underwriting, valuation work, or a quick send to a broker or asset manager who needs a current roll. The time savings is simple. What usually takes about an hour of reading, typing, and checking drops to about ten minutes. The bigger gain is consistency. Each lease is handled the same way, and the summary metrics are calculated on the same basis every time. There is also a practical upside when you are working across assets. Different teams and brokers format rent rolls in their own way. Starting from the leases gives you a clean baseline that is not shaped by someone else’s template or shortcuts. This is a straightforward task with a clear output. Give Vic the leases and get back a complete rent roll with tenant rows, totals, and a summary block. Spend your time on underwriting decisions, not data entry.