Partner Settlement Process

2023-08-08 06:59

Settlement Process

The settlement is done on a T+1 basis and the relevant amount is credited into the partner's bank account. The bank details are captured during the onboarding process.

Settlement File

The settlement file is generated on T+1 and stored in a secured SFTP location. The file is in CSV format. The file is generated at 9 AM on the next day that T+1. The SFTP folder can either be access directly by the Merchant's backend system to extract the files OR an actual user (eg. the Merchant's Finance PIC) can access the SFTP folder using programs like WinSCP (https://winscp.net/eng/download.php)

Accessing the Settlement File

The following steps are to be followed to access the settlement file:

To access the SFTP the relevant IP Address has to be whitelisted. The IP address will be passed to the relevant team for processing the request.
After whitelisting is complete, the below formation will be provided to the Merchant for accessing the SFTP folder:

Host Name: The hostname to access the SFTP
Port Number: The port number to access the SFTP
User Name: The user name is the Partner ID/MerchantID/MID that is created while onboarding
Password: This will be created during onboarding

Inside the SFTP folder, Merchant will be able to find the "settlement" folder. In there will contain an individual folder for each date of transaction. In each date folder, there will be a .csv file as per the below naming convention.

File Naming Convention

The file name consists of 3 parts as per below:

MERCHANT_SETTLEMENT_217120000001951865257_20201209 _ _ _ _

MERCHANT_SETTLEMENT	This denotes the purpose of the file
217120000001951865257	This the Partner ID/Merchant ID/MID that is created during onboarding
20201209	The date of transaction

Sample File

The sample CSV file is attached below.

📎MERCHANT_SETTLEMENT_217120000001951865257_20201214.csv

File Fields & Definitions

Summary Section

Field	Length / Type	Sample
Title	(100) string	SETTLEMENT_SUMMARY
INVOICE_NO	(100) string	E/200406A02111926
INVOICE_DATE	DD/MM/YYYY	5/4/2020
SETTLEMENT_BATCH_NO	(35) string	20200721111213810400171009302746820
MERCHANT_ID	(32) string	217125500055098351954
MERCHANT_NAME	(32) string	TNGD
NET_TRANSACTION_AMOUNT	(16) string	28830
NET_COMMISSION_AMOUNT	(16) string	0
NET_SETTLEMENT_AMOUNT	(16) string	0
TOTAL_COUNT	(14) string	20

Detail Section

No.	Field Name	Length	Description
1	MERCHANT_ID	(32) string	The merchant ID generated by TNGD during onboarding. This is also referred to as MID or Partner ID
2	MERCHANT_NAME	(32) string	The merchant name configured on TNGD system
3	SHOP_ID	(32) string	The actual sub merchant id where the user makes the transaction
4	SHOP_NAME	(100) string	The actual sub merchant name where the user makes the transaction
5	MERCHANT_TRANS_ID	(64) string	Must be unique transaction no, generated by the partner
6	ACQUIREMENT_ID	(35) string	Unique transaction reference provided by TNGD
7	TRANSACTION_TYPE	(6) string	Payment/Refund based on the request received by the partner
8	TRANSACTION_REQUEST_ID	(14) string	When the txn_type is ‘Refund’, this is the unique request id provided by the partner while making the refund request
9	TRANSACTION_ID	(35) string	If txn_type is PAYMENT, the value is the same as ACQUIREMENT_ID; If txn_type is REFUND, the value is wallet refund_id/refund_id;
10	PRODUCT_CODE	(20) string	The acquirement product code, provided by TNGD
11	TRANSACTION_AMOUNT	(16) string	Always positive, and unit is Cent. 10.00
12	TRANSACTION_CURRENCY	(3) string	MYR
13	TRANSACTION_DATETIME	Date time	The payment or refund transaction Date and the Format is "yyyy/MM/dd HH:MM:SS"
14	COMMISSION_AMOUNT	(16) string	Always a positive number and its Unit is cent. For the ‘Payment’ type, it is the fee TNGD charges partner. For the ‘Refund’ type, it is the fee TNGD returns to the partner
15	COMMISSION_TAX	(16) string	Reserved Field. Currently, there is no Tax in Malaysia. It's a positive number and the unit is cent.
16	SETTLE_AMOUNT	(16) string	Refers to the Net Settlement Amount, it's a positive number and the unit is Cent. settle_amount = transaction_amount - commission_amount.
17	PAY_METHOD	(7) string	Currently, value is balance by default. Several pay_methods will be separated by "\|".
18	MERCHANT_CUST_ID	(32) string	User identifier in on partner system