MMS - Settlement Report File
About MMS - Settlement Report FIle
Settlement Report File uses by Merchant to check the Settlement report in offline mode until specific time. Settlement Report File obtained by download the file on MMS - Settlement - Settlement Report menu.
MMS - Settlement Report File
On Settlement Report menu, there are 2 different buttons to download the report file. Those buttons are Excel button and Excel(Details) button . The file that has been successfully download from each of the button contains different format.
Excel
File that downloaded through Excel button contain the summary of the whole Merchant transaction. The following table contains explanation related to the file content.
Header Name | Header Description | Remark |
|---|---|---|
Brand Name | Name of the brand that own by Merchant | |
I-MID | Merchant ID | |
Type | Payment method type | |
Transaction | Merchant transaction information | |
Transaction.Transaction | Total transaction proceed on each of payment method | |
Transaction.Amount | Total transaction nominal executed on each of payment method | |
Fee | Fee that Merchant must pay | |
Fee.NICEPAY | Transaction calculation on NICEPAY side | If the transaction type is Aggregator |
NICEPAY.Fee | MDR fee | |
NICEPAY.Installment Fee | MDR fee | |
NICEPAY.FDS Fee | FDS checking fee | |
NICEPAY.VAT | PPN | 11% |
NICEPAY.Total | Total fee that Merchant must pay to NICEPAY | |
Fee.Bank/Mitra.Fee | Mandatory fee paid by Merchant to Bank/Partner | |
Scheduled Settlement Amount | Amount nominal that will be received by Merchant after Settlement process | |
Scheduled Settlement Amount.From NICEPAY | Transaction calculation from NICEPAY side | If the transaction type is Aggregator |
From NICEPAY.Scheduled Settlement Amount | Amount nominal that will be received by Merchant after Settlement process | |
From NICEPAY.Hold On | Unsettled settlement amount that pending from Settlement process | Amount total is a minus originate from NICEPAY Fee from facilitator transaction, so the hold fund as debt and can't proceed to Settlement process toward Merchant |
From NICEPAY.Hold Off | Release the pending settlement amount on the next period (Hold On release) occur if the total Settlement amount is sufficient | Hold Off will decrease the total Settlement Amount (Scheduled) |
From NICEPAY.Setoff | Adding or deducting Scheduled Settlement Amount according to the resolution of certain issues | Special for Payout |
From NICEPAY.Refund | Amount nominal that going through refund process | |
From NICEPAY.Settlement Confirmation Amount | Final amount nominal that will be received by Merchant | |
Scheduled Settlement Amount.From Bank/Mitra | Transaction calculation from Bank/Partner side | If the transaction type is Facilitator |
From Bank/Mitra.Settlement Amount | Total final fee that will be received by Merchant from total transaction | |
Excel Detail
File that downloaded through Excel(Details) button contain the summary of the whole transaction and information detail from every transaction own by Merchant.
The following is the table explanation for that part.
Header Name | Header Description | Remark |
|---|---|---|
Brand Name | Name of the brand that own by Merchant | |
I-MID | Merchant ID | |
Type | Payment method type | |
From NICEPAY | Transaction calculation from NICEPAY side | If the transaction type is Aggregator |
From NICEPAY.Transaction | Merchant transaction information | |
Transaction.Number | Total transaction done on each of payment method | |
Transaction.Amount | Total transaction nominal executed on each of payment method | |
From NICEPAY.Fee | Fee that Merchant must pay to NICEPAY | |
Fee.Full Payment | MDR fee | |
Fee.Installment | MDR fee | |
Fee.NICEPAY | MDR fee | |
Fee.VAT | PPN | 11% |
Fee.Total | Total fee that Merchant must pay to NICEPAY | |
From NICEPAY.Settlement Amount(Scheduled) | Amount nominal that will proceed through Settlement process | |
Settlement Amount(Scheduled).Scheduled Amount | Amount nominal that will be received by Merchant after Settlement process | |
Settlement Amount(Scheduled).Hold On | Unsettled settlement amount that pending from Settlement process | Amount total is a minus originate from NICEPAY Fee from Facilitator transaction, so the hold fund as debt and can't proceed to Settlement process toward Merchant |
Settlement Amount(Scheduled).Hold Off | Release the pending settlement amount on the next period (Hold On release) occur if the total Settlement amount is sufficient | Hold Off will decrease the total Settlement Amount (Scheduled) |
Settlement Amount(Scheduled).Setoff | Adding or deducting Settlement Amount (Scheduled) according to the resolution of certain issues | Special for Payout |
Settlement Amount(Scheduled).Refund | Amount nominal that going through refund process | |
From NICEPAY.Settlement Amount(Scheduled) | Final amount nominal that will be received by Merchant | |
From Bank/Mitra | Transaction calculation from Bank/Partner | If the transaction type is Facilitator |
From Bank/Mitra.Transaction | Information detail related to on-going transaction process | |
Transaction.Transaction | Total on-going transactions process | |
Transaction.Amount | Total transaction amount paid by Customer | |
From Bank/Mitra.Fee | Fee that Merchant must paid to NICEPAY | |
Fee.Full Payment | MDR fee | |
Fee.Installment (Onus) | MDR fee | |
Fee.Installment (Offus) | MDR fee | |
From Bank/Mitra.Settlement Amount | Total final fee that will be received by Merchant from total transaction | |
The following table contains explanation related to the detail transaction.
Header Name | Header Description | Remark |
|---|---|---|
Date | Data collection on specific process | |
Date.Settlement | Transaction date through Settlement process | |
Date.Approved | Transaction approval date | |
Date.Purchase | Goods purchase date | |
Date.Cancelled | Transaction cancelled date | |
Merchant Information | Collection of Merchant information on a transaction process | |
Merchant Information.Brand Name | Name of {{th}} brand that own by Merchant | |
Merchant Information.I-MID | Merchant ID | |
Type | Collection of type on a transaction process | |
Type.Settlement | Settlement transaction type | |
Type.Payment Method | Payment method on a transaction |
|
Type.Status | Transaction status | |
Type.Month | To acknowledge the month of occur payment until payment is successful | |
From NICEPAY | Transaction calculation from NICEPAY side | If transaction type is Aggregator |
From NICEPAY.Transaction | Transaction proceeds by User from Merchant side | |
Transaction.Amount | Amount nominal paid by User from Merchant side on a transaction detail | Amount Settlement that have been deducted with Fee transaction and tax 11% |
From NICEPAY.Fee | Fee that Merchant must paid to NICEPAY | |
Fee.Full Payment | NICEPAY payment channel fee on the transaction | |
Fee.Installment | MDR fee | |
Fee.NICEPAY | MDR fee | |
Fee.VAT | PPN | 11% |
Fee.Total | Total fee that Merchant must paid to NICEPAY | |
From NICEPAY.Settlement | Amount information that will going through Settlement process | |
Settlement.Amount | Amount Settlement had been deduct with Fee NICEPAY and {{tax}} 11% | |
From Bank/Mitra | Merchant transaction calculation from Bank/Partner side | If transaction type is Facilitator |
From Bank/Mitra.Transaction | Transaction proceeds by user from Merchant side | |
Transaction.Amount | Amount nominal that must User paid from Merchant side on a transaction detail | |
From Bank/MitraFee | Fee that Merchant must paid to NICEPAY | |
Fee.Full Payment | Bank fee | |
Fee.Installment (Onus) | Bank fee | |
Fee.Installment (Offus) | {Bank fee | |
From Bank/Mitra.Settlement | Amount information that will going through Settlement process | |
Settlement.Amount | Amount nominal that Merchant will received | |
Bank/Mitra Type | Bank/Partner type used on the transaction | |
Bank/Mitra Type.Acquire | Name of Bank/Partner used on the transaction | |
Bank/Mitra Type.Issuer | Name of Bank/Partner used on the transaction | Specific for Credit Card transaction |
Approval Code/Account No | Account number/approval code from an on-going transaction detail | |
Order Number | Number of on-going order transaction | |
Buyer | User name that execute the transaction | |
Product Name | Product name from Merchant data | |
TID | Transaction ID | |
Batch No | Batch number to identify the transaction that going through batch process | |