Disbursement Settlement File

---

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.

There are a few cases that might occur during the transactions, described as follows:

Name	Description
Success	Transactions with successful status refer to the disbursements that have received a notification from the Bank indicating a success. Successful transactions will add the transaction fees (charge amount) to the settlement
Pending	Transactions with pending status refer to those with cases in which the disbursement has not received a notification from the Bank for more than one day (usually never occur for more than one day). In such cases, the settlement will display the same record but has not been charged with transaction fees
Refund	Refund transactions refer to those that were initially pending. In this context, a pending transaction takes place, but the disbursement returns a result notification from the Bank indicating a failure. Subsequently, since it has not been charged with a transaction fee, both the fund amount and the paid total amount are subtracted. For refund transaction, the following fields are stated as negative values: FUND_AMOUNT PAID_TOTAL_AMOUNT
Reversal	Reversal transactions refer to those initially marked as successful. In this context, a successful transaction takes place, but the disbursement returns a result notification from the Bank indicating a failure. Subsequently, both the charge amount and fund amount are subtracted. For reversal transaction, the following fields are stated as negative values: FUND_AMOUNT CHARGE_AMOUNT FEE VAT PAID_TOTAL_AMOUNT

---

File Name	MERCHANT_DANA_DISBURSEMENT_SETTLEMENT_REPORT_MID_YYYYMMDD.csv (YYYYMMDD refer to the transaction date)
File Format	.csv
File Generation	T+1 of each transaction date
Function	This settlement is used to show all recorded disbursement transactions based on a certain time
Settlement Cut Off	00.00.00
Delimiter	Comma
Related Services	Disbursement to Balance Disbursement to Bank Account

File Format

Field	Type	Description
REQUEST_ID	String1 - 64 char	Partner unique request identifier
FUND_AMOUNT	Long1 - 32 char	Original transaction amount
FUND_AMOUNT_CURRENCY	String1 - 3 char	Original transaction currency
CHARGE_AMOUNT	Long1 - 32 char	Total charge amount (MDR includes taxes)
FEE	Long1 - 32 char	Base MDR fee amount
WHT	Long1 - 32 char	Withholding tax amount
VAT	Long1 - 32 char	Value-added tax amount
PAID_TOTAL_AMOUNT	Long1 - 5 char	The transaction paid total amount (including MDR)
PAYER_ROLE_ID	String1 - 64 char	Payer identifier (merchant)
DEPOSIT_ACCOUNT_NO	String1 - 16 char	Deposit account number
MERCHANT_NAME	String1 - 64 char	Merchant name
TRANSACTION_DATE	Datetime17 char	Transaction date time, in format YYYYMMDD HH:MM:SS
SOURCE	String1 - 64 char	Merchant name
REPORT_DATE	Datetime8 char	Settlement report date, in format YYYYMMDD
BENEFICIARY_BANK_ACCOUNT	Datetime1 - 32 char	Beneficiary Bank account number Y:= Disbursement to Bank Account
BENEFICIARY_BANK_NAME	Datetime1 - 25 char	Beneficiary Bank name Y:= Disbursement to Bank Account

Example CSV File Format

To DANA Balance

To Bank Account

To Bank & Balance

File Name	MERCHANT_DANA_DISBURSEMENT_SETTLEMENT_REPORT_216620000180483821815_20210429.csv (20210429 refer to the transaction date)
Example File	Download Example File

To DANA Balance

REQUEST_ID,FUND_AMOUNT,FUND_AMOUNT_CURRENCY,CHARGE_AMOUNT,FEE,WHT,VAT,PAID_TOTAL_AMOUNT,PAYER_ROLE_ID,DEPOSIT_ACCOUNT_NO,MERCHANT_NAME,TRANSACTION_DATE,SOURCE,REPORT_DATE
AQYAAIdZuL1sUk9Sttx3o33xzpdwC,6000.0,IDR,550.0,500.0,0.0,50.0,6550.0,216620000180483821815,20070000016604140817,Helo,20210429 08:31:11,Helo,20210429
AQYAABgYdI8hQkGRs5ItKuotCw0C,2000.0,IDR,550.0,500.0,0.0,50.0,2550.0,216620000180483821815,20070000016604140817,Helo,20210428 16:12:39,Helo,20210429
AQYAAGW4Fa9ScLEDchMnCifB6QQQC,2000.0,IDR,550.0,500.0,0.0,50.0,2550.0,216620000180483821815,20070000016604140817,Helo,20210428 04:23:32,Helo,20210429
AQYAAHqKNZZZZElXkkurodWBvsUC,4000.0,IDR,550.0,500.0,0.0,50.0,4550.0,216620000180483821815,20070000016604140817,Helo,20210428 01:48:48,Helo,20210429
AQYAAPYv2fY99SUGKkUA39S0TE6wgC,4000.0,IDR,550.0,500.0,0.0,50.0,4550.0,216620000180483821815,20070000016604140817,Helo,20210428 09:53:28,Helo,20210429
AQYAAAS9PfR29ScUznjpvdBd99DbSkC,2000.0,IDR,550.0,500.0,0.0,50.0,2550.0,216620000180483821815,20070000016604140817,Helo,20210428 02:28:05,Helo,20210429