STR owners — how are you actually tracking expenses and getting Schedule E right?

Question

I run a small Airbnb/VRBO portfolio and I've spent a lot of time this year digging into the bookkeeping side of STR ownership. The more I looked, the more I realized how easy it is to get the numbers wrong — especially the gap between what platforms deposit into your bank and what Schedule E actually wants you to report.

Curious what other STR owners are doing:

- Are you using Stessa, a spreadsheet, a CPA, or something else to track your rental income and expenses?

- How do you handle the difference between your platform payouts and what belongs on Schedule E line 3?

- Do you track bookings and occupancy per-property, or just work off the 1099 at year end?

- Anyone actually logging material participation hours, or just hoping for the best?

Not looking for CPA recommendations — more interested in what tools and workflows people are actually using day to day and what's working or not working about them.

Ashish Acharya · Answer

JD, the part I’d be watching most closely isn’t just the headline amount of multifamily debt coming due. It’s the gap between the debt these properties were originally underwritten with and what the same NOI can support at today’s refinance terms.

A deal that looked completely reasonable at a 3%–4% rate can look very different when the replacement debt is closer to 6%, especially if rents haven’t grown enough to offset insurance, taxes, payroll, repairs, and other operating costs.

For investors looking at distressed multifamily now, I’d be very careful not to assume that a 20%–40% discount automatically means the deal is cheap. I’d want to understand why the prior owner got into trouble in the first place. Was it simply bad short-term debt, or is the property dealing with weak rent growth, high concessions, deferred maintenance, insurance pressure, or a market with too much new supply?

I’d underwrite these deals using today’s debt service, not the seller’s historical financing, and I’d stress-test the refinance again before buying. If the deal only works because rates have to fall later, that’s still a financing bet.

There’s also a tax-planning angle when distressed assets start changing hands. A new buyer may get a fresh depreciable basis, and cost segregation may become useful depending on the property and whether the resulting losses are actually usable. For owners deciding whether to sell, refinance, or hand back a property, depreciation recapture, suspended passive losses, and 1031 options can materially change the after-tax outcome.

The opportunity is real, but I think the winners will be the buyers who can distinguish capital-structure distress from fundamentally weak real estate.

Feel free to DM me, I’d be happy to send over a few resources that might help with multifamily underwriting, refinance risk, and tax planning around distressed acquisitions.

Chris Mitchell · Answer

Thanks, I’m looking for different suggestions and building out my own site at Tallyroost. Trying to get as much input as possible.

Jason Malabute · Answer

The cleanest mental model is to keep "what the platform sent me" and "what the property actually earned" as two different numbers. Line 3 wants gross rents, not the net deposit, so at the property level I'd track gross booking revenue, platform fees, cleaning income and cleaning expense, lodging taxes collected, refunds and chargebacks, maintenance, utilities and furnishings each on their own line, with the payout used only to reconcile. Building the return off the 1099-K or off net deposits is where people get hurt, because it understates gross income and quietly drops the platform fees you were entitled to deduct. I'd also track bookings and average guest stay per property all year, since average stay drives the passive loss side, and keep a contemporaneous hour log if material participation is part of the plan, along with reasonable records of what cleaners, co-hosts and contractors did so you can show nobody put in more time than you. One last thing: not every short-term rental belongs on Schedule E. It's the substantial services provided to guests that push an activity toward Schedule C and self-employment tax, not just short stays or being active, so it's worth making sure your setup matches how the property actually operates. The right answer depends on your particular facts, so have your own CPA or tax advisor confirm it.

Andrew Steffens · Answer

I have a bookkeeper tracking everything before it goes to a CPA but Quickbooks can handle all of this for you especially if you are a small portfolio operator.

Tim Johansson · Answer

I typically recommend REIHUB.net to my clients as it's more cost effective than Quickbooks and has a great dashboard / interface. Also, the IRS views an AIRBNB / STR property as an "active" business. Are you taking advantage of the short term rental loophole? I would consider reporting your short term rental activity on Schedule C and not Schedule E since you are an active participant.

Ashish Acharya · Answer

Chris, I think the cleanest way to handle this is to separate what the platform deposits from what the property actually earned.

For bookkeeping, I’d want each STR tracked at the property level with gross booking revenue, platform fees, cleaning income/expense, lodging taxes, refunds, maintenance, utilities, furnishings, and other expenses separated out. The net Airbnb/VRBO payout hitting the bank is useful for reconciliation, but it generally should not be treated as the same thing as gross rental income.

For Schedule E, I’d want the books to reconcile back to the gross rents actually earned, with platform fees and other deductible costs recorded separately. I would not prepare the return simply from the 1099 or from net bank deposits.

I’d also track bookings and average guest stay by property throughout the year. That becomes important if you’re relying on the STR rules because the tax treatment can change depending on the average stay and the level of services provided.

And yes, if you’re relying on material participation, I’d absolutely keep a contemporaneous hour log. If using the 100-hour-and-more-than-anyone-else test, I’d also keep reasonable records of cleaner, co-host, and contractor participation so you can support that nobody else participated more than you.

One additional wrinkle: not every STR automatically belongs on Schedule E. If substantial services are being provided to guests, the reporting can potentially move toward Schedule C treatment, so I’d make sure the bookkeeping workflow matches the actual operating facts.

Feel free to DM me, I’d be happy to send over a few resources that might help with STR bookkeeping, material participation, and getting the tax reporting right.

Chris Mitchell · Answer

Thanks for the feedback.

Chris Mitchell · Answer

We’re building out a site that can be handed off to a cpa. I tried QB personally and didn’t think it was very user friendly for rentals. I was using Stessa.

Chris Mitchell · Answer

Thanks, yes pushing to schedule C makes sense. I need to think about that when creating our site.

Chris Mitchell · Answer

Curious which one you use?

STR owners — how are you actually tracking expenses and getting Schedule E right?

13 Replies