Transaction Page & Report

The Transactions page and Transactions reports allow you to get detailed information on transactions in Xendit.

• Retrieve and monitor transactions across all states - whether they’re successful, failed, or refunded.
• See all key data associated with a transaction, including fees and taxes, in a single line for easier reconciliation and reporting.

Currently, you can get information on the following types of transactions on the Transactions page on Dashboard:

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

Search for transactions

Search

Easily retrieve your transaction and look up its associated information by searching using any of the following parameters:

• Reference
• Account number
• Amount
• Product ID (Xendit): See below for the ID to use per transaction type and channel

Transaction Type / Channel	Search Identifier
Credit Card	credit card charge id
Virtual Account	virtual account deposit id / taxed invoices id
eWallet	charge_request.id
Direct Debit	id
Direct Debit	id

Filter

You can filter transactions based on the following criteria to do more granular reporting:

• Status
• Type
• Channel

Check fees and taxes in transactions report

You can easily identify fees and taxes with its corresponding transaction in the transaction report, which makes it easier for you to do reconciliation for any fees and taxes.

Export reports

You can download these reports as CSVs on your preferred time range.

Alternatively, schedule report delivery to your email or SFTP servers.

Available columns

Learn more about the columns available in the Transactions report and how to use them.

Transaction Report Column	Description
Status	The corresponding transaction status PENDING: The transaction is still in processing. This is only applicable to money-out transaction when the amount is still on hold SUCCESS: This refers to transactions that are completed. For money-in, this means that transaction has been paid by end user but settlement to balance is not captured by this status and depend on payment channel settlement configuration. For money-out, this means that the money has been successfully sent FAILED: The transaction failed to send (Only applicable to money-out) VOIDED: The money-in transaction is voided by you REFUNDED: The money-in transaction is refunded by you REVERSED: The transaction is reversed by Xendit
Type	Some examples of transaction type: DISBURSEMENT, PAYMENT, TRANSFER and etc
Channel	DISBURSEMENT: REMITTANCE_PAYOUT, BANK and CASH PAYMENT: CARDS, CARDLESS_CREDIT, DIRECT_DEBIT, EWALLET, PAYLATER, QR_CODE, RETAIL_OUTLET, VIRTUAL_ACCOUNT TRANSFER: XENPLATFORM
Channel Name	Channel name will be different for each channel. See channel codes for more information
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. See our supported currencies
Amount	Nominal amount for the transaction. The number of decimal place will be different for each currency according to ISO 4217.
Fee Amount	Amount of payment fee for this transaction.
VAT Amount	Amount of the VAT for this transaction.
3rd Party WHT	Amount of the 3rd Party Withholding Tax for this transaction if applicable.
Xendit WHT	Amount of the Xendit Withholding Tax for this transaction if applicable.
Net Amount	Net Amount of transaction after fee/VAT/WHT is included.
Reference	The reference of transaction. This is generated from your side and on some product is known as External Id
Transaction Id	Unique identifer of the transaaction
Invoice Id	The id of the invoice, if this transaction is payment using invoice
Batch Id	Batch ID for Batch Disbursements
Payment Id	This is also known as Product ID. This field will be renamed to Product ID in the next iteration of report update. Xendit generated ID sent to you via API callback: 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 timestamp when end user paid
Timestamp - Created	The timestamp when the transaction is created
Timestamp - Updated	The timestamp when the transaction is updated
Timestamp - Settled	The estimated settlement timestamp of transaction
Timezone	Timezone information formatted as “+XXXX UTC”. The timezone will always be +0000 UTC when report is generated via this API. This is different from Dashboard which will use the user's local system's timezone.
Description	The description of transaction
Channel Reference	The reference that is generated by our channel partner. This can be used to reconcile between the data from your side, Xendit, and our partner: payment_channel_transaction_id: Direct Debit, Direct Bank Transfer (Not available in callback response) bank_reference: Disbursement, Batch Disbursement, Remittance Payout, Remittance, Remittance Collection
Settlement Status	Settlement status of a transaction Pending Settled Empty (Failed Disbursements & Chargeback Deduction)
Actual Settlement Time	Actual settlement time of a particular transaction settlement is completed
Estimated Settlement Time	Estimated settlement time for a particular transaction before settlement is completed

Additional columns

When exporting a Transactions report, you can add more columns into your report. The information will appear if there is a corresponding transaction.

Additional Column	Description
Switcher	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 Batch Disbursement feature.
Batch Disbursement Reference	The Reference of Batch Disbursement. This is only available for disbursement that’s created using 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 behaviour is defined. This is only available for subscriptions payment.
Transaction Fee	Amount of payment fee for this transaction.
Transaction VAT	Amount of payment VAT for this transaction.
Transaction Fee Deduction Type	An identifier whether the 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.
Early Settlement Fee Deduction Type	An identifier whether the early settlement fee of this transaction is DIRECT or INDIRECT.
Indirect Fee	Amount of indirect fee of this transaction if applicable.

Report Versioning

When exporting a report, you may choose between 3 versions of Transactions report. The default version is version 2, but you might choose any version based on what your business needs. Learn more about what each version offers you.

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	❌	❌	✅