Reconciliation reports - Waffo Documentation

Overview

Waffo provides transaction and settlement reports for reconciliation. It explains the definitions of the reports, how to obtain and use them for reconciliation.

All report files are in CSV (Comma-Separated Values) format with UTF-8 encoding. Reconciliation reports older than 7 days on the SFTP server might be deleted and can still be downloaded from Merchant Portal.

Enable SFTP access

To receive reconciliation reports through SFTP, contact Waffo technical support to enable access. Before requesting access, prepare:

The email address that should receive SFTP account details and follow-up notifications.
The public IP address or IP range that will connect to the SFTP server.

Waffo technical support will configure access based on this information and share the SFTP connection details when the setup is complete. After access is enabled, download files from the SFTP paths listed in each report section.

Transaction Details Report

The transaction details report contains detailed records of all transactions on T day. It is generated on T+1 day. If there is no transaction on T day, it generates an empty file containing a header of field names only. Obtaining

Query from Merchant Portal.
Download through SFTP Server\transactions\\{transaction date}\
File name: transaction_details_{merchant id}_{transaction date}.csv
- merchant id: The unique identifier is assigned by Waffo to identify a merchant.
- transaction date: The date on which the transaction is processed, in the format of YYYYMMDD and time zone of UTC+8.

Fields

Field	Type	Description
Merchant Id	MANDATORY String (64)	The unique identifier that is assigned by Waffo to identify a merchant.
Sub Merchant Id	OPTIONAL String (64)	The unique identifier that is assigned by Waffo to identify a secondary merchant that directly provides services or goods to users.
Order Id	MANDATORY String (32)	The unique identifier that is assigned by Waffo to identify a transaction or chargeback. When ‘Transaction Type’ is `PAYMENT`, it indicates a payment transaction id. When ‘Transaction Type’ is `REFUND`, it indicates a refund transaction id. When ‘Transaction Type’ is `CHARGEBACK`, it indicates a chargeback id.
Merchant Order Id	OPTIONAL String (32)	The unique identifier that is assigned by the merchant to identify a transaction.
Payment Request Id	OPTIONAL String (32)	The unique identifier that is assigned by the merchant to identify a transaction payment request.
Original Order Id	OPTIONAL String (32)	The unique identifier for the original transaction. When ‘Transaction Type’ is `PAYMENT`, it is empty. When ‘Transaction Type’ is `REFUND` or `CHARGEBACK`, it indicates the original payment transaction id.
Order Amount	MANDATORY String (24)	The transaction amount in corresponding currency.
Order Currency	MANDATORY String (3)	The currency of transaction amount, specified by a 3-letter currency code as defined in ISO 4217.
Transaction Type	MANDATORY String (32)	The type of transaction. `PAYMENT`: it indicates a payment transaction. `REFUND`: it indicates a refund transaction. `CHARGEBACK`: it indicates a chargeback.
Payment Method	MANDATORY String (32)	The payment method for processing the payment. Refer to API specifications.
Payment Option	OPTIONAL String (32)	The payment option stands for sub method of payment method for processing the payment processing the payment. e.g. Payment option is balance when using DANA balance for the payment. When there is no payment option, it is empty.
Payment Request Datetime	MANDATORY String (32)	The datetime that Waffo receives payment request from the merchant, in the format of YYYY-MM-DD hh:mm:ss and in Time Zone UTC+8.
Payment Date	MANDATORY String (32)	The datetime when the corresponding transaction reaches success status, in the format of YYYY-MM-DD and time zone of UTC+8.
Payment Time	MANDATORY String (32)	The datetime when the corresponding transaction reaches success status, in the format of hh:mm:ss and time zone of UTC+8.
Order Description	OPTIONAL String (128)	The description of the transaction.
Product Name	MANDATORY String (32)	The payment product that is contracted between Waffo and the merchant. `ONE_TIME_PAYMENT`: One Time Payment Product
Merchant User Id	OPTIONAL String (64)	The unique identifier that is assigned by the merchant to identify its own user.

Example

Text

