---
title: "Balance report"
slug: "balance-report"
updated: 2025-06-30T03:56:30Z
published: 2025-06-30T03:56:30Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.xendit.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Balance report

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](https://dashboard.xendit.co/balance) page at any time.
- **Scheduled exports**: [Schedule automated report](/v1/docs/scheduling-reports) 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](https://developers.xendit.co/api-reference/#report-object).

### 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: - **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 |
| **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: - **TRANSACTION** - **FEE** - **VAT** - **TRANSACTION_REVERSAL**/ **FEE_REVERSAL**/ **VAT_REVERSAL** |
| **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: - **DEBIT**: Balance is deducted. - **CREDIT**: Balance is added. |
| **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: - **VA**: Bank code for the source of the transaction. - **Disbursement**: Bank code for the destination of the transaction. |
| **Account Number** | The account number is valid only for specific products: - **Receiver's Bank Account Number**: Disbursement, Batch Disbursement, Remittance Payout, Remittance, Remittance Collection. - **Sender's Bank Account Number**: Virtual Account Payment. - **Sender's eWallet Account Numbe**r: eWallet Payment (only for tokenized payments). |
| **Channel Reference** | Reference generated by our channel partner, useful for reconciliation between your data, 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. |
| **Name** | Name field is valid only for certain products: - **Receiver's Name**: Disbursement, Batch Disbursement, Remittance Payout, Remittance, Remittance Collection. - **Sender's Name**: Virtual Account Payment, eWallet Payment. |
| **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.