Merchant Card Reconciliation

How do I access the merchant reconciliation report?

These reports are actually "queries" and are available in the PeopleSoft Financials Reporting instance. Anyone who is a financial system user should automatically have access to this instance and the reconciliation queries.You can access this instance from One Stop.

Follow these steps:

1. Go to the One Stop Staff page.
2. In the column just to the right of center (titled Administrative Tools), scan down to the section titled PeopleSoft Enterprise Financial System (EFS).
3. Select the second link in this section - EFS financial reporting.
4. Log in with your M Key.
5. Navigation: Reporting Tools > Query > Query Viewer

The first report is the revenue reconciliation report named UM_DBI_MERCHANT_REVENUE_RPT. This report contains daily activity data.

The second report is the merchant payment reconciliation report named UM_FAR_MERCHANT_CLEARING_RPT. This report does not currently have data. This data should be populated within about one week (information provided on 7/16/2008).

The online training course from Training Services called "Bank Card Reconciliation" outlines how to use these queries and perform the reconciliation. This training is recommended for those involved in the merchant card process reconciliation.