
6 Ways AI Can Make Your Multifamily Budget Review Easier
In this issue · 6 ways
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
- Step 1, pick one property.
- Step 2, open an AI chat window.
- 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.
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.
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.
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.
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.
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.
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.
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.
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
Keep reading



