Statement Report

What is the Statements Report?

The Statements Report provides a consolidated view of all financial movements within a given period, combining both payins (incoming transactions) and payouts (outgoing transactions).
It offers merchants a comprehensive financial statement that allows them to:

📊 Track all money flows (credits and debits).
💰 Validate balances and settlement amounts.
🧾 Reconcile transactions against bank statements or internal accounting.
🌍 Gain visibility across countries, currencies, and payment methods.

This report is designed to be the single source of truth for merchants to understand their net position and settlement details with Bamboo Payments.

How it fits together

The Statements Report integrates both Payins (incoming funds) and Payouts (outgoing funds), normalizes them, and consolidates all financial movements into a single ledger:

                ┌─────────────────────┐
                │ Transaction Payins  │
                │  (Incoming funds)   │
                │  • Amounts          │
                │  • Methods          │
                │  • Statuses         │
                │  • Customer data    │
                └─────────┬───────────┘
                          │
                          │ Normalize & Map
                          │  (currency, method, IDs, dates)
                          ▼
                ┌─────────────────────┐
                │  Statements Report  │
                │  (Unified ledger)   │
                │  • Movements (±)    │
                │  • Fees/Adjustments │
                │  • Net amounts      │
                │  • Balances         │
                └─────────▲───────────┘
                          │
                          │ Normalize & Map
                          │  (beneficiary, bank, IDs, dates)
                ┌─────────┴───────────┐
                │ Transaction Payouts │
                │   (Outgoing funds)  │
                │  • Amounts          │
                │  • Methods/Accounts │
                │  • Statuses         │
                │  • Beneficiary data │
                └─────────────────────┘

Report Fields

Field Name	Description
TransactionId	Unique identifier for the original transaction related to this specific movement.
MovementId	Unique identifier for the specific financial movement within the account.
Created	Date and time the movement was created, in UTC.
Type	Type of movement: Purchase, Refund, ChargeBack, TrafficFee, Withdrawal, Cashout, among others.
Country	The specific country where the original transaction took place.
Currency	ISO 4217 code for the currency in which the movement was recorded.
Sign	Indicates whether the financial movement is a Credit or a Debit.
Amount	The specific monetary amount associated with this individual account movement.
ReferenceId	An additional reference identifier provided for the movement, if applicable.
EndUserNotes	Specific notes or comments related to the transaction provided by the user.
ExchangeRate	The exchange rate applied to the original transaction, if conversion occurred.
Status	Current status of the movement, such as Approved, Pending, or Rejected.
Merchant_Account_Id	Unique identifier of the merchant's specific account in Bamboo's system.
Merchant_Account_Name	The registered name of the merchant's account within the Bamboo platform.
Merchant_Id	Unique identifier assigned to the merchant within Bamboo's financial system.
Merchant_Name	The officially registered business name of the merchant.
Payment_Method	The specific payment method used, such as Visa, MasterCard, or OCA.
Payment_Method_Type	General category of the payment method used, like CreditCard or PrePaid.
Last_Status_Date	The most recent date when the movement's status was officially updated.
AvailableDate	Date when the movement funds become available for the merchant to use.
Merchant_Transaction_Id	Same value as Unique_Id in the Transactions Payins report.
Transaction_Date_Time	Date and time (UTC) when the payment happened. Created is when the movement was recorded.
Completed_Date_Time	Date and time (UTC) when the movement was completed.
Withdrawal_Id	Identifier for the specific withdrawal related to this movement, if applicable.
Withdrawal_Status	Current status of the associated withdrawal, such as Pending or Approved.
Order	Merchant's internal reference ID used to identify the specific customer order.
Settlement_Currency	ISO 4217 code for the currency used for the final settlement.
Settlement_Exchange_Rate	Rate used to convert Amount (movement currency) into Settlement_Currency, for example 599.90 BRL / 5.4123 = 110.84 USD.
Settlement_Amount	Amount in Settlement_Currency.