Skip to main content

Payment Services Settlement File Specification

Document Version 1.2.0

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 NameMERCHANT_SETTLEMENT_MID_UNIT_UNIT NAME_YYYYMMDD.csv (YYYYMMDD refer to the transaction date)
File Format.csv
FunctionThis settlement is used to show all recorded payment services based on a certain time
Settlement Cut Off00.00.00
DelimiterSemicolon
Related Solution

File generation​

The following sections are the details on how the file is generated:

  1. Merchant can choose when the settlement file will be generated and get the payout. T+X where X >= 1
  2. Merchant can choose what kind of settlement file unit will be used.
    • MERCHANT
    • DIVISION/REGION
    • SHOP
  3. DANA will deliver the settlement file and payout based on the agreed #1 and #2

Additional Information​

Highlight for Gapura Payment Gateway Scenario: TXN_TYPE ACQUIRING_ORDER with PAY_METHOD ADJUSTMENT is the process of crediting the merchant's account. This only applies when DANA cannot do a refund process in the Gapura Payment Gateway business scenario.

File Format​

FieldTypeDescription
SETTLEMENT_TXN_IDString1 - 64 char
Settlement file’s batch number
TXN_IDString1 - 64 char
Transaction identifier based on TXN_TYPE, with these rules:
  • ACQUIRING_ORDER: acquirementId
  • VOUCHER_DEDUCTION: acquirementId
  • CAPTURE: captureId
  • REFUND: refundId
  • CANCEL: acquirementId
TXN_TYPEString1 - 32 char
Transaction type, values:
  • ACQUIRING_ORDER
  • VOUCHER_DEDUCTION
  • CAPTURE
  • REFUND
  • CANCEL
ACQUIREMENT_IDString1 - 64 char
acquirementId or referenceNo from API response
MIDString1 - 64 char
Merchant identifier assigned by DANA
SETTLE_DATEDatetime25 char
Settlement date in format YYYY-MM-DDTHH:mm:ss+07:00 (GMT+7)
MERCHANT_NAMEString1 - 128 char
Merchant official name
TXN_AMOUNTLong1 - 18 char
Transaction amount in cent, with these rules:
  • ACQUIRING_ORDER = transaction amount
  • VOUCHER_DEDUCTION = voucher amount
  • CAPTURE = capture amount
  • REFUND = refund amount
  • CANCEL = cancel amount
TXN_CURRENCYString1 - 3 char
3-letter currency code, typically IDR
TXN_DATEDatetime25 char
Date time with timezone, in format YYYY-MM-DDTHH:mm:ss+07:00. Time must be in GMT+7 (Jakarta time) and with these rules:
  • ACQUIRING_ORDER = acquire success date time
  • VOUCHER_DEDUCTION = acquire success date time
  • CAPTURE = capture success date time
  • REFUND = refund success date time
  • CANCEL = cancel success date time
ORIGINAL_TXN_IDString1 - 64 char
Original transaction identifier, with these rules:
  • REFUND = when refund is specific to acquiring order, the value is acquirementId; and when refund is specific to capture, the value is captureId
  • CANCEL = acquirementId
TXN_TYPE == REFUND or CANCEL
ORIGINAL_TXN_DATEDatetime25 char
Original transaction date, in format YYYY-MM-DDTHH:mm:ss+07:00. Time must be in GMT+7 (Jakarta time) and with these rules:
  • REFUND = when refund is specific to acquiring order, the value is acquire success date; and when refund is specific to capture, the value is capture success date
  • CANCEL = acquire success date
TXN_TYPE == REFUND or CANCEL
MERCHANT_COMMISSION_EDIKString1 - 18 char
Charged fee to the merchant (in cent)
SERVICE_TAX_EDIKString1 - 18 char
Tax of the charged fee paid by the merchant (in cent)
WITHHOLDING_TAX_EDIKString1 - 18 char
Withholding tax
MERCHANT_COMMISSION_ASRString1 - 18 char
Charged fee to the merchant (in cent)
SERVICE_TAX_ASRString1 - 18 char
Tax of the charged fee paid by the merchant (in cent)
WITHHOLDING_TAX_ASRString1 - 18 char
Withholding tax
SETTLE_AMOUNTLong1 - 18 char
Settle amount, with these rules:
  • ACQUIRING_ORDER:
    SETTLE_AMOUNT = TXN_AMOUNT - MERCHANT_COMMISSION - SERVICE_TAX + WITHHOLDING_TAX
  • VOUCHER_DEDUCTION:
    SETTLE_AMOUNT = TXN_AMOUNT
  • CAPTURE:
    SETTLE_AMOUNT = TXN_AMOUNT - MERCHANT_COMMISSION - SERVICE_TAX + WITHHOLDING_TAX
  • REFUND :
    SETTLE_AMOUNT = TXN_AMOUNT - MERCHANT_COMMISSION - SERVICE_TAX + WITHHOLDING_TA
  • CANCEL:
    SETTLE_AMOUNT = TXN_AMOUNT - MERCHANT_COMMISSION - SERVICE_TAX + WITHHOLDING_TAX
