Credit Card Summary Report

Run the Credit Card Summary report to list all the approved credit card transactions for a specific date range or batch number. Use the totals on this report to compare to the totals on the Cash Box Journal when run for credit card types. For more information, see Cash Box Journal.

The report provides the following information:

• The Order # column identifies the number assigned to the sales order.

• The Br column identifies the branch where the transactions occurred.

• The Type column identifies the credit card type, such as VI for Visa, and MC for Master Card.

• The Tran Amount column identifies the dollar amount requested as credit. Compare the total of this column with the total of the CCard column for reconciliation purposes on the Cash Box Journal.

• The Collect Amount identifies the dollar amount to be collected. 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.

• The Auth Amount column identifies the authorization method used for this transaction, for example, whether this was an automatic or manual authorization.

• The Tran Dt column identifies the date when the transaction occurred.

• The Collect Dt column identifies the date when the funds were collected from the bank.

• The Batch # column identifies the number assigned to a group of transactions. This number is assigned when the Credit Card End of Day Settlement Report runs.

• The Settle Dt column identifies the date when the settlement occurred.

• The Settle Info column identifies any information relative to the settlement of the transaction, for example, whether the credit was accepted or declined.

• The Merchant # column identifies the merchant ID number.

• The Processor column identifies the processor type used for the transaction, such as Vital or NDC.

To run the Credit Card Summary report:

1. From the A/P / Reports/Journals menu, select Credit Card Summary Report to display the A/R Credit Card Summary Report screen.

2. In the Processor field, press F10 and select one of the following to determine the processor that you want to use:

• All includes all processors. This is the default.

• Vital

• NDC

• FDMS

• NBSI

• BOM

Note: If you enter new information in the Processor field, the system deletes the information in the Merchant Number field until you press Enter to confirm the information in the Br/Tr/All field.

3. In the Br/Tr/All field, enter the branch or territory for which you want to run the report. Enter All to run the report for all branches.

4. In the Merchant # field, enter the ID number of the merchant for whom you are running the report. This number is assigned to you by your chosen processing firm.

5. In the Start Date field, enter the first date of the period you want to include in the report.

6. In the End Date field, enter the last date of the period you want to include in the report.

7. In the Batch Number field, enter the batch number assigned by the End of Day Settlement report.

8. In the Sort by field, press F10 and select one of the following sorting methods:

• Card Type – Sorts by the type of credit card used, for example, Visa or American Express.

• Auth Method – Sorts by the type of authorization used, either manual or automatic.

• Processor – Sorts by the processor company used by your firm, for example Vital or NDC.

• Merchant Number – Sorts by the merchant ID number.

• Payment Date – Sorts by the date the authorization was processed.

• Branch – Sorts by the branches in your company.

• Batch Number – Sorts by batch numbers for each batch processed.

9. Use the Print, Hold, and Opts hot keys as necessary to run the report.

See Also:

Credit Card End of Day Settlement Report

Cash Box Journal