The Balance Report provides a detailed ledger of your account transactions, including credits, debits, fees, and taxes. You can access and download these reports in CSV or PDF format for any preferred time range, allowing for flexible and comprehensive financial reconciliation.
Download Balance Reports
On-demand export: Download the Balance Report directly from your dashboard Balance page at any time.
Scheduled exports: Schedule automated report deliveries to your email or SFTP servers, ensuring you receive up-to-date information without manual effort.
Export via API: Automate report generation and export via the report endpoint.
Reports data
The Balance Report includes various columns to help you understand each transaction. Below is a detailed description of each available column:
Field Name | Description |
---|---|
Product ID | Xendit generated ID sent to you via API callback/response:
|
Transaction ID | Xendit generated Unique identifier of the transaction. |
Transaction 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. |
Line Type | List of available line types:
|
Payment Channel | The channel used to identify the source of the transaction. |
Reference | Your generated ID, which will be sent to Xendit’s system and is also available on some product callbacks as external_id. |
Currency | Transaction currency. |
Amount | The nominal amount for the transaction. The number of decimal places will vary for each currency. |
Balance | Your account balance after this transaction. |
Debit or Credit | Indicates whether the transaction is a debit or credit:
|
Created Date ISO | Date timestamp when the transaction was created in ISO 8601 format in +0 GMT. |
Time Zone | 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 time zone. Timestamps are in ISO 8601 format. |
Created Date | Date timestamp when the transaction was created. |
Payment Date | Date timestamp of the transaction when paid by the end user. |
Settlement Date | The date when the payment is settled. This means the funds are received and added to your balance. This is only available for payment transactions. |
Completed Date | Date timestamp when the balance history ledger line is completed. |
Bank Code | The bank channel used for this transaction:
|
Account Number | The account number is valid only for specific products:
|
Channel Reference | Reference generated by our channel partner, useful for reconciliation between your data, Xendit, and our partner:
|
Name | Name field is valid only for certain products:
|
Description | Description of the transaction. |
Invoice ID | The ID of the invoice. This is only available for payments made via invoice |
Additional columns
When exporting a Balance report, you can add more columns into your report. The information will appear if there is a corresponding transaction.
Field name | Description |
---|---|
Remittance Collection VA ID | The ID of Remittance Collection VA. This is only applicable for Remittance Collection transactions. |
Legacy Callback ID | The ID of legacy callback. This is only applicable for VA 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. |
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. |
Account name | Recipient Account holder name inputted in the Disbursement or Payout request. |
Balance Report in PDF Format
Suitable for formal and visually structured reports.
Includes columns such as:
Date & Time
Transaction Type
Customer Reference
Line Type
Payment Channel
Amount
Balance
Benefits of PDF Reports:
Features the official Xendit logo.
Includes opening and closing balances.