If you wish to have access to this feature, submit a request at Zuora Global Support.
What Is Gateway Reconciliation?
Gateway reconciliation is the process of verifying that the electronic payment and refund transactions processed in Zuora match the transactions reported by the gateway. For example, if Zuora processed 200 transactions through a gateway, you should see the same number of transactions on the gateway's reconciliation report, sometimes also called the settlement report.
A settlement report usually includes events from the following three stages of a payment's lifecycle:
- Processing event indicating that Zuora submitted the payment to the gateway.
- Settlement event indicating that the payment has been successfully debited from the payer and credited to the payee. For credit cards, settlement can take up to three business days. With some payment methods, like direct debit, it's possible that settlement fails.
- Post-settlement events are usually exceptions, like chargebacks for credit cards and reversals for other payment methods. These types of events indicate that the customer has taken an action through their bank that affects the payment.
Zuora Gateway Reconciliation feature supports retrieval and recording of gateway's payment processing, settlement, and post-settlement events, to aid in the gateway reconciliation efforts.
Gateway Reconciliation only applies to the gateway state of the payment or refund transaction. Cash Reconciliation is the actual financial information of the amount that was settled, the fees charged, and potential currency exchange performed. Cash reconciliation is not supported at this time. Zuora does not support reconciliation of refunds that are rejected. Only settled refunds are supported for gateway reconciliation.
How Does Gateway Reconciliation Work?
Most gateways produce settlement reports on a daily basis. Zuora follows the schedule appropriate for each gateway, which is usually daily, and retrieves the appropriate gateway reconciliation report for processing in a job. Within a reconciliation job, every record in the report is parsed into an event and matched with the corresponding Zuora transaction. Zuora then takes the appropriate action based on the event information received and logs it. The following table lists the event types and the actions taken for each event:
|Successful Settlement||Zuora updates the Gateway State to "Settled" and the Settled On date field of a Payment transaction.|
Optionally, Zuora creates an External Refund with the Reason Code set to "Payment Reversal".
Zuora provides a feature to disable payment reversal in Gateway Reconciliation chargeback events. With this feature enabled, Zuora will not create an External Refund when a Post-Settlement Exception occurs, and you need to use your own logic to process the settlement events. By default, this feature is disabled.
This feature is in Limited Availability. If you want to have access to the feature, submit a request at Zuora Global Support.
|Unknown Transaction||Zuora just logs the event and does not take any action.|
|Unmapped Event||Zuora just logs the event and does not take any action.|
Configuring Gateway Reconciliation
If you have the Multi-entity feature enabled, you must apply for a merchant account for each entity. Use the corresponding merchant ID to configure the payment gateway instance for each entity.
Gateway reconciliation is currently supported by the following gateways:
- Adyen Gateway
- Adyen Integration v2.0
- Gulf Management Systems
- PayPal Express Checkout
- Chase Orbital
- Merchant eSolutions
- WorldPay 1.4 (See Configuring WorldPay Gateway Reconciliation to lean more.)
To use gateway reconciliation, select the Enable gateway reconciliation check box in the configuration page for the preceding gateways. Ensure that you have enabled the "Issue External Refund" payments permission, and the "Unapply Payment" payments permission if the Invoice Settlement feature is enabled in your tenant. Contact your tenant administrator to update your user role or corresponding permissions.
Viewing a Gateway Reconciliation Job
Zuora strongly recommends you to enable the Gateway Reconciliation Job Completion | Reconciliation Completed notification when you are using the Gateway Reconciliation feature. You will get notified when a Gateway Reconciliation job is completed or encounters an error. See Edit a Notification for more information.
- Navigate to Payments and select the Gateway Reconciliation.
The Gateway Reconciliation page lists the following information:
|Job Number||The number assigned to the job for a particular reconciliation period.|
|Period Start||This is the earliest date for which reconciliation events are expected for this job.|
|Period End||This is the latest date for which reconciliation events are expected for this job.|
|Gateway Name||The name of the gateway for which the source information will be retrieved.|
|Source Name||The source from which the reconciliation report information will be retrieved. For example, the file name of the gateway settlement report.|
The status of the reconciliation job.
|Last Attempt On||The last time the system attempted to retrieve source information from the gateway.|
|Completed On||The time indicating when the job completed.|
- Click on the Job Number from the Gateway Reconciliation page to view the job details.
The gateway reconciliation job detail page provides the following information:
|Status||The status of the reconciliation job.|
|Creation Date||Time when the job was created.|
|Period Start||The period of time in which reconciliation started for this particular job.|
|Period End||The period of time in which reconciliation ended for this particular job.|
|Gateway Type||The type of gateway used.|
|Gateway Name||The name of the gateway from which the source information will be retrieved.|
|Attempt||The number times the job has been submitted. If the initial attempt fails, the system will not retry automatically. The retrieval can be retried manually.|
|Start Date||Date when the attempt has started.|
|End Date||Date when the attempt ended.|
|Source Name||The name of the reconciliation report that is being retrieved.|
The result of the attempt.
|Reason||Only provided when the attempt fails, giving the reason for the failure.|
Recovering from a failed Gateway Reconciliation Job
If the initial attempt to retrieve a gateway reconciliation report fails, the job's Status will say Error. Jobs can fail for a variety of reasons. The following is a list of common errors:
- Zuora could not connect to the gateway to retrieve the source information. This can happen, if for example, the credentials were incorrect.
- Zuora was able to connect, but could not find the source settlement report, perhaps because the automatically generated source file name was wrong for some reason.
- Zuora connected and retrieved the file, but could not parse it. This can happen when the source file is created manually for testing, rather than by a well defined automatic process.
Once the first job attempt fails, Zuora will not retry retrieving the report. However, you have three options in which to retrieve the report:
Simply retries retrieving the report using the same default job information.
|Retry Upload File||
Retries retrieving the report by allowing an upload of a file from your local directory.
|Retry File Name||
Retries retrieving the report using the specified file/source name.