Running the Credit Card Summary Report

Run a Credit Card Summary Report to list all the approved credit card transactions for a specific date range or batch number. Both voice-authorized and system-authorized credit card transactions display in this report. Use the totals on this report and compare them to the totals on the Cash Box Journal when run for credit card types. For more information, see Cash Box Journal.

To run a Credit Card Summary Report:

From the A/R > Reports/Journals menu, select Credit Card Summary Report to display the Credit Card Summary Report window.
In the Processor field, press F10 and select the processor that you use to settle your credit card transactions. You can run the report for Worldpay, or other processors such as VITAL. The default is to run the report for all processors.

In the FilterBranchfield, enter the branch or territory to filter the merchant numbers available for that branch. Your selection here restricts the merchant numbers available to run the report for in the Merchant Number field.
In the Merchant Number field, enter the ID number of the merchant to run the report for a single merchant ID. To run the report for all merchants, select All. If you are using Worldpay Payment Processing, the merchant number is the Worldpay acceptor ID.

Your processing firm assigns you a merchant number. You might have multiple merchant numbers if you have multiple branches or use more than one processing firm.

If you entered a branch or territory, or combination of branches and territories in the Filter Branchfield you can only run the report for the merchants that are defined for the specified branches and territories.
If you specify a merchant number and that merchant number is also used by a branch that you did not select, any orders for that merchant number at that branch are included in the report, even though you did not select that branch in the Filter Branchfield.

In the ReportBranchfield, enter the branch, branches, or territories for which you want to run the report.
In the Start Date and End Date fields, enter the first and last date of the period you want to include in the report.
In the Batch Number field, enter the batch number assigned in the End of Day Settlement Report for VITAL and TSYS, or the batch number provided by Worldpay Payment Processing.
In the Sort by field, select how you want to sort the contents of the report, for example, by manual or automatic authorization.
In the Select by Date field, if you have changed the payment date on a credit card transaction, select one of the following to determine which date to run the report by:

Cash Box - Uses the override date.
Authorized - Uses the original authorization date.

Set options, if needed, and run the report.

What the Report Shows

The Credit Card Summary Report provides the following information:

Column	Description
Order #	The sales order number to which the credit card payment applies.
Br	The branch where the sales order was take and the credit card transaction initiated.
Type	The credit card company, such as VI for Visa and MC for Master Card.
Tran Amount	The dollar amount requested for payment. Compare the total of this column with the total of the CCard column for reconciliation purposes on the Cash Box Journal Report.
Collect Amount	The dollar amount the collect. The amount in this column should match the amount in the Tran Amount column, except for pre-authorizations, as pre-authorizations are not actual payments.
Auth Amount	The authorization method for the transaction, for example, if ti was an automatic authorization, or a voice authorization that was entered manually.
Tran Dt	The date the transaction occurred.
Collect Dt	The date when funds were collected from the bank for the transaction.
Batch #	The number assigned to the group of transactions in which this transaction was processed. The system assigns a batch number when you run the Credit Card End of Day Settlement Report.
Settle Dt	The date when the settlement occurred. The settled date does not display if you ran the report for only the Worldpay processor. Use the Transaction ID to identify the transaction instead.
Settle Info	Any information relative to the settlement of the transaction, for example, whether the card was accepted or declined. The settle information does not display if you ran the report for only the Worldpay processor. Use the Transaction ID to identify the transaction instead.
Transaction ID	If you use Worldpay Payment Processing, the report includes the Worldpay transaction ID instead of a settlement date and settlement information. The transaction ID, identifies the transaction to you within the Worldpay system.
Merchant #	The merchant ID number that the processing firm assigned to you, and that the transaction was processed under. If you are using Worldpay Payment Processing, this is your Acceptor ID.
Processor	The processor used for the transaction, such as Worldpay or Vital.