How do you calculate Occupancy Tax for monthly remitting?

Curious how everyone handles Occupancy Tax reporting.

Because I am API-connected, I collect taxes for my Vrbo and personal website bookings but not Airbnb. To calculate the gross revenue numbers required for remitting taxes, I have to run the OR Tax Summary report twice. Once for "only Airbnb" and once for "Everything but Airbnb". The numbers go in a spreadsheet to calculate totals.

I would love to hear about a better way, or how y'all do it.

Thanks,

Tim

Assuming your situation requires you to report the total bookings, including Airbnb, and then exempt/subtract the Airbnb bookings from the taxable amount.

One option - 

You could run the Tax Detail report, check the taxability box and group the report by Listing Site (last drop down box).

This way all of the Airbnb bookings will be sectioned off. While you'll still have to add the Airbnb, Vrbo,etc. total lines to get the total bookings, the Airbnb amount to exempt will be right there in the same report so you aren't maneuvering multiple reports.

If you have a question more specific to your situation, please reach out to us at the HelpDesk for additional assistance!