Settlement Statement Report
Settlement Statement
The Settlement Statement Report is a comprehensive financial statement that consolidates all settlements for a merchant during a specified date range, providing a period-level overview of financial activities. The report concludes with trailer totals summarizing all settlements in the period, including total collected, total refunds, total chargebacks, total settlement costs, total percentage fees, total fixed fees, and total fee and cost amounts. This statement serves as a monthly or period-based reconciliation tool, allowing merchants to review their complete settlement activity and financial performance across multiple settlement cycles in a single consolidated view.
Settlement Statement Report Sample
| Field | Format | Description | Example | Edge Cases |
|---|---|---|---|---|
| INVOICE/CODE | String (alphanumeric, e.g., SET-{country}-{YYMMDD}-{seq}) | Human-readable unique identifier for the settlement invoice. | SET-BR-240915-001, 2000 | Format varies by merchant configuration; some use numeric codes. |
| TRANSFER_DATE | Date string (DD/MM/YYYY format) | Date when the settlement transfer occurred or is scheduled. | 07/12/2023, 01/03/2023 | Can differ from settlement_date; used for period filtering. |
| TOTAL_COLLECTED | Decimal number with 2 decimal places (positive) | Total payment amounts collected during the settlement period. | 6, 12, 500 | Always positive or zero; represents gross payment amounts before fees. |
| TOTAL_REFUNDS | Decimal number with 2 decimal places (positive) | Total refund amounts processed during the settlement period. | 15, 30, 20 | Displayed as a positive value but reduces the net settlement amount. |
| TOTAL_CHARGEBACKS | Decimal number with 2 decimal places (positive) | Total chargeback amounts processed during the settlement period. | 3, 6, 0 | Displayed as a positive value but reduces the net settlement amount. |
| TOTAL_SETTLEMENT_COST | Decimal number with 2 decimal places | Settlement processing costs and operational fees. | 0, 30 | Often zero for standard settlements; includes special processing costs. |
| TOTAL_%_FEE | Decimal number with 2 decimal places | Total percentage-based fees charged on transactions. | 3.8, 7.6, 5 | Varies by payment method and contract. |
| TOTAL_FIXED_FEE | Decimal number with 2 decimal places | Total fixed fees charged per transaction. | 1.9, 3.8, 5 | Constant per transaction regardless of amount; varies by payment method. |
| TOTAL_FEE_AND_COST | Decimal number with 2 decimal places | Combined total of all fees and costs for the settlement. | 4, 8, 30 | Sum of percentage fees, fixed fees, and settlement costs. |
Trailer Totals
TOTAL COLLECTED SETTLEMENTS: Sum of all total_collected values
TOTAL REFUNDS SETTLEMENTS: Sum of all total_refunds values
TOTAL CHARGEBACKS SETTLEMENTS: Sum of all total_chargebacks values
TOTAL SETTLEMENT COST SETTLEMENTS: Sum of all total_settlement_cost values
TOTAL % FEE SETTLEMENTS: Sum of all total_%_fee values
TOTAL FIXED FEE SETTLEMENTS: Sum of all total_fixed_fee values
TOTAL FEE AND COST SETTLEMENTS: Sum of all total_fee_and_cost values
Example Settlement Statement Calculation
Scenario: Brazilian merchant with two settlements in the period
Settlement Data
Settlement 1 (Code: SET-BR-240915-001):
Transfer Date: 07/12/2023
Total Collected: BRL 6.00
Total Refunds: BRL 15.00
Total Chargebacks: BRL 3.00
Total Settlement Cost: BRL 0.00
Total % Fee: BRL 3.80
Total Fixed Fee: BRL 1.90
Total Fee and Cost: BRL 5.70
Settlement 2 (Code: SET-BR-240920-001):
Transfer Date: 12/12/2023
Total Collected: BRL 250.00
Total Refunds: BRL 10.00
Total Chargebacks: BRL 0.00
Total Settlement Cost: BRL 0.00
Total % Fee: BRL 8.00
Total Fixed Fee: BRL 3.50
Total Fee and Cost: BRL 11.50
Trailer Totals Calculation
TOTAL COLLECTED SETTLEMENTS: BRL 256.00 (6 + 250)
TOTAL REFUNDS SETTLEMENTS: BRL 25.00 (15 + 10)
TOTAL CHARGEBACKS SETTLEMENTS: BRL 3.00 (3 + 0)
TOTAL SETTLEMENT COST SETTLEMENTS: BRL 0.00 (0 + 0)
TOTAL % FEE SETTLEMENTS: BRL 11.80 (3.80 + 8.00)
TOTAL FIXED FEE SETTLEMENTS: BRL 5.40 (1.90 + 3.50)
TOTAL FEE AND COST SETTLEMENTS: BRL 17.20 (5.70 + 11.50)
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.