How do you handle per-unit expense reporting?
Member since 2026 · 4 posts · 4 votes
How do you handle per-unit expense reporting?
Most Popular Reply
Investor · Chicago · Member since 2026 · 17 posts · 11 votes
4wI self-manage two Chicago rentals, so there's no PM software in the middle and I rebuild it all in my custom P&L, one per property, every month.
The mortgage takes the most work. My payment hits as a single line, so I split it into principal, interest, and escrow before anything else. Without that the property looks more expensive than it is and the equity number drifts. I track the escrow balance separately too, since a shortage shows up there months before it changes what I pay.
In general, I use Monarch for transactions and expense tracking and then I import that data into my P&L tool for KPI's and analysis.
29 Replies
- 1moAdam BartomeoBusiness MemberReal Estate Broker · Cape Coral, FL · Member since 2015 · 2k+ posts · 1k+ votes
Appfolio tracks all of the unit expenses for multifamily- maintenance, utilities, etc. If there are overhead expenses than you would have to divide those out - taxes, insurance, lawn, etc.
Bartomeo Property Management4.7150 Reviews - Investor · Chicago · Member since 2026 · 17 posts · 11 votes4w
I self-manage two Chicago rentals, so there's no PM software in the middle and I rebuild it all in my custom P&L, one per property, every month.
The mortgage takes the most work. My payment hits as a single line, so I split it into principal, interest, and escrow before anything else. Without that the property looks more expensive than it is and the equity number drifts. I track the escrow balance separately too, since a shortage shows up there months before it changes what I pay.
In general, I use Monarch for transactions and expense tracking and then I import that data into my P&L tool for KPI's and analysis.- 3wSri S.Business MemberDublin, CA · Member since 2024 · 40 posts · 19 votes
Quote from @Joseph Zimmerman:
I self-manage two Chicago rentals, so there's no PM software in the middle and I rebuild it all in my custom P&L, one per property, every month.
The mortgage takes the most work. My payment hits as a single line, so I split it into principal, interest, and escrow before anything else. Without that the property looks more expensive than it is and the equity number drifts. I track the escrow balance separately too, since a shortage shows up there months before it changes what I pay.
In general, I use Monarch for transactions and expense tracking and then I import that data into my P&L tool for KPI's and analysis.
Joseph, the escrow point is the sharpest thing in this thread and I think it gets overlooked. A shortage showing up in the balance months before it changes your payment is exactly the kind of thing you only catch if you're looking, and most people aren't looking.
The split itself is the part I'd want automated. One ACH hits the account, and until it's broken into principal, interest, and escrow the property P&L overstates your expenses and the equity line drifts. Doing that by hand every month for two properties is annoying. Doing it for eight is where people give up and stop keeping books at all.
Full disclosure, I'm building a tool in this space (Revenli), and this is one of the things it handles. It takes the loan terms, builds the amortization schedule, and splits the payment automatically each month, then tracks the escrow balance so a developing shortage surfaces as a flag rather than a surprise. Not trying to pitch you on switching off Monarch. I'm mostly curious whether the split or the escrow tracking is the part that actually costs you time, because I've been assuming it's the split and your reply makes me think it might be the escrow. - Investor · Chicago · Member since 2026 · 17 posts · 11 votes3wThe split, by a wide margin. My escrow balance is one number I carry forward each month, so watching it costs me almost nothing. I rebuild the principal, interest and escrow breakdown for both properties every month, and that's the recurring work. Monarch gives me the total. The pieces come off the servicer statement, so it's two sources every time.
Quote from @Sri S.:
Quote from @Joseph Zimmerman:
I self-manage two Chicago rentals, so there's no PM software in the middle and I rebuild it all in my custom P&L, one per property, every month.
The mortgage takes the most work. My payment hits as a single line, so I split it into principal, interest, and escrow before anything else. Without that the property looks more expensive than it is and the equity number drifts. I track the escrow balance separately too, since a shortage shows up there months before it changes what I pay.
In general, I use Monarch for transactions and expense tracking and then I import that data into my P&L tool for KPI's and analysis.
Joseph, the escrow point is the sharpest thing in this thread and I think it gets overlooked. A shortage showing up in the balance months before it changes your payment is exactly the kind of thing you only catch if you're looking, and most people aren't looking.
The split itself is the part I'd want automated. One ACH hits the account, and until it's broken into principal, interest, and escrow the property P&L overstates your expenses and the equity line drifts. Doing that by hand every month for two properties is annoying. Doing it for eight is where people give up and stop keeping books at all.
Full disclosure, I'm building a tool in this space (Revenli), and this is one of the things it handles. It takes the loan terms, builds the amortization schedule, and splits the payment automatically each month, then tracks the escrow balance so a developing shortage surfaces as a flag rather than a surprise. Not trying to pitch you on switching off Monarch. I'm mostly curious whether the split or the escrow tracking is the part that actually costs you time, because I've been assuming it's the split and your reply makes me think it might be the escrow.
The escrow pays off differently. A shortage sits in that balance for months before the servicer re-runs the analysis and changes my payment, so a small amount of attention buys a long warning. At eight properties, I'd automate the split first.
- Member since 2026 · 73 posts · 25 votes3w
Adam, I think you’re right, and that distinction between direct unit expenses and shared overhead is important.
The larger platforms like AppFolio and Buildium are designed to handle that kind of multi-unit reporting and allocation because they’re built around professional property management and owner reporting. For a larger multifamily portfolio, that makes a lot of sense.
For a smaller self-managing portfolio, I think the need is a little different. I want to track income and expenses by property, see how each property is performing, and still be able to look at the portfolio as a whole without needing all the infrastructure of a larger PM platform.
I use Easy Rental Records for my own properties for that, and if I want to manipulate the data further or need it for my CPA, I export it to Excel.
So I do think there’s a gap—but maybe it’s less about whether the larger platforms can produce the reports and more about how much software you need to get the financial visibility you actually use.
I’d be curious how often your owners ask for true per-unit reporting versus property-level reporting.
- Member since 2026 · 4 posts · 4 votes3w
Good question - I don't manage properties myself, this was more me trying to gauge whether per-unit reporting is a real widespread pain point or something the bigger platforms already handle well enough. Your point about needing less infrastructure for a smaller portfolio makes sense - sounds like the actual gap might be less about missing features and more about most tools being sized for a bigger operation than a lot of self-managers actually run.
- 3wRyan SpathBusiness MemberReal Estate Agent · Boise, ID · Member since 2017 · 557 posts · 376 votes
WE self manage small multi units. Excel sheets work just fine for what we are wanting to do. We try and "KISS" keep it super simple
- Investor · Las Vegas, NV · Member since 2013 · 8k+ posts · 10k+ votes3w
Try something small and simple like quicken. It can tell you total expenses, general expenses, and property specific expenses. It can break them down by property, by time period, and by expense or income type.
Of course it will also compare it to your budget, last year or any other time period you can think of. It will download and enter automated transactions from bank accounts and credit cards. I only have a dozen properties, but it doesn't take an hour per month even with 10+ HOA's.
- 3wSri S.Business MemberDublin, CA · Member since 2024 · 40 posts · 19 votes
Quote from @Bill B.:
Try something small and simple like quicken. It can tell you total expenses, general expenses, and property specific expenses. It can break them down by property, by time period, and by expense or income type.
Of course it will also compare it to your budget, last year or any other time period you can think of. It will download and enter automated transactions from bank accounts and credit cards. I only have a dozen properties, but it doesn't take an hour per month even with 10+ HOA's.
Bill, that's a useful data point and it cuts against the premise of my question, which I appreciate.
Twelve properties plus HOAs in under an hour a month is faster than almost anyone else I've talked to. What I'm trying to figure out is whether that's Quicken doing the work or whether it's you having built good habits over a long time, because those produce very different advice for someone starting out.
Two specifics if you don't mind. How does the mortgage payment get split into principal, interest, and escrow, and do you reconcile that against the amortization schedule or let it ride? And when you hand things to your CPA at tax time, does the Quicken output go across cleanly to Schedule E per property, or is there a step in between?
- Attorney · 10451 Mill Run Cir #755 Owings Mills, MD 21117 · Member since 2024 · 340 posts · 124 votes3w
Quote from @Aravind Sanjeevi:
Curious how other property managers here handle reporting — specifically things like per-unit expense tracking, or seeing rent income broken out by month in a way that's actually usable for owner statements. Do you rely on what your PM software (Buildium, AppFolio, etc.) gives you natively, or do you end up rebuilding reports yourself in Excel? Trying to understand how big a gap this actually is for people, or whether it's a non-issue.
@Aravind Sanjeevi, from owning and working around rental property, I’ve learned that I care less about having a perfect report and more about whether I can quickly see what needs my attention.
For me, I want to be able to look at a property and answer a few simple questions. Which unit is costing me more than the others? Are repairs starting to repeat? Is one unit turning over more often? Is the rent still covering what that unit is really costing me?
I also do not think every expense needs to be forced down to the unit level. Things like taxes, insurance, landscaping, or work on a shared area may make more sense at the property level.
What matters to me is keeping the reporting consistent. If the same types of expenses are tracked the same way every month, it becomes much easier to see when something changes.
That is where I think the real value is. The report should help the owner make a decision, not just give them more numbers to look at.
- Member since 2026 · 4 posts · 4 votes3w
This is a really useful reframe, thanks. Sounds like the real value isn't more granularity but consistency - and a report that points you to what needs attention rather than just handing you more numbers. That's a distinction I hadn't thought about enough.
- 3wSri S.Business MemberDublin, CA · Member since 2024 · 40 posts · 19 votes
Quote from @Diana Khan:
Quote from @Aravind Sanjeevi:
Curious how other property managers here handle reporting — specifically things like per-unit expense tracking, or seeing rent income broken out by month in a way that's actually usable for owner statements. Do you rely on what your PM software (Buildium, AppFolio, etc.) gives you natively, or do you end up rebuilding reports yourself in Excel? Trying to understand how big a gap this actually is for people, or whether it's a non-issue.
@Aravind Sanjeevi, from owning and working around rental property, I’ve learned that I care less about having a perfect report and more about whether I can quickly see what needs my attention.
For me, I want to be able to look at a property and answer a few simple questions. Which unit is costing me more than the others? Are repairs starting to repeat? Is one unit turning over more often? Is the rent still covering what that unit is really costing me?
I also do not think every expense needs to be forced down to the unit level. Things like taxes, insurance, landscaping, or work on a shared area may make more sense at the property level.
What matters to me is keeping the reporting consistent. If the same types of expenses are tracked the same way every month, it becomes much easier to see when something changes.
That is where I think the real value is. The report should help the owner make a decision, not just give them more numbers to look at.
Diana, coming back to this because your reply has been rattling around since I read it.
Your four questions are the part I keep returning to. Which unit is costing more than the others, are repairs starting to repeat, is one unit turning over more often, is the rent still covering what the unit actually costs. None of those require allocating every expense down to the unit. They require consistent categorization and something watching for change.
Disclosure so it's on the table: I'm building Revenli, which is aimed at exactly that. Rather than producing a per-unit P&L, we watch the transaction stream and surface the exceptions. The same vendor at the same unit three times in eight months. A turnover that cost noticeably more than the last one. Rent that didn't arrive on the day it normally arrives.
The piece I'm least confident about is turnover, because no single transaction announces itself as one. You have to infer it from a deposit going back out, a gap in the rent series, a cluster of cleaning and paint charges in the same two weeks. That inference will sometimes be wrong. I'd be curious whether you'd want the system to flag it and ask you to confirm, or whether you'd rather just tell it a unit turned and skip the guessing.
- 3wAaron ZimmermanBusiness MemberAccountant · Chicago, IL · Member since 2018 · 2k+ posts · 1k+ votes
For mine, I don't track expenses by unit. I typically know which unit is the biggest headache
Brick House CPAs53 Reviews - Investor · Las Vegas, NV · Member since 2013 · 8k+ posts · 10k+ votes3w
It does all the schedule E work for you or property.
You enter the loan balance, # of payments and interest rate plus any extras like insurance/hoa/property taxes. So each loan payment is automatically and correctly allocated and matches the bank’s amortization table, even if you make extra payments.
- 3wMichael TempelBusiness MemberMN · Member since 2026 · 5 posts · 0 votesI know this sounds crazy, but sometimes I import reports into AI and ask for this exact info then any ways to improve performance of what KPI should I include or remove. I have been able to build some really great reporting this way. I also use it to underwrite the properties even 300 unit deals.
ROI Multifamily- 3wSri S.Business MemberDublin, CA · Member since 2024 · 40 posts · 19 votes
Quote from @Michael Tempel:
I know this sounds crazy, but sometimes I import reports into AI and ask for this exact info then any ways to improve performance of what KPI should I include or remove. I have been able to build some really great reporting this way. I also use it to underwrite the properties even 300 unit deals.
Not crazy at all, honestly I think you're just early. The KPI part especially. Figuring out which metrics are worth watching is judgment, and that's where these things are actually good.
Two things watch though. 1.Rent rolls. PL totals are your own numbers, whatever, low stakes. But a rent roll has tenant names and payment history in it, and that's not really your info to be uploading. I'd just strip those columns first. The analysis never needs them anyway.
2. And on the 300 unit stuff, check the math yourself. These models are great at telling you how to think about a deal and weirdly bad at adding things up. A wrong NOI that sounds confident is worse than an obviously wrong one, at least a spreadsheet shows you the formula.
- Investor · Charleston, SC · Member since 2018 · 195 posts · 82 votes3w
Even on the other side of this, using a PM instead of self-managing, the gap is still real. My PM's software produces a statement built for their operations, not my books, so I still end up re-deriving true per-property net and tying it back to what actually hit my bank before I trust the number for taxes or a hold sell call. Kim's point lands for me too, it was never really about the size of the platform, it was whether the report was built for the owner's decision or the manager's workflow.
- Member since 2026 · 4 posts · 4 votes2w
Really appreciate everyone chiming in on this -- this thread ended up being more useful than I expected.
Diana's reframe stuck with me most: the value isn't more granularity, it's consistency, plus something that flags what actually needs a look -- a unit costing more than others, repairs repeating, a turnover that ran high. That's different from a fuller per-unit P&L, and closer to what a few of you described actually wanting.
I've started mocking up exactly that: a simple "needs attention" feed sitting on top of whatever you already use (Buildium, Excel, Quicken, etc.) rather than replacing it. Still early and using illustrative data for now, but if anyone wants a look or has thoughts on what should trigger a flag, I'd love to hear it.
- Los Angeles, CA · Member since 2026 · 20 posts · 0 votes2w
The income side is where my reports used to fall apart, not the expense side. My tenants pay by Zelle, Cash App, check, sometimes cash. None of that flows into any software on its own. So the "rent income by month" view was only ever as honest as my manual entry, and my manual entry was not honest. I was rebuilding in a spreadsheet every month, same as you.
So the gap is real, but for a self-manager it isn't that PM software reports badly. It's that half the transactions never reach the software in the first place.
For the people here on Buildium or AppFolio - are your tenants actually paying through the portal, or are you hand-entering the Zelle and Cash App payments too? That answer decides whether the native reports mean anything.
- Investor · Pacific Northwest · Member since 2026 · 536 posts · 300 votes2w
The gap is real, but I wouldn’t frame it as “AppFolio vs Excel.”
The bigger issue is whether the expense still carries enough context when it reaches the owner report.
Per-unit reporting is only useful if you can answer things like: was this recurring or one-time, controllable or uncontrollable, unit-specific or allocated, maintenance or capital, normal variance or an emerging pattern?
Most PM systems can tell you what was spent. The harder problem is preserving why it was spent, what changed, whether it should repeat, and what action it created.
That’s where teams usually end up rebuilding the story manually in spreadsheets, notes, email, or owner commentary.
So I’d look for a reporting process that preserves the transaction plus the operating context around it, not just cleaner monthly columns.
Feel free to reach out if you have any questions.
- Englewood, NJ · Member since 2018 · 464 posts · 88 votes3d
the income side gap yisroel mentioned is the one that bites people hardest i think. you can get your expense tracking as clean as you want but if half your rent is coming in through zelle and venmo and cash app and it never makes it into whatever system you're using, your "per unit report" is already wrong before you even look at it.
i spent way too long trying to get the expense side perfect before realizing the real mess was on the income side. payments hitting the wrong account, tenants splitting rent between roommates on different apps, security deposit vs first month getting coded wrong. once i fixed that pipeline the expense tracking part got a lot less stressful because at least i knew the starting number was right.
the mortgage split thing joseph brought up is real too. until you separate principal from interest your property looks like it's bleeding more than it actually is, and your equity number is just a guess. that one's worth automating early if you have more than a couple doors.- 2dSri S.Business MemberDublin, CA · Member since 2024 · 40 posts · 19 votes
Yisroel and Igor, I'm curious about something. Do you have dedicated bank accounts for your rentals, or do you receive rent into your personal bank accounts?
If you're receiving rent through Zelle, Venmo, or Cash App, and those payments eventually hit your bank account, wouldn't connecting that account to your bookkeeping software capture those transactions automatically?
Are you not connecting your bank accounts to these platforms, or is the issue that the software doesn't recognize these deposits as rental income and assign them to the correct property or unit?
I'm trying to understand where the actual gap is — getting transactions into the software, identifying them correctly, or both.
- Los Angeles, CA · Member since 2026 · 20 posts · 0 votes2d
Both, but mostly the second. The bank feed gets the deposit in fine. A Zelle memo that just says "rent," or a Cash App transfer from a roommate's name, doesn't tell the software which unit or which month it's for. Someone still sits there and tags it.
- Los Angeles, CA · Member since 2026 · 20 posts · 0 votes2d
Starting number first, then the expenses. That's the order I wish I'd figured out sooner. Roommates splitting rent across two apps is the worst of it - one unit, two names, and neither one matches the lease.
- 2dGabriel GraumannPro MemberReal Estate Broker · Phoenix, AZ · Member since 2019 · 165 posts · 100 votes
@Yisroel Pollock An important question would be what scale are you referring to. I manage 910 single-family properties in Phoenix metro and we use AppFolio. Easily provides tracking on a property to property basis, even when one owner may hold 30+ properties in the same portfolio.
- Los Angeles, CA · Member since 2026 · 20 posts · 0 votes2d
Fair - at 910 doors AppFolio is built for exactly that. I meant the other end: a few doors, rent coming in by Zelle and Cash App, no portal at all. I'd guess nearly all your rent runs through the portal, which is why the numbers hold.
- Member since 2026 · 73 posts · 25 votes2d
I use Easy Rental Records. I enter the expense and assign it to the property when I record it. Then I can pull a P&L for an individual property or the full portfolio. I can also export the reports to Excel when I need them; no formulas required. It keeps me from having to separate everything later.
- 2dSimon W.Business MemberReal Estate Consultant · Lehigh Valley PA & New York City · Member since 2013 · 1k+ posts · 659 votes
Most of what owners actually need is clean property-level reporting, not true unit-level for every single expense.
In practice:
• Rent and unit-specific repairs can live at the unit
• Shared costs (insurance, property management fee, many utilities, mortgage interest/escrow) usually stay at the property and get allocated only when the owner statement actually needs it
• Forcing every expense down to the unit creates noise and breaks context on the transaction
If you're in AppFolio/Buildium, use their native property/unit structure and keep the chart of accounts consistent. Excel is fine as a presentation layer, not as the system of record.
The goal isn't perfect unit cost accounting. It's owner statements you can explain in two minutes without rebuilding the month.
- Member since 2026 · 13 posts · 4 votes1d
In QuickBooks the report is only as good as the tagging. If every bill gets assigned to a property and unit the day it's entered, the built-in reports work fine for owner statements. When that slips, you end up rebuilding it in Excel at month end.
Join the conversationCreate a free account to reply, vote on answers and follow this thread.