Owner Statement Reconciliation: A Month-End Checklist for STR Property Managers

Owner Statement Reconciliation: A Month-End Checklist for STR Property Managers

This article is for property managers running 5 to 50 short-term rental units who send owner statements every month and want to make sure the numbers are actually right before they hit send.

Reconciling owner statements is not glamorous work. It is also not optional. When your statements are off - even by small amounts - trust erodes, owners ask questions you cannot answer quickly, and the errors compound over time into a mess that can take days to untangle.

This checklist walks through every step of a sound month-end reconciliation process, from pulling your raw data to confirming the owner payout figure is defensible.

What Owner Statement Reconciliation Actually Means

Reconciliation, in this context, means proving that every dollar collected during the month is accounted for - either paid to the owner, kept as your management fee, remitted as taxes, held in reserve, or paid to a vendor.

If those figures do not tie back to gross booking revenue, something is missing or miscoded. The reconciliation process forces you to find it before the owner does.

For a deeper grounding in the underlying framework, see our owner trust accounting guide, which covers how property manager funds should be segregated from owner funds throughout the month.

What You Need Before You Start

Gather these before touching any statements:

• OTA payout reports for the month (Airbnb, VRBO, Booking.com, direct booking processor)

• Your PMS booking ledger showing gross nightly revenue, cleaning fees, and pet fees per reservation

• Vendor invoices for any expenses paid on behalf of owners (repairs, supplies, landscaping)

• Your management fee schedule for each owner (flat fee or percentage, and what it applies to)

• Prior month's ending reserve balance per property

• Tax remittance records if you collect and remit occupancy tax on behalf of owners

If any of these are missing before you start, the reconciliation will break partway through. Pull everything first.

The Month-End Checklist

Step 1: Confirm Gross Revenue Per Property

Start at the top of the income waterfall. For each property, list every reservation that had a check-out date within the month. Sum:

• Nightly rent

• Cleaning fees

• Any additional guest fees (pets, extra guests, late checkout)

This is your gross collected revenue for the property. Do not net anything yet.

Common problem: Some PMS exports show net payouts from OTAs rather than gross booking amounts. If you are working from a Stripe or Airbnb deposit figure, you are already missing the OTA service fee line and possibly the cleaning fee treatment. Always reconcile from gross booking value, not deposit amount.

Step 2: Subtract OTA Channel Fees

If OTAs collect and remit to you (the manager) net of their own host fee, document that host fee as a line item. It should appear on the owner statement so the owner understands what the platform charged.

For direct bookings processed through your own payment gateway, you will subtract the payment processing fee instead.

Total: Gross Revenue - OTA/Processing Fees = Net Channel Revenue

Step 3: Apply Your Management Fee

Apply your management fee according to each owner's contract. Be precise about what the fee applies to:

• Does your 20% fee apply to nightly rent only, or does it also apply to cleaning fees?

• Is there a separate booking or reservations fee?

• Do you charge a renewal fee for long-term stays?

Document each fee component as a separate line. Bundling them into a single "management fee" figure makes it impossible to audit later.

Total: Net Channel Revenue - Management Fees = Owner Net Revenue

Step 4: Add or Deduct Owner Expenses

List every expense paid on the owner's behalf during the month:

• Repairs and maintenance (attach invoice or reference number)

• Supplies restocked

• Landscaping or pool service if billed directly to the property

• HOA payments, if applicable

• Insurance premiums paid by you on their behalf

Total: Owner Net Revenue - Owner Expenses = Owner Distributable Amount

Step 5: Account for Reserves

If you hold a maintenance reserve for the owner, reconcile it explicitly:

• Starting reserve balance (prior month ending)

• Plus: Any reserve contributions added this month

• Minus: Any reserve funds used to pay expenses (cross-reference Step 4)

• Ending reserve balance

This ending balance should be a real number that you can point to in your trust account. If it is not, you have a trust accounting problem, not just a statement problem.

Step 6: Confirm Occupancy Tax Treatment

For each property, confirm whether you or the OTA remitted occupancy tax. Platforms like Airbnb remit certain taxes directly in many jurisdictions - but not all. If you are responsible for collecting and remitting, show the tax amount collected and the remittance reference on the statement.