MERCHANT_TRANS_IDString1 - 64 char
Merchant transaction identifier
MERCHANT_REQUEST_IDString1 - 64 char
Merchant request identifier, with these rules:
  • When the TXN_TYPE is CAPTURE, the value is the requestId of capture
  • When the TXN_TYPE is REFUND, the value is the requestId of refund
TXN_TYPE == REFUND or CAPTURE
PAY_METHODString1 - 32 char
Payment method.
Note: Payment method ADJUSTMENT is the process of crediting the merchant's account. This only applies when DANA cannot do a refund process in the Gapura Payment Gateway scenario
MERCHANT_CUST_IDString1 - 64 char
Send by the merchant from API, to identify user in merchant system
SETTLE_UNIT_TYPEString1 - 32 char
Settlement unit type: MERCHANT, REGION, SHOP
SETTLE_UNIT_VALUEString1 - 64 char
Settle unit value, with these rules:
  • Division/region identifier if settle unit is REGION
  • Shop identifier if settle unit is SHOP
SHOP_IDString1 - 64 char
Shop identifier
BUYER_MOBILE_NOString1 - 16 char
[OBSOLETE] Not used anymore
DIVISION_IDString1 - 64 char
Division/region identifier
PRODUCT_TYPEString1 - 16 char
Which product type is used for this transaction

Example CSV File Format​

Payment Services
File NameMERCHANT_SETTLEMENT_216620000005573112345_REGION_JAKARTA_20200128.csv (20200128 refer to the transaction date)
Example FileDownload Example File
Success Transaction
SETTLEMENT_TXN_ID;TXN_ID;TXN_TYPE;ACQUIREMENT_ID;MID;SETTLE_DATE;MERCHANT_NAME;TXN_AMOUNT;TXN_CURRENCY;TXN_DATE;ORIGINAL_TXN_ID;ORIGINAL_TXN_DATE;MERCHANT_COMMISSION_EDIK;SERVICE_TAX_EDIK;WITHHOLDING_TAX_EDIK;MERCHANT_COMMISSION_ASR;SERVICE_TAX_ASR;WITHHOLDING_TAX_ASR;SETTLE_AMOUNT;MERCHANT_TRANS_ID;MERCHANT_REQUEST_ID;PAY_METHOD;MERCHANT_CUST_ID;SETTLE_UNIT_TYPE;SETTLE_UNIT_VALUE;SHOP_ID;BUYER_MOBILE_NO;DIVISION_ID;PRODUCT_TYPE
20211214111213810400166007016111327;20211213111212800100166217756347323;ACQUIRING_ORDER;20211213111212800100166217756347323;216620000005573112345;2021-12-14T10:58:08+07:00;Sambal Pak Bayu;6600000;IDR;2021-12-13T10:58:08+07:00;;2021-12-13T10:00:01+07:00;41976;4198;0;0;0;0;6553826;GP791478099968220288;;BALANCE;;;;10790;;;MPM (Kode QR Penjual)
20211214111213810400166007016111327;20211213111212800100166217756347323;VOUCHER_DEDUCTION;20211213111212800100166217756347323;216620000005573112345;2021-12-14T10:58:08+07:00;Sambal Pak Bayu;2000000;IDR;2021-12-13T10:58:08+07:00;;2021-12-13T10:00:01+07:00;0;0;0;0;0;0;2000000;GP791478099968220288;;COUPON_DEALS;;;;10790;;;MPM (Kode QR Penjual)
20211214111213810400166007016111327;20211213111212800100166217756347323;ACQUIRING_ORDER;20211213111212800100166217756347323;216620000005573112345;2021-12-14T10:58:08+07:00;Sambal Pak Bayu;2000000;IDR;2021-12-13T10:58:08+07:00;;2021-12-13T10:00:01+07:00;0;0;0;0;0;0;2000000;GP791478099968220288;;COUPON_DEALS;;;;10790;;;MPM (Kode QR Penjual)
20211214111213810400166008516089937;20211213111212800100166381655722251;ACQUIRING_ORDER;;216620000005573112345;2021-12-14T00:02:49+07:00;Sambal Pak Bayu;45000;IDR;2021-12-13T00:02:49+07:00;;2021-12-13T23:44:40+07:00;0;0;0;0;0;0;0;BL21173R7KTIINV;;REBATE;3978211;DEFAULT;DEFAULT;;;;Auto Debit
20211214111213810400166008516089937;20211213111212801300166384744796198;REFUND;;216620000005573112345;2021-12-14T00:02:53+07:00;Sambal Pak Bayu;45000;IDR;2021-12-13T00:02:53+07:00;20211213111212800100166381655722251;2021-12-13T23:44:40+07:00;0;0;0;0;0;0;0;BL21173R7KTIINV;f89103f9-427e-4dba-8ade-e158049309c8;REBATE;3978211;DEFAULT;DEFAULT;;;;Auto Debit
20211214111213810400166008516089937;20211212111212800110166738354425938;ACQUIRING_ORDER;;216620000005573112345;2021-12-14T23:09:38+07:00;Sambal Pak Bayu;50000;IDR;2021-12-12T23:09:38+07:00;;2021-12-12T23:04:38+07:00;500;50;0;0;0;0;49450;BL21173R4AFKINV;;BALANCE;548061827;DEFAULT;DEFAULT;;;;Online Cashier
20211214111213810400166008516089937;20211212111212800110166738354425938;CANCEL;;216620000005573112345;2021-12-14T23:09:38+07:00;Sambal Pak Bayu;50000;IDR;2021-12-12T23:09:38+07:00;20211212111212800110166738354425938;2021-12-12T23:04:38+07:00;500;50;0;0;0;0;49450;BL21173R4AFKINV;;BALANCE;548061827;DEFAULT;DEFAULT;;;;Online Cashier
20211214111213810400166008516089937;20211213111212800110166442454401805;ACQUIRING_ORDER;;216620000005573112345;2021-12-14T00:00:21+07:00;Sambal Pak Bayu;1014000;IDR;2021-12-13T00:00:21+07:00;;2021-12-13T23:55:00+07:00;10140;1014;0;0;0;0;1002846;BL21173R7ENOINV;;BALANCE;34847407;DEFAULT;DEFAULT;;;;Online Cashier
20211214111213810400166008516089937;20211213111212801300166988445615496;REFUND;;216620000005573112345;2021-12-14T00:00:26+07:00;Sambal Pak Bayu;1014000;IDR;2021-12-13T00:00:26+07:00;20211213111212800110166442454401805;2021-12-13T23:57:08+07:00;0;0;0;0;0;0;1014000;BL21173R7ENOINV;ded25302-33bc-49c0-9564-24a1302ba793;BALANCE;34847407;DEFAULT;DEFAULT;;;;Online Cashier
20220211111213810400166003417174859;20220210111212801800166418504527898;CAPTURE;20220210111212800100166410960423200;216620000005573112345;2022-02-11T06:31:54+07:00;Sambal Pak Bayu;4312000;IDR;2022-02-10T06:31:54+07:00;;2022-02-10T06:22:54+07:00;21560;2156;0;0;0;0;4288284;43690613-6281281749288-20220209225420-1;f5e4730a-d2b1-416f-88ac-f87d9dfc262e;BALANCE;;;;;;;Auth Capture
20231012111213810400166002126971912;20231011111212800100166975862922599;ACQUIRING_ORDER;20231011111212800100166975862922599;216620000646227614331;2022-02-11T06:31:54+07:00;Sambal Pak Bayu;2103200;IDR;2023-10-11T18:59:39+07:00;;;0;0;0;0;0;0;2103200;12010220231011011002173068496285;;ADJUSTMENT;;DEFAULT;DEFAULT;;;;Direct Agreement Pay
Version 1.2.0 - October 29, 2024
Affected Solutions
Changes
  • Added a new section “Additional Information”
