English
API ReferenceSign In

Reconciling the billing statement for products integrated through API

Last updated 11/05/2020

Reconciling the billing statement

In the next sections we will provide summary tables that give an overview of what can be found on the billing statement, please refer to the following key,

  • Standard text/font refers to agreed values
  • {Text in curly brackets} refers to a pre-calculated amount
  • Italics text/font refers to a calculated amount from billing statement
  • is an indicator that this box will not be filled in billing statement

Virtual Accounts - Aggregator

Billing statement line items

ProductUnit PriceQty.VolumeBilled Amount
Virtual AccountFixed fee{Sum Transaction Count}{Sum Amount}Calculated

Billing logic

For customers using VA Aggregator, the billing statement uses transaction data from the product database to gather the count and volume information. Only completed VA Aggregator transactions from the same time period as the billing statement (i.e. first day of the month until the last day of the month) are included in the billing statement.

How to reconcile

  1. Download billing statement
  2. Go onto Customer Dashboard > Cash tab
  3. Filter from first day of month to last day of month (e.g. 01 August - 31 August)
  4. Download Cash tab report CSV
  5. Refer to the following table to match up the values
Billing HeadingMatch on CSVNotes
Qty.1. Filter `status` column with value “COMPLETED” 2. Filter `type` column with value “VIRTUAL_ACCOUNT_SETTLEMENT” 3. Count number of transaction line items
Volume1. Filter the `status` column with value “COMPLETED” 2. Filter the `type` column with value “VIRTUAL_ACCOUNT_SETTLEMENT” 3. Sum the `amount` column
Billed AmountCalculated field: Unit Price * Qty.
Virtual Account Fees Paid1. Filter the `status` column with value “COMPLETED” 2. Filter the `type` column with value “VIRTUAL_ACCOUNT_FEE” 3. Sum the `amount` column

Virtual Accounts - Switcher

Billing statement line items

ProductUnit PriceQty.VolumeBilled Amount
BCA Virtual AccountFixed fee{Sum Transaction Count}{Sum Amount}Calculated
BRI Virtual AccountFixed fee{Sum Transaction Count}{Sum Amount}Calculated

Billing logic

For customers using VA Switcher, the billing statement uses transaction data from the product database to gather the count and volume information. Only completed VA Switcher transactions from the same time period as the billing statement (i.e. first day of the month until the last day of the month) are included in the billing statement.

NB: Since VA Switcher transactions will not settle on the Xendit dashboard, there are no records of the transaction on the Cash tab. The only tab that has information for VA Switcher transactions is the Accept Payments > Invoices tab. From the Invoices tab, you will need to know the external_id for the VA Switcher transactions as set for the transaction settings by you in order to separate out the specific invoice transactions (from other product types)

How to reconcile

  1. Download billing statement
  2. Go onto Accept Payment > Invoices tab
  3. Filter from first day of month to last day of month (e.g. 01 August - 31 August)
  4. Download Invoices tab report CSV
  5. Reconcile against external_id in the `reference` column

Retail Outlets

Billing statement line items

ProductUnit PriceQty.VolumeBilled Amount
Retail Outlet - AlfamartFixed fee{Sum Transaction Count}{Sum Amount}Calculated
Retail Outlet - IndomaretFixed fee{Sum Transaction Count}{Sum Amount}Calculated

Billing logic

For customers using Retail Outlets, the billing statement uses transaction data from the product database to gather the quantity and volume values. Only completed Retail Outlet transactions from the same time period as the billing statement (i.e. first day of the month until the last day of the month) are included in the billing statement.

How to reconcile

  1. Download billing statement
  2. Go onto Customer Dashboard > Cash tab
  3. Filter to include Transaction type for “Retail Outlets”
  4. Filter from first day of month to last day of month (e.g. 01 August - 31 August)
  5. Download Cash tab report CSV
  6. Refer to the following table to match up the values
Billing HeadingMatch on CSVNotes
Qty.1. Filter `status` column with value “COMPLETED” 2. Filter `type` column with value “FIXED_PAYMENT_CODE_SETTLEMENT” 3. Count number of transaction line items
Volume1. Filter the ‘status’ column with value "COMPLETED" 2. Filter `type` column with value “FIXED_PAYMENT_CODE_SETTLEMENT” 3. Sum the ‘amount’ column
Billed AmountCalculated field: Unit Price * Qty.
Retail Outlet Fees Paid1. Filter the ‘status’ column with value "COMPLETED" AND the ‘type’ column with value  2. Filter `type` column with value “XENDIT_FIXED_PAYMENT_CODE_PAYMENT_DIRECT_FEE”

Ewallets

Billing statement line items

ProductUnit PriceQty.VolumeBilled Amount
Ewallet - OVO% fee{Sum Transaction Count}{Sum Amount}Calculated
Ewallet - DANA% fee{Sum Transaction Count}{Sum Amount}Calculated
Ewallet - LinkAja% fee{Sum Transaction Count}{Sum Amount}Calculated

Billing logic

