How to Run a Year-End STR Portfolio Audit (And What the Numbers Tell You)

A 7-step year-end audit framework for multi-property STR operators. Find your worst-margin properties, run real YoY comparisons, and build an action plan before peak season.

Most STR operators end the year with one number: total payouts received. They know roughly whether revenue went up or down. What they don't know is which three properties generated 80% of the actual profit, which two quietly ran below-breakeven margins for six months, or whether their apparent ADR improvement was real revenue growth or just rate inflation masking flat occupancy. A year-end portfolio audit answers those questions and sets the baseline for next year's decisions.

This isn't a feel-good annual reflection. It's a seven-step framework for extracting real intelligence from a full year of performance data. Run it in December or January, and you'll enter the new year with specific interventions for your underperformers and a replicable playbook from your best properties.

Step 1: Run Revenue by Property, Not Portfolio Total

The first mistake most multi-property operators make is looking at the portfolio aggregate. Total revenue up 11% year-over-year feels like success until you break it down by door and discover that three of your seven properties had declining revenue — and the aggregate growth came entirely from two properties that had a price increase and one new listing that wasn't in the prior-year comparison.

Pull ADR, occupancy rate, RevPAN (revenue per available night), and net payout for each property side-by-side for the full year. Compare against the same period last year. A Nashville operator running 7 properties recently completed this exercise and found that the portfolio aggregate showed healthy 14% YoY growth — but two individual properties were down 18% and 31% YoY in net payout respectively. Both had ongoing maintenance issues that quarterly reviews had never surfaced because the portfolio total always looked fine.

MagicBnB's YoY comparison runs this automatically — every KPI shows a delta pill (+18.3% / -6.2%) against the same period last year, at the property level and portfolio level simultaneously. For operators managing this in spreadsheets, that comparison takes 3-4 hours to build correctly; it's the primary reason most operators skip the per-property breakdown and look only at totals.

Step 2: Reconstruct a Real P&L for Each Property

Most STR operators know their gross payout from Airbnb and VRBO. Fewer know their net margin per door. A year-end audit requires building — or verifying — a complete income statement for each property: gross booking revenue, platform fees, cleaning costs, utilities, maintenance and repairs, mortgage or rent, insurance, licensing fees, and any management or co-host fees.

According to AirDNA's 2025 State of STR report, operating expenses for US short-term rental operators typically run between 35% and 60% of gross revenue — a massive range that reflects the difference between an operator who bought with a low-rate mortgage in 2019 and one running rental arbitrage at 2024 rents. The operators who know their exact expense ratio per property can make decisions about where to invest and where to cut. The operators who don't are flying on incomplete data.

A Scottsdale operator running 5 vacation rentals completed a full P&L reconstruction last December and discovered two properties were operating at 62% expense ratios — 15 points above the market average. Both had uncategorized maintenance charges and underestimated cleaning costs she had been roughly tracking but never precisely allocating. The two properties looked profitable on the revenue side but were each generating less than $400/month in net cash flow.

MagicBnB's Profitability and P&L view builds this automatically when your bank account and PMS are connected — per-property expense category breakdown (cleaning, utilities, maintenance, platform fees) with full YoY comparison. The Expense inbox isolates the unallocated transactions that still need property assignment, making the reconciliation a 15-minute weekly habit rather than a 6-hour year-end scramble.

Step 3: Run YoY Comparisons on the Metrics That Actually Matter

Top-line revenue growth is a vanity metric if expenses grew faster. A real YoY audit compares the right metrics in the right order:

• ADR YoY: did your average daily rate keep pace with market rate growth? If your ADR grew 4% but the overall market grew 8%, you left money on the table — even if total revenue is up.
• Occupancy YoY: the same occupancy percentage with fewer available nights (due to owner holds, maintenance blocks, or relisting gaps) can mask declining demand. Availability-adjust this number before comparing.
• RevPAN YoY: revenue per available night ties ADR and occupancy into one number. Declining RevPAN almost always precedes declining bookings by 60-90 days.
• Net payout YoY: gross revenue growth combined with rising expenses doesn't produce margin growth. Compare net, not gross.
• Channel mix YoY: if VRBO's share dropped from 28% to 14% and you didn't make a deliberate decision to reduce VRBO exposure, something changed — pricing divergence, search visibility, or calendar sync issues.

