Card-Based Reports

Overview

Card-based reports provide insights into the lifecycle of payment cards within a program, including their creation, transaction activity, and settlement details. These reports help clients track card issuance, monitor transactions, and analyze cardholder activity across different merchant categories. The following reports are available in this category:

• New Card Creation Report – Lists newly created cards within a reporting period.
• Card Creation Summary – Summarizes the total number of new, renewal, and replacement cards.
• Cardholder Details – Provides information on cardholders within a program.
• Card Auth Detail – Lists authorization transactions performed using cards.
• Card Settlement Detail – Details settlement transactions for card-based payments.
• MCC Summary – Categorizes transactions by Merchant Category Code (MCC).

---

New Card Creation Report

Report Overview

This report provides a detailed listing of all newly created cards for the specified reporting period. It includes information about the cardholder, the issuing program, and key card details.

Report Data Elements

• Date & Time – Card creation date and time.
• Client Name – The client associated with the card.
• Program Name – The program under which the card was issued.
• Program GUID – A unique identifier assigned to the program.
• Wallet GUID – A unique identifier for the wallet associated with the card.
• Account GUID – A unique identifier for the account linked to the card.
• Masked Card Number – The last four digits of the issued card.
• Person Name – The name of the cardholder.
• Card Expiry – The card's expiration date.
• Card Type – The type of card (e.g., plastic, virtual, one-time).

---

Card Creation Summary

Report Overview

This report provides a summary of the number of cards created during a given period. It includes details on new, renewal, and replacement cards.

Report Data Elements

• Date – The date for which the summary applies.
• Client Name – The client associated with the cards.
• Program Name – The program under which the cards were issued.
• Program GUID – A unique identifier for the program.
• Card Type – The type of card (e.g., plastic, virtual, one-time).
• Number of New Cards – The total number of newly created cards.
• Number of Replacement Cards – The total number of replacement cards.
• Number of Renewal Cards – The total number of renewal cards.

---

Cardholder Details

Report Overview

This report provides detailed information on all cardholders associated with a program. It includes personal details, account identifiers, and current balances.

Report Data Elements

• Client Name – The client associated with the cardholders.
• Program Name – The program under which the cardholders are registered.
• Program GUID – A unique identifier for the program.
• Person Name – The name of the cardholder.
• Person GUID – A unique identifier assigned to the cardholder.
• Account GUID – The unique account identifier linked to the cardholder.
• Masked Card Number – The last four digits of the cardholder's active card.
• Current Available Balance – The available balance on the cardholder's account.
• Account Currency – The currency of the account.

---

Card Auth Detail

Report Overview

The Card Auth Detail report provides a list of authorization records for transactions performed using issued cards. It captures details about authorized transactions, including amounts, merchant information, and authorization status.

Report Data Elements

• Transaction Date & Time – The date and time the authorization request was processed.
• Client Name – The client associated with the transaction.
• Program Name – The program under which the transaction occurred.
• Program GUID – A unique identifier for the program.
• Masked Card Number – The last four digits of the card number used.
• Person Name – The name of the cardholder performing the transaction.
• Transaction Amount – The authorized transaction amount.
• Merchant Name – The name of the merchant where the transaction occurred.
• Authorization Status – Indicates whether the transaction was approved or declined.

---

Card Settlement Detail

Report Overview

This report provides details on settled transactions for card-based payments. It includes data on the transaction amount, merchant information, and settlement date.

Report Data Elements

• Settlement Date – The date when the transaction was settled.
• Transaction Date & Time – The date and time the transaction was authorized.
• Client Name – The client associated with the transaction.
• Program Name – The program under which the transaction occurred.
• Program GUID – A unique identifier for the program.
• Masked Card Number – The last four digits of the card number used.
• Transaction Amount – The settled transaction amount.
• Merchant Name – The merchant where the transaction took place.
• Settlement Currency – The currency in which the transaction was settled.
• Interchange Amount – The interchange fee applied by the network.

---

MCC Summary

Report Overview

The MCC Summary report provides an analysis of card transactions categorized by Merchant Category Code (MCC). This report helps clients track spending trends across different merchant types.

Report Data Elements

• Transaction Date – The date of the transaction.
• Client Name – The client associated with the transactions.
• Program Name – The program under which the transactions were made.
• Program GUID – A unique identifier for the program.
• Card Type – The type of card used in the transaction.
• MCC Code – The merchant category code assigned to the transaction.
• Transaction Country – The country where the transaction took place.
• Total Transaction Amount – The total amount spent within the MCC category.
• Transaction Currency – The currency of the transaction.
• Total Transaction Count – The total number of transactions within the MCC category.

---

Related Topics

• Introduction
• Account-Based Reports
• Transaction and Activity Reports
• Balance and Status Reports
• Financial and Ledger Reports
• Operational and Compliance Reports