How I structure P&L reporting for a 5-property portfolio

Question

I do monthly financial reporting for small real estate portfolios, and one of the most common problems I see is landlords mixing operating expenses in ways that make it impossible to analyze performance.

Here's the chart of accounts structure I use — it works for 2 properties or 20:

Income accounts: Rental Income (1100), Other Rental Income (1110), Late Fees (1120)

Operating expenses: Repairs & Maintenance (2100), Property Management Fees (2400), Property Taxes (2500), Property Insurance (2510), Bank Fees (2600)

Once you have clean data in this structure, you can run: monthly P&L by property, consolidated portfolio view, YTD totals, and a T12 rolling period — which is what lenders actually want to see.

One thing worth noting: property taxes and insurance should be accrued monthly even if paid annually. Paying ,400 in taxes in one month wrecks your NOI for that month if you don't smooth it.

Any questions on how to set this up — happy to help.

Stephen Delahoussaye · Answer

Solid framework Fatima. Clean chart of accounts is one of those things that separates owners who actually understand their portfolio performance from those who are just guessing.

From the PM side, I would add a couple of line items that we track for our owners in Nashville that have been really valuable.

First, break out Turnover Costs as its own category separate from Repairs and Maintenance. Turns are a major expense that most owners lump in with regular maintenance, but they behave very differently. Regular maintenance is somewhat predictable and ongoing. Turnovers are lumpy, expensive, and directly tied to tenant retention. If you cant see turnover costs separately you cant measure whether your screening is getting better or worse over time.

Second, add a Vacancy Loss line. Not just tracking days vacant, but the actual dollar amount of rent lost. When an owner sees that a 30 day vacancy on a $1,800 unit cost them $1,800 in lost rent plus $3,500 in turnover costs, it changes the conversation about renewal incentives and tenant retention strategies real fast.

Third, CapEx reserves. Even if you are not funding a separate account, tracking your capital expenditure contributions and spend gives you a much clearer picture of true cash flow vs what you are actually keeping.

The T12 rolling period is exactly right for lender conversations. We send our owners monthly P&L by property plus a portfolio rollup and it makes refinancing and acquisition conversations so much smoother when the numbers are already clean.

Drew Sygit · Answer

You should check out the NARPM Standard Chart of Accounts and start using that:)

Michele Fischer · Answer

I also split yard maintenance from regular maintenance since only some propeties incur that.  Same for utilities.  There are turnover utilities and utilitites we include in rent.  And eviction legal costs are good to have seperated as well.

Diego Sanchez-Ochoa · Answer

Great framework Fatima. The chart of accounts structure you laid out is exactly the right foundation and a lot of landlords skip this step entirely.

One thing worth adding is that QuickBooks Online Plus or Advanced makes this structure easy to maintain on an ongoing basis. You can set up each income and expense category exactly as you described, then use the Class feature to track everything by property automatically. Once it is built correctly, your monthly P&L by property, portfolio rollup, and YTD totals generate in seconds rather than hours of manual spreadsheet work.

The accrual point you made about property taxes and insurance is especially important. Most landlords pay these annually but spreading them across 12 months gives a much more accurate picture of true monthly performance.

How I structure P&L reporting for a 5-property portfolio

Most Popular Reply