Short Term Rental Management Accounting

[Josiah Pisel]

Hello BP! I am looking for advice and recommendations. I own a vacation rental management company and have properties on both VRBO and Airbnb. I am using Guesty for Host as a property management platform and am mostly happy with it. However, I seem to be struggling with putting monthly statements together for owners in Guesty for Host due to the info that Guesty is "pulling" from VRBO. I charge a commission on the reservation only, while the owners get the remainder of the reservation + cleaning fee and I remit the sales tax on their behalf. The info Guesty is "pulling" from VRBO has the reservation amount + the sales tax in one number, which happens to be the same number that Guesty uses to base the commissions off of. This makes all the numbers wrong, rendering the Guesty for Host reports useless.  

Looking for any insight on how to remedy this (reached out to VRBO and Guesty with no solution yet)! Of course we can create a spreadsheet and manually enter everything but this is very time consuming and not scaleable.

Looking for something that is easy to use, time efficient and minimizes time spent on monthly accounting. What are other short term rental management platforms are people using? What are people using for accounting? QuickBooks Online? Wave? Excel?.... 

Thanks in advance!