Welcome to Xendit’s latest documentation. For legacy content, access the previous version here.

Balance report

Prev Next

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:

  • 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 Number: 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.