Transactions report

The Transactions report provides detailed insights into all transaction activities within Xendit, facilitating effective monitoring and management of financial operations.

Monitor and Retrieve Data: Track detailed information on the status of transactions, whether they are successful, failed, or refunded.
Comprehensive Reporting: Each transaction is displayed with all key information such as fees and taxes on a single line, simplifying reconciliation and reporting.

The transaction report includes:

Payments, Incoming Transfers, Top-ups, Remittance payments: Incoming transactions appear on the Transactions report once the money has been successfully paid to you, even if they have not yet settled.
Disbursements, Outgoing Transfers, Withdrawals, Remittance payouts: Outgoing transactions are shown on the Transactions report once the transaction has been successfully created. When these transactions are successfully debited from your balance, they will also be displayed on the Balances page and report.

Download Transactions Reports

On-Demand export: Download the Transactions Report directly from your dashboard Transactions page on the Transaction tab.
Scheduled Delivery: Schedule automated report deliveries to your email or SFTP servers, ensuring you receive up-to-date information without manual effort.
Via API: Automate report generation and export via the report endpoint.

Available Columns (Report version 2)

Field name	Description
Status	The status of the transaction. Available statuses: PENDING: The transaction is still pending to be processed. This refers to money-out transactions when the amount is still on hold. SUCCESS: The transaction is successfully sent for money-out or has already arrived for money-in. FAILED: The transaction failed to send or receive. VOIDED: The money-in transaction is voided by the customer. REVERSED: The transaction is reversed by Xendit.
Type	The type of the transaction. Available types: ADJUSTMENT_ADD: An adjustment transaction that adds to the balance. ADJUSTMENT_DEDUCT: An adjustment transaction that deducts from the balance. BNPL_PARTNER_SETTLEMENT_CREDIT: Buy Now Pay Later partner settlement credit transaction. BNPL_PARTNER_SETTLEMENT_DEBIT: Buy Now Pay Later partner settlement debit transaction. CASHBACK_FEE: Cashback fee transaction. CASHBACK_VAT: Cashback VAT transaction. CHARGEBACK: A chargeback transaction for disputed charges. CONVERSION: Balance conversion transactions between different currencies. DISBURSEMENT: The disbursement of money-out transaction. FOREX_DEDUCTION: Foreign exchange deduction transaction. FOREX_DEPOSIT: Foreign exchange deposit transaction. IN_PERSON_PAYMENT: In-person payment transaction. LOAN_REPAYMENT: Loan repayment transaction. OTHER: Other transaction types not covered by specific categories. PAYMENT: The payment that includes all variation of money-in transaction. REFUND: A refund transaction created to refund amount from money-in transaction. REMITTANCE: A remittance transaction. REMITTANCE_COLLECTION_PAYMENT: Remittance collection payment transaction. REMITTANCE_PAYOUT: The remittance pay-out transaction. RESERVES_HOLD: Transaction for holding reserves. RESERVES_RELEASE: Transaction for releasing held reserves. TOPUP: A top-up transaction for adding money to account balance. TRANSFER_IN: Transfer into the account from another Xendit account. TRANSFER_OUT: Transfer out of the account to another Xendit account. WITHDRAWAL: A withdrawal transaction for money-out operation
Channel	The channel category of the transaction to identify the source of the transaction. Available channels per type: DISBURSEMENT and REMITTANCE_PAYOUT: BANK and CASH PAYMENT: CARDS, CARDLESS_CREDIT, DIRECT_DEBIT, EWALLET, PAYLATER, QR_CODE, RETAIL_OUTLET, VIRTUAL_ACCOUNT TRANSFER: XENPLATFORM
Channel Name	The channel used to identify the source of the transaction.
Account Number	Account number field is only valid for the following products: Receiver's Bank Account Number: Disbursement, Batch Disbursement, Remittance Payout, Remittance, Remittance Collection Sender's Bank Account Number: Virtual Account Payment, Direct Bank Transfer Sender's eWallet Account Number: eWallet Payment (only for tokenization)
Currency	Transaction currency
Amount	Nominal amount for the transaction.
Total Fee	Amount of the Xendit fee for this transaction.
Total VAT	Amount of the Value Added Tax (VAT) for this transaction.
Net Amount	The net amount of the transaction after it is deducted by fees and VAT.
Reference	The reference of the transaction. On some products, the term reference is the same as external_id. This is the ID that you generate and can be used for reconciliation.
Transaction ID	Unique transaction identifier
Invoice ID	The invoice ID (if applicable)
Batch ID	The Batch ID for Batch Disbursements
Product ID	Xendit generated ID sent to you via API callback/response: Credit Card: id Virtual Account: id eWallet: data.id (remove ewc_ from callback value if present) QR Code: data.id (remove qrpy_ from callback value if present) Direct Debit: id Retail Outlets (OTC): payment_id PayLater: data.id (remove plc_ from callback value if present) Disbursements: data.id For merchants using Payment API v3 endpoints, report Product ID corresponds to API callback/response payment_id
Payment Date	The date the end-user made the payment
Timestamp - Created	The timestamp when the transaction is created.
Timestamp - Updated	The timestamp when the transaction is updated.
Estimated Settlement Time	Estimated settlement time for a particular transaction before settlement is completed.
Actual Settlement Time	Estimated settlement time for a particular transaction before settlement is completed.
Timezone	The timezone will always be +0000 UTC when the report is generated via API. When exported from the dashboard, the report will use the user's configured timezone.
Description	The description of the transaction.
Channel Reference	The reference that is generated by our channel partner. This can be used to reconcile data between your side, Xendit, and our partner: payment_channel_transaction_id: Direct Debit bank_reference: Disbursement, Batch Disbursement, Remittance Payout, Remittance, Remittance Collection
Settlement Status	Settlement status of a transaction: Pending: Transaction amount has not been settled to the merchant's balance. Settled: Transaction has been settled to the merchant's balance. Early settled: Transaction has been settled to the merchant's balance via early settlement. Empty (Failed Disbursements & Chargeback Deduction)

