Calculate monthly total based on check in date