Knowledge Center

Knowledge Center > Billing and Payments > Payment Gateways > Gateway Reconciliation

Gateway Reconciliation

This feature is in Limited Availability. If you wish to have access to the 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:

  1. Processing event indicating that Zuora submitted the payment to the gateway.
  2. Settlement event indicating that the payment has been successful 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.
  3. 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.

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:

Event Type Action
Successful Settlement Zuora updates the Gateway State to "Settled" and the Settled On date field of a Payment transaction.
Settlement Error
  • Zuora updates the Gateway State to "Failed to Settle" on the Payment transaction
  • Zuora creates an External Refund with the Reason Code set to "Payment Rejection"
  • Zuora updates Failed Payment count on the corresponding Payment Method
Post-Settlement Exception

Optionally, Zuora creates an External Refund with the Reason Code set to "Payment Reversal"

Automatic handling of this event type is not enabled by default. Contact Zuora Global Support if you are interested in enabling this part of the automation.

Unknown Event Zuora just logs the event and does not take any action.

Configuring Gateway Reconciliation

To use gateway reconciliation, you have to add and configure a gateway appropriately, by navigating to Z-Payment Settings > Setup Payment Gateway.

Gateway reconciliation is currently supported by the following gateways:

Viewing a Gateway Reconciliation Job

  1. Navigate to Payment Operations and select the Gateway Reconciliation tab.

gateway_reconciliation.png

The Gateway Reconciliation page lists the following information:

Column Name Description
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.
Status

The status of the reconciliation job.

  • Processing -- The job is processing.
  • Completed -- The job has completed and the report was successfully processed.
  • Error -- The job failed due to an error. The job details page provides additional information.
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.
  1. Click on the Job Number from the Gateway Reconciliation page to view the job details.

gateway_reconciliation_report.png

The gateway reconciliation job detail page provides the following information:

Basic Information
Job Field Description
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 History
Job Field Description
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.
Result

The result of the attempt.

  • Succeeded
  • Failed - See the Reason field for more details.
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:

Retry Option Description
Retry

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.

 

Last modified
14:18, 27 Jun 2016

Tags

Classifications

(not set)