Skip to content
CRE Agents LogoCRE Agents
All Posts
Asset Management

One workbook that shows how your asset is really doing

Stop stitching together T12s, rent rolls, and debt metrics each month and get a clean dashboard with comparisons and a clear read.

VicVic
February 18, 20263 min read
One workbook that shows how your asset is really doing

Month end turns into a scavenger hunt. You pull a T12, reconcile a rent roll, paste in budget, then try to remember where you left last period's numbers. By the time the deck is stitched together, you have spent more time assembling than thinking.

The friction is not the math. It is the repetition and the risk of small inconsistencies across tabs. This task cuts the assembly work and gives you one place to read the asset.

Asset Management
~10 min to run
Build Asset Management Dashboard
Vic prompt
Use Vic to build an asset management dashboard for one asset or a full portfolio using the latest T12 and rent roll.
Purpose
Gives a current view of asset or portfolio health without manual data pulls each period and cuts the typical 90-minute analyst effort to about 10 minutes.
Inputs
Performance InputsRequired
Portfolio ScopeOptional
PeriodOptional
Output FormatOptional
Outputs
An Excel workbook with a header KPI strip and separate sections for operations, leasing, capital, and debt, each with budget and prior-period comparisons, plus a portfolio summary tab when scope covers more than one asset and a concise health narrative.
Time saved
Cuts the typical 90 minute analyst effort to about 10 minutes.

How it works

Hand Vic your performance inputs, usually a current T12 and rent roll. Point it at one asset or include a portfolio if you want a roll up. If you care about a specific period or output format, say so. Then run: "Use Vic to build an asset management dashboard for one asset or a full portfolio using the latest T12 and rent roll."

The output is a single Excel workbook that is easy to move through. At the top is a KPI strip with key numbers and comparisons to budget and the prior period. Below that, the workbook splits into operations, leasing, capital, and debt. Each section follows the same pattern: current results, budget, prior period, with formatting that reads like an institutional report.

On the operations side, you get rolling occupancy and economic occupancy, plus NOI against budget and last period. The leasing section tracks status and rollover so you can see what is coming due and what has moved. Capital and reserves sit in the same file, so you do not have to reconcile separate schedules. The debt section includes DSCR, debt yield, LTV, and maturity, which keeps the capital stack next to property performance.

If you include more than one asset, the workbook adds a portfolio summary tab with a roll up row. This is where manual builds often break. Consistent mapping to a standardized chart of accounts and CRE number formatting keeps the roll up clean without hand edits.

There is also a short written health read. It calls out items that are off plan based on the comparisons already in the file. It is concise. You can drop it into a monthly report or use it as a starting point before an asset call.

The value is not a flashy chart. It is a repeatable structure that lines up operations, leasing, capital, and debt in one place, every period, without rework. You spend time on variance and decisions instead of hunting for numbers.

For teams that run recurring reporting, the time change is real. Work that took about 90 minutes of analyst time comes back in roughly 10 minutes. More important, the output is consistent month to month, which makes trends easier to see and conversations easier to have.

If you have ever double checked whether a variance is real or just a paste error, this fixes it. One workbook. Same structure every time. Clear comparisons and a direct read on what needs attention.

Vic

Written by

Vic

Vic is the seasoned CRE pro behind CRE Agents. He gives the AI you already use (Claude, ChatGPT, and more) the methods and data to do commercial real estate work well.