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.

Michael Eskenasy · Answer

I think the mistake is treating this as a tax-time problem.

If you’re trying to reconstruct the property from a 1099, Airbnb payout and bank statement in March, the operating system already failed months earlier.

The way I’d build it is much simpler:

Every booking becomes an event tied to a property.

Gross revenue. Platform fee. Cleaning. Refund. Tax. Actual deposit.

Same thing on the expense side.

Receipt comes in, it gets attached to the property and categorized once. Contractor gets paid, it gets recorded once. Owner spends two hours dealing with a guest or repair, that gets captured when it happens.

Then the bank deposit is just reconciliation. It isn’t the source of truth.

That changes everything because year-end stops being “figure out what happened” and becomes “hand the CPA a clean record of what already happened.”

Same with participation hours. If the system is already capturing the work as it happens, the log becomes a byproduct instead of another thing you’re supposed to remember in December.

I’d still let the CPA decide the tax treatment. That’s their lane.

But the operator’s job should be to make sure nothing has to be reconstructed from memory.

This is actually very close to the kind of problem we’ve been working on: getting the work itself to create the record, instead of asking the human to remember to create one later.

Simon W. · Answer

The gap you're feeling is usually reconciliation, not software.

Workflow that keeps this clean:

• Treat Airbnb/VRBO payouts as deposits, not as "rent income" by themselves

• Reconcile booking reports to bank deposits every month (gross booking vs fees vs net deposit)

• Keep a per-property monthly view so year-end isn't one giant pile of 1099s

• Track expenses in the books with the property tagged the same way every time

Schedule E wants gross rents and expenses in the right buckets. Your CPA files that. Your job is books that tie: platform report → bank → property P&L.

If you only look at the bank deposit, Schedule E will always feel wrong.

For material participation logs, contemporaneous notes beat a year-end scramble. I'm not giving tax advice on qualification — just the bookkeeping hygiene that makes the CPA's job possible.

Matthew Tregoning · Answer

The per-property view matters even before tax time. A portfolio total can hide one unit quietly eating the profit from the others. I'd keep booking revenue, platform deductions and the actual bank payout visible separately, then review each property's expenses monthly. Which part of that reconciliation is taking you the most time?

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.

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.

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.

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.

Chris Mitchell · Answer

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

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.

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

17 Replies