Skip to main content
Answered

Accounting Help Please!

  • August 6, 2026
  • 1 reply
  • 18 views

MichelleC
Participating Frequently
Forum|alt.badge.img+1

I desperately need some help! ​@Brandon Huetteman doesn’t have any appointment times for the next two months and I can’t get find education anywhere on Hospitable or get answers from Smarty.  I finally hired a bookkeeper and we’re really struggling to find an accurate way to reconcile reported booking payments to what is actually deposited.  Airbnb and Vrbo do lump deposits making it extremely difficult to determine what is what with 18 different properties.  Does anyone have a system or report that works?

Best answer by Brandon Huetteman

Hi ​@MichelleC!

Thanks for reaching out with this, and I definitely can understand how confusing this can be. Whether you are using our QuickBooks integration or just trying to reconcile reservations against payouts, I suggest the same approach. 

I find it helpful to utilize the financial data being provided from the platform that is acting as the Merchant of Record — the ones who are processing the payments from guests and paying the host out. They are going to be the source of truth because they are the actual ones to manage the payment flow from beginning to end. This data helps to match which payouts and reservations match.

Personally, I will use the Transaction Report from Airbnb, the Bank Deposits Report from VRBO, or the Payments and Payouts Data for Hospitable — these would be for whoever is the Merchant of Record. It breaks down the reservations that the payouts apply to, as well as if there were adjustments taken out of the payout for bookings in the past that payments have already been processed for such as resolution adjustments, etc. This allows you to easily reconcile which reservations are included in the bulk payouts. You can use Metrics from Hospitable, however given we do not receive the payment processing data, it would be a bit more tricky to attempt to match reservations with payouts if you have many at a given time. 

1 reply

Brandon Huetteman
Hospitable Team Member
Forum|alt.badge.img

Hi ​@MichelleC!

Thanks for reaching out with this, and I definitely can understand how confusing this can be. Whether you are using our QuickBooks integration or just trying to reconcile reservations against payouts, I suggest the same approach. 

I find it helpful to utilize the financial data being provided from the platform that is acting as the Merchant of Record — the ones who are processing the payments from guests and paying the host out. They are going to be the source of truth because they are the actual ones to manage the payment flow from beginning to end. This data helps to match which payouts and reservations match.

Personally, I will use the Transaction Report from Airbnb, the Bank Deposits Report from VRBO, or the Payments and Payouts Data for Hospitable — these would be for whoever is the Merchant of Record. It breaks down the reservations that the payouts apply to, as well as if there were adjustments taken out of the payout for bookings in the past that payments have already been processed for such as resolution adjustments, etc. This allows you to easily reconcile which reservations are included in the bulk payouts. You can use Metrics from Hospitable, however given we do not receive the payment processing data, it would be a bit more tricky to attempt to match reservations with payouts if you have many at a given time.