Skip to content

Let's keep in touch

Subscribe to our newsletter for timely insights and actionable tips on your real estate journey.

By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions
Followed Discussions Followed Categories Followed People Followed Locations
General Real Estate Investing
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

User Stats

657
Posts
599
Votes
Justin R.
  • Rental Property Investor
  • San Anselmo
599
Votes |
657
Posts

Using AI to analyze your portfolio, and track important metrics

Justin R.
  • Rental Property Investor
  • San Anselmo
Posted

I’ve been experimenting with using AI alongside QuickBooks Online to improve my annual property reviews.

My current process is:

  • Run a property-level P&L by class in QBO
  • Separate true NOI from interest, principal, depreciation, and CapEx
  • Calculate economic occupancy, cap rate, LTV, DSCR, and actual cash flow
  • Compare property performance over multiple years
  • Identify unusual expenses, accounting errors, and cash-basis timing issues
  • Create a standardized one-page annual report for every property

I started a few years ago with Chap GPT, then moved to Claude, and currently back with Chat GPT. 

AI has been especially useful for turning basic accounting reports into something much more powerful from an owner/investor perspective. More powerful and faster, but not more simple.

I’m curious how others are using AI:

  • What reports do you run monthly or annually?
  • Do you use ChatGPT, Claude, Gemini, Copilot, or another system?
  • Are you uploading QBO reports, rent rolls, loan statements, or property-management reports?
  • What metrics or problems has AI helped you identify?
  • Have you built any repeatable templates, dashboards, or automated workflows?

I’d love to hear what is actually working for other owners

  • Justin R.
  • Most Popular Reply

    User Stats

    262
    Posts
    37
    Votes
    Igor Ganapolsky#1 Wholesaling Contributor
    • Englewood, NJ
    37
    Votes |
    262
    Posts
    Igor Ganapolsky#1 Wholesaling Contributor
    • Englewood, NJ
    Replied

    All of these are great post-acquisition workflows. The AI use case I've found most valuable is on the pre-acquisition side — specifically for tax deed auction underwriting, where the analysis problem is fundamentally different from portfolio management.

    At a county tax deed auction, you might have 16 properties to evaluate simultaneously. You can't inspect any of them inside. You have the assessed value, the minimum bid, and public records — that's it. The margin for error is huge because you're buying sight-unseen with 100% cash.

    Here's how AI changes the auction analysis:

    1. Batch comparable screening: Feed the AI the full auction property list with assessed values and parcel details. Have it pull comparable sales within 0.5 miles for each property simultaneously. What would take a analyst days becomes a structured comparison table in minutes. For Broward County's upcoming Auction #113, I'm ranking all 16 properties by spread (assessed value vs. expected bid range) and flagging which ones have the thickest equity cushion.

    2. Public data extraction: County appraiser records give you land value vs. building value, year built, square footage, zoning, and ownership history. AI can parse those records across multiple parcels and build a standardized underwriting sheet — something that would require manually pulling data from 16 different property appraiser pages.

    3. Risk scoring: Aaron's point about T12 variance analysis applies even more at auction. Since you can't see inside the property, AI can flag risk factors from public data — properties with code enforcement liens, environmental overlays, flood zones, or title clouds that the clerk's database reveals. It's not a replacement for a title search, but it helps you decide which properties deserve deeper due diligence before bidding.

    4. Rehab estimation from exterior data: This is where AI is still rough but improving. Street view images, property age, and neighborhood comparable conditions can give you a rehab range — not a precise estimate, but enough to know whether the spread justifies the risk.

    The key difference from Justin's QBO workflow: you're not analyzing historical performance. You're predicting forward returns on properties where the data is incomplete and the acquisition is irreversible. Alison's point about treating AI like a fast junior analyst is exactly right — but at auction, that junior analyst is working with half the information and the stakes are higher because there's no inspection contingency.

    For anyone doing tax deed auctions, the AI edge isn't in the reporting — it's in the speed of initial screening. You need to know within 48 hours of the auction which 4-5 properties deserve your full attention and which 11 you should pass on. That's where batch AI analysis pays for itself.

    Loading replies...