Transaction and Activity Reports

Overview

Transaction and activity reports provide detailed insights into financial activities within a Qolo program. These reports help clients track individual transactions, summarize account activity, and monitor fund movements such as loads, unloads, and electronic fund transfers (EFTs). The reports also include declined or rejected transactions and acquiring-related details.

The following reports fall under this category:

• Activity Detail Report – Provides a detailed view of all transactions on an account.
• Activity Summary Report – Summarizes financial transactions over a report period.
• Client Transaction History – Lists all transactions associated with a program’s funding account.
• Decline and Reject Transactions – Provides details of declined transactions during the reporting period.
• EFT Report – Captures electronic funds transfer (EFT) transactions, including ACH payments.
• Acquiring Report – Provides insights into transactions acquired by Qolo, such as OCTs and AFTs.
• Load Report – Details funds loaded onto accounts or cards.
• Daily Unload Report – Lists all funds withdrawn or unloaded from an account.

---

Activity Detail Report

Report Overview

This report provides a detailed listing of all financial activities on an account, including authorized and posted transactions. It includes both approved and declined transactions and can change based on when the report is pulled, as some authorized transactions may be settled later.

Report Data Elements

• Client Name – The client associated with the transaction.
• Program GUID – A unique identifier for the program.
• Program Name – The name of the program where the transaction occurred.
• Post Date/Time – The date and time when the transaction was posted.
• Account GUID – A unique identifier for the account.
• Masked PAN – The last four digits of the card number.
• Person Name – The name of the cardholder involved in the transaction.
• Request Code – A unique identifier for the transaction type.
• Transaction Amount – The value of the transaction.
• Merchant Name – The name of the merchant where the transaction took place.
• Settled – Whether the transaction has been settled (Yes/No).

---

Activity Summary Report

Report Overview

This report provides a high-level summary of financial transactions over the reporting period. It includes total transaction counts and amounts based on different transaction types.

Report Data Elements

• Date – The date of the report.
• Client Name – The client associated with the transactions.
• Program Name – The program under which the transactions occurred.
• Request Code – The transaction type identifier.
• Total Post Amount – The total settled amount for the report date.
• Total Transaction Count – The total number of transactions for each request type.

---

Client Transaction History

Report Overview

This report provides a list of transactions from the program’s funding account, tracking all fund movements and balances.

Report Data Elements

• Transaction Date – The date of the transaction.
• Account GUID – A unique identifier for the account.
• Request Code – The transaction type identifier.
• Transaction Amount – The transaction value.
• Account Currency – The designated currency of the transaction.
• Account Balance – The balance after the transaction.

---

Decline and Reject Transactions

Report Overview

This report lists transactions that were declined or rejected during the reporting period. It includes reasons for rejection and associated transaction details.

Report Data Elements

• Transaction Date – The date of the declined transaction.
• Program Name – The program under which the transaction was attempted.
• Transaction Amount – The amount of the declined transaction.
• Request Code – The identifier for the transaction type.
• Reason Code – The reason for the decline or rejection.

---

EFT Report

Report Overview

The EFT Report captures bank-related transactions such as electronic funds transfers (EFTs), including ACH payments and wire transfers. It includes details on the settlement status and transaction trace information.

Report Data Elements

• Date – The reporting date.
• Client Name – The client associated with the transaction.
• Program Name – The program linked to the transaction.
• Account GUID – The unique identifier of the account involved in the transfer.
• Request Code – The transaction type identifier.
• Transaction Amount – The EFT transaction amount.
• Transaction Status – Indicates whether the transaction is pending or settled.
• Channel Name – Specifies whether the transfer was through ACH, wire, or RTP.

---

Acquiring Report

Report Overview

This report provides details on transactions acquired by Qolo, such as Original Credit Transactions (OCTs) and Account Funding Transactions (AFTs).

Report Data Elements

• Transaction Date – The date of the acquired transaction.
• Program Name – The program under which the transaction occurred.
• Request Code – The identifier for the transaction type.
• Transaction Amount – The acquired transaction amount.
• Settlement Date – The date when the transaction was settled.
• Transaction Status – Indicates if the transaction is pending or settled.

---

Load Report

Report Overview

This report details all fund loads in a program during the reporting period. It includes information on account credits and load transactions initiated by clients.

Report Data Elements

• Transaction Date – The date of the load transaction.
• Program Name – The program linked to the load transaction.
• Person Name – The cardholder or accountholder receiving the load.
• Transaction Amount – The amount loaded onto the account.
• Request Code – The identifier for the transaction type.
• Masked Card Number – The last four digits of the card number, if applicable.

---

Daily Unload Report

Report Overview

This report lists all fund unloads from accounts within a program during the reporting period. It is similar to the Load Report but focuses on debits instead of credits.

Report Data Elements

• Transaction Date – The date of the unload transaction.
• Program Name – The program under which the unload transaction occurred.
• Person Name – The cardholder or accountholder associated with the unload.
• Transaction Amount – The amount unloaded from the account.
• Request Code – The identifier for the transaction type.
• Masked Card Number – The last four digits of the card number, if applicable.

---

Related Topics

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