How to do bookkeeping for an Airbnb business?

Book each Airbnb payout as one deposit that equals the bank lump, with lines for accommodation, cleaning, the host service fee, and occupancy tax paid out to you. Rec the bank to the Paid CSV on the payout date. Do not Categorize the AIRBNB line as income.

This is the monthly cycle for a small property-management office on Guesty, AppFolio or Rentvine that keeps a few short-term listings, and for the host who owns those listings and keeps the books in QuickBooks Online because the CPA lives there. Pull last month’s Paid CSV, the bank statement for the account Airbnb pays, and the management agreement that says who keeps cleaning.

The bank shows one number

The bank shows one AIRBNB lump. Airbnb shows several rows that add up to that lump. A payout is the cash Airbnb sent, not one reservation.

Airbnb’s payout help, read 2026-11-03, writes the formula as nightly rate plus extra charges minus the host service fee and any co-host share. That net should equal the bank line. Hosts on property-management software sit on the single-fee structure. Most of those hosts pay 15.5 percent, taken from the payout, read 2026-11-03. Read the Airbnb service fee line on the earning, not a remembered rate.

Line on the Paid CSV	Firm-owned listing	Managed door
Accommodation	Rental income	Owner funds
Cleaning fee	Income if the firm keeps it	Owner funds, or sweep to operating
Host service fee	Channel-fee expense, as a negative	Charged to the owner who kept that money
Occupancy tax Airbnb remitted	Skip it. It never hit the bank	Skip it
Occupancy tax paid out to you	Occupancy-tax payable	Occupancy-tax payable
Co-host share paid to someone else	Skip it	Skip it

How to download the Paid CSV is that file. The guest receipt is not. Group rows by the amount and date that hit the bank, not by confirmation code. Airbnb’s earnings dashboard says several listings with reservations that start on the same day may pay out as one row.

Booking the bank lump as sales is how QuickBooks looks profitable while the 1099-K is higher by the host fee. On r/QuickBooks in March 2025, a host with three listings booked the net feed as income and could not match Airbnb’s 1099-K. A class per listing is enough. On r/airbnb_hosts in November 2024, a CPA who books for hosts said ten properties sit on one QuickBooks Online file that way.

Record the money during the month

Do this as cash lands. Date the deposit to the bank date. How to reconcile Airbnb payouts in QuickBooks Online is the click path.

Intuit’s record bank deposits help, updated 2026-08-03, is this path. Put the fee on the deposit. Guests paid Airbnb, so skip Undeposited Funds unless you already recorded sales receipts.

1. Pull the Paid CSV for the bank-statement dates. Airbnb’s download help, read 2026-11-03, says that spreadsheet includes earnings, the host service fee, cleaning, gross earnings and any taxes withheld.
2. Group CSV rows to each AIRBNB bank line.
3. Build one Bank Deposit per lump. Accommodation, cleaning, host fee as a negative, occupancy tax paid out to you as a liability. The total equals the bank to the cent.
4. Match the bank feed. Intuit’s categorize help, updated 2026-08-24, treats Post or Add as a new ledger entry. Categorize on an Airbnb payout records the cash twice.
5. Enter the cleaner bill when you pay them. Track W-9s. For payments made in 2026, the IRS 1099-NEC threshold is $2,000, up from $600 for payments made before 2026.

Example, not a real office. Accommodation $800, cleaning $150 the firm keeps, host service fee −$147.25, occupancy tax remitted so it is not in the payout. Deposit $802.75.

If the listings run through Guesty, Guesty’s payout article, read 2026-11-03, says a short-term payout can take 72 hours to show, and a co-host split leaves Guesty seeing only the host share. Use Airbnb’s CSV when Guesty and the bank disagree.

Occupancy tax is not rent

Occupancy tax is money held for a tax authority, or already sent there. Airbnb’s tax-collection help, read 2026-11-03, says remittance does not change the host payout. It may collect a regional tax and not a local one. Check Listings, the listing, Settings, Taxes. No local tax-collection section means Airbnb is not remitting for that listing.

