Transaction Detail Report

This report delivers a detailed breakdown of payment transactions and the associated parties, such as the payer and beneficiary.

Prerequisites

Before accessing the Transaction Detail report, ensure you have:

Access Requirements


Navigation Path

Side Menu → Reports → Client → Transaction Detail

Step-by-Step Instructions

  1. From the main business portal, click on Reports in the side menu.

  2. Within the Reports section, choose Client.

  3. Click on Transaction Detail to access the report interface.

  4. Use the available filters to refine your search:

  5. Examine the displayed transactions that match your criteria.

Exporting Report Data

  1. Click the Export button located above the transaction list.

  2. Choose your preferred File Type and toggle Loaded Rows Only if you want to export only the currently displayed results.

📘

Note
If your search returns more than 15,000 rows, the file cannot be downloaded directly. Instead, the request is queued and listed in Historical Reports, where you can check its status and download it once ready.

  1. Click Export to download the file.
💡

File Naming Convention

Reports are automatically named as: Client_Details_<MMDDYYYY>_<HHMMSS>


Available Filters

Refine your activity search using the following criteria:

  • Client: Select the originating client name.
  • Country: Choose the account country for transactions.
  • Account Number: Enter the Localpayment account number.
  • Transaction Status: Completed, cancelled, refunded, approved, inprogress, authorized, expired, locked, rejected, rejected_by_bank, pending authorization, pending_debit, pending_credit, chargeback, onhold, returned, recalled, in_dispute, doc_received, received, disputed_lost, disputed_won, waitingauth, inchargeback, active, update_pending, temporarily_suspended, pending_auth, onhold_aml, and refund_aml.
  • Transaction Type: PayIn, PayOut, GateWayIn, GateWayOut, ChangeBack, RecurringFee, Credit, Debit, WireIn, WireOut, CurrencyBuy, CurrencySell, Expenses, InternalDomesticTransfer, InternalForeignTransfer, Refund, Return, UnidentifiedRefund, Recall, CurrencyExchange, PartnerContribution, PartnerDistribution, Loan, Investment, VirtualAccountFee, InterestEarned, Rescue, and RefundAml.
  • Beneficiary Bank Number: Identifies the beneficiary's bank. Supports exact match, partial (contains), or multiple comma-separated values.
  • Search by Document ID
    • Document ID: Enter the identity document identifier.
    • Document Role: Select Payer or Beneficiary.
    • Document Type: Choose a type that corresponds to your selected country.
  • LotOut ID: Enter the processing identifier.
  • Time Zone: Choose between UTC or the local time of the account’s country.
  • Date Range: Specify the time period for transaction history.
  • Smart Search: Find transactions by their Internal or External ID.

Report Columns Reference

🕒

Time Zone Information

All timestamps are displayed in your browser's local time zone.

The following table indicates which columns appear in the business portal view versus the downloaded report:

GroupColumn NameDescriptionBusiness PortalDownload
Country
CountryCountry for transactions.✗✓
Date
CreationTransaction creation date (YYYY-MM-DD HH:MM:SS)✓✓
ProcessedProcessing completion date (YYYY-MM-DD HH:MM:SS)✓✓
SettlementPayIn credit date (YYYY-MM-DD HH:MM:SS)✓✓
ExpirationTransaction expiration date (YYYY-MM-DD HH:MM:SS)✓✓
Internal
Internal IDUnique system-generated identifier✓✓
Internal LotIn IDBatch processing identifier (when applicable)✓✓
External
External IDYour custom reference ID (must be unique)✓✓
Client Information
NameName of the client account✓✓
Account CodeSystem account code✓✓
Account NumberLocalpayment account number✓✓
Account DescriptionLocalpayment account number description✓✓
MoRMerchant of Record✓✓
Merchant
Merchant NamePayment sender identification✓✓
Payment Method
Transaction TypeType of transaction designation✓✓
Method TypeSpecific payment method used✓✓
Method NamePayment method display name✓✗
Payment Method CodeSystem payment method code✗✓
Payer
TypeThe entity type. Values: INDIVIDUAL or COMPANY.✓✓
NameName of the payer✓✓
Last nameLast name of the payer (for individuals).✗✓
Document TypeType of government-issued ID✓✓
Document IdThe identification number✓✓
EmailPayer's email address.✓✓
User referenceAdditional reference data for the payer.✓✓
Payer Bank
NameName of the payer's bank✓✓
CodeThe bank's routing code.✓✓
BranchThe branch code of the payer's bank.✓✓
Account TypeType of bank account✓✓
Account NumberPayer's bank account number.✓✓
Account AliasAlias for the payer's account✓✓
Account PhonePhone number associated with the bank account.✓✓
Beneficiary
TypeThe entity type. Values: INDIVIDUAL or COMPANY.✓✓
NameName of the beneficiary✓✓
LastnameLastname of the beneficiary✗✓
Document TypeType of government-issued ID✓✓
Document IdThe identification number✓✓
EmailBeneficiary's email address✓✓
Beneficiary Bank
NameName of the beneficiary's bank✓✓
CodeThe bank's routing code.✓✓
BranchThe branch code of the beneficiary's bank.✓✓
Account TypeType of bank account✓✓
Account NumberBeneficiary's bank account number✓✓
Account AliasAlias for the beneficiary's account✓✓
Account PhonePhone number associated with the bank account.✓✓
Status
StatusCurrent transaction status✓✓
DescriptionStatus description✓✓
CommentAdditional status notes✗✓
Payment
Amount CurrencyOriginal transaction amount's currency✗✓
AmountOriginal transaction amount✓✓
Withholdings / Financial Fee CurrencyWithholding/fee amounts' currency✗✓
Financial Fees WithholdingsWithholding/fee amounts✓✓
Payment CurrencyNet amount's currency✗✓
Payment AmountNet amount (Amount - Fees/Withholdings)✓✓
FX QuoteExchange rate (if applicable)✓✓
Confirmed CurrencyConfirmed transaction value's currency✗✓
ConfirmedConfirmed transaction value✓✓
Local Taxes CurrencyLocal tax amounts' currency✗✓
Local TaxesLocal tax amounts✓✓
Financial Fees CurrencyProcessing fee amounts's currency✗✓
Financial FeesProcessing fee amounts✓✓
Fees CurrencyAdditional fee amounts' currency✗✓
FeesAdditional fee amounts✓✓
Created by
Created byUser who initiated the transaction✓✓

Sample Report

View a sample Transaction Detail report to understand the data structure and format:


Need Help? If you have questions about this process or any other feature, our support team is here for you. We can assist with troubleshooting, integration planning, and optimization.



Did this page help you?