Run a Credit Card Summary Report to list all the approved credit card transactions for a specific date range or batch number. Both manual- 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 report 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 report.
The Collect Amount identifies the dollar amount to 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.
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 Procesor column identifies the type of processor used for the transaction, such as Vital or NDC.
To run the Credit Card Summary Report:
From the A/R > Reports/Journals menu, select Credit Card Summary to display the Credit Card Summary Report window.
In the Processor field, select from the following list 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 removes the information in the Merchant # field until you press Enter to confirm the information in the Branch/Territory field.
In the Branch/Territory field, enter the branch or territory for which you want to run the report. Type All to run the report for all branches. You can enter multiple branches by listing them, separating each branch number by a comma. For example, to display a report on branches 1, 3, and 5, list them as follows: 1,3,5.
Keep in mind the following:
If you enter a particular branch or territory, or combination of branches and territories, and then use the Multiple List icon in the Merchant Number field, the system displays a list of only those merchant numbers 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. When you specify a merchant number, you are saying that you want to see all orders for that merchant number at all branches where that merchant number is used.
In the Merchant Number 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.
In the Start Date field, enter the first date of the period you want to include in this report.
In the End Date field, enter the last date of the period you want to include in this report.
In the Batch Number field, enter the batch number assigned by the End of Day Settlement report.
In the Sort By field, select one of the following to determine how to sort the report:
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.
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.
See Also:
Credit Card Authorization Overview