Reconciling OwnerRez Payouts to QuickBooks Online Deposits

Who this is for

This guide is for short-term rental property managers who use OwnerRez as their property management system and QuickBooks Online (QBO) as their general ledger. You're probably running between 5 and 50 properties, you're responsible for owner accounting, and you've noticed that the numbers coming out of OwnerRez don't always match what ends up coded in QBO - sometimes by a few dollars, sometimes by hundreds.

The root cause is almost never a platform problem. It's the inherent complexity of multi-channel, multi-owner payouts: gross booking amounts, OTA commissions netted before they hit you, occupancy taxes remitted by the channel vs. collected by you, cleaning fees that pass through at varying rates, and PM management fees that have to be split out correctly. All of that complexity has to be translated into clean QBO entries - and the translation is where things break.

This walkthrough gives you a repeatable process for making that translation correctly, every time.

Step 1: Pull the right OwnerRez report

Before you touch QBO, get the data out of OwnerRez.

Go to Reports > Owner Statements and generate a statement for the owner and date range you're working on. OwnerRez owner statements show:

• Gross booking revenue (per booking)

• Cleaning fees (if passed through to owner)

• OTA channel commissions

• Your property management fee

• Owner-reimbursable expenses

• Net owner payout

Also pull the Transactions or Payout Summary report for the same period. This lets you verify that the bookings included in the statement match the bookings that generated actual payout activity.

Save both reports. You'll use them as your source of truth.

Step 2: Understand what the OwnerRez payout number actually represents

This is where most reconciliation errors originate.

OwnerRez calculates the owner payout by starting from gross booking revenue and subtracting: OTA commissions (if the channel is netting them before remittance), your PM fee, and any owner-chargeable expenses - then adding cleaning fees if applicable.

Here's a concrete example:

In QBO, you cannot just record a $1,625 deposit and call it income. That single number has to be disaggregated into its components so your chart of accounts reflects what actually happened. Rental income, cleaning fee income, channel commission expense, PM fee income (your side), and owner expense reimbursements all go to different accounts.

If you collapse this into one line, your revenue is understated, your expenses are invisible, and an owner audit will surface the discrepancy immediately. For more on how this flows through your books, see our property management accounting guide.

Step 3: Map OwnerRez line items to QBO accounts

Before you record anything, confirm your QBO chart of accounts has a home for each component:

• Rental Income - gross nightly rent only

• Cleaning Fee Income - if you collect and pass through or retain a portion

• Channel Commission Expense (or contra-revenue account) - OTA fees netted from gross

• Management Fee Income - your PM fee, booked as revenue on your side

• Owner Expense Reimbursements - maintenance, supplies, etc. charged to owner

• Occupancy Tax Liability - taxes you collect and remit (not revenue)

If your QBO chart of accounts doesn't have these separated, fix it before you start reconciling. Trying to reconcile against a single "Rental Revenue" bucket makes it impossible to catch errors at the line-item level.

Step 4: Record the QBO entry correctly

For each OwnerRez owner statement period, create a deposit entry in QBO that records the gross booking components, not just the net payout. This usually means:

1. Debit your clearing or trust account for the gross booking total

2. Credit Rental Income for the nightly rent amount

3. Credit Cleaning Fee Income for the cleaning amount

4. Debit Channel Commission Expense for the OTA fee

5. Credit or debit Management Fee Income appropriately

6. Credit any tax liability accounts for occupancy tax collected

If you're using a trust accounting workflow - holding owner funds in a separate account before disbursement - the entries look slightly different. Our owner trust accounting guide covers the double-entry mechanics for that setup in detail.

Step 5: Compare totals and identify variances

Once you've recorded QBO entries for the period, run a QBO Profit & Loss report filtered to the relevant properties and date range. Compare it line by line to the OwnerRez owner statement.

The totals that should match:

• Gross rental income in QBO = gross nightly rent per OwnerRez

• Cleaning fee income in QBO = cleaning fees per OwnerRez

• Channel commission expense in QBO = OTA fees per OwnerRez

• Net owner payout per OwnerRez = net amount you disbursed, per your disbursement records

If any line doesn't match, work backward booking by booking. Common culprits:

OTA commission rate changed mid-period

Airbnb and other channels occasionally adjust commission structures. If you're applying a flat rate assumption across all bookings, a rate change mid-period will create a variance.

Tax collection status varies by booking source

For bookings where the OTA collects and remits occupancy tax directly (called "Voluntary Collection Agreements" or marketplace facilitator rules), that tax never flows through your books. For direct bookings, you collect and remit it yourself. If these get coded the same way, your tax liability account will be wrong.

Cleaning fees coded inconsistently

Some operators pass cleaning fees 100% to owners, some retain a portion as a markup, and some treat them as a separate line of business income. If the treatment varies booking to booking, QBO and OwnerRez will diverge.

Multi-booking payout batching

OwnerRez sometimes batches multiple booking payouts into a single disbursement. If QBO has one entry for the lump sum rather than individual booking entries, tracing a discrepancy becomes nearly impossible.

Step 6: Document your reconciliation

Once the numbers tie out, document it. A simple spreadsheet or PDF with:

• OwnerRez statement date and period

• Gross revenue per OwnerRez vs. QBO

• Any variances found and how they were resolved

• Sign-off date

This creates an audit trail if an owner questions their statement or if you have a tax review. It also makes the next reconciliation faster because you've already identified your systematic error points.

Where errors accumulate faster than you notice

Even a solid process breaks down when you're managing 20+ properties with multiple channels per property. A $40 coding error on a single booking is easy to miss in QBO. Multiply that across 200 bookings a month and the cumulative error can be significant by year-end.

That's the gap PX Accounting is built for. Rather than replacing your OwnerRez-to-QBO workflow, PX sits on top of it and audits what your current process produces - flagging payout mismatches, miscoded fees, and tax gaps across your owner statements. You can audit your owner statements at no cost for the first 60 days to see what your current workflow is missing.

For a full breakdown of what PX checks and how it fits into your existing stack, see the features overview.

Frequently Asked Questions

Why does my OwnerRez net payout never match what I record in QuickBooks Online?

The most common reason is that OwnerRez payout figures include components - OTA commissions, management fees, expenses - that need to be recorded as separate line items in QBO rather than as a single net amount. When QBO only records the net payout, the gross revenue and expense detail is lost, making the two systems appear to disagree even when the underlying cash is correct.

Should I record gross revenue or net revenue in QuickBooks Online for STR properties?

Generally, gross revenue. Recording only net amounts hides important data: your true top-line revenue, the cost of OTA distribution, and your management fee income. Lenders, owners, and tax preparers all want to see gross figures. Check with your CPA on the specific treatment for your business structure, but gross recording is the standard for property management operations.

How do I handle occupancy taxes in this reconciliation?

Occupancy taxes collected by OTAs under marketplace facilitator laws do not flow through your books at all - they never hit your revenue or your liability account. Taxes you collect directly on non-OTA bookings should be credited to a tax liability account, not to income. Mixing these two treatments is one of the most common sources of tax gaps in STR accounting.

How often should I reconcile OwnerRez to QuickBooks Online?

Monthly is the minimum for most operators. If you're running more than 15 properties or handling high booking volumes, a mid-month reconciliation catch helps prevent small errors from compounding. Quarterly reconciliation is too infrequent - by the time you find an error, it may have carried forward for months.

What if a booking spans two calendar months in OwnerRez?

OwnerRez typically recognizes income at checkout, which means a booking from late January to early February would post in February. Your QBO entries need to match this convention consistently. If your accountant prefers accrual-based recognition (income spread across the stay), you'll need a manual adjustment process - the default OwnerRez statement won't do this automatically. Confirm the preferred method with your CPA.

Next steps

Start with your most recent complete month. Pull the OwnerRez owner statement, map each line to your QBO chart of accounts, and run the comparison. Most operators find at least one systematic error the first time they do this exercise.

If you want an outside set of eyes on your existing statements before you rebuild the process, get a free owner statement audit through PX Accounting. We flag the errors your current workflow is producing so you know exactly what to fix - without replacing the tools you already use.

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