This level of YoY precision is why the audit matters more than a quarterly check-in. Annual patterns — seasonality effects, pricing drift, platform algorithm changes — only become visible at a 12-month comparison resolution.

Step 4: Identify Your Portfolio Outliers

The goal of the audit is to find outliers at both ends: the properties dramatically outperforming, and the ones quietly bleeding. Four questions drive this:

• Which property has the highest net margin? What's different about its cost structure or pricing strategy that's replicable elsewhere?
• Which property has the highest RevPAN? Is that ADR-driven, occupancy-driven, or both — and can any element transfer to a similar property?
• Which property showed the most YoY improvement? What changed — a renovation, a pricing reset, a guest communication upgrade?
• Which property is in decline? Define decline specifically: falling RevPAN, rising expense ratio, dropping review scores, or all three simultaneously.

A Denver operator running 8 properties completed this four-question exercise and found that one 2-bedroom condo she had considered offloading was actually her highest RevPAN property at $198/night, driven by a superior location and a cleaning partner who kept turnover time under 3 hours. Meanwhile, her largest property — a 4-bedroom house with $30,000 in recent renovations — ranked last in portfolio margin at 19% net.

The properties I thought were my best performers weren't. The RevPAN data completely reshuffled my mental ranking — and my investment priorities for next year.

Step 5: The Expense Audit

Year-end is the right time to review every expense category against market benchmarks. Three to prioritize:

Cleaning Cost Per Booked Night

Cleaning costs should run 8-15% of ADR for most market types, according to VRMA industry benchmarks. Urban and condo properties skew lower; mountain and cabin properties with larger square footage skew higher. If your cleaning cost per booked night exceeds 18% of ADR, you have either a pricing problem (ADR is too low relative to the cleaning cost floor) or a cleaning vendor problem (cost is above market). Both are fixable — but only if you're tracking at the per-property level.

Platform Fee Structure

If you're running split-fee pricing on Airbnb (guests pay approximately 14% service fee, hosts pay 3%), verify your host fee rates are actually at 3%. Custom rate requests, professional hosting tools, and specific listing configurations can result in different fee tiers — and many operators assume they're on the standard rate when they're not. Total platform fees across Airbnb and VRBO combined shouldn't exceed 15% of gross booking revenue for a well-configured portfolio.

Maintenance Cost Trend

Plot maintenance costs by property over 12 months. A flat or declining trend is healthy. Any property showing 25%+ maintenance cost increases year-over-year is aging ahead of its depreciation schedule and will likely require a capital investment or repositioning decision within the next 12-24 months. Catching this at year-end rather than mid-season gives you planning time and optionality.

Step 6: Owner Statement Reconciliation

If you manage properties for multiple owners, year-end is the moment to verify that every number in your owner statements ties back to a canonical source. The most common reconciliation problem in multi-property portfolios: net payout figures that differ between what your PMS reports, what your bank account shows, and what your owner statement says — because each calculation applies fees, refunds, and adjustments differently.

According to a 2024 Vacation Rental Management Association (VRMA) survey, 41% of professional property managers reported owner disputes about financial reporting at least once per year — and the majority of disputes stemmed from inconsistent calculations across reporting surfaces. Trace one property's numbers from source to statement: gross booking revenue to platform fee deduction to cleaning fee pass-through to host payout from Airbnb to bank deposit. If the figures don't flow cleanly between each step, you have a reconciliation gap.

MagicBnB's Net Payout source of truth is a single canonical calculation that flows through every surface — profitability view, portfolio overview, listings table, property detail, and monthly reports. When an owner challenges a number, you show one number from one source and trace the calculation path. That auditability is what separates professional operators from everyone else.

Step 7: Build the Action Plan for Next Year

The audit produces intelligence. The action plan converts it to decisions. At minimum, address three questions:

• Which 2-3 underperforming properties need specific interventions — and what exactly are those interventions? (ADR adjustment, cleaning vendor change, expense reduction, maintenance investment, or divestiture.)
• Which 2-3 top-performing properties have replicable elements? (Pricing strategy, check-in experience, cleaning turnaround time, listing photos, amenities.) Document what works before operational drift erodes it.
• Is there a property in the portfolio that no longer meets your minimum margin threshold and should be exited? Year-end is the cleanest time to make this call — you have a full year of data and typically a natural lease renewal or listing contract decision point.

