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
Why are my construction job estimates always off?
Your estimates are probably off because you don't have accurate data on what past jobs actually cost. Without tracking actuals against estimates, you keep repeating the same mistakes on every bid.
Read answerWhat records do truck drivers need to keep for taxes?
Owner-operators need to track fuel purchases with state-by-state details, mileage logs, maintenance receipts, meals and lodging, tolls, equipment purchases, and all licensing costs. Company drivers have far less to track since most employee deductions disappeared in 2017.
Read answerWhat is the best bookkeeping software for contractors?
For most small to mid-size contractors, QuickBooks Online is the standard. It handles job costing, integrates with common tools, and every accountant knows how to work with it. The key is setting it up correctly for contractor needs.
Read answerHow do I calculate cost per mile for my trucking business?
Add up every expense tied to running your truck and divide by total miles driven. The challenge is capturing all costs, not just the obvious ones like fuel and maintenance.
Read answerDo I need separate bookkeeping for each short-term rental?
It depends on your legal structure. If each property is in a separate LLC, yes. If they're all under one entity, you can use one set of books with class tracking to see each property's performance individually.
Read answerHow do I register for a New Mexico business tax ID?
Register for a CRS ID through the New Mexico Taxation and Revenue Department's online portal. The process is free and typically takes a few business days to receive your number.
Read answer