Additional columns

When exporting a report, you can include additional columns for more information:

Field name	Description
Is Switcher Payment	This is only applicable for Virtual Account or Cards transactions.
Remittance Collection VA ID	The ID of Remittance Collection VA. This is only applicable for Remittance Collection transactions.
Batch Disbursement ID	The ID of Batch Disbursement. This is only available for disbursement that’s created using the Batch Disbursement feature.
Batch Disbursement Reference	The Reference of Batch Disbursement. This is only available for disbursement that’s created using the Batch Disbursement feature.
Remittance ID	The ID of Remittance. This is only applicable for remittance transactions.
Plan ID	Xendit unique ID to identify a subscriptions plan. Returned on the create plan API response. This is only available for subscriptions payment.
Cycle ID	Xendit unique ID to identify a cycle of subscriptions to refer one specific instance of subscriptions plan's action. Cycle object is generated from the subscriptions plan object where the subscriptions behavior is defined. This is only available for subscriptions payment.
Transaction Fee Deduction Type	An identifier whether the fee of this transaction is DIRECT or INDIRECT.
Transaction Fee	Amount of the payment fee for this transaction
Transaction VAT	Amount of payment VAT related to transaction fee.
Xendit WHT	Amount of withholding tax retained by Xendit for this transaction.
Early Settlement Fee Deduction Type	An identifier whether the early settlement fee of this transaction is DIRECT or INDIRECT.
Early Settlement Fee	Amount of the early settlement fee for this transaction.
Early Settlement VAT	Amount of the early settlement VAT for this transaction.
Legacy Callback ID	The ID of legacy callback. This is only applicable for VA transactions.
Account Name	Recipient Account holder name inputted in the Disbursement or Payout request.
Transaction Label	Additional identifier of a transaction. Available value: Shopee: E-Wallet or QR
Transfer Remark	A remark or a note that is inputted by the payer when they are about to make a payment.
Net Amount Currency	Currency used for the net amount after fees. This reflects to which balance currency the transaction is settled.
Converted Currency	Currency that the transaction amount is converted into when FX conversion happens.
Converted Amount	Amount after currency conversion, expressed in the converted currency.
Settlement Currency	Expected currency used to settle funds to or from your account for the transaction. Available for unsettled transactions.
Failure reason	Payout failure reason Only available via on-demand report
Payment Request ID	ID of the payment request you can find in the callback of your payment request (v2 and v3).
Capture ID	Capture ID from payment transaction using v3 endpoints.
Reusable Payment Link ID	ID of Reusable Payment Link
Payment Session ID	ID of Payment session
Metadata	Metadata from payment transaction using v3 endpoints.
Forex Rate	Forex rate applicable to the transaction Only available via on-demand report
Destination Amount	Destination amount for overseas withdrawals Only available via on-demand report
Destination currency	Destination currency for overseas withdrawals Only available via on-demand report

Transactions report versions

Below is a table detailing different versions of the Transactions report. While you have the option to select from three versions depending on your business needs, it is recommended to use the latest version to ensure you are accessing the most current features and data.

View transaction report versions comparison

Column	Ver. 0	Ver. 1	Ver. 2
Status	✅	✅	✅
Type	✅	✅	✅
Channel	✅	✅	✅
Channel Name	✅	✅	✅
Account Number	✅	✅	✅
Currency	✅	✅	✅
Amount	✅	✅	✅
Fee	✅	✅	❌
VAT	✅	✅	❌
3rd Party WHT	✅	✅	❌
Xendit WHT	✅	✅	❌
Net Amount	✅	✅	✅
Reference	✅	✅	✅
Transaction ID	✅	✅	✅
Invoice ID	✅	✅	✅
Batch ID	✅	✅	✅
Payment ID	✅	✅	❌
Payment Date	✅	✅	✅
Timestamp - Created	✅	✅	✅
Timestamp - Updated	✅	✅	✅
Timestamp - Settled	✅	✅	❌
Timezone	✅	✅	✅
Description	✅	✅	✅
Channel Reference	✅	✅	✅
Settlement Status	❌	✅	✅
Actual Settlement Time	❌	✅	✅
Estimated Settlement Time	❌	✅	✅
Product ID	❌	❌	✅
Total Fee	❌	❌	✅
Total VAT	❌	❌	✅