EPI Payment Reconciliation Report

EPIExternal Payment Interface Payment Reconciliation report provides the status of all reconciled transactions, in a given duration. The admin user has the freedom to choose the report format – CSV or pdf.

You are here How to reach here:

Administration Dashboard > Toggle menu > Report > Report Generation

EPI Payment Reconciliation - Adhoc Report

EPI Payment Reconciliation Adhoc reports are generated on demand or on request. Reports can be requested from the 'Reports' screen. Adhoc reports can be viewed using 'My Reports' screen.

To generate the EPI Payment Reconciliation adhoc report:

Click the Adhoc tab.
From the Report Name list, select the appropriate report to be generated.
The receptive report generation screen appears.

Field Description

Field Name	Description
Report Name	The type of report to be generated.
Report Format	The format in which report is to be generated. The options with Oracle Business Intelligence (BI) Publisher are: PDF XLS The options with Internal Reporting Application are: PDF CSV
Merchant Code	The unique code assigned to a specific merchant by the Bank.
Duration	The period for which the report is to be generated. Start date of the date range from which you want to generate the report. End date of the date range up-to which you want to generate the report.

From the Report Format list, select the appropriate report output format.
In the Merchant Code field, enter the merchant's code for whom the report to be generated.
From the Duration - From Date and Duration - To Date list, select the appropriate duration.
Click Generate Report to generate the report.
OR
Click Clearto reset the search parameters.
OR
Click Cancel to cancel the transaction.
The success message of request along with the status and Report Request Id and Reference Number appears . Click Done to complete the transaction.
OR
Click on the Report Request Id link to download the report. User is directed to My Reports screen. The list of reports appears.
Click on desired Report ID to view and download the generated report. You can download the report in PDF, XLS, and CLV formats.

Note: You can also download the requested report from Administration Dashboard > Report > My Reports.

For reference, a specimen of the report generated is given below:

Generated Adhoc report

Field Description

Field Name	Description
Report Parameters
Merchant Description	The description of the merchant.
Merchant Code	The unique code assigned to a specific merchant by the bank.
Date From	The start date of period for which the report is generated.
Date To	The end date of the date for which the report is generated.
Date Time	Transaction date and time.
Transaction ID	The transaction Id of the transaction.
Description	The description of the transaction.
Customer Name-Account Number	The name and account number of the customer.
Merchant Account Number	The merchant's account number.
Transaction Type	The transaction type. The options are: Sale Commission
Amount, CCY	The amount of the transaction in local currency.
Status	The status of the transaction.

Home