How to track rental property P&L without losing your mind

By Elbert Ballo · QuickBooks Certified ProAdvisor & real estate investor

If you own more than one rental, you've probably done this: opened your bank app, scrolled through a mess of deposits and withdrawals, and tried to guess which property is actually making money. You can get a rough number that way. You can't run a portfolio on it.

Here's how to actually track profit and loss per property — without building a spreadsheet you'll abandon in six weeks.

Start with one account per property, or a clean way to split them

The single biggest reason investor books turn into a mess is mixing multiple properties through one bank account. If you can, give each property its own checking account. If you can't, every transaction needs a property tag from day one, applied consistently. Retrofitting six months of unlabeled transactions later is the actual mind-losing part.

Separate CapEx from operating expenses immediately

A new roof and a plumbing repair both leave your bank account the same way. They shouldn't land in the same bucket. Operating expenses — repairs, management fees, insurance, utilities — hit your P&L this year. Capital expenditures — roof, HVAC replacement, major renovation — get capitalized and depreciated. Your CPA needs them separated, not merged into "repairs and maintenance" where they'll get missed or misclassified at tax time. See where exactly that line falls if you're unsure on a specific expense.

Track cash flow and P&L as two different numbers

P&L tells you if the property is profitable on paper. Cash flow tells you what actually hit your bank account, after debt service, escrow, and reserves. A property can show a paper profit and still bleed cash if your mortgage principal payment isn't in the P&L — it isn't; principal is a balance sheet item, not an expense. Investors who only look at P&L are often more cash-strapped than their numbers suggest. Check both every month.

Reconcile monthly, not at tax time

Waiting until January to reconcile a year of transactions means reconstructing your business from memory and bank statements. Categorization mistakes compound — a security deposit booked as income in March throws off every report until someone catches it. Monthly reconciliation catches the error in the month it happened, when you still remember what it was.

What this actually buys you

None of this is complicated in theory. It's tedious in practice, which is why most investors either do it inconsistently or stop entirely. Done right, per-property tracking tells you which units to keep, which to sell, and whether that fourth property you're eyeing actually pencils out — using your real numbers instead of a back-of-napkin guess.

This is exactly what I do for rental property owners across Orange County — per-property books, closed by the 15th, with CapEx separated for your CPA automatically. See the full real estate investor bookkeeping service, or if you want to see what that looks like for your portfolio, the button below books 30 minutes on my calendar.