--- title: MMS - Settlement Report File slug: en/mms-settlement-report-file description: Information about the Settlement Report file uses by Merchant to check report regarding Settlement image: https://archbee-image-uploads.s3.amazonaws.com/ZHvSjR5ZrsoxwKbJa3xmo/r1w6ci_qCmYnMAo3arm5-_microsoftteams-image.png icon: {"faIcon":"fa-solid fa-book-atlas"} docTags: createdAt: 2023-11-21T07:24:34.201Z --- # 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](docId\:QWF7iJF4RNAmK4sPiFoy1) 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 ![](https://api.archbee.com/api/optimize/ZHvSjR5ZrsoxwKbJa3xmo/A8muY8iZR_NIoQnmENwIO_image.png "Settlement Report - 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. ::embed[]{url="https://youtu.be/IZ6hgs9tO4Y"} | **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 ![](https://api.archbee.com/api/optimize/ZHvSjR5ZrsoxwKbJa3xmo/vE1KeiCDgPcrk-NKHkHjV_3.png "Settlement Report - 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. ::embed[]{url="https://youtu.be/IZ6hgs9tO4Y"} The following is the table explanation for that part. ![](https://api.archbee.com/api/optimize/ZHvSjR5ZrsoxwKbJa3xmo/dpgxkq9NR9nwb9KORVYK3_1.png "Settlement Report - Excel(Detail) - Summary") | **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 | | ![](https://api.archbee.com/api/optimize/ZHvSjR5ZrsoxwKbJa3xmo/KTWVTSJVIqh-ZbEoFrxE-_2.png "Settlement Report - Excel(Detail) - Each Transaction Detail") 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 | - MA - Aggregator - PG - Facilitator/Direct | | `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 | |