6 minute read

Airbnb bookkeeping: fixing pooled-payout mystery math

Cover Image for Airbnb bookkeeping: fixing pooled-payout mystery math

One Airbnb payout can hide revenue, fees, and taxes from several properties at once. Here's how to break it apart, attribute income to each listing, and keep your books Schedule E-ready.

Airbnb bookkeeping falls apart the moment one deposit lands in your account with nothing attached to explain it. That single payout can roll up stays from every active listing, with the platform fee, cleaning fee, and occupancy tax for each reservation already netted out before the money arrives. The bank feed shows one line item, and the books inherit one number.

For short-term rental hosts, one number can't carry that much. Gross revenue, deductible fees, and tax liabilities sit mixed together behind a single transaction, so Schedule E support thins out, per-property profitability disappears, and year-end cleanup turns into billable CPA hours spent untangling pooled deposits.

Pooled payouts work exactly as Airbnb designed them. The bookkeeping problem starts when reservation-level detail never reaches the books.

There's a repeatable way through it: record each booking at its full value, run every payout through one holding account that splits it back into revenue, fees, and taxes, and tag each line to the property it came from. Done consistently, one mystery deposit becomes clean per-property books before month-end, and a Schedule E your CPA can file instead of rebuild.

What's actually inside a pooled Airbnb payout

One pooled Airbnb deposit can combine revenue, fees, taxes, and multiple properties in a way the bank feed never explains. The IRS expects your gross booking revenue on Schedule E—the tax form where rental income gets reported—with Airbnb's service fees listed separately as a deductible expense. The number that actually hits your account is the net: what's left after Airbnb takes its cut.

Say a $600 booking lands as a $540 payout. Record that $540 as revenue and you've hidden $60 of income the IRS still expects to see, and buried a fee you could have deducted. Do it all year and your books end up wrong on the return and useless for telling which property makes money.

Airbnb combines payouts from every active listing into one bank deposit, so producing a property-level profit view takes reservation-level records the feed doesn't give you.

Cleaning fees, occupancy taxes, pet fees, and parking fees don't all belong in the books the same way. A cleaning fee counts as booking revenue, but it's really a pass-through: money that lands in your income and then leaves again as the payment to your cleaner, so it has to be booked on both sides. Occupancy tax works differently: it's the guest's money you're holding for the government. Airbnb collects and remits it for you in some places but not others, and where it doesn't, that tax is a liability you owe the local authority, not income you earned.

How do you attribute revenue to each property?

You attribute revenue to each property in one of three places: your accounting tool, dedicated short-term rental (STR) accounting software, or the bank-account level, before the payout ever reaches your books. Decide this first, because the banking choice determines whether you need a Payment Clearing Account workflow at all.

Three attribution approaches

Each approach gets you per-property visibility; the trade-offs are operational.

  1. Class tracking in QuickBooks Online or tracking categories in Xero. Every transaction gets tagged to a property, so per-property profit and loss (P&L) reports are available on demand, but every reservation and expense entry has to be tagged, manually or through automation rules.

  2. Native property tagging in STR-specific accounting tools. Attribution is built in, so tagging happens automatically when you categorize the transaction.

  3. Banking-layer separation. Open a separate Airbnb host account for each property, each routing payouts to its own bank account. Attribution happens before the money reaches the accounting tool.

Approach 3 takes more setup upfront—a new Airbnb account and a new bank account per property—but produces the simplest downstream bookkeeping. Approaches 1 and 2 work with a single Airbnb account but need the Payment Clearing Account method to decompose each deposit. The choice comes down to where you'd rather do the work: upfront at the banking layer, or ongoing inside the accounting tool.

How banking setup affects the accounting tool's workload

With one bank account receiving every Airbnb payout, the accounting tool does the heavy lifting: Payment Clearing Account reconciliation, per-reservation records, and class tracking on every line. With per-property bank accounts, each deposit arrives pre-attributed, and the accounting tool's job shrinks to categorizing and reconciling one property's transactions at a time.

