MTD and YTD Calculations

Modified on: Wed, 12 Oct, 2022 at 10:16 AM

Applies to:          Stayntouch PMS          

MTD and YTD Calculations


Month to Date (MTD) and Year to Date (YTD) on the Manager Dashboard are calculated as described below.


MTD calculation: date_range = MAX(month_start_date, pms_start_date) to current date 
Hourly: Total reservation in the date range / (total_rooms * total_days in the date range)
Nightly: Total occupied rooms in the date range / (total_rooms * total_days in the date range)

YTD calculation: date_range = MAX(year_start_date, pms_start_date) to current date
Hourly: Total reservation in the date range / (total_rooms * total_days in the date range)
Nightly: Total occupied rooms in the date range / (total_rooms * total_days in the date range)


To summarize, the MTD column tracks from the start of the month to the present day and resets every month. The YTD column (which displays as the current year) continues to add up over the year and will only reset on January 1 of the next year. It is what is achieved (history), not a forecast.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.