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 docid\ qwf7ijf4rnamk4spifoy1 {{menu}} mms settlement report file on {{settlement}} report {{menu}} , there are 2 different {{button}} s to {{download}} the report file those {{button}} s 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 {{download}} ed 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 {{paymentproduct}} method type transaction {{merchant}} {{transaction}} {{information}} transaction transaction total {{transaction}} {{proceed}} on each of {{paymethod}} transaction amount total {{transaction}} nominal executed on each of {{paymethod}} 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 {{download}} ed 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 {{paymentproduct}} 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 {{paymethod}} transaction amount total {{transaction}} nominal executed on each of {{paymethod}} 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 {{transaction}} s {{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 {{paymentproduct}} 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 {{proceed}} s 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 {{proceed}} s 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 {{cc}} {{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}}