How do I reconcile Airbnb payouts in QuickBooks?
The challenge is that Airbnb deposits net amounts after taking their service fee. A guest pays $500 for a weekend stay, Airbnb takes their 3% host fee, and you receive $485. If multiple reservations pay out together, you get one lump deposit that doesn’t match any single booking. Standard reconciliation breaks down when deposit amounts don’t trace to individual transactions.
You have two options for handling this in QuickBooks.
The simpler method is tracking net payouts only. Record each Airbnb deposit as income when it hits your bank. This matches your bank statement and keeps bookkeeping straightforward. The downside is you won’t see your true gross revenue or how much you’re paying in platform fees over time. For vacation rental operators with one or two properties who just need clean books for taxes, this works fine.
The more detailed method tracks gross revenue and fees separately. Record each reservation at its full booking amount as rental income. Then record Airbnb’s service fee as an expense. The difference between the two is what appears as your bank deposit. This takes more time but gives you accurate data on what Airbnb actually costs you and what your true revenue is before platform fees.
Either way, download Airbnb’s payout reports to reconcile. From your host account, find the transaction history or earnings section and export a CSV for the month you’re closing. This report breaks down each reservation, shows the gross amount, lists the fee deducted, and confirms the net payout. It’s the source of truth for matching to QuickBooks.
Watch for timing differences. Airbnb sometimes holds funds across reservation dates or batches payouts in ways that don’t align with when guests actually stayed. Cancellation refunds and resolution payouts can also create discrepancies. If your bank deposit doesn’t match what you expected, the payout report will show adjustments you might have missed.
Cleaning fees need consistent treatment. If guests pay cleaning fees that go directly to your cleaner, decide whether you’re recording that as pass-through revenue or as income with a matching expense. Either approach works as long as you’re consistent month to month.
For multiple properties, use classes or locations in QuickBooks so you can see profitability by rental. Without this separation, you’ll know your overall Airbnb income but not which property is actually making money.
If the reconciliation process feels overwhelming, a small business bookkeeper in New Mexico familiar with vacation rentals can set up your QuickBooks correctly from the start and handle the monthly reconciliation so your books stay accurate without eating into your time.
Santa Fe's Small Business Bookkeeper
The Next Step:
A Quick Conversation
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
What records do I need to keep for Airbnb taxes?
Keep income records from all booking platforms, receipts for every expense by category, property documents for depreciation, and a calendar tracking rental vs personal use days. In New Mexico, you'll also need GRT and lodgers' tax documentation.
Read answerHow do I prepare for IFTA reporting?
IFTA preparation is mostly about what you track throughout the quarter, not what you do at filing time. Keep mileage logs by jurisdiction, organize fuel receipts by state, and file your quarterly return by the end of the month following each quarter.
Read answerShould I use cash or accrual accounting for trucking?
Most small trucking companies use cash basis accounting. It's simpler and shows your actual cash position. Accrual makes more sense when you have significant receivables outstanding or need accurate period-by-period profitability.
Read answerHow do I fix categorization mistakes in QuickBooks?
Open the transaction in QuickBooks, change the category field to the correct account, and save. QuickBooks updates your reports automatically. For older transactions, use the search function or run reports to find what needs fixing.
Read answerHow do I separate business and personal expenses?
Open dedicated business bank accounts and credit cards so every business transaction flows through business accounts only. When mixing happens, record it correctly using owner equity accounts or draws.
Read answerHow do I do bookkeeping for my Airbnb rental?
Track income based on what Airbnb actually deposits, categorize expenses specific to vacation rentals, and reconcile monthly. The tricky part is handling the difference between what guests pay and what you receive after platform fees.
Read answer
