Hello All
I need to prepare my lodging tax return. This is due every quarter. We are new to MEWS and have been on it for three months.
I need the following information (Keyword here is STAYED in):
- How many room nights stayed in by the guests at the hotel
- How many of those nights came from OTAs
- How many reservations were were 7-30 nights stayed in
- How many reservations were 30+ night stayed in
- How much revenue from nightly stay within a given period
- How much revenue from 7-30 nightly stay for a given period
- How much Revenue from 30+ nightly stay in a given period
I have been trying to figure this out from the reservation report, but this is not helping since it pulls data from when the reservation was created, or overlapping etc. It need data for nights that were consumed (for lack of better word) or STAYED in (regardless of when the reservation was created or modified or updated). Taxes are collected when the night is stayed in.
Any guidance you can provide would be much appreciated.