Relay supports both setups. For a single account, Relay's automated transfer rules move a set percentage of every deposit into dedicated accounts—tax reserves, maintenance, operating cash—the moment a payout lands. For per-property routing, you can open a dedicated checking account for each property (up to 20 on the Starter and Grow plans, 10 as a sole proprietor), with QuickBooks Online and Xero connections feeding each account's activity straight into your books.

The Payment Clearing Account methodology

A Payment Clearing Account is just a holding pen inside your accounting software. You enter each booking there at full value first, before Airbnb's deposit ever shows up. When the lump-sum payout lands, you match it against those bookings, and the account splits that one number back into what was revenue, what was a fee, and what was tax.

Skip this section if you set up per-property bank accounts; each deposit already arrives pre-attributed.

For single-account setups, the clearing account lives inside your accounting tool, not your bank. It bridges the gap between gross reservation amounts and the net payout that actually lands.

The workflow has six steps:

  1. Set up a Payment Clearing Account in your accounting tool. It lives in your books only, not at your bank.

  2. Record each reservation with these line items:

    • Gross booking amount (revenue)

    • Platform service fee (expense)

    • Cleaning fee (revenue)

    • Cleaning pass-through (expense)

    • Occupancy tax (liability or pass-through, depending on jurisdiction)

  3. Mark each reservation "paid" into the Payment Clearing Account, not the bank account.

  4. When the pooled payout hits the bank, create a transfer entry from the bank account to the clearing account for the net deposit amount.

  5. Reconcile the clearing account. It should zero out. A non-zero balance means a reservation record is missing, a line item is wrong, or a payout wasn't matched.

  6. Tag each reservation line to a specific property using your accounting tool's class tracking or tracking categories.

Manual entry works for a smaller portfolio. As reservation volume grows, automation cuts the repetitive data entry and speeds up monthly reconciliation.

Deductible expenses for Airbnb hosts

Running an Airbnb creates expenses well beyond Airbnb's fees, and each one needs its own line in the books to count as a deduction. Every expense you track here lowers the rental income you owe tax on. Miss one and you overpay.

The common categories:

  • Depreciation. The building (not the land) is depreciated over 27.5 years for residential rental property. Furniture, appliances, and equipment follow shorter schedules.

  • Mortgage interest. Deductible against rental income on Schedule E; principal payments are not.

  • Utilities. Electricity, gas, water, internet, and trash service for the rental.

  • Supplies. Toiletries, paper goods, coffee, linens, and other guest consumables.

  • Cleaning and maintenance. Cleaning crew payments, lawn care, pool service, and routine upkeep.

  • Repairs. Fixing what's broken (a leaking faucet, a chipped wall) is deductible in the year paid; improvements that add value are capitalized and depreciated.

  • Insurance, property tax, HOA fees, and management fees. Each gets its own expense category.

Categorize every expense at the property level using the same tagging system you use for revenue. Mixed-use properties—where you also stay in the unit—require splitting expenses between personal and rental use by days of each.

Common Airbnb bookkeeping mistakes

Recording the net deposit as rental revenue is the most common Airbnb bookkeeping error, and once reconciliation slips, the rest of the cleanup gets harder.

  1. Recording net deposit as rental revenue. Record the gross booking amount plus separate platform service fee lines, per the clearing account method.

  2. Skipping cleaning fee pass-through treatment. Record the cleaning fee as booking revenue on the reservation record, and record the cleaning crew payment as a separate expense. Both sides must appear in the books.

  3. Assuming Airbnb handles all occupancy taxes. Check each property's state and city obligations. Airbnb collects and remits in many jurisdictions, but not all. Where it doesn't, the occupancy tax is your liability.

  4. No per-property tracking. Use class tracking, tracking categories, or native property tagging. Without per-property detail, a portfolio-level P&L won't tell you which listing is actually performing.

  5. Annual reconciliation only. Reconcile monthly at minimum. Delay it to year-end, and the cleanup takes much longer.

  6. Filing on the wrong tax schedule. Review the nature of the stays and the services you provide with a CPA before filing.

Tax compliance touchpoints for Airbnb hosts

