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
How do I track maintenance and repair costs by truck?
Use classes, tags, or locations in your accounting software to assign each maintenance expense to a specific truck. Capture the truck number, mileage, and repair type for every expense so you can run reports showing total costs per vehicle.
Read answerWhat expenses can I deduct on rental properties?
Rental property owners can deduct mortgage interest, property taxes, repairs, depreciation, insurance, management fees, and travel to their properties. The key is tracking everything and understanding what counts as a repair versus an improvement.
Read answerHow do I track fuel costs and mileage for my trucking business?
Fuel cards capture purchase data automatically, while ELD or GPS systems track mileage by truck and by state. Organize everything by unit number so you can calculate cost per mile and have clean records for IFTA reporting.
Read answerHow do I separate gallery sales from secondary market purchases?
Set up separate income and cost of goods sold accounts for each revenue stream. Consignment sales and secondary market purchases have different accounting treatment because of how you acquire the work and what you owe when it sells.
Read answerHow do I file New Mexico gross receipts tax?
File through the Taxpayer Access Point (TAP) portal after registering for a CRS number. You'll report gross receipts by location code and pay by the 25th of the following month.
Read answerWhat 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 answer
