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: BATCH_DISBURSEMENT: disbursement transaction that involves sending multiple payments to different recipients at once. DISBURSEMENT: The disbursement of a money-out transaction. IN_PERSON_PAYMENT: Transactions that occur through direct interactions between the customer using a payment terminal. PAYMENT: The payment that includes all variations of money-in transactions. PLATFORM_FEE: Fees deducted from transactions for the use of XenPlatform services. REFUND: A refund transaction created to refund an amount from a money-in transaction. REMITTANCE_PAYOUT: The remittance payout transaction. TRANSFER: The transfer transaction between Xendit accounts. This can be a transfer in or out. WITHDRAWAL: Transactions from your Xendit account to your own bank account. OTHER: This category is used for transactions that do not neatly fit into the other specified types, covering a variety of transactional scenarios that are less common.
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
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.
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.
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) Only available on scheduled report
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	❌	❌	✅