Airbnb bookkeeping touches tax reporting at several points: the forms you receive or issue, your Schedule E versus Schedule C classification, and the quality of records supporting your filing position if questions come up later.

Tax forms to know. Form 1099-K reports platform payouts to you; for 2026, the reporting threshold is $20,000 and 200 transactions. Whether or not you receive one, rental revenue remains taxable. Form 1099-NEC is the form you, the landlord, may need to issue to unincorporated contractors—cleaners, handymen, repair vendors—when annual payments reach the IRS reporting threshold for nonemployee compensation. Confirm current 1099 payment and filing requirements with a certified public accountant (CPA) before year-end.

Schedule E versus Schedule C. Schedule E generally applies to passive rental activity; Schedule C applies when the activity looks more like an operating business because of stay pattern or substantial services. If you provide daily housekeeping, concierge service, or meals to guests, the IRS may treat the activity as Schedule C, which can trigger self-employment tax and affect the qualified business income deduction. Confirm your classification with a CPA.

Noncompliance risk. A U.S. Treasury tax gap analysis groups rental income with other opaque income sources where limited third-party reporting is associated with higher noncompliance rates. Clean Airbnb bookkeeping, with gross revenue properly recorded on Schedule E, gives you cleaner support for what you report.

Set up the reconciliation workflow before the next payout

Record each reservation at its gross amount, route it through a Payment Clearing Account, and keep every property's revenue, fees, and taxes visible before month-end instead of buried in one bank-feed line. Done consistently, that hands your CPA clean per-property data at year-end instead of a stack of pooled deposits to untangle.

Relay handles the upstream banking side of that setup. Open a separate checking account for each property so payouts arrive already attributed, set automated transfer rules that move part of every deposit into tax and maintenance reserves, and connect QuickBooks Online or Xero so each account feeds clean data into your books before monthly close. To route payouts by property and keep reconciliation contained, open a Relay account.


Frequently asked questions

How do I do bookkeeping for multiple Airbnb properties?

Use a Payment Clearing Account with class tracking in QuickBooks Online or tracking categories in Xero to attribute each reservation to the right property. For less manual work, open a separate Airbnb host account per property routed to separate bank accounts.

Why is my Airbnb deposit smaller than the booking amount?

Airbnb nets out the platform service fee and, in some jurisdictions, occupancy taxes before depositing. Recording the net figure as rental revenue leaves booking revenue and deductible expenses mixed together on your books.

What is the 14-day rule for Airbnb hosts?

The 14-day rule (or "Augusta rule") lets you rent a personal residence for fewer than 15 days a year without reporting the income, but you also can't deduct rental expenses against it. At 15 days or more, all rental income becomes reportable and expenses must be allocated between personal and rental use. Confirm with a CPA.

What chart of accounts should I use for an Airbnb business?

Mirror Schedule E line items: rental income, cleaning fee income, platform service fees, cleaning expense, repairs, utilities, supplies, insurance, mortgage interest, depreciation, property tax, and management fees. Add a Payment Clearing Account (current asset) and a liability account for occupancy taxes you remit yourself, then tag each with class tracking or tracking categories.

Should Airbnb income go on Schedule E or Schedule C?

Schedule E covers passive rental activity; Schedule C applies when substantial services or stay patterns push the activity into business territory. That can trigger self-employment tax and affect the qualified business income deduction. Confirm with a CPA.

What is the easiest way to reconcile pooled Airbnb payouts?

A Payment Clearing Account in QuickBooks Online or Xero is the standard method for matching per-reservation gross amounts against net pooled deposits. Automation tools cut manual entry, and for smaller portfolios, monthly manual reconciliation is manageable.

More about the authorThe Relay Editorial Team produces practical, expert-backed content for small business owners navigating the financial side of running a company. Our work is informed by contributions from CPAs, advisors, and experienced operators, and held to rigorous editorial standards for accuracy and relevance. Relay is a banking platform built for small businesses—and our editorial mission reflects that focus.View more articles by Relay Editorial Team

Relay is a financial technology company and is not an FDIC-insured bank. Banking services provided by Thread Bank, Member FDIC.