Transaction Summary Report
Report that shows transaction information.
Description
The Transactions Summary report shows details including transaction totals, account details, card details, and fee details. You can only view transactions associated with locations you are permitted to see. If you do not have access to all locations in a transaction, then the information in the report is limited. Payment Administrators only see data related to accounts they own.
For details about required privileges to view the report, see Predefined Payment Groups and Privileges.
Report Navigation
-
You can view the report by navigating to Payment Cloud Service and then click Transactions at the bottom of the dashboard.
-
Click Help in the Actions drop-down menu to open a pop-up window, providing detailed help documentation to assist you in navigating and customizing your report.
-
The Transaction Summary Metrics Banner appears at the top of the Transactions page.
The Transaction Summary Table appears below the Transaction Summary Metrics banner. This is a high-level overview of the report helping you manage and analyze your transaction data more effectively. Click Actions at the top of this table to filter the information or complete other actions like creating a chart or downloading the information. The table provides a clear and concise breakdown of your transactions, allowing you to quickly assess the following key data points:
-
Payment Method: view the distribution of transactions by the method of payment (for example, credit card merchant).
-
Transaction Count: view the total number of transactions for each payment method.
-
Transaction Amount: check the aggregate value of transactions by payment method.
-
Processing Fee: review the fees associated with each payment method, helping you better understand the cost structure.
-
Deposit to Bank: track the amount deposited to your bank after processing fees, giving you full visibility on your net transactions.
The predefined timeframes feature lets you filter the data by different transaction close dates. Click the drop-down menu below the Transaction Summary Table and then select the predefined view. When you change the selection, it updates not only the main report, but also updates the table summary at the top. The available views are:
-
Yesterday: view transactions that were closed the previous day.
-
2 Days Ago: view transactions that were closed two days ago.
-
3 Days Ago: view transactions that were closed three days ago.
-
Last 14 Days (default): review a two-week snapshot of your transactions for more detailed trend analysis.
-
Last Month: easily assess the full set of transactions from the previous calendar month.
These predefined views are also reflected in the Transaction Summary Table, ensuring a seamless experience as you switch between different timeframes. Whether you’re analyzing recent activity or identifying trends over the past month, these options give you maximum flexibility and efficiency for tracking and managing your transaction data.
- The Transactions Summary Report appears below the predefined view drop-down field. To view the other report details, click the Payment Reference number.
Transaction Summary Metrics Banner
Table 11-1 Transaction Summary Metrics Banner
| Metric | Description |
|---|---|
| Total Transaction Count | Total number of transactions. |
| Total Transaction Amount | Total monetary amount of transactions in the time period. |
| Total Refund Amount | Total monetary amount of refunds. |
| Total Chargeback Amount | Total monetary amount of chargebacks. |
| Total Processing Fee | Total monetary amount of the processing fee. |
Transactions Summary Report
Table 11-2 Transactions Summary Report
| Metric | Description |
|---|---|
| Payment Reference | Original reference for payment. |
| POS Transaction Reference | Reference for the transaction. |
| Tender Reference | Unique transaction identifier generated by the POS. |
| Transaction Date and Time | Date and time transaction received. |
| Business Day | Business day of the chargeback. |
| Transaction Amount | The original transaction amount. |
| Transaction Currency | Currency for processing the payment. An ISO three character code. |
| Payment Processing Fee | Monetary amount to process the transaction. Not shown until paid out. |
| Net Proceeds | Transaction amount minus the payment processing fee. |
| Transaction Status | Latest status of the transaction. |
| Transaction Type | Either Sale, Refund, Void, or Chargeback. |
| Payout Reference | Reference for the payout that the transaction was part of. |
| Payout Date | Date and time when the payout was made. |
| Payout Status | Status when the transaction was paid out or if it was withdrawn in the case of a refund or chargeback. |
| Settlement Currency | Currency for the settlement. An ISO three character code. |
| Exchange Rate | Exchange rate for the settlement. It is 1 if processed and settled with the same currency. |
| Payment Method | Payment method used for the transaction. |
| Location Name | Name for the location. |
| Payment Location Identifier | Payment reference for the location. |
| Payment Terminal Identifier | Unique identifier for the terminal. |
| Shopper Interaction | The method the guest used to make the payment. For example, in-store, e-commerce, or MOTO. |
| Card Present | Indicates if a card was present or not at time of transaction. |
| Offline | States Yes if an offline transaction was performed. |
| Card Bin | BIN number used in the transaction |
| Card Last 4 Digits | Last 4 digits of the card used in the transaction. |
| Account Holder Name | Legal business name of the account holder. |
| Account Holder Code | Code created for the account holder. |
| Account Name | Name of the account. |
| Account Code | Code created for the account. |
Transaction Details
Table 11-3 Transaction Details
| Metric | Description |
|---|---|
| Transaction Status | Latest status of the transaction. |
| Transaction Type | Either Sale, Refund, Void, or Chargeback. |
| Transaction Amount | The original transaction amount. |
| Payment Reference | Original payment service provider reference. |
| Tender Reference | Unique transaction identifier generated by the POS. |
| Entry Mode | Method used to enter the card. |
| CVM Performed | Possible values are: * Offline plaintext PIN * Offline * Offline plaintext PIN and Signature * Offline enciphered PIN * Offline enciphered PIN and Signature * Signature * No CVM Performed |
Payout Details
Table 11-4 Payout Details
| Metric | Description |
|---|---|
| Payout Date | Date of the payout. |
| Payout Reference | Unique reference for the payout. |
| Transaction Accounting Type | For example, credited or debited. |
| Payout Amount | Amount paid out. |
| Payout Currency | Currency of the payout. For example, USD. |
| Reason | Shows the amount of money debited or credited as part of a funds transfer. |
Transaction Event Log
Table 11-5 Transaction Event Log
| Metric | Description |
|---|---|
| Status type | Row for each status the transaction has gone through. |
| Date and Time | When the status occurred. |
| Authorized | Date and time of when transaction was authorized. |
| Sent for Settle | Date and time of when transaction was sent for settlement. |
| Settled | Date and time of when transaction was settled. |
The payment cycle is illustrated in the following image.
Fee Details
Table 11-6 Fee Details
| Metric | Description |
|---|---|
| Transaction Amount | The original transaction amount. |
| Transaction Type | Transaction type for each fee charged. |
| Fixed Fee | Monetary amount to process transaction. |
| Variable Fee | Monetary amount to process transaction based on a variable rate. |
| Total Fee | Sum of the fixed fee and variable fee. |
Card Details
Table 11-7 Card Details
| Metric | Description |
|---|---|
| Payment Method | Payment method used for the transaction. |
| Card Type | Sub-brand of the payment method. For example, Visa Classic or Visa Debit. |
| Card Number | Last four digits of the card used in the transaction. |
| Expiry Date | Expiration date. |
| Issuing Country | Name of the country where card was issued. |
Store Details
Table 11-8 Store Details
| Metric | Description |
|---|---|
| Location Name | Name of the location. |
| Payment Location Identifier | Payment provider’s reference for the location. |
| Location Address | Address of the location. |
Terminal Details
Table 11-9 Terminal Details
| Metric | Description |
|---|---|
| Payment Terminal Identifier | Terminal’s unique identifier. [Device model]-[Serial number] |
| Terminal Version | POS terminal version. |
| Payment Device | Model name of the terminal. |
Account Details
Table 11-10 Account Details
| Metric | Description |
|---|---|
| Account Holder Name | Legal business name of the account holder. |
| Account Holder Code | Code created for the account holder. |
| Account Name | Name of the account. |
| Account Code | Code created for the account. |
| Bank Account Name | Name for the bank account. |
Parent topic: Reports