Skip to content

Blog

How to Reconcile Airbnb Payouts to Your Bank and Your 1099-K

Vivek Agrawal, CA, Founder ·

Chartered Accountant (ICAI) and Certified QuickBooks ProAdvisor with 6+ years of experience, founder of FinAccurex. About the team · All posts

Your Airbnb bank deposits will almost never match the gross figure on your Form 1099-K, and that is expected. The 1099-K reports gross payments. Your bank receives net payouts, after the host service fee, refunds and other adjustments have come out. To reconcile, record every reservation at its gross amount, record the fees and refunds as separate lines, and run the net through a clearing account that should reach zero when the deposits land. Do that every month and the year-end 1099-K becomes a check on your books instead of a surprise.

This guide walks through the monthly method we use, a worked example with one month of numbers, and how to compare the year-end form to your ledger.

Why deposits are not your income

Most hosts start bookkeeping by treating each Airbnb deposit as income. It feels natural: money arrives, you book it. The problem is that a deposit is a net number. By the time it reaches your account, three things have usually happened:

  • Fees have been taken out. The host service fee is deducted before the payout is sent.
  • Refunds or adjustments have been netted off. A partial refund to a guest, or a resolution adjustment, reduces the payout.
  • Timing has shifted. A payout can land in a different month from the stay it relates to, so one month's deposits and one month's bookings rarely line up exactly.

If you book deposits as income, your revenue is understated (because fees are hidden inside it) and your expenses are understated by the same amount. Your net profit may look right, but your gross income will not match the 1099-K, and that gap is what prompts questions.

What the 1099-K actually reports

The IRS is direct about this. On its page explaining what to do with Form 1099-K, it says the gross payment amount in Box 1a "isn't adjusted for any" fees, credits, refunds, shipping, cash equivalents or discounts. It adds that you can deduct those items from the gross amount, and that good records are what support the income and expenses you report.

Two other points from the same IRS page matter for hosts:

  • You must report income even without a form. If you received payments for goods, services or property, you report the income whether or not a 1099-K arrives.
  • Rental income may be reported on Schedule E or Schedule C. Which one applies is a question for your CPA, not your bookkeeper.

On the threshold itself, the IRS page Understanding your Form 1099-K, last reviewed 28 June 2026, says payment apps and online marketplaces must report payments on Form 1099-K when the total payments you receive for goods or services through the platform exceed $20,000 in more than 200 transactions. Check the current IRS threshold before you file.

For bookkeeping, the threshold matters less than you might think. Whether or not you get a form, your books should carry gross income, fees and refunds as separate lines. That way you can explain any form you do receive.

The monthly method

Here is the routine, in order.

1. Pull the reservation detail behind each deposit

Start with the payout detail from your Airbnb account: the report that lists each reservation behind each payout, with its gross amount, the host fee and any adjustment. Your bank statement tells you what arrived. The reservation detail tells you why.

2. Set up an Airbnb clearing account

In QuickBooks or Xero, create a current asset account named something like "Airbnb Clearing". Every reservation is posted here at gross. Fees and refunds are posted against it. Bank deposits are then matched out of it. If you use more than one channel, give each one its own clearing account, so a Vrbo difference never hides inside an Airbnb balance.

3. Record gross income, fees and refunds separately

For each month:

  • Credit rental income with the gross booking amount.
  • Debit a "Platform fees" expense account with the host service fees.
  • Debit a refunds or "Guest refunds and adjustments" account (a contra-income account works well) with any refunds.
  • Debit the clearing account with the net.

4. Match the deposits

When each payout arrives, match the bank deposit to the clearing account. At month end, the clearing account balance should equal only the payouts that are still in transit. Anything else is a difference to investigate.

5. Tie it out

Write down four numbers every month: gross bookings, total fees, total refunds and total deposits. Gross minus fees minus refunds, adjusted for payouts in transit, should equal deposits. If it does not, the answer is almost always a missed reservation, a refund booked twice, or a payout that belongs to the next month.

Worked example (illustrative numbers)

Example only. These figures are invented to show the method.

A host has three reservations in March. One guest received a $150 partial refund after a broken appliance.

ReservationGrossHost feeRefundNet payout
A$1,350.00$40.50$0.00$1,309.50
B$2,100.00$63.00$150.00$1,887.00
C$900.00$27.00$0.00$873.00
Total$4,350.00$130.50$150.00$4,069.50

The March journal entry:

AccountDebitCredit
Airbnb Clearing$4,069.50
Platform fees$130.50
Guest refunds and adjustments$150.00
Rental income$4,350.00

Two deposits arrive in March for A and B, totalling $3,196.50. The payout for C arrives on 2 April. At 31 March the clearing account shows $873.00, which is exactly reservation C in transit. The books reconcile.

Now the part that matters at year end. If this host booked deposits as income, March revenue would show $3,196.50. With the clearing method it shows $4,350.00 gross, with fees and refunds visible underneath. Over twelve months, the gross figure in the books is the one you compare to the 1099-K.

Comparing the 1099-K to your books

When the form arrives:

  1. Take the Box 1a gross amount.
  2. Pull your rental income account for the same calendar year, filtered to the Airbnb clearing account.
  3. List the differences. The usual ones are timing (a stay booked in December with the payment in January, or the reverse), refunds, and any reservation you missed.
  4. Keep the reconciliation as a one-page schedule and hand it to your CPA with the year-end package.

If the gross amount on the form looks wrong after that review, the IRS page on what to do with Form 1099-K explains the steps for an incorrect form. Your bookkeeper's job is to give you the evidence. What you file is your CPA's call.

Common mistakes

  • One income account for everything. Cleaning fees, nightly rent and pet fees all land in one line, so you cannot tell what is driving revenue.
  • No clearing account. Deposits go straight to income and the host fee disappears.
  • Refunds booked as expenses in the wrong place. A refund is a reduction of income, not a repair or supplies cost.
  • Mixing personal and rental accounts. If payouts land in a personal account, reconciliation takes far longer.
  • Waiting until tax season. Twelve months of differences are much harder to trace than one.

When the volume grows

The method is the same for one listing or seventy. What changes is the time it takes. One of our clients, a vacation rental manager with 70 properties across 6 states on Guesty and QuickBooks Online, was spending more than 15 hours a month on manual reconciliation, and owner statements went out 12 to 15 days late. After we automated the Guesty to QuickBooks pipeline, monthly reconciliation dropped from 15 hours to under 1 hour and statements moved to within 5 days. The full story is in the 70-property case study.

If you own your properties and want a monthly routine like this run for you, see our Airbnb bookkeeping service.

A short checklist

  • Clearing account per channel, set up once.
  • Reservation detail downloaded every month.
  • Gross, fees and refunds posted as separate lines.
  • Deposits matched, in-transit payouts listed.
  • Year-end: 1099-K compared to the gross income account, differences listed on one page.

If you would rather hand this off, our Airbnb bookkeeping team can set up the clearing accounts, reconcile each month and prepare the year-end schedule for your CPA. Book a 15-minute call and we will look at your current setup with you. Confirm the treatment with your CPA.

Want this handled for you every month?

Book a 15-minute call
Book a Free Call