Texas is the example. The Texas Comptroller, read 2026-11-03, sets state hotel occupancy tax at 6 percent of the room cost. Airbnb’s Texas page says it remits that 6 percent, including cleaning, for stays of 29 nights or shorter, plus listed local taxes. Hosts still owe taxes Airbnb does not list. Other states differ. This is not tax advice. Check the listing, the agency and your CPA.

Close the month on the payout date

Pick the bank-statement date first. Run the Paid CSV to that date. The usual miss is matching a check-in date to a deposit that landed days later. On ACH in the US, Airbnb’s payout timing, read 2026-11-03, is 3 business days after release, or 3 to 5 for a bank account. Weekend batches wait. A review can delay funds up to 45 days after check-in. Leave those unmatched until Paid.

Airbnb’s US tax-document help, read 2026-11-03, reports gross reservation totals before Airbnb fees, including cleaning paid out to you, pass-through taxes and co-host payouts. Occupancy taxes Airbnb remitted are not in Gross Amount. Their example is $500 lodging plus $90 cleaning plus $10 pass-through tax = $600 reported, then −$18 fees and −$114.40 co-host = $467.60 net. Filter the CSV on Earnings Year for the 1099-K. Tie month-end to the payout date. A January bank line can be prior-year earnings on Airbnb’s side.

IRS Topic 414 (read 2026-11-03) says most individuals count rental income when they receive it. It points rental real estate at Schedule E, and at Schedule C when you provide substantial services primarily for the guest’s convenience. Publication 527 (2025) is that packet. This is not tax advice. Ask your CPA which form you file. Managed doors still close with a three-way rec after the splits.

When the lists still disagree

Work CSV-to-bank first, then bank-to-QuickBooks.

Symptom	Likely cause	What to do
Bank is smaller than gross by about the fee	Gross in the books, net at the bank	Negative host-fee line on the deposit
QuickBooks income is the guest total	Categorize on the feed, or tax booked as rent	Reverse it. Match the split deposit
QuickBooks income is the bank lump	Host fee never booked	Add the fee so gross matches Amount plus Host Fee
Bank line has no matching deposit	ACH lag, weekend hold, or a review	Wait until Paid
CSV total is higher than the bank	Adjustment taken from this payout	Airbnb adjustments come out of the next payout. Put them on this deposit
1099-K higher than the P&L	Cleaning, pass-through tax, or co-host share missing	Read Gross Earnings against Box 1a

What the software already does

Airbnb wins the Paid CSV and the 1099-K. Guesty wins reservation-level payout status. QuickBooks Online wins the two-way rec. AppFolio, Rentvine and Buildium win owner ledgers and the three-way rec on long-term doors.

Job	Airbnb	Guesty	QuickBooks Online	AppFolio, Rentvine or Buildium
Source of truth for the payout	Yes, the Paid CSV	Reservation status	No	No
Split rent, cleaning, fee, tax	The report already knows	Partial	Yes, one Bank Deposit, then Match	Only if you built the split
Two-way bank rec	No	No	Yes, native	Yes
Owner ledgers and three-way rec	No	No	No. Bank vs register only	Yes, that is the product
1099-K to the listing owner	Yes, when the threshold is met	No	No	No

Airbnb’s QuickBooks sync, read 2026-11-03, wins a monthly price-item post for home hosts who connect listings. Someone still has to Match the bank.

How to tell this month is closed

Every AIRBNB bank line is Matched to a deposit that equals the statement to the cent. Each deposit has accommodation, cleaning, host fee and, if it paid out, occupancy tax. Rent for managed doors sat in owner funds. The Paid CSV total for the statement dates agrees with those deposits.

Pull last month’s Airbnb Paid CSV, the Guesty payout report if you use one, and the bank statement for the account Airbnb pays. Start with those three files. They already exist.