Settlement Reporting - SAP Batch Reconciliation

The settlement process in SAP is a send and forget type process, meaning there is no immediate feedback on the success of the data transfer to XiPay On-Demand nor to the processor. Therefore, SAP Settlement runs should be validated on a daily basis to ensure the expected funds are being processed. Since settlement runs are typically scheduled as batch jobs in the evenings after the billing run, this validation is usually performed the following morning.

Procedure

The following steps outline the typical daily settlement reconciliation that should occur after the settlement runs are complete in SAP:

  1. Validate Batches in SAP

    1. Review the SAP Settlement Batch Spool File results to validate all settlement batch runs ended successfully.

    2. Review the SAP Settlement Log reports for each batch to validate all batches were successfully cleared and logged in SAP.

      1. Use any or all of the following methods as desired:

        1. SAP transaction FCC4 - the SAP Settlement Batch Log. This displays the header details of the batch - transmission date, amount, # of items, clearing document number, etc.

        2. SAP transaction FCCR – a collection of standard SAP reports for reviewing settlement transactions. This displays information about each individual transaction in a batch.

        3. FI Report Documents by Settlement Batch Number - Custom report shows more detailed information than transaction FCC4 about each individual transaction in a batch. This report also offers a better breakdown by credits and debits with subtotals and grand totals.

        4. FI Report Documents by Settlement Date Range - Custom report, showing more detailed information than transaction FCC4, regarding individual transactions across settlement batches and based on a date range specified in the selection screen. Has a better breakdown by credits and debits with subtotals and grand totals.

  2. Validate Batches in XiPay

    1. Review the batch results in the XiPay Server to ensure they were all successfully received, validated, and sent to the processor(s). From the Virtual Terminal Reports menu, click Settled Reports and review the results of the batches in question.

    2. Locate the Batch ID in XiPay that matches the Batch ID or settlement run number from SAP.

    3. Validate the settlement total in XiPay matches the settlement total from SAP and the total transactions per batch are as expected.

    4. Drilling into the Batch ID should display the transactions in the batch and the status of all transactions should be 'Complete'.

  3. Validate Batches at the Processor

    1. Review the settlement results with the processor(s) to ensure they were all successfully received and processed. Logon or call your bank/processor(s) to verify the settlement files were received and approved. Validate the Settlement total matches the settlement total from SAP and XiPay and the total transactions per batch are as expected.

  4. Validate Funding with Merchant Bank

    1. Ensure that the amount deposited matches the settlement total from SAP and XiPay.