Over the Counter (OTC) Top Up Settlement File
Document Version 1.0.3
The settlement file report is used by merchants or payment processing partners such as Banks. The settlement file gives merchants and Banks detailed information about each transaction that affects funds settlement to their accounts
| File Name | OVER_THE_COUNTER_[CHANNEL_ID]_YYYYMMDD.csv (YYYMMDD refer to the transaction date) |
| File Format | .csv |
| Function | This settlement is used to display all recorded top up transactions based on a certain time |
| Settlement Cut Off | 00.00.00 |
| Delimiter | Comma |
| Related Services | Over the Counter (OTC) Top Up |
File Generation
The following sections are the details on how the file is generated:
For OTC Top Up, the settlement file is only generated by merchant unit and will be generated T+1
(The transactions that have occurred the previous day)
File Format
| Field | Type | Description |
|---|---|---|
| PARTNER_REFERENCE_NO | String1 - 64 char | Unique reference identifier generated by the partner system |
| CUSTOMER_NO | String1 - 14 char | Customer phone number |
| TRANSACTION_AMOUNT | Long1 - 32 char | Transaction amount that will be disbursed to user, i.e.: Rp. 100000 |
| FEE_AMOUNT | Long1 - 32 char | Denom fee for DANA, excluding tax, i.e.: Rp. 250 |
| NET_CLEARING_AMOUNT | Long1 - 32 char | Total amount that will be settled by partner to DANA, i.e., user top up Rp. 100.000, admin fee Rp. 555 net clearing amount equals to Rp. 100.277,5 → (277,5 = FEE_AMOUNT + VALUE_ADDED_TAX) |
| VALUE_ADDED_TAX | Long1 - 32 char | 11% tax of transaction amount i.e. (Rp. 27,5) |
| WITH_HOLDING_TAX | Long1 - 32 char | According to business agreement, can refer to SKB between DANA & partner |
| TRANSACTION_DATE | Datetime25 char | Transaction time, in format YYYY-MM-DDTHH:mm:ss+07:00. Time must be in GMT+7 (Jakarta time) |
| ADDITIONAL_INFO | String1 - 100 char | Additional info that might be needed in settlement file |
Example CSV File Format
Over the Counter (OTC) Top Up
| File Name | OVER_THE_COUNTER_[CHANNEL_ID]_20220404.csv (20220404 refer to the transaction date) |
| Example File | Download Example File |
PARTNER_REFERENCE_NO,CUSTOMER_NO,TRANSACTION_AMOUNT,FEE_AMOUNT,NET_CLEARING_AMOUNT,VALUE_ADDED_TAX,WITH_HOLDING_TAX,TRANSACTION_DATE,ADDITIONAL_INFO
2020102900000000000001,081289786456,10000000,25000,100277.5,27.5,0,2020-12-21T14:56:11+07:00,topup order memo for_Ozzie_M
2020102900000000000002,081289786481,10000000,25000,100277.5,27.5,0,2020-12-21T14:56:11+07:00,topup order memo for_Frank
