Virtual Account (VA) Settlement File
Document Version 1.0.4
The settlement file report is used by DANA to do reconciliation transaction. The settlement file gives detailed information about each transaction that affects funds settlement to DANA Bank accounts.
| File Name | VIRTUAL_ACCOUNT_[CHANNEL_ID]_YYYYMMDD.csv (YYYYMMDD refer to the transaction date) |
| File Format | .csv |
| Function | The settlement file report is used by DANA to do reconciliation transaction and provide detailed information about each transaction that affects funds settlement to DANA Bank accounts |
| Settlement Cut Off | 00.00.00 |
| Delimiter | Comma |
| Related Services | Virtual Account (VA) |
File Generation
The following sections are the details on how the file is generated:
- Bank/merchant need to generate the settlement file T+1 after transaction.
- Bank/merchant will deliver the settlement file through SFTP.
File Format
| Field | Type | Description |
|---|---|---|
| PAYMENT_REQUEST_ID | String1 - 64 char | Unique reference identifier generated by Bank system Notes:
|
| REFERENCE_NO | String1 - 64 char | Payment auth code generated by Bank |
| TRX_DATE_TIME | Datetime25 char | Bank internal system datetime with timezone, in format YYYY-MM-DDTHH:mm:ss+07:00. Time must be in GMT+7 (Jakarta time) |
| VIRTUAL_ACCOUNT_NO | String1 - 28 char | Information of virtual account number which combine partnerServiceId and customerNo |
| VIRTUAL_ACCOUNT_NAME | String1 - 50 char | Customer name |
| HASHED_SOURCE_ACCOUNT_NO | String1 - 32 char | Source account number in hash |
| CURRENCY | String1 - 3 char | 3-letter currency code, typically it’s IDR |
| TOTAL_AMOUNT | Long1 - 32 char | Amount based on the minor currency |
| PAID_AMOUNT | Long1 - 32 char | Settled net amount |
| FEE_AMOUNT | Long1 - 32 char | Fee amount Notes: If fee calculate net off, put zero |
| VALUE_ADDED_TAX | Long1 - 32 char | Put if value added tax exist |
| WITH_HOLDING_TAX | Long1 - 32 char | Put if withholding tax exist |
Example CSV File Format
Virtual Account (VA)
| File Name | VIRTUAL_ACCOUNT_[CHANNEL_ID]_20220404.csv (20220404 refer to the transaction date) |
| Example File | Download Example File |
PAYMENT_REQUEST_ID,REFERENCE_NO,TRX_DATE_TIME,VIRTUAL_ACCOUNT_NO,VIRTUAL_ACCOUNT_NAME,HASHED_SOURCE_ACCOUNT_NO,CURRENCY,TOTAL_AMOUNT,PAID_AMOUNT,FEE_AMOUNT,VALUE_ADDED_TAX,WITH_HOLDING_TAX
160755501286,2022021410121481030100166897500561786,2022-02-14T16:10:36+07:00,081568406663,123456,123456,IDR,12000,12250,227,23,0
182032937836,2022021410121481030100166737700558283,2022-02-14T18:23:16+07:00,08127416027,123456,123456,IDR,25000,25250,227,23,0
231624645364,2022021410121481030100166897500561792,2022-02-14T23:19:07+07:00,081568406663,123456,123456,IDR,20000,20250,227,23,0
