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 is the best way to track crew labor hours by project?
Track labor daily using time tracking apps or paper timesheets with one person responsible for each crew. Capture hours by job and task type, and review entries weekly before closing them out.
Read answerWhat deductions are available for New Mexico GRT?
New Mexico GRT allows deductions for sales for resale, out-of-state shipments, subcontractor payments, and government sales. You'll need proper documentation including NTTCs to claim them.
Read answerHow do I prepare my books for my CPA?
Start by reconciling all bank and credit card accounts through year end. Then clear up any uncategorized transactions, document major purchases, and organize supporting records like receipts and contracts your CPA might need.
Read answerHow do I handle retainage in construction bookkeeping?
Track retainage as a separate receivable on your balance sheet, not as regular accounts receivable. Set up dedicated accounts for both retainage you're owed and retainage you're holding from subcontractors.
Read answerShould owner-operators hire a bookkeeper?
Most owner-operators benefit from professional bookkeeping. The time spent doing your own books is time you're not earning money, and trucking-specific complexities like IFTA and per diem make DIY bookkeeping harder than it looks.
Read answerHow do HVAC contractors track service calls and installations?
Service calls get tracked by category and department metrics, while installations need project-level job costing. The two types of work have different financial characteristics and require different tracking approaches to understand profitability.
Read answer