For customers using Ewallets, the billing statement uses transaction data from the Cash tab to gather the quantity and volume values. Only completed Ewallet transactions from the same time period as the billing statement (i.e. first day of the month until the last day of the month) are included in the billing statement.

How to reconcile

  1. Download billing statement
  2. Go onto Customer Dashboard > Cash tab
  3. Filter to include Transaction type for “E-wallets”
  4. Filter from first day of month to last day of month (e.g. 01 August - 31 August)
  5. Download Cash tab report CSV
  6. Filter the Cash tab report CSV on “payment_channel” column with specific Ewallet product, e.g. OVO, Dana, Linkaja
  7. Refer to the following table to match up the values
Billing HeadingMatch on CSVNotes
Qty.1. Filter `payment_channel` column with specific Ewallet channel 2. Filter `status` column with value “COMPLETED” 3. Filter `type` column with value “DIRECT_EWALLET_SETTLEMENT” 3. Count number of transaction line items
Volume1. Filter `payment_channel` column with specific Ewallet channel 2. Filter the `status` column with value “COMPLETED” 3. Filter the `type` column with value “DIRECT_EWALLET_SETTLEMENT” Sum the `amount` column
Billed AmountCalculated field: Unit Price * Volume
Ewallet Fees Paid1. Filter `payment_channel` column with specific Ewallet channel 2. Filter the `status` column with value “COMPLETED” 3. Filter the `type` column with value “DIRECT_EWALLET_XENDIT_FEE” Sum the `amount` column

Credit Cards

Billing statement line items

ProductUnit PriceQty.VolumeBilled Amount
Cards - Fixed FeesFixed fee{Sum Transaction Count}Calculated
Cards - MDR% fee{Sum Amount}Calculated

Billing logic

For customers using Cards on aggregator or switcher, the billing statement uses calculations based on the different stages of a full complete cards transaction. There are two filters being used for including Cards transactions as billable in the current system

To begin reconciling for Credit Card transactions, navigate to Dashboard > Accept Payments > Credit /Debit Cards > Charges

How to reconcile

  1. Download billing statement
  2. Go onto Customer Dashboard > Accept Payments > Credit / Debit Cards > Charges tab
  3. Filter to include all status (“Charged”, “Refunded”, and “Failed”)
  4. Filter from first day of month to last day of month (e.g. 01 August - 31 August)
  5. Download Credit Cards Charge tab report CSV
  6. Refer to the following table to match up the values
Billing HeadingMatch on CSVNotes
Qty.1. Filter `status` column with value “SETTLED” 2. Count number of transaction line items
Volume1. Filter the `status` column with value “SETTLED” 2. Sum the `amount` column
Billed AmountCalculated field: - Unit Price * Qty. - Unit Price * Volume
Credit Card Fees Paid1. Filter the `status` column with value “SETTLED” 2. Sum the following columns, -`fixed_fee` -`variable_fee` -`vat_amount`

Disbursements

Billing statement line items

ProductUnit PriceQty.VolumeBilled Amount
DisbursementsFixed fee{Sum Transaction Count}{Sum Amount}Calculated

Billing logic

For customers using direct disbursement and/or batch disbursement, the billing statement uses transaction data from the Cash tab to gather the quantity and volume values.

How to reconcile direct disbursement

  1. Download billing statement
  2. Go onto Customer Dashboard > Cash tab
  3. Filter to include Transaction type for “Disbursements”
  4. Filter from first day of month to last day of month (e.g. 01 August - 31 August)
  5. Download Cash tab report CSV
  6. Refer to the following table to match up the values
Billing HeadingMatch on CSVNotes
Qty.1. Filter `status` column with value “COMPLETED” 2. Filter `type` column with value “DIRECT_DISBURSEMENT_CREATED” 3. Count number of transaction line items
Volume1. Filter `status` column with value “COMPLETED” 2. Filter `type` column with value “DIRECT_DISBURSEMENT_CREATED” 3. Sum the `amount` column
Billed AmountCalculated field: Unit Price * Qty.
Disbursement Fees Paid1. Filter `status` column with value “COMPLETED” 2. Filter `type` column with value “XENDIT_DISBURSEMENT_FEE” 3. Sum the `amount` column

How to reconcile batch disbursement

  1. Download billing statement
  2. Go onto Customer Dashboard > Send Payments > Batch Disbursements > Approved tab
  3. Filter to include status of “Completed”
  4. Filter from first day of month to last day of month (e.g. 01 August - 31 August)
  5. Download Disbursement tab report CSV
  6. Refer to the following table to match up the values
Billing HeadingMatch on CSVNotes
Qty.1. Filter `status` column with value “COMPLETED” 2. Count number of transaction line items
Volume1. Filter `status` column with value “COMPLETED” 2. Sum the `amount` column
Billed AmountCalculated field: Unit Price * Qty.
Disbursement Fees Paid1. Filter `status` column with value “COMPLETED” 2. Filter `type` column with value “BATCH_DISBURSEMENT_FEE” 3. Sum the `amount` column