Skip to main content
Solved

Report that captures Night stayed in for Tax Preparation

  • February 5, 2026
  • 3 replies
  • 34 views
J

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. 

Best answer by MattJones

This can be achieved in the reservation report using filters for ‘Overlapping’ reservations but the breakdown you need can’t be done easily. The best option here, if you are confident with excel, is to export the report and run a pivottable - mews has a # of nights field in that export so you can filter by number of nights.

 

For yours I would probably just export to excel a report on Overlapping reservations between a certain set of dates and create a very simple set of formulas - countif on the nights field for COUNTIF(A2:A5000,”>30”) as an example for how many are above 30 nights, and so on for the nights counts. Expand to COUNTIFS function for between certain dates

 

On the reservation export there is a nights tab - go to that and select all between specific dates to get reservation values or on that sheet at the top, insert two new rows, one for count and one for revenue and do SUMIF and COUNTIF for the columns to get a count and revenue figure.

3 Replies

J
  • Jigawho
  • Author
  • Navigator
  • February 10, 2026

Anyone with any thoughts?

MattJones
Forum|alt.badge.img+2
  • MattJones
  • Answer
  • February 13, 2026

This can be achieved in the reservation report using filters for ‘Overlapping’ reservations but the breakdown you need can’t be done easily. The best option here, if you are confident with excel, is to export the report and run a pivottable - mews has a # of nights field in that export so you can filter by number of nights.

 

For yours I would probably just export to excel a report on Overlapping reservations between a certain set of dates and create a very simple set of formulas - countif on the nights field for COUNTIF(A2:A5000,”>30”) as an example for how many are above 30 nights, and so on for the nights counts. Expand to COUNTIFS function for between certain dates

 

On the reservation export there is a nights tab - go to that and select all between specific dates to get reservation values or on that sheet at the top, insert two new rows, one for count and one for revenue and do SUMIF and COUNTIF for the columns to get a count and revenue figure.

Director of Revenue and Technology (Chief Tech Nerd) at www.effectivehospitality.co.uk
    J
    • Jigawho
    • Author
    • Navigator
    • February 16, 2026

    This can be achieved in the reservation report using filters for ‘Overlapping’ reservations but the breakdown you need can’t be done easily. The best option here, if you are confident with excel, is to export the report and run a pivottable - mews has a # of nights field in that export so you can filter by number of nights.

     

    For yours I would probably just export to excel a report on Overlapping reservations between a certain set of dates and create a very simple set of formulas - countif on the nights field for COUNTIF(A2:A5000,”>30”) as an example for how many are above 30 nights, and so on for the nights counts. Expand to COUNTIFS function for between certain dates

     

    On the reservation export there is a nights tab - go to that and select all between specific dates to get reservation values or on that sheet at the top, insert two new rows, one for count and one for revenue and do SUMIF and COUNTIF for the columns to get a count and revenue figure.

    Will give this a try. Thank you. 

    Terms and ConditionsCookie settingsAccessibility statement