All Transactions Report
All Transactions
This comprehensive report consolidates all transaction types (payments, refunds, chargebacks, and reversals) into a single unified view for the reporting period. The report is delivered in multiple formats (CSV, XLSX, JSON) and can be separated by currency or country based on merchant configuration. Each transaction entry includes the transaction type, date, amounts, fees, customer information, and status, providing a complete financial activity overview. The report enables merchants to perform comprehensive reconciliation and analysis across all transaction categories in a single document, with optional fields for additional data like email addresses, exchange rates, and installment details.
| Field | Format | Description | Example | Edge Cases |
|---|---|---|---|---|
| MERCHANT | String (UTF-8 encoded) | Name of the merchant who processed the transaction. | EBANX Demo Merchant | Always populated; required field for all transactions. |
| PAYMENT HASH | Hexadecimal string (48 characters) | Unique EBANX payment hash identifier. | 54154bb...44a4ac | Always populated and unique; never null; immutable. |
| MERCHANT PAYMENT CODE | String (merchant-defined) | Merchant's internal reference code for the payment. | INV-2024-001 | Can be null; not guaranteed to be unique. |
| STATUS | String enumeration (CO, CA, OP, PE) | Current payment status code. | CO (Confirmed), CA (Cancelled) | Always populated; determines payment processing state. |
| OPEN DATE | DateTime string (YYYY-MM-DD HH:MM:SS) | Date and time when the payment was initially created. | 2024-10-24 10:30:15 | Never null; always populated at payment creation. |
| CONFIRM DATE | DateTime string or null | Date and time when the payment was confirmed. | 2024-10-24 14:22:30, null | Null for unconfirmed payments. |
| AMOUNT LOCAL | Decimal number with 2 decimal places | Payment amount in local currency. | 543.10, 1250.00 | No decimal places for zero-decimal currencies (COP, CLP). |
| AMOUNT EXT | Decimal number with 2 decimal places | Payment amount in external/original currency. | 100.00, 250.50 | May equal AMOUNT LOCAL for domestic transactions. |
| AMOUNT IOF | Decimal number with 2 decimal places | IOF tax amount applied to the payment (Brazil-specific). | 5.43, 0.00 | Zero for non-Brazil transactions. |
| EXCHANGE RATE | Decimal number (4-6 decimal places) | Currency conversion rate applied to the payment. | 5.4310, 1.0000 | 1.0000 for same-currency transactions. |
| COUNTRY | String (country name) | Country where the payment was processed. | Brazil, Mexico | Always populated. |
| CURRENCY EXT | 3-letter ISO 4217 currency code | External/original currency code of the payment. | USD, EUR, BRL | Determines AMOUNT EXT currency. |
| CURRENCY LOCAL | 3-letter ISO 4217 code or empty | Local currency code of the payment's processing country. | BRL, MXN, `` | Can be an empty string. |
| INSTALMENTS | Integer | Number of installments for the payment. | 1, 3, 12 | Special handling for e-wallets (may show "Not available"). |
| PAYMENT TYPE | String | Name of the payment method type. | Credit Card, Boleto, PIX | Always populated. |
| PAYMENT TYPE GROUP | String | Payment method group/category. | creditcard, cash, ewallet | Groups multiple payment types. |
| SETTLEMENT CODE | String or empty string | Settlement code if payment has been settled. | SET-BR-240915-001, `` | Empty for unsettled payments. |
| SET GROSS | Decimal or empty string | Gross settlement amount for the payment. | 543.10, `` | Empty for unsettled payments. |
| SET FIXED | Decimal or empty string | Fixed fee amount in settlement. | 1.50, `` | Empty for unsettled payments. |
| SET FEE PERCENTUAL | Decimal or empty string | Percentage-based fee amount in settlement. | 17.38, `` | Empty for unsettled payments. |
| SET FEE | Decimal or empty string | Total fee amount in settlement (fixed + percentual). | 23.77, `` | Empty for unsettled payments. |
| SET NET | Decimal or empty string | Net settlement amount (gross - fees). | 519.33, `` | Empty for unsettled payments. |
Example All Transactions Report Calculation
Scenario: Brazilian merchant with comprehensive transaction mix on May 20, 2022
Base Data
Report Date: May 20, 2022
Merchant: EBANX Demo Merchant
Currency: BRL
Report Type: ALL_TRANSACTIONS
Transaction Breakdown by Type
Payments (2 transactions)
Payment 1 - Local (FULL_LOCAL):
Merchant Code: INV-MERCHANT-CODE-001
Order Number: PAYMENT-CODE-001
Payment Type: Credit Card (Mastercard)
Open Date: 2022-04-15
Confirmed Date: 2022-04-20
Deposited Date: 2022-05-20
Charge Amount: BRL 2.00
Processing Fee: BRL 0.20
Net: BRL 1.80
Hash: 54154bb33b47474eb64ef36193644cce4e4c44c4e444a4ac
Recipient Code: ME (local)
Single Transaction Type: FULL_LOCAL
Payment 2 - Cross-Border (MIXED):
Merchant Code: INV-MERCHANT-CODE-002
Order Number: PAYMENT-CODE-002
Payment Type: Credit Card (Mastercard)
Open Date: 2022-04-16
Confirmed Date: 2022-04-20
Deposited Date: 2022-05-20
Charge Amount: BRL 4.00
Processing Fee: BRL 0.40
Net: BRL 3.60
Hash: 65265cc44c58585fc75fe47204755ddf5f5d55d5f555b5bd
Recipient Code: ebanx-xb (cross-border)
Single Transaction Type: MIXED
Refunds (2 transactions)
Refund 1 - Local:
Related to Payment 1
Refund Amount: BRL 2.00
Refund Fee: BRL 0.20
Total Cost: BRL 2.20
Recipient Code: ME
Single Transaction Type: FULL_LOCAL
Refund 2 - Cross-Border:
Related to Payment 2
Refund Amount: BRL 2.00
Refund Fee: BRL 0.20
Total Cost: BRL 2.20
Recipient Code: ebanx-xb
Single Transaction Type: MIXED
Chargebacks (2 transactions)
Chargeback 1 - Local:
Related to Payment 1
Chargeback Amount: BRL 2.00
Chargeback Fee: BRL 0.20
Total Cost: BRL 2.20
Recipient Code: ME
Single Transaction Type: FULL_LOCAL
Chargeback 2 - Mixed:
Related to Payment 2
Chargeback Amount: BRL 2.00
Chargeback Fee: BRL 0.20
Total Cost: BRL 2.20
Recipient Code: ebanx-xb
Single Transaction Type: MIXED
Reversals (2 transactions)
Reversal 1 - Local:
Related to Chargeback 1
Reversal Amount: BRL 2.00
Reversal Fee: BRL 0.20
Net Credit: BRL 1.80
Recipient Code: ME
Single Transaction Type: FULL_LOCAL
Reversal 2 - Cross-Border:
Related to Chargeback 2
Reversal Amount: BRL 2.00
Reversal Fee: BRL 0.20
Net Credit: BRL 1.80
Recipient Code: ebanx-xb
Single Transaction Type: MIXED
Summary by Transaction Type
FULL_LOCAL:
PAYMENT: BRL 1.80 (2.00 - 0.20)
REFUND: BRL 2.20 (2.00 + 0.20)
CHARGEBACK: BRL 2.20 (2.00 + 0.20)
CHARGEBACK REVERSAL: BRL 1.80 (2.00 - 0.20)
─────────────────────────────────────────────
TOTAL: BRL -0.80
TYPE: FULL_LOCAL
MIXED:
PAYMENT: BRL 3.60 (4.00 - 0.40)
REFUND: BRL 2.20 (2.00 + 0.20)
CHARGEBACK: BRL 2.20 (2.00 + 0.20)
CHARGEBACK REVERSAL: BRL 1.80 (2.00 - 0.20)
─────────────────────────────────────────────
TOTAL: BRL 1.00
TYPE: MIXED
Final Calculation Summary
Total Payments Net: BRL 5.40 (1.80 + 3.60)
Total Refunds Cost: BRL -4.40 (2.20 + 2.20)
Total Chargebacks Cost: BRL -4.40 (2.20 + 2.20)
Total Reversals Credit: BRL 3.60 (1.80 + 1.80)
─────────────────────────────────────────────────────
Net Impact: BRL 0.20
Still need help?
We hope this article was helpful. If you still have questions, you can explore the following options:
- Merchant support: Contact our support team at sales.engineering@ebanx.com for assistance.
- Not a partner yet? Please complete the Merchant Signup Form, and our commercial team will reach out to you.