Hand-illustrated budget comparison, review findings, and playbook

NewsletterIssue 02 · November 2026 · 6 min read

6 Ways AI Can Make Your Multifamily Budget Review Easier

In this issue · 6 ways
  1. 1Make a budget dashboard for one property
  2. 2Compare the budget with actuals line by line
  3. 3Compare budgets across the portfolio
  4. 4Put resident fees and vendor contracts side by side
  5. 5Check whether a finding applies to other properties
  6. 6Save what you learned for next budget review

It’s budget season, and I’ve had about 10 budgets come in over the past month. More are on the way for November.

The biggest change for me this year is that I’m using AI to help me throughout the process.

In addition to making the process more efficient and enjoyable (of course!), it’s also helping me catch things I might have missed before—or that would have taken me A LOT longer to find.

I’ve shared six ways it’s helped me below. For each of them, I’ve also shared the exact prompts you can copy and try on your own budgets.

I’m using Claude and Claude Code. The examples below use Claude Chat, but you can adapt these prompts for other AI tools too.

The last one is my favorite so far—and behind it is a mindset that can help you get much more out of AI, no matter what you’re working on.

1. Make a budget dashboard for one property

  1. Step 1, pick one property.
  2. Step 2, open an AI chat window.
  3. Step 3, attach one property’s proposed budget and latest T12. Ask for dashboard (or “Artifact” in Claude), which is an interactive page that opens beside the chat.
Try this prompt

I’ve attached the proposed 2027 budget and latest T12 for [property name]. Create a budget review dashboard with four tabs.

  • Overview — Give me an overview of the budget, including the key numbers and key assumptions. Put budget and actual income, operating expenses, and NOI side by side, and label the periods. Add visualizations where helpful.
  • Budget Detail — Let me expand each category to see the individual accounts.
  • Capital Projects — Show each project, its budget, and its timing if available.
  • Proposed Operational Changes — Pull out changes to staffing, vendor services, resident charges, and other operations described in the budget notes.

Flag missing details and show me where the figures and changes came from.

When it opens, tell AI what you’d move or add. “Put NOI at the top.” “Show expenses per unit.” You can keep going in the same chat until the page works the way you want.

Example of an AI-created budget review dashboard. All property details and figures are fictional.

2. Compare the budget with actuals line by line

We all know the devil is in the details when it comes to the budget. When we review the budget in detail, I always find myself going back and forth between the budget, the notes, T12, and sometimes reforecasts.

This prompt lets AI do the first review pass for you.

Try this prompt

Compare each 2027 budget line with its T12 actuals. Show both amounts and the dollar and percentage change where meaningful. Flag new, missing, or uncertain account matches. Start with the biggest changes to NOI. For each one, show me what the budget notes explain, where to verify it, and what I should ask the property manager.

You could ask it to put the analysis in an Excel. Or if you are a visual person, you could even ask it to build it on top of the dashboard you created with the first prompt. And of course, you can set any criteria you want. Let's say you want to review anything with a change of plus or minus 5%—just tell AI.

Even better, if you've been keeping operational notes or have a property knowledge base (something I talked about in my previous newsletter), feed that to AI too. That gives it more context about the property to work with, so it can do a much better and grounded review for you.

3. Compare budgets across the portfolio

Once you’re happy with the review for one property, you can repeat the process for the others. Just give AI each property’s information and ask it to do the same thing.

But we don’t have to stop there. With AI’s help, we can bring those budgets together in one comparison file and look at them side by side across the portfolio.

If you work with multiple property management companies, they’ll likely categorize things a little differently. AI can help you standardize those categories so you’re comparing apples to apples.

Try this prompt

Now I want to compare the portfolio. Show one column per property plus a portfolio total, with annual dollars and annual dollars per unit. Group expenses into payroll, repairs and maintenance, contract services, marketing, utilities, management fees, and non-controllables. Show property taxes and insurance as separate lines within non-controllables. Keep the original account names in a mapping table, flag uncertain matches, and make sure the total ties.

Illustrative portfolio comparison with annual budgets and a bar chart of operating costs per unit. All properties and figures are fictional.

4. Put resident fees and vendor contracts side by side

This is where AI helped me catch things I've missed before.

By putting together the standard residents' fees and vendor contracts, I created a comparison across the portfolio that lists out every single resident's charges and how much we pay each vendor. This gave me a really clear view, and I actually took the opportunity to standardize the fees across the portfolio in the same geography.

It also ensures that if one property is using a very expensive vendor, it stands out in this comparison view.

Try this prompt

Add a Resident Fees tab and a Contract Services tab, each with one column per property. For fees, show the rate, how often it’s charged, and annual budgeted income where available. For contracts, show annual cost and any details on scope or frequency. Distinguish a confirmed zero from a missing line. Flag differences worth checking and tell me what to ask for.

Illustrative resident-fee and vendor-contract comparison across three properties, with fee differences and a higher landscaping cost highlighted. All properties and figures are fictional.

5. Check whether a finding applies to other properties

When I spot something at one property, I tell AI what caught my eye and ask it to look for the same thing elsewhere.

This simple prompt has saved me so much time going back and forth between different properties' budgets, and also ensures consistency.

Try this prompt

I noticed [what you saw] at [property]. Check the other properties for the same pattern and point out any differences that matter. Add a short comment to each relevant line in the dashboard with what you found, the source, and any question for the property manager. Keep my existing notes and label open questions separately from decisions.

6. Save what you learned for next budget review

By the end of the review, we’ve made a lot of little calls, and put in a lot of our own judgements. How I want to compare across portfolios? What kind of expense breakdown I want to see?

Ask AI to turn the conversation into a short Budget Review Playbook. Then keep it somewhere you can easily find it: email it to yourself, save it to your laptop, or add it to a Project called “Budget Review” in your favorite AI tool. That way, next year you can pick up where you left off and build on the work you’ve already done.

Turn this review into a playbook I can use for next budget review. Capture the dashboard layout, the account mapping I approved, and the checks I’d want to run again. Record the decisions we made, why we made them, and what’s still open. End with a short list of what I should upload and verify next time.

That’s what I’d like to keep building on: giving AI more of the repetitive, tedious work, so I have more time for the questions and decisions that need my judgment. And as I keep refining the playbook, I’m building a budget review process I can use again and keep improving.

Talk soon,

Daisy

Daisy Wan

Daisy Wan

Multifamily Owner & Operator · Asset Manager

My work spans multifamily asset management, investing, and Kenli. I write to make the lessons from that work more durable and reusable.

About Daisy →

Keep reading