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.

Drew Sygit · Answer

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

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.