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. Click Analysis > information library > add an ad hoc query
  2. Choose the Reservations Record Type and the group sales reservations source view
  3. Under browse for fields in click on the Order field > drag sales order status from the middle column to the include records where section. Change the first textbox to Not one of > then click on complete and click the arrow pointing to the right to send that status over. Then repeat that process with Cancelled so only Complete and Cancelled show in the right column. Click OK
  4. Under browse for fields in click on Group Sales Reservations > drag Arrival date from the middle column to the include records where section. Change the first textbox to After and the second textbox to today
  5. Drag that same arrival date field that you used in the last step from the middle column to the Results fields to display section
  6. Under browse for fields in expand order by clicking the '+' next to the field.
  7. Click on Sales order Payment > drag amount from the middle column to the Results fields to display section (This will display any payments added to the order)
    1. If you would like to total all of the payments to reduce duplicates click on the Order\Sales Order Payment\Amount field. Then click on the summarize icon above Results fields to display text
    2. Choose SUM
  8. Click on Order under browse for fields in > drag amount from the middle column to the Results fields to display section (This will display the overall amount of the order)
User-added image