Batch Gateway Reconciliation on FiservIPG
Zuora's FiservIPG integrations support the following event types for Batch Gateway Reconciliation :
- Payment
- Refund
If gateway reconciliation is enabled, Zuora retrieves settlement information from FiservIPG on a daily basis. The Gateway Reconciliation job for FiservIPG is scheduled to start at 19:00 pm (PST) every day.
Prerequisites for enabling gateway reconciliation in Zuora
Before enabling gateway reconciliation in your Fiserv IPG gateway instance, complete the following tasks in your Fiserv IPG merchant account:
- Download the reconciliation files provided by Fiserv IPG from the SFTP server.
- Create report user credentials in the Fiserv IPG gateway to receive the settlement reports. The report user credentials will be entered in the Reconciliation Username and Reconciliation Password fields in the configuration page of the Fiserv IPG gateway instance. Report user credentials usually have the prefix report_ and are different from the credentials used for web service transactions.
Enable gateway reconciliation in Zuora
To enable batch gateway reconciliation:
- Click your username in the upper right and navigate to Settings > Payments > Setup Payment Gateway.
- On the Configure Gateway Instance tab, click the Fiserv IPG Gateway instance for which you want to enable the Gateway Reconciliation service.
- On the Gateway Instance Configuration page, select Enable gateway reconciliation and configure the following credentials:
- Reconciliation Username: SFTP username for the reconciliation.
- Reconciliation Password: SFTP password for the reconciliation. This password expires every three months.
For more detailed information, see Set up and configure FiservIPG integration.
Status mapping
The following table describes how different transaction status is mapped to the corresponding gateway reconciliation event type:
Gateway Field | Zuora Field |
---|---|
UNIQUE_TRAN_ID(lpgTransactionId) |
gatewayReferenceId |
CUSTOM_ DATA |
gatewaySecondReferenceId |
TRAN_ TYPE |
Not Mapped |
TRAN_ AMT |
Amount |
TRAN_ DATE |
eventDate |
TRAN_ STAT |
reconciliationEventType |
Not Applicable | gatewayRawRecord |
Not Applicable | attemptId |
Not Applicable | currencyCode |
Reconciliation files only contain records for successful payments. If a transaction record is not received in the reconciliation file, its gateway state will remain Submitted and will not automatically change to Settled.