Skip to main content

Balance

info

If you registered for a Xendit account before March 2021, you will see a toggle on your dashboard that enables you to switch between the Cash and Balance view. The Cash view will be deprecated and replaced by the Balance view from 31 August 2022. After 31 August 2022, you will be able to monitor all balance movements on the Balance view.

See Mapping Cash to Balance History report for more information on how to interpret the columns on the new balance history report

Cash View (Old)Balance View (New)

Balance Page

The Balance page displays all balance activity on your Xendit account. Use this view to see every money movement that flows in and out of your Xendit account balance.

It consists of several components:

  • Available Balance Summary
  • Balance History
  • Pending

Available Balance Summary

This section shows a summary of all balance activity:

  • Available Balance: This is the total balance that can be withdrawn to your bank account or transferred to another recipient bank account through Disbursement.
  • Total Balance: The last balance recorded on balance history. This is the sum of your Pending Outgoing balance and Available balance.
  • Pending Outgoing: The sum of outgoing transactions that are still being processed. For example, any withdrawals or payouts that were created and not yet sent out due to partner operational downtimes will be represented here. You will also be able to see all Pending Outgoing transactions in the Pending tab.

Balance History and Pending Tabs

View your account’s detailed balance activity in the Balance History Tab and Pending Tab.

Balance History Tab

All money movements into and out of your balance are recorded in the balance history tab. You can use balance history as the source of truth for money movements of all transactions.

The Balance History displays all historical transactions that have been completed.

For example:

  • Payments that have been settled to Xendit balance
  • Top-ups that have been credited to Xendit balance
  • Withdrawal transactions that have been successfully created and debited from Xendit balance
  • Disbursement transactions that have been successfully created and debited from Xendit balance

Only completed transactions will be recorded in Balance History.

  • Incoming transactions like payments and top-ups are completed when settlement to balance is completed
  • Outgoing transactions like disbursements and withdrawals are completed when the transaction has been successfully created and debited from Xendit balance

Transactions fees, and VAT as separate lines

For ease of differentiation between transactions and the fees they incur, fees and VAT are recorded as separate line items in Balance History report.

These are differentiated via a column called “Line Type” to make it easier to distinguish and filter between transactions, fees and taxes to facilitate reconciliation and reporting.

Pending Tab

The Pending tab displays transactions that are still pending and haven’t been moved in, or out of your Xendit balance.

For example:

  • Payments that have been paid by your users and are not yet settled.
  • Disbursements that have been created outside of partner operational times and will be processed when the partners are operational again

These transactions can be found in the Pending tab instead of the Balance History tab.

Search for Transactions in the Balance History view

To confirm whether a transaction has been debited from, or credited to, your available balance, you can search for the transaction using reference.

Export reports

You can download the balance history report as CSVs and PDFs 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 Balance History report and how to use them