Mishandling this step creates liability that follows you, not just the owner. Check with your CPA or local tax authority if you are unsure who owes what in your market.

Step 7: Calculate and Verify the Owner Payout

Owner Payout = Owner Distributable Amount - Reserve Contribution +/- Any Prior Month Adjustments

This figure should match exactly what you transferred to the owner. If it does not match, do not move on. Find the gap first.

Step 8: Cross-Check Against Prior Month Adjustments

Look back at last month's statements. Were there any reservations that were paid out in the prior period but subsequently cancelled or modified? Were there chargebacks? Were there vendor invoices from last month that arrived and were paid this month?

Any of these require a prior-period adjustment line on the current statement. Skipping this step is how small errors accumulate into large ones over six months.

Worked Example: Single Property, One Month

Here is how the math flows for a single cabin property in October.

If the owner received $3,085, the statement reconciles. If they received $3,200, you have a $115 discrepancy that needs to be identified before next month's statement goes out.

The Errors That Slip Through

Even careful managers using solid tools make these mistakes:

• Cleaning fee miscoding: Cleaning fees charged to guests get coded as revenue when they should pass through to the cleaning vendor, or vice versa

• OTA fee double-deduction: The fee is already netted from the OTA payout, then deducted again manually

• Management fee applied to wrong base: The fee runs against gross collected rather than the contractual base, overstating your take

• Reserve balance drift: Expenses paid from reserves are not deducted from the reserve ledger, so the stated balance grows fictitiously

• Prior-month cancellations ignored: A November cancellation of an October reservation requires an October adjustment that never appears

These are not rare. They are the normal byproduct of managing multiple owners across multiple platforms with different payout schedules.

Our STR property management accounting guide covers how to structure your chart of accounts to make these errors easier to catch systematically.

If you want to know whether your existing statements have errors you have not caught yet, you can audit your owner statements with PX - we review the last 60 days of statements and flag mismatches before they turn into owner disputes.

For a full picture of what PX checks during an audit, see the features overview.

Frequently Asked Questions

How long should a month-end owner statement reconciliation take?

For a single property, a thorough reconciliation should take 15 to 30 minutes if your source data is organized. For a portfolio of 20 properties, budget two to four hours total across the month-end close, depending on how many mid-month adjustments you need to make. If it consistently takes longer than that, your data sources are not well organized or you are finding a high volume of errors - both worth addressing.

What is the difference between reconciling owner statements and reconciling a trust account?

Owner statement reconciliation confirms that the numbers on each individual statement are accurate and internally consistent. Trust account reconciliation confirms that the total of all owner balances held in your trust account equals the actual funds available. Both are necessary. A statement can look correct while the underlying trust account is out of balance, and vice versa. You need both checks running every month.

Do I need to reconcile statements for properties that had zero bookings?

Yes. A zero-revenue month still requires confirming that no expenses were charged, that the reserve balance did not change without cause, and that no prior-period adjustments carried over. A blank statement sent without review is not a reconciled statement - it is an unreviewed one.

How do I handle a reservation that spans two calendar months?

The industry standard is to recognize revenue in the month of check-out. So a reservation checking in October 29 and checking out November 2 would appear on the November statement. Whatever convention you use, apply it consistently across all properties and document it in your management agreements so owners understand when to expect income from long stays.

What should I do if I find an error after the owner payout has already been sent?

Document the error immediately with the correct figures and how the discrepancy arose. On the following month's statement, include an explicit prior-period adjustment line showing the amount and the reason. Do not silently correct it by adjusting next month's fee. Transparency protects trust and creates a clean audit trail if the owner or a third party ever reviews the records.

Next Steps

Run through this checklist on your next month-end close and note which steps take the longest or surface the most uncertainty. Those are the pressure points in your reconciliation process.

If you want a second set of eyes on your existing statements before you build new habits on top of old errors, find the errors in your owner statements with a free 60-day PX audit. We flag discrepancies in your actual statement data so you know exactly what needs fixing.

By Jessica Hudson, CPA - specializing in short-term rental tax, bookkeeping, and financial operations for vacation rental hosts and property managers.