Settlement Reconciliation Report
XiRecon provides a consolidated view via the Settlement Reconciliation Report within SAP of the end-to-end processing status of settlement batches and details from SAP, Paymetric Gateway, and the Processor.
Requires a Reconciliation RFC be configured in SAP, PCMA and PAS. The report lists such items as the batch status, G/L information, reconciliation details, errors, and transaction detail. If the Reconciliation RFC has not been configured on your system, the report will yield no results.
Use SAP's standard customization functionality to select hidden fields or select only certain columns to be displayed in your report and create variants for user-specific reporting. Users must have security authorization to view the requested documents (when clicking on a hotspot, e.g. ).
Click the Legend icon in SAP for reference to the color coding displayed in the report.
Procedure
-
Go to the Settlement Reconciliation Report menu option on the PCMA main menu (program /PMPAY/RECON).
-
Enter the Settlement Batch Number, or click on the drop-down list to select the batch number.
-
Enter the Batch submission date or a date range.
Only reportable settlement batches for reconciliation (starting from the time XiRecon is configured) are available in the drop-down list.
Reporting is not possible for batches submitted prior to the date that XiRecon was configured. Meaning the RFC Destination was configured in the PCMA Execution Settings and PAS.
-
(Optional) Enter the Company Code, Credit Card Type, or Reconciliation Date.
-
Select to receive a Summary or Detail report.
-
In the RFC Information section, select the desired setting.
-
Run Report Only (No Refresh) – The report is generated using all the data currently stored in SAP. This option does not make the RFC call thus not impacting system performance if this is an issue.
-
Refresh XiPay Data & Run Report – Transaction data in SAP is refreshed based on the status in XiPay and the Settlement Reconciliation Report displays. Refresh only occurs for batches with Incomplete transaction status and based on the selection criteria designated. If you select this option, the Ping reconciliation dest field will appear with the default selected when your system was configured. Do NOT modify this value.
-
Refresh XiPay Data Only – No report is displayed. Updated status is loaded in SAP. Can be used, for example, if you want to schedule a nightly job to be refreshed and have data available the following morning. Refresh only occurs for batches with Incomplete transaction status and based on the selection criteria designated. If you select this option, the Ping reconciliation dest field will appear with the default selected when your system was configured. Do NOT modify this value.
-
-
Do NOT modify Ping reconciliation dest. This field defaults from the Execution Settings.
-
Choose a Display variant if necessary. Refer to SAP Help for selecting or hiding fields to display in your report and creating a Display variant.
-
Click Execute. The report displays (unless you selected Refresh XiPay Data Only in Step 5). See the following for an example and field descriptions for the Summary and Detail level reports.
Summary Level Example
Summary level field descriptions
| Field | Data Source | Description and Hot Spot Information | Hidden or Displayed by Default? |
|---|---|---|---|
|
Batch No |
SAP |
Batch number If the Batch number is 999- with status XiPay Refresh Required, this indicates a new batch that was submitted for settlement but the data has never been updated from XiPay. This would only occur if you choose "Run Report Only (No Refresh) in step 5. Hot spot: Directs you to the SRR report detail for for that batch. |
Displayed |
|
Batch Status No |
PAS |
XiPay numeric status code for the batch Displayed Batch Status XiPay Text description of the batch status numeric code Highlighted Red if the batch was settled but never refreshed for a new batch status. |
Displayed |
|
Co Cd |
SAP |
Company Code |
Displayed |
|
G/L Acct |
SAP |
General ledger account |
Displayed |
|
Merchant |
SAP |
Merchant |
Displayed |
|
Settled On |
SAP |
Settled on Date |
Displayed |
|
1st Settled Date |
SAP |
First Settlement Date |
Hidden |
|
1st Settled Time |
SAP |
First Settlement Time |
Hidden |
|
Batch Settle Amt |
SAP |
Batch settlement total amount regardless of report selection criteria. Amounts are highlighted yellow when the selection criteria results in a partial batch. For example, if you have multiple card types in a batch but limit criteria to only VISA, this amount will still reflect the entire batch, including the other card types. |
Conditional - only displayed when a batch is partial based on selection criteria |
|
Number of Batch Items |
SAP |
Total number of items settled in the batch regardless of report selection criteria |
Conditional - only displayed when a batch is partial based on selection criteria |
|
Select Set |
SAP |
The SAP amount based on the selection criteria of the report. |
Displayed |
|
Select Items |
SAP |
Items based on selection criteria |
Displayed |
|
Crcy |
SAP |
Currency |
Displayed |
|
XiPay Amount |
XiPay |
The total settlement amount received by XiPay. Includes transactions that are in a status of 100 through 210. Excludes any negative transaction status numbers as those indicate erred transactions. |
Displayed |
|
XiPay Items |
XiPay |
Number of items within the Batch in XiPay that meet the XiPay Amount calculation criteria. |
Displayed |
|
Confirm Amount |
XiPay |
Amount acknowledged as received by the Processor. These items passed the XiPay Cartridge and the initial Processor validations. Includes transactions that are in a status of 300, 310, or 350. Excludes any negative transaction status numbers as those indicate erred transactions. |
Displayed |
|
Confirm Items |
XiPay |
Number of items acknowledged as received by the processor that meet the Confirm Amount criteria. |
Displayed |
|
Recon Amount |
XiPay |
The amount of transactions that are marked as complete within the batch. Includes only those transactions that are in a status of 400. |
Displayed |
|
No. Reconciliation Items |
XiPay |
Number of items for the transactions that are marked as Complete (status 400) in XiPay. Number of reconciliation items based on calculation method of Recon Amount. |
Displayed |
|
Refresh Dt |
|
Last date that the data was requested from XiPay. (I.e. last date the getbatchstatus operation was last run via the RFC.) |
Displayed |
|
Refresh Time |
|
Last time that the data was requested from XiPay. (I.e. last time the getbatchstatus operation was last run via the RFC.) |
Displayed |
|
Posted (Settlement Doc Posted) |
SAP |
Indicates that the settlement document belonging to this settlement has been posting in financial accounting. An 'X' indicates it has been posted; blank indicates it has not been posted. |
Hidden |
|
Ok |
SAP |
Indicates successful settlement |
Hidden |
|
Errors |
SAP |
|
Hidden |
|
Settled By |
SAP |
SAP user name that submitted the settlement batch. |
Hidden |
|
Last Settled By |
SAP |
The user name who performed settlement resubmission if applicable. |
Hidden |
|
Last Settled Time |
SAP |
The time that the batch was resubmitted for settlement if applicable. |
Hidden |
Detail Level Example
Detail level field descriptions
| Field | Data Source | Description and Hot Spot Information | Hidden or Displayed by Default? |
|---|---|---|---|
|
Batch No |
SAP |
Batch number |
Displayed |
|
Transaction Status No |
XiPay |
Transaction Status number |
Displayed |
|
Transaction Status |
XiPay |
Transaction Status |
Displayed |
|
SAP Settle Date |
SAP |
SAP Settlement Date |
Displayed |
|
SAP Settle Time |
SAP |
SAP Settlement Time |
Hidden |
|
Auth Date |
XiPay |
Authorization Date |
Hidden |
|
Auth Time |
XiPay |
Authorization Time |
Hidden |
|
Recon Date |
XiPay |
Reconciliation Date |
Displayed |
|
Doc. No |
SAP |
Document number Hot spot: View accounting document |
Displayed |
|
Co Cd |
SAP |
Company Code |
Displayed |
|
Clearing doc |
SAP |
Clearing Document number Hot spot: View accounting document |
Displayed |
|
Document Type |
SAP |
Document Type Displayed Bill doc SAP Billing Document Hot spot: View billing document |
Displayed |
|
Revs Doc |
SAP |
Reversal Document Hot spot: View accounting document |
Conditional - displays only when a transaction is reversed |
|
Card Type |
SAP |
Card Type |
Displayed |
|
Sales Doc |
SAP |
Sales Document number Hot spot: View sales document |
Hidden |
|
SaTy |
SAP |
Sales document type |
Hidden |
|
Sales Org |
SAP |
Sales Organization |
Hidden |
|
Dchil |
SAP |
Distribution Channel |
Hidden |
|
Dv |
SAP |
Division |
Hidden |
|
Bill Type |
SAP |
Billing Type |
Hidden |
|
Card Number |
SAP |
Credit Card number |
Hidden |
|
Name of cardholder |
SAP |
Name of Cardholder |
Hidden |
|
Exp date |
SAP |
Expiration Date |
Hidden |
|
Sold to pt |
SAP |
Sold-to Party Hot spot: View customer/payer |
Hidden |
|
Payer |
SAP |
Payer Hot spot: View customer/payer |
Hidden |
|
Name1 |
SAP |
Customer Name |
Hidden |
|
Auth No |
SAP |
Authorization number |
Hidden |
|
Auth Ref Code |
SAP |
Authorization Reference Code |
Hidden |
|
Settled amount |
SAP |
Settled Amount |
Displayed |
|
Curr |
SAP |
Currency |
Displayed |
|
Reconciled amount |
XiPay |
This is the settled/promised to deposit amount. It will include only those transactions with a status of 400 Complete. |
Displayed |
|
Unreconciled amount |
XiPay |
This is the SAP settlement amount minus the reconciled amount. |
Displayed |