Balance History Report ColumnDescription
Product IDXendit generated ID sent to you via API callback:
Credit Card: credit card charge id
Virtual Account: virtual account deposit id / taxed invoices id
eWallet: charge_request.id
Direct Debit: id
Retail Outlets (OTC): id
Transaction IDUnique identifier of the transaction on balance history report
Transaction TypeList of transaction types available in Xendit like VA PAYMENT, EWALLET PAYMENT and etc
Line TypeList of available line type:
  • TRANSACTION
  • FEE
  • VAT
  • TRANSACTION_REVERSAL / FEE_REVERSAL / VAT_REVERSAL
  • Payment ChannelThe channel to identify the source of the transaction.
    See channel codes for more information.
    ReferenceYour generated ID which will be sent to Xendit’s system and will also be available on some product callback as ‘external_id’
    CurrencyTransaction currency.
    See our supported currencies
    AmountNominal amount for the transaction. The number of decimal place will be different for each currency according to ISO 4217.
    BalanceYour account balance on this transaction.
    Debit or CreditDEBIT = Balance is deducted
    CREDIT = Balance is added
    Created Date ISODate timestamp on when the transaction is created using ISO 8601 format in +0 GMT
    Time ZoneTimezone 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.
    Created DateCreate date timestamp when transaction is created
    Payment DateDate timestamp of the transaction paid by end user
    Settlement DateDate on when payment is settled. This means the fund is already received and added to your balance. This is only available for payment transaction.
    Completed DateDate timestamp when balance history ledger line is completed
    Bank CodeThe bank channel that are used as source or destination of transaction. This is only available for VA PAYMENT and DISBURSEMENT
    Account NumberAccount 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)
    Channel ReferenceThe 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
    NameName field is only valid for the following products:
    Receiver's Name: Disbursement, Batch Disbursement, Remittance Payout, Remittance, Remittance Collection
    Sender's Name: Virtual Account Payment, eWallet Payment
    DescriptionThe description of transaction
    Invoice IDThe ID of invoice. This is only available for payment that are paid via invoice.
    Ledger SequenceLedger Sequence is the order in which the ledger is sorted in.

    Mapping Cash Report to Balance History Report

    The Cash report is a legacy report used in older Xendit dashboard views. This is no longer supported as of 31 Aug 2022 and we highly recommend that you use Balance History report instead.

    The Cash report doesn’t support the following features:

    • Several products, including PayLater
    • Searching by reference
    • Fee and VAT recorded as separate lines

    If you registered for a Xendit account before March 2021, you may have access to, and may have downloaded Cash reports from the dashboard. Learn how to map data to the latest Balance History report to the deprecated Cash report.

    Cash Report ColumnMappingBalance History Report ColumnDescription
    idProduct IDXendit generated ID sent to you via API callback:
    Credit Card: credit card charge id
    Virtual Account: virtual account deposit id / taxed invoices id
    eWallet: charge_request.id
    Direct Debit: id
    Retail Outlets (OTC): id
    statusremovedRemoved. Any Balance ledger line created is succesful and confirmed
    typeTransaction TypeList of transaction types available in Xendit like VA PAYMENT, EWALLET PAYMENT and etc
    payment_methodremovedRemoved from report
    payment_channelPayment ChannelThe channel to identify the source of the transaction.
    See channel codes for more information.
    created_dateCreated DateCreate date timestamp when transaction is created
    time_zoneTime ZoneTimezone 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.
    created_date_isoCreated Date ISODate timestamp on when the transaction is created using ISO 8601 format in +0 GMT
    referenceReferenceYour generated ID which will be sent to Xendit’s system and will also be available on some product callback as ‘external_id’
    descriptionDescriptionThe description of transaction
    is_creditDebit or CreditDEBIT = Balance is deducted
    CREDIT = Balance is added
    amountAmountNominal amount for the transaction. The number of decimal place will be different for each currency according to ISO 4217.
    balanceBalanceYour account balance on this transaction.
    nameNameName field is only valid for the following products:
    Receiver's Name: Disbursement, Batch Disbursement, Remittance Payout, Remittance, Remittance Collection
    Sender's Name: Virtual Account Payment, eWallet Payment
    bank_codeBank CodeThe bank channel that are used as source or destination of transaction. This is only available for VA PAYMENT and DISBURSEMENT
    account_numberAccount NumberAccount 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)
    bank_referenceremovedChannel reference is a general replacement for this field but covering more cases
    newLine TypeList of available line type:
  • TRANSACTION
  • FEE
  • VAT
  • TRANSACTION_REVERSAL / FEE_REVERSAL / VAT_REVERSAL
  • newTransaction IDUnique identifier of the transaction on balance history report
    newCurrencyTransaction currency.
    See our supported currencies
    newPayment DateDate timestamp of the transaction paid by end user
    newCompleted DateDate timestamp when balance history ledger line is completed
    newChannel ReferenceThe 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
    newSettlement DateDate on when payment is settled. This means the fund is already received and added to your balance. This is only available for payment transaction.
    newInvoice IDThe ID of invoice. This is only available for payment that are paid via invoice.
    newLedger SequenceLedger Sequence is the order in which the ledger is sorted in.
    Was this page helpful?