I am working with the unearned revenue portion of the total revenue and payment report. I noticed something as I was pulling a report. As we check in group sales, I have noticed that the revenue moves around depending on what dates I pull.
The Unearned Revenue section of the Total Revenue and Payments reports displays group sales over payments, prepayments and refunds. Reservation deposits or payments made in advance for group sales are considered unearned. Payments are unearned revenue until the group is checked in. When a group is checked in the revenue moves from unearned to earned. If you run the Total Revenue and Payment report for a date when a reservation has not been checked in or has not occurred the revenue will show in the Unearned Revenue. If you then run the report for a date after the reservation has occurred and been checked in, the revenue will show as earned. Since you have already accounted for the revenue the move from Unearned to Earned Revenue should not affect your reporting.