Merchant Id,Sub Merchant Id,Order Id,Merchant Order Id,Payment Request Id,Original Order Id,Order Amount,Order Currency,Transaction Type,Payment Method,Payment Option,Payment Request Datetime,Payment Date,Payment Time,Order Description,Product Name,Merchant User Id
1000000001,2000000001,A202407310821400761577,MO202407310821400601333,PR2024073108214006013332,,100.00,HKD,PAYMENT,ALIPAY,,2024-08-06 16:22:27,2024-08-06,16:22:28,Order Description1,ONE_TIME_PAYMENT,userId12345678
1000000001,2000000001,A202407310826263631579,MO202407310821400601333,PR2024073108214006013331,A202407310821400761577,10.00,HKD,REFUND,ALIPAY,,2024-08-06 16:22:04,2024-08-06,16:22:05,,ONE_TIME_PAYMENT,userId12345678

Settlement Details Report

The settlement details report contains detailed settlement records for each transaction within a settlement period. It is generated on the next day after receiving the bank receipt for the settlement. If there is no net settlement on settlement date, it will NOT generate settlement details report. If you need the empty report that has no transaction, please contact the technical support team to configure it. Obtaining

Query or download from Merchant Portal.
Download through SFTP Server\settlements\\{settlement date}\
File name: settlement_details_{merchant id}_{settlement batch id}_{settlement date}_{settlement currency}.csv
- merchant id: The unique identifier is assigned by Waffo to identify a merchant.
- settlement batch id: The unique identifier that is assigned by Waffo to identify a settlement within a settlement period.
- settlement date: The date on which the settlement file is generated, in the format of YYYYMMDD and time zone of UTC+8.
- settlement currency: The currency of settlement amount.

Fields

