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 manage cash flow for a remodeling business?
Structure customer payments so money comes in before you need to pay it out. Require deposits that cover materials, set up progress payments tied to milestones, and negotiate supplier terms that give you breathing room between expenses and income.
Read answerHow do I prepare my rental property books for my CPA?
Your CPA needs income and expense totals by property, categorized correctly for Schedule E. Separate each property in your records, distinguish repairs from improvements, and have mortgage statements and receipts ready.
Read answerWhat is the difference between GRT and sales tax?
Sales tax is imposed on the buyer and collected by the business. Gross Receipts Tax is imposed on the business itself for the privilege of doing business in New Mexico. This distinction affects how you price, invoice, and report.
Read answerWhat bookkeeping mistakes do landlords commonly make?
Landlords often commingle personal and rental funds, fail to track income and expenses by property, and misclassify repairs versus capital improvements. Security deposit handling and depreciation tracking also trip up many property owners.
Read answerHow do I know if a construction project is profitable?
A project is profitable when revenue exceeds all costs including allocated overhead. Most contractors undercount costs by missing their own time, vehicle use, and overhead allocation, making jobs look more profitable than they are.
Read answerWhat bookkeeping software is best for real estate investors?
QuickBooks Online works well for most real estate investors because it handles multiple properties, tracks income and expenses at the property level, and produces the reports your accountant needs at tax time. Purpose-built options like Stessa or REI Hub are simpler if your portfolio is strictly rentals.
Read answer
