> This page is for Docs.

> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://zuora.ferndocs.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://zuora.ferndocs.com/_mcp/server.

# Gateway Reconciliation Log data source

> Data source to export Gateway Reconciliation Log data

Data source to export Gateway Reconciliation Log data

Use this data source to export Gateway Reconciliation Log data. This data source only includes the events, by job, that matched a Zuora transaction. Use this data to identify which transactions have been actually reconciled.

## Accessing the data source

Navigation: **Reporting > Data Sources** and select **Gateway Reconciliation Event** as the data source.

## Objects available in the data source

![gateway reconciliation log datasource](/_fern-img/2c51e079760ff79070d38dc8305f6184cbd885a4634384f8004ca405f7a63479.webp)

## Gateway reconciliation log

<table>
  <tr>
    <th>
      Object
    </th>

    <th>
      Description
    </th>
  </tr>

  <tr>
    <td>
      Created Date
    </td>

    <td>
      Time the job was created.
    </td>
  </tr>

  <tr>
    <td>
      Created Object ID
    </td>

    <td>
      The result of the event processing.
    </td>
  </tr>

  <tr>
    <td>
      Created Object Type
    </td>

    <td>
      The type of result of the even processing. Currently, the only result type is Refund.
    </td>
  </tr>

  <tr>
    <td>
      Error Code
    </td>

    <td>
      The code assigned to a specific gateway error.
    </td>
  </tr>

  <tr>
    <td>
      Error Message
    </td>

    <td>
      The message associated with a specific gateway error code.
    </td>
  </tr>

  <tr>
    <td>
      ID
    </td>

    <td>
      The reconciliation ID.
    </td>
  </tr>

  <tr>
    <td>
      Related Object ID
    </td>

    <td>
      The object influenced by the event.
    </td>
  </tr>

  <tr>
    <td>
      Related Object Type
    </td>

    <td>
      Related object types are:

      * Payment
      * Refund
    </td>
  </tr>

  <tr>
    <td>
      Status
    </td>

    <td>
      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.
    </td>
  </tr>
</table>

## Gateway reconciliation event

<table>
  <tr>
    <th>
      Object
    </th>

    <th>
      Description
    </th>
  </tr>

  <tr>
    <td>
      Amount
    </td>

    <td>
      The event amount returned by the gateway.
    </td>
  </tr>

  <tr>
    <td>
      Created Date
    </td>

    <td>
      Time the job was created.
    </td>
  </tr>

  <tr>
    <td>
      Event Date
    </td>

    <td>
      Event execution date.
    </td>
  </tr>

  <tr>
    <td>
      Event Type
    </td>

    <td>
      The event types are as follows:

      * Transaction Settled
      * Transaction Rejected
      * Transaction Reversed
    </td>
  </tr>

  <tr>
    <td>
      Gateway Raw Record
    </td>

    <td>
      The gateway response string.
    </td>
  </tr>

  <tr>
    <td>
      Gateway Reason Code
    </td>

    <td>
      The error code returned by the gateway.
    </td>
  </tr>

  <tr>
    <td>
      Gateway Reason Message
    </td>

    <td>
      The reason message corresponding to the Gateway Reason Code.
    </td>
  </tr>

  <tr>
    <td>
      ID
    </td>

    <td>
      The gateway reconciliation event ID.
    </td>
  </tr>

  <tr>
    <td>
      Related Gateway Reference ID
    </td>

    <td>
      This is used in relation to the payment gateway transaction.
    </td>
  </tr>

  <tr>
    <td>
      Related Gateway Second Reference ID
    </td>

    <td>
      This is used in relation to the payment gateway transaction.
    </td>
  </tr>
</table>

## Gateway reconciliation job

<table>
  <tr>
    <th>
      Object
    </th>

    <th>
      Description
    </th>
  </tr>

  <tr>
    <td>
      Created Date
    </td>

    <td>
      Time when the job was created.
    </td>
  </tr>

  <tr>
    <td>
      Gateway
    </td>

    <td>
      The name of the gateway from which the source information will be retrieved.
    </td>
  </tr>

  <tr>
    <td>
      ID
    </td>

    <td>
      The job ID.
    </td>
  </tr>

  <tr>
    <td>
      Job Number
    </td>

    <td>
      The number assigned to the job for a particular reconciliation period.
    </td>
  </tr>

  <tr>
    <td>
      Period End
    </td>

    <td>
      This is the latest date for which reconciliation events are expected for this job.
    </td>
  </tr>

  <tr>
    <td>
      Period Start
    </td>

    <td>
      This is the earliest date for which reconciliation events are expected for this job.
    </td>
  </tr>

  <tr>
    <td>
      Status
    </td>

    <td>
      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.
    </td>
  </tr>
</table>

## Entity

<table>
  <tr>
    <th>
      Zuora object
    </th>

    <th>
      Description
    </th>
  </tr>

  <tr>
    <td>
      Entity
    </td>

    <td>
      The entity that the data relates to. Part of the [Multi-entity](/docs/platform/user-management/multi-entity/overview-of-multi-entity) feature. Contains the following fields:

      * Address 1
      * Address 2
      * City
      * Country
      * Created By ID
      * Created Date
      * Display Name
      * Email
      * ID
      * Name
      * Postal Code
      * State
      * Updated By ID
      * Updated Date
    </td>
  </tr>
</table>