Reports: Commerce (New): Balance Due (Excel)

This report displays the outstanding balances from the reservation activity for an event within the given date range.

This report displays in your web browser. You can also view the report in Excel by choosing the Balance Due (Excel) report.

To run the report:

  1. Select an event by doing one of the following:

  1. Enter the date range, which is the first to last date of reservation activity to be included in the report.

  2. Select the reservation status (active, cancelled, or both) to view in the report from the Choose Reservation Status drop-down list.

  3. Select the form of payment to view in the report from the Choose Form Of Payment drop-down list.

  4. In Select Sort Options, choose to have the report sort on the user's last name, company name, or hotel name.

  5. Optionally, check the Show only reservations with incomplete. box to filter the report to show only those transactions that require your attention.

  6. Optionally, check the Show reservations with manual adjustments. box to show those transactions that have had manual adjustments, such as refunds or manual charges.

  7. Click Generate Report.