MTD and YTD Calculations (2024)

Applies to: MTD and YTD Calculations (1) Stayntouch PMS

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)

MTD and YTD Calculations (2)

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.

MTD and YTD Calculations (2024)
Top Articles
Latest Posts
Article information

Author: Jamar Nader

Last Updated:

Views: 5477

Rating: 4.4 / 5 (55 voted)

Reviews: 86% of readers found this page helpful

Author information

Name: Jamar Nader

Birthday: 1995-02-28

Address: Apt. 536 6162 Reichel Greens, Port Zackaryside, CT 22682-9804

Phone: +9958384818317

Job: IT Representative

Hobby: Scrapbooking, Hiking, Hunting, Kite flying, Blacksmithing, Video gaming, Foraging

Introduction: My name is Jamar Nader, I am a fine, shiny, colorful, bright, nice, perfect, curious person who loves writing and wants to share my knowledge and understanding with you.