Payments In/Out Report

The Payments In/Out Report indicates how much you have collected from a party (payments in), how much you have paid providers for the party's purchases (payments out), group payables, and actual sales for the party.

Before the party or group is closed out, the report shows you what you have taken in, paid out, and how much you owe. After the party or group is closed out, it shows you how much profit you made on the group or party.

The report includes the party code and primary contact for each party. The report also includes the following information for each transaction:

• Transaction number
• Transaction type
• Passenger name
• Provider code
• Transaction amount

The transaction amount appears in a column for sales, provider payables, party payments and refunds, or provider payments, depending on the transaction type.

For each party, the report shows the available funds (total party payments less refunds less payments made to providers) and the totals for provider payments, party payments and refunds, provider payables, and actual sales. At the end of each group is the same information for the group.

Payments and checks will not appear on the report until they have been applied to group transactions. On account items are not included on this report.

You have the following options:

• Include the first comment line on the report.
• Sort by account ID, party ID, or passenger.
• Include a particular party ID, a particular passenger, or an account ID. If including an account ID, you can use @tagged or @interest feature to print tagged account IDs or those with an interest.
• Include journal entries; that is, any adjustments made directly in the general ledger for the group not included in the available funds calculation.
• Enter one or two remarks for the report heading.

Running the Report

To run the report:

1. On the Groups submenu, click Payments In/Out Report.

   The Payments In/Out Report dialog box appears.

   Payments In/Out Report dialog box

   

   Field descriptions

   The following table describes the fields in the Payments In/Out Report dialog box.

   Field	Description
   Group ID	Identifier of the group for which to run the report. Leave this field blank to include all groups. To find and select a group ID, click the lookup () button. The Find Group screen appears. For details, see Using the Lookup Buttons and Screens.
   From (for date range)	Beginning date of a range of transaction dates. Use this date in conjunction with the To date to define a range. If you specify only the From date, the range includes all dates from this date to the current date.
   To (for date range)	Ending date of a range of transaction dates. Use this date in conjunction with the From date to define a range. If you specify only the To date, the range includes all dates before and including this date.
   Sort By	Indicates how to sort the report data. Select one of the following sort options from the drop-down list: Party ID – Sort by party ID. Passenger – Sort by passenger name. Account ID – Sort by account ID. You can use the Select On field to include only a specific party ID, passenger name, or account ID on the report.
   Select On	Indicates the specific party ID, passenger name, or account ID to include on the report. This must match the type of data selected in the Sort By field. For example, to run the report for passenger name JONES/MARK, select Passenger in the Sort By field, and specify JONES/MARK in the Select On field. If sorting by account ID, you can specify @TAGGED to include tagged accounts only , or @ followed by a customer interest code (for example, @SKI) to include only accounts with that interest.
   Subtotal	Indicates whether to subtotal on the selection in the Sort By field.
   Include Journal Entries	Indicates whether to include journal entries (payment type and amount).
   Include Comment #1	Indicates whether to include the first comment from the invoice item.
   New Page per Group	Indicates whether to start each group on a new page.
   Summary Only	Indicates whether to create a summary-only report (available funds and totals for each group, and if subtotaling, the party ID, passenger, or account ID).
   Header Message	Message text to include in the header area of the report. You can provide one or two messages.

2. Complete the fields as appropriate.
3. Choose one of the following print options:

   • To print the report immediately, click PRINT.

     The Send to dialog box appears. Select a report destination. For more information, see Printing Overview.

   • To store the report as part of a batch for printing later, click BATCH.

     The Choose a Batch dialog box appears. For more information, see Batch Printing.

Report Example

Payments In/Out Report example