Version 1.1.0 - October 18, 2024
Affected Solutions
Changes
  • Updated remarks on PAY_METHOD by adding new value for Payment Gateway Solution
  • Updated File Content
Version 1.0.7 - January 26, 2024
Affected Solutions
Changes
  • Updated document format on Specification section
  • Added a new Info Panel & Document Version section
Version 1.0.6 - Jan 15, 2024
Affected Solutions
Changes
  • Updated the values in the Specification table for: File Version, Related Service
Version 1.0.5 - September 19, 2023
Affected Solutions
Changes
  • Updated the values in the Specification table for: File Version, Related Service
Version 1.0.4 - July 07, 2023
Affected Solutions
Changes
  • Updated the values in the Specification table for: File Version, Delimiter, Related Service
  • Updated remarks for ACQUIREMENT_ID
Version 1.0.3 - May 26, 2023
Affected Solutions
Changes
  • Updated the values in the Specification table for: Settlement Cut Off, Related Service
Version 1.0.2 - March 08, 2023
Affected Solutions
Changes
  • Updated content based on document format
  • Added information about the data format of the File Name in the Specification and Example CSV section
Version 1.0.1 - August 04, 2022
Affected Solutions
Changes
  • Changed the file name format
  • Updated the content of the file generation section
  • Updated the datetime format
  • Updated the file sample with the new datetime format
  • Updated the currency length
  • Updated the file version on the specification table
  • Changed “Settlement Time” into “Settlement Cut Off” on the specification section
  • Changed “Related API” into “Related Service” on the specification table
Version 1.0.0 - July 11, 2022
  • Initial Document