AYA Card Transaction Fee Shared Calculator

Upload CSV files and recalculate FEE values automatically

MDR: {{ mdrStatusText }}

Upload Transaction File

Drop your CSV file here or click to browse

AYA_DAILY_SETTLED_REPORT format

{{ csvFile.name }}

{{ formatFileSize(csvFile.size) }}

Processing Progress

{{ progressMessage }}

Processing Results

Total Records

{{ filteredData.length }} / {{ processedData.length }}

Total FEE

{{ formatCurrency(totalFee) }}

Avg FEE

{{ formatCurrency(avgFee) }}

Filters

{{ filters.SOURCE.length }} selected
{{ filters.TXN_ENTRY_MODE.length }} selected
{{ filters.MCC_ID.length }} selected
{{ filters.TXNTYPE_ID.length }} selected

Data Preview

Showing {{ displayRange.start }}-{{ displayRange.end }} of {{ displayRange.total }} records
CARD_NO CRDBRAND_ID APPROVED_AMT SOURCE TXN_ENTRY_MODE MCC_ID FEE MERC_MDR_AMT
{{ row['CARD_NO '] || row.CARD_NO }} {{ row[' CRDBRAND_ID '] || row.CRDBRAND_ID }} {{ row[' APPROVED_AMT '] || row.APPROVED_AMT }} {{ row[' SOURCE '] || row.SOURCE }} {{ row[' TXN_ENTRY_MODE '] || row.TXN_ENTRY_MODE }} {{ row[' MCC_ID '] || row.MCC_ID }} {{ formatCurrency(row.FEE) || '-' }} {{ row.MERC_MDR_AMT }}
Page of {{ totalPages }}

Error Processing File

{{ errorMessage }}

MDR Data Management

Current Status

{{ mdrStatusText }}
{{ mdrRecordCount }} records
Last updated: {{ formatDate(mdrLastUpdated) }}

Upload MDR File

{{ mdrUploadStatus.message }}

Download Current MDR

Download current MDR data for editing

Initialize from Static File

Load initial MDR data from the static MDR.xlsx file

MDR Data Preview

MCC_ID MCC_NAME TYPE MDR DEBIT_ISSUER CREDIT_ISSUER GROUP
{{ record.MCC_ID }} {{ record.MCC_NAME }} {{ record.TYPE }} {{ formatValueForDisplay(record.MDR, 'MDR') }}{{ getDisplaySuffix(record.MDR, 'MDR') }} {{ formatValueForDisplay(record.DEBIT_ISSUER, 'DEBIT_ISSUER') }}{{ getDisplaySuffix(record.DEBIT_ISSUER, 'DEBIT_ISSUER') }} {{ formatValueForDisplay(record.CREDIT_ISSUER, 'CREDIT_ISSUER') }}{{ getDisplaySuffix(record.CREDIT_ISSUER, 'CREDIT_ISSUER') }} {{ record.GROUP }}

{{ mdrData.length }} records total

Merchant MDR Data Management

Current Status

{{ merchantMdrStatusText }}
{{ merchantMdrRecordCount }} merchant records
Last updated: {{ formatDate(merchantMdrLastUpdated) }}

Upload Merchant MDR File (POS_Merchant_DB.xlsx)

{{ merchantMdrUploadStatus.message }}

Download Current Merchant MDR

Download current merchant MDR data for review

Merchant MDR Data Preview (First 50 records)

MID_MMK MID_USD {{ colName }}
{{ record.MID_MMK || '-' }} {{ record.MID_USD || '-' }} {{ record[colName] !== null && record[colName] !== undefined ? record[colName] : '-' }}

{{ merchantMdrData.length }} merchant records total (showing first 50)