Settlement Report (Reconciliation)

PG Settlement Report provides merchants the fund transfer or balance clearance and settlement reconciliation for a specific date.

Version 1.0, 2.0 and 3.0 will be obsoleted and the following is the latest specification of version 4.0 ,5.0 and 6.0. Version 4.0, 5.0 and 6.0 will include refund and chargeback records that are excluded from the settlement batch. Version 5.0 supports pagination for big merchants.

Request

URL: https://api.fiuu.com/RMS/API/settlement/report.php

Method: GET

Formula of token

md5( {merchantID}{verify_key}{date} )

Response

📘
F row only available in version 5.0 and when page value is more than 0. To speed up the response on the subsequence pages, row R & G will be excluded and may only appear at page 1.

Error (always in JSON format)

Example (in JSON format)

The following example might not be accurate and please only take it as a format reference

[
	{
    	"RecordIdentifier": "H",
    	"SettlementCurrency": "MYR",
    	"SettlementNetAmount": "1033293",
    	"SettlementCommissionAmount": "2439",
    	"NumberOfTransactions": 15,
    	"BatchReferenceNumber": "20170817-613",
    	"SettlementDate": "20170817",
    	"SettlementGSTAmount": "2239",
    	"BankAccount": "(MALAYAN BANKING BHD) MerchantID SDN BHD 5144 8457 3110",
    	"RefundNetAmount": "179741",
    	"RefundGSTAmount": "334"
	},
	{
        "RecordIdentifier": "D",
        "MerchantId": "merchantIDSB",
        "OrderId": "OP-02559",
        "Channel": "maybank2u",
        "AcquirerReference": "18300981",
        "RefundFees": "0",
        "TransactionNetAmount": "9732",
        "TransactionCommissionAmount": "178",
        "TransactionDate": "20170807",
        "TransactionTime": "112250",
        "TransactionGrossAmount": "9900",
        "TransactionCurrency": "MYR",
        "TransactionGST": "010",
        "SettlementNetAmountInProcessingCurrency": "9722",
        "SettlementNetAmount": "000",
        "SettlementCurrency": "MYR",
        "Forex": null,
        "Status": "SETTLED"
        }, 
        {
        "RecordIdentifier": "D",
        "MerchantId": "merchantIDSB",
        "OrderId": "163138",
        "Channel": "credit",
        "AcquirerReference": "18310736",
        "RefundFees": "0",
        "TransactionNetAmount": "294521",
        "TransactionCommissionAmount": "9656",
        "TransactionDate": "20170807",
        "TransactionTime": "133001",
        "TransactionGrossAmount": "303630",
        "TransactionCurrency": "MYR",
        "TransactionGST": "547",
        "SettlementNetAmountInProcessingCurrency": "293974",
        "SettlementNetAmount": "000",
        "SettlementCurrency": "MYR",
        "Forex": null,
        "Status": "SETTLED"
        },
				{
        "RecordIdentifier": "D",
        "MerchantId": "merchantIDSB",
        "OrderId": "79126387162378123",
        "Channel": "credit",
        "AcquirerReference": "18516590",
        "RefundFees": "0",
        "TransactionNetAmount": "153745",
        "TransactionCommissionAmount": "5040",
        "TransactionDate": "20170810",
        "TransactionTime": "120057",
        "TransactionGrossAmount": "158500",
        "TransactionCurrency": "MYR",
        "TransactionGST": "285",
        "SettlementNetAmountInProcessingCurrency": "153460",
        "SettlementNetAmount": "000",
        "SettlementCurrency": "MYR",
        "Forex": null,
        "Status": "SETTLED"
        }, 
        {
        "RecordIdentifier": "D",
        "MerchantId": "merchantIDSB",
        "OrderId": "31283671293",
        "Channel": "credit",
        "AcquirerReference": "18532262",
        "RefundFees": "0",
        "TransactionNetAmount": "9700",
        "TransactionCommissionAmount": "318",
        "TransactionDate": "20170810",
        "TransactionTime": "155958",
        "TransactionGrossAmount": "10000",
        "TransactionCurrency": "MYR",
        "TransactionGST": "018",
        "SettlementNetAmountInProcessingCurrency": "9682",
        "SettlementNetAmount": "000",
        "SettlementCurrency": "MYR",
        "Forex": null,
        "Status": "SETTLED"
        },

	{
        "RecordIdentifier": "R",
        "MerchantId": "merchantIDSB",
        "OrderId": "54671293761293",
        "Channel": "credit",
        "AcquirerReference": "13251784",
        "RefundFees": 0,
        "TransactionNetAmount": "-179741",
        "TransactionCommissionAmount": "000",
        "TransactionDate": "20170503",
        "TransactionTime": "155958",
        "TransactionGrossAmount": "-185300",
        "TransactionCurrency": "MYR",
        "TransactionGST": "-018",
        "SettlementNetAmountInProcessingCurrency": "-179741",
        "SettlementNetAmount": "000",
        "SettlementCurrency": "MYR",
        "Forex": null,
        "Status": "REFUND"
        }
]

Unsettled/Refunded Transaction Report (Exclusion from settlement)

Any unsettled transaction that has been canceled within a given settlement batch will be retrievable using this API

Request

URL: https://api.fiuu.com/RMS/API/settlement/report_refund.php

Method: GET

Formula of token

md5( {merchantID}{verify_key}{date} )