If you need to see unearned group sales revenue you can view the unearned revenue section in the Total Revenue and Payments section. If you need to output information that is not shown in the total revenue and payments report you can also create a group sales reservations query to group that information

Access the Total Revenue and Payments Report:
  1. Click Revenue > Total Revenue and Payments
  2. Mark show revenue that moved from unearned to earned
  3. Enter your date range and mark any other settings that you would want to include
  4. Click View report
Create a Group Sales Reservation Query
  1. Navigate to Analysis, then click on Information library
  2. Click Add an ad-hoc query
  3. Select the source view of Group Sales Reservations and click OK
  4. In the left column, select Order. From the middle, drag Sales Order Status into Include records where. Set equal to Not One Of and select the following statuses: Complete, Cancelled. Click OK.
  5. In the left column, select Group Sales Reservations. From the middle, drag Arrival date into Include records where. Set equal to After Today.
  6. To display the arrival date: From the middle column, drag Arrival date into Results fields to display.
  7. To display payments added to the reservation: In the left column, expand Order, then select Sales Order Payment. From the middle, drag Amount from the middle column to Results fields to display.
  8. To total all of the payments to reduce duplicates: Within Results fields to display, click on the Order\Sales Order Payment\Amount field. Then click on the Sigma icon above Results fields to display text. Select SUM.
  9. To display the overall amount on order: In the left column, select Order. From the middle, drag Amount into Results fields to display section
Your final query will look similar to below:
User-added image