Field	Type	Description
Merchant Id	MANDATORY String (64)	The unique identifier that is assigned by Waffo to identify a merchant.
Sub Merchant Id	OPTIONAL String (64)	The unique identifier that is assigned by Waffo to identify a secondary merchant that directly provides services or goods to users.
Settlement Batch Id	MANDATORY String (64)	The unique identifier that is assigned by Waffo to identify a settlement within a settlement period.
Settlement Date	MANDATORY String (16)	The date when the settlement file is generated, in the format of YYYY-MM-DD and time zone of UTC+8.
Order Id	MANDATORY String (32)	The unique identifier that is assigned by Waffo to identify a transaction or chargeback. When ‘Transaction Type’ is `PAYMENT`, it indicates a payment transaction id. When ‘Transaction Type’ is `REFUND`, it indicates a refund transaction id. When ‘Transaction Type’ is `CHARGEBACK`, it indicates a chargeback id.
Merchant Order Id	OPTIONAL String (32)	The unique identifier that is assigned by the merchant to identify a transaction.
Payment Request Id	OPTIONAL String (32)	The unique identifier that is assigned by the merchant to identify a transaction payment request. When ‘Transaction Type’ is `CHARGEBACK`, it is empty.
Original Order Id	OPTIONAL String (32)	The unique identifier for the original transaction. When ‘Transaction Type’ is `PAYMENT`, it is empty. When ‘Transaction Type’ is `REFUND`or `CHARGEBACK`, it indicates the original payment transaction id.
Order Amount	MANDATORY String (24)	The transaction amount in corresponding currency.
Order Amount (Settlement Currency)	MANDATORY String (24)	The transaction amount in settlement currency.
Order Currency	MANDATORY String (3)	The currency of transaction amount, specified by a 3-letter currency code as defined in ISO 4217.
Transaction Type	MANDATORY String (16)	The type of transaction. `PAYMENT`: it indicates a payment transaction. `REFUND`: it indicates a refund transaction. `CHARGEBACK`: it indicates a chargeback.
Payment Method Type	MANDATORY String (32)	The payment method type for processing the payment. Refer to API specifications.
Payment Method	MANDATORY String (32)	The payment method for processing the payment. Refer to API specifications.
Payment Option	OPTIONAL String (32)	The payment option stands for sub method of payment method for processing the payment processing the payment. e.g. Payment option is balance when using DANA balance for the payment. When there is no payment option, it is empty.
Payment Request Datetime	MANDATORY String (32)	The datetime that Waffo receives payment request from the merchant, in the format of YYYY-MM-DD hh:mm:ss and in Time Zone UTC+8.
Payment Date	MANDATORY String (32)	The datetime when the corresponding transaction reaches success status, in the format of YYYY-MM-DD hh:mm:ss and time zone of UTC+8.
Payment Time	MANDATORY String (32)	The datetime when the corresponding transaction reaches success status, in the format of hh:mm:ss and time zone of UTC+8.
Product Name	MANDATORY String (32)	The payment product that is contracted between Waffo and the merchant. `ONE_TIME_PAYMENT`: One Time Payment Product
Forex Currency Pair	OPTIONAL String (16)	The currency pair for the settlement process in foreign exchange is denoted by separating the two currencies with a slash and using their 3-letter ISO 4217 currency codes (e.g., USD/HKD). The specific currency pairs are determined as follows: If the Settlement Currency is not equal to the Order Currency, the pair is indicated as `Settlement Currency/Order Currency`. If the Settlement Currency is not equal to the Fee Currency (and the previous condition does not apply), the pair is indicated as `Settlement Currency/Fee Currency`. If none of the above conditions apply (i.e., there is no foreign exchange involved), it remains empty.
Forex Rate	OPTIONAL String (24)	The foreign exchange rate of Forex Currency Pair for settlement process, which is provided by the foreign exchange partner. It is empty when the Forex Currency Pair is empty.
Fee Amount	MANDATORY String (24)	The amount of the processing fee that is charged by Waffo.
Fee Amount (Settlement Currency)	MANDATORY String (24)	The amount of the processing fee in settlement currency that is charged by Waffo.
Fee Currency	MANDATORY String (3)	The currency of fee amount, specified by a 3-letter currency code as defined in ISO 4217.
VAT Amount	OPTIONAL String (24)	The amount of the Value-Added Tax for this transaction if applicable.
VAT Amount (Settlement Currency)	OPTIONAL String (24)	The amount of the Value-Added Tax in settlement currency for this transaction if applicable.
VAT Currency	OPTIONAL String (3)	The currency of Value-Added Tax amount, specified by a 3-letter currency code as defined in ISO 4217.
WHT Amount	OPTIONAL String (24)	The amount of the Withholding Tax for this transaction if applicable.
WHT Amount (Settlement Currency)	OPTIONAL String (24)	The amount of the Withholding Tax in settlement currency for this transaction if applicable.
WHT Currency	OPTIONAL String (3)	The currency of Withholding Tax amount, specified by a 3-letter currency code as defined in ISO 4217.
Settlement Amount	MANDATORY String (24)	The net settlement amount in corresponding currency.
Settlement Currency	MANDATORY String (3)	The currency of settlement amount, specified by a 3-letter currency code as defined in ISO 4217.

Example

Text

Merchant Id,Sub Merchant Id,Settlement Batch Id,Settlement Date,Order Id,Merchant Order Id,Payment Request Id,Original Order Id,Order Amount,Order Amount (Settlement Currency),Order Currency,Transaction Type,Payment Method Type,Payment Method,Payment Option,Payment Request Datetime,Payment Date,Payment Time,Product Name,Forex Currency Pair,Forex Rate,Fee Amount,Fee Amount (Settlement Currency),Fee Currency,VAT Amount,VAT Amount (Settlement Currency),VAT Currency,WHT Amount,WHT Amount (Settlement Currency),WHT Currency,Settlement Amount,Settlement Currency
1000000001,2000000001,S2024073108214,2020-08-08,A202407310821400761571,MO202407310821400601331,PR2024073108214006013331,,100.00,100.00,USD,PAYMENT,EWALLET,ALIPAY,,2024-08-06 16:21:00,2024-08-06,16:21:00,ONE_TIME_PAYMENT,,,1.00,1.00,USD,,,,,,,99.00,USD
1000000001,2000000001,S2024073108214,2020-08-08,A202407310826263631572,MO202407310821400601332,PR2024073108214006013332,A202407310821400761571,10.00,10.00,USD,REFUND,EWALLET,ALIPAY,,2024-08-06 16:22:00,2024-08-06,16:22:00,ONE_TIME_PAYMENT,,,0.00,0.00,USD,,,,,,,-10.00,USD
1000000001,2000000001,S2024073108214,2020-08-08,A202407310821400761573,MO202407310821400601333,PR2024073108214006013333,,100.00,12.83,HKD,PAYMENT,EWALLET,ALIPAY,,2024-08-06 16:23:00,2024-08-06,16:23:00,ONE_TIME_PAYMENT,USD/HKD,7.79217921,1.00,0.12,HKD,,,,,,,12.71,USD
1000000001,2000000001,S2024073108214,2020-08-08,A202407310826263631584,MO202407310821400601334,PR2024073108214006013334,A202407310821400761573,10.00,1.28,HKD,REFUND,EWALLET,ALIPAY,,2024-08-06 16:24:00,2024-08-06,16:24:00,ONE_TIME_PAYMENT,USD/HKD,7.79217921,0.00,0.00,HKD,,,,,,,-1.28,USD

Settlement Summary Report

The settlement summary report contains settlement summary for all transactions with the same settlement currency and net settlement amount within a settlement period. It is generated on the next day after receiving the bank receipt for the settlement. If there is no net settlement on settlement date, it will NOT generate settlement summary report. If you need the empty report that has no transaction, please contact the technical support team to configure it. Obtaining

Query or download from Merchant Portal.
Download through SFTP Server\settlements\\{settlement date}\
File name: settlement_summary_{merchant id}_{settlement batch id}_{settlement date}_{settlement currency}.csv
- merchant id: The unique identifier is assigned by Waffo to identify a merchant.
- settlement batch id: The unique identifier that is assigned by Waffo to identify a settlement within a settlement period.
- settlement date: The date on which the settlement file is generated, in the format of YYYYMMDD and time zone of UTC+8.
- settlement currency: The currency of settlement amount.

Fields

Field	Type	Description
Merchant Id	MANDATORY String (64)	The unique identifier that is assigned by Waffo to identify a merchant.
Settlement Batch Id	MANDATORY String (64)	The unique identifier that is assigned by Waffo to identify a settlement within a settlement period.
Settlement Date	MANDATORY String (16)	The date when the settlement file is generated, in the format of YYYY-MM-DD and time zone of UTC+8.
Transaction Type	MANDATORY String (32)	The type of transaction. `TOTAL`: it indicates all transactions. `PAYMENT`: it indicates payment transactions. `REFUND`: it indicates refund transactions. `CHARGEBACK`: it indicates refund chargebacks.
Transaction Count	MANDATORY String (16)	The total number of transactions of specified transaction type.
Fee Amount (Settlement Currency)	MANDATORY String (24)	The amount of the processing fee in settlement currency that is charged by Waffo.
VAT Amount (Settlement Currency)	OPTIONAL String (24)	Amount of the Value-Added Tax in settlement currency for this transaction if applicable.
WHT Amount (Settlement Currency)	OPTIONAL String (24)	Amount of the Withholding Tax in settlement currency for this transaction if applicable.
Settlement Amount	MANDATORY String (24)	The total amount of net settlement for all transactions of specified transaction type.
Settlement Currency	MANDATORY String (3)	The currency of settlement amount, specified by a 3-letter currency code as defined in ISO 4217.

Example

Text

Merchant Id,Settlement Batch Id,Settlement Date,Transaction Type,Transaction Count,Fee Amount (Settlement Currency),VAT Amount (Settlement Currency),WHT Amount (Settlement Currency),Settlement Amount,Settlement Currency
1000000001,S2024073108214,2020-08-08,TOTAL,100,1.12,1.12,,90.42,USD
1000000001,S2024073108214,2020-08-08,PAYMENT,97,1.00,1.12,,111.70,USD
1000000001,S2024073108214,2020-08-08,REFUND,2,,,,-11.28,USD
1000000001,S2024073108214,2020-08-08,CHARGEBACK,1,0.12,,,-10.00,USD

​Overview

​Enable SFTP access

​Transaction Details Report

​Settlement Details Report

​Settlement Summary Report

Overview

Enable SFTP access

Transaction Details Report

Settlement Details Report

Settlement Summary Report