Operators who run this audit consistently — even a simplified version — make materially better portfolio decisions than those who wait for a property to feel broken before investigating. Underperformance is almost always visible in the data 6-9 months before it becomes obvious operationally.

Running the Audit Without the Manual Work

The blockers for most operators aren't analytical — they're logistical. Pulling per-property ADR and occupancy from a PMS export, matching it to bank transactions, building YoY comparison tables, and reconciling net payout across three sources takes 8-12 hours for a 5-property portfolio if done manually in Excel. That's why most operators don't do it thoroughly, or at all.

A full expense allocation methodology is covered in our post at magicbnb.io/blog/how-to-calculate-real-profit-per-property. For the YoY metric framework — which metrics to prioritize and in what order — see magicbnb.io/blog/revpar-vs-adr-vs-occupancy-rate-which-matters.

MagicBnB's Portfolio Overview, Profitability and P&L, and YoY comparison run this analysis automatically from live PMS and bank data. The Property Health Grid surfaces your worst-margin properties on the homepage — red health dots identify underperformers before you run a formal audit. The Monthly Portfolio Report Builder generates the owner-ready output at the end of the process.

Start your year-end review at magicbnb.io — connect your PMS and bank account, and your YoY comparisons and per-property P&L populate automatically. The first audit is the hardest; after that, the data is always current.

FAQ: Year-End STR Portfolio Audit

When should I run my year-end STR audit?

December or January. December lets you identify and act on issues while you still have time to make pricing adjustments for the upcoming peak season. January gives you a complete 12-month dataset. Running it later than February means you'll have missed the spring booking window for whatever pricing or positioning changes the audit recommends.

What metrics matter most in a year-end STR review?

RevPAN (revenue per available night), net margin per property, and YoY ADR and occupancy comparisons are the highest-signal metrics. RevPAN combines pricing and occupancy into one number, making it the best single indicator of overall property performance. Net margin tells you whether revenue translates to actual profit. YoY comparisons tell you whether you're improving or drifting — adjusted for seasonality.

How do I calculate net margin for my Airbnb properties?

Net margin = (net payout minus total property expenses) divided by gross booking revenue times 100. Total property expenses include cleaning, utilities, maintenance, platform fees, mortgage or rent, insurance, licensing fees, and any management fees. Many operators undercount expenses because they don't allocate shared costs (like software subscriptions) to individual properties. A full expense allocation exercise is worth running at least once per year.

What's a healthy net margin for a short-term rental?

Benchmarks vary significantly by market and model. Rental arbitrage operations typically target 20-35% net margin after rent. Owner-operator STRs with low-rate mortgages can run 50-65% margins. Properties with high mortgage payments in expensive markets typically run 25-40% margins. Any property running below 15% net margin on a consistent 12-month basis should be evaluated for repricing, expense reduction, or divestiture — in that order.

How many properties do I need before a formal audit is worth running?

Two or more. As soon as you have two properties, you have the ability to compare them — and that comparison is where actionable intelligence lives. A single-property operator audits against market benchmarks. A multi-property operator audits properties against each other, which is more immediately actionable because the variables (your pricing strategy, your cleaning vendor, your guest communication approach) are all within your control.

What should I do if the audit reveals a property is losing money?

First, verify the expense allocation is accurate — underperforming properties are sometimes artifacts of sloppy expense assignment rather than genuine losses. If the allocation is correct, identify whether the problem is revenue-side (low ADR, low occupancy) or expense-side (high cleaning, maintenance, or fixed costs). Revenue problems are addressable with pricing and listing changes. Expense problems that are structural — high rent or an above-market mortgage — may require a market exit decision if the revenue ceiling doesn't cover the cost floor.

About MagicBnB

MagicBnB (magicbnb.io) is a portfolio intelligence platform built for short-term rental operators managing multiple properties. The YoY comparison runs automatically across every metric — ADR, occupancy, RevPAN, net payout, and channel mix — with delta pills showing the percentage change versus the same period last year at both the property and portfolio level. The Profitability and P&L view builds per-property income statements automatically from connected PMS and bank data, with full expense category breakdowns. The Monthly Portfolio Report Builder generates owner-ready PDF and Excel statements with 40+ configurable columns. For operators who have been running year-end audits in spreadsheets, MagicBnB makes the data collection automatic — leaving the analytical and strategic work to the operator.