Setting Up QuickBooks to Handle OTA Payouts: A Guide for STR Operators

If you've ever opened QuickBooks after a busy weekend and wondered why nothing lines up with your bank statement, the problem almost certainly starts here, before any reconciliation tool or workflow enters the picture. Getting your QuickBooks setup right for OTA payouts is the foundation everything else builds on. This guide covers what you need to know to categorize deposits correctly and keep your books clean month to month.

How STR Revenue Actually Flows

Before you can set up QuickBooks properly, it helps to understand what's actually happening financially every time a guest books and checks out.

Four things happen on every reservation:

Rental income. The nightly rate the guest pays. This is your primary revenue line and should be tracked per property.

Cleaning fee income. Collected from the guest, often treated as a separate income line.

OTA service fee. The commission Airbnb, VRBO, or Booking.com deducts before paying you. This is an expense, and it's deductible. Many operators miss this entirely because it never shows up as a separate transaction. It's just netted out of the payout.

Occupancy tax. Collected from the guest on behalf of your local municipality and passed through. This is a liability, not income. It moves through your books but shouldn't sit on your revenue line.

Beyond those four, reservations can include additional income items like pet fees, early check-in upsells, and damage reimbursements. On the expense side, refunds and adjustments need to be properly categorized when they occur. Each of these has its own place in your chart of accounts.

The key takeaway: a single reservation generates multiple pieces that belong in different places in your books. If you're recording a payout as a single deposit with one income line, your books don't reflect what actually happened.

Why Deposit Splitting Matters

Understanding what's in a reservation is step one. The harder problem is that your OTA doesn't pay you one reservation at a time.

Airbnb batches multiple reservations into a single deposit, nets out fees, refunds, and adjustments (including ones that may relate to completely different reservations), and sends you one number every few days. VRBO does the same thing with its own payout structure. Booking.com has its own timing and netting logic.

So a single deposit hitting your bank account might contain rental income and cleaning fees from three different reservations, OTA fees deducted across all of them, an occupancy tax piece for each, and an adjustment from a refund you issued to a guest two weeks ago.

If you record that deposit as a lump sum, you're understating gross revenue, missing deductible OTA fees, and misclassifying tax liabilities. Your books look balanced but the numbers are wrong. That creates problems at tax time and makes it nearly impossible to understand the actual performance of your properties.

Deposit splitting is the process of breaking that lump sum into its pieces and posting each one to the right account.

Setting Up Your Chart of Accounts

The following account structure is a starting point for operators managing OTA payouts in QuickBooks. These are suggestions, not accounting rules. Your specific setup should be reviewed with a CPA or bookkeeper who understands your business.

Income accounts

• Rental Income (one per property, or use class tracking; more on that below)
• Cleaning Fee Income
• Pet Fee Income
• Other Guest Fees (upsells, early check-in, etc.)

Expense accounts

• OTA Service Fees (Airbnb, VRBO, Booking.com; you can separate these or consolidate)
• Guest Refunds and Adjustments

Liability accounts

• Occupancy Tax Payable (for pass-through taxes you collect and remit)

A note on class tracking. If you're managing multiple properties in one QuickBooks account, class tracking is worth setting up. It lets you assign every transaction to a specific property, which means you can run a profit and loss report at the property level rather than just seeing company-wide numbers. Your accountant will likely appreciate it too. The typical setup is one class per property, named by address or a short property identifier.

How to Split a Deposit

When a deposit arrives in your bank feed, your job is to break it into its pieces before posting it to QuickBooks.

Start with your OTA payout CSV. It shows you exactly which reservations are included in the deposit, what was netted out, and why. Cross-reference it against your reservation data to confirm the amounts and identify which property each reservation belongs to. Once you know what's in the deposit and where it came from, you can allocate each piece to the right account: rental income to the right property's income account, cleaning fees to cleaning fee income, OTA commissions to your OTA service fee expense account, and taxes to your occupancy tax liability account.

A few mistakes worth calling out:

Recording net instead of gross. When you only record the amount Airbnb deposited, you're missing gross revenue and the OTA fee expense. Both matter. The fee is deductible and gross revenue is what your 1099-K will reflect.

Missing the tax piece. Occupancy taxes are not your income. They pass through your books as a liability. If they're landing in an income account, your revenue is overstated.

Skipping the adjustment line. Refunds and adjustments that get netted out of a deposit still need to be recorded. They don't disappear just because they're invisible in the deposit amount.

Where This Gets Complicated

A clean, single-reservation deposit with no adjustments is straightforward once your accounts are set up correctly. It takes time, but the logic is clear.

Things get harder fast when you run into any of the following:

Multi-reservation payouts. One deposit, multiple reservations, multiple properties. You have to identify each reservation, pull its pieces, and allocate everything correctly across properties and accounts. On a busy weekend with four or five checkouts, this is a significant amount of manual work.

Stay extensions. A guest extends their stay and Airbnb processes the additional nights as a separate payout, sometimes a week or more later. Now you have one reservation split across two deposits. You need data from both the original payout and the extension to complete the picture.

Refunds and adjustments netted across unrelated reservations. Airbnb deducts refunds from whatever payout is going out at the time, regardless of which reservation the refund relates to. A refund from a guest who stayed three weeks ago might be sitting inside a deposit that otherwise covers this weekend's checkouts. Tracing that correctly requires pulling data from your OTA payout report, cross-referencing your PMS reservation history, and sometimes digging into guest conversations to understand what the adjustment relates to.

Each of these scenarios requires stitching together data from multiple sources. That's where manual deposit splitting stops being tedious and starts being genuinely error-prone.

This Is the Work Host Ledger Automates

Getting your chart of accounts right is a one-time setup. Splitting deposits correctly every month is an ongoing process, and the edge cases above are the part that takes the most time and carries the most risk of error.

Host Ledger connects to your Hospitable account and QuickBooks, processes your OTA payout CSVs, and handles the deposit splitting automatically. It combines your payout data with your Hospitable reservation data to make accurate, property-level splits, categorizes every piece, and builds QuickBooks entries that reconcile to the penny against your actual bank deposit.

This guide is written for operators using cash basis accounting. It may not apply to accrual-based or trust accounting setups. If you're unsure which method is right for your business, talk to a CPA or bookkeeper familiar with short-term rentals.