Unfortunately, the reports that AirBnb offers are rather pitiful. Having said that, below please find my structure and process for doing this via QB (Quickboooks).
My structure
1) Airbnb 'Bank Account' in COA (This is where I post money [full amount] received by Airbnb on my behalf. Its not a real 'bank account' - just a holding account since they hold the money for me until they payout).
2) My bank account (This is where I transfer money from Airbnb 'bank account'. This is a real bank account and where I receive my payouts after Airbnb has taken their share)
3) Airbnb 'supplier' (This is where I enter the Airbnb invoices for their comms. These invoices/bills get paid from the "Airbnb bank account" (1) above before transferring to (2) above).
4) Airbnb 'customer' (This is where I enter my invoices to the end customer/person im hosting. You may choose to make a new customer per person you host, but for simplicity, I've put it all under one). Money received from the customer (Airbnb processes the payment) goes to pay this invoice and is deposited in Airbnb "bank account" (1) above.
My process
Might not make sense to you, its notes I have so I remember what to do each month since Airbnb's reports make this whole process a nightmare.
Make Airbnb (supplier) bills for Sales of Period
====================================
Host > Reservations
1) Filter for ALL and the statement period
> Print invoices for that month
> Add to QB
> Pay from "Airbnb"
Reconcile
========
1) Get Statement/Transaction History > *Completed Payouts*
https://www.airbnb.com/users/transaction_history
All Payout Methods + All Listings + Select Period > Download CSV
2) With CSV:
- Add total field at the end
- Delete Reference Field
- Resize Listing field to overlap Details field
- Add Title "Transaction History "+ Y-m
- Bold Title Fields
- Currency the amount fields
- Resize Fields
3) Print CSV
4) Add QB Customer Invoices
5) Reconcile "Airbnb"
Another thing that makes this whole thing a nightmare is the fact that Airbnb issues multiple invoices/bills for a single reservation when that reservation has had extensions. That means you get two invoices from Airbnb for example, difference invoice numbers, both for the same amount. So for example, if "John" stays at your place for 1 day and Airbnb takes "10$" as comms - they issue an invoice "123" for 10$.
If John decides to extend his stay for another day, instead of Airbnb simply giving you a new invoice "124" for an extra 10$ - they give you a new invoice "124" for the original 10$ plus the new 10$. They also revise invoice 123 to have the new 10$.
This means you now have invoice 123 for 20$ and invoice 124 for 20$
Not only is this entirely wrong (and illegal in my eyes) - but totally confusing. They only take 20$, so why do you now have two bills for 20$ each?
Anyway, what I end up doing is printing the latest one (in this case, 124) and only inputting that one.