Welcome to Zuora Product Documentation

Explore our rich library of product information

Billing and Revenue data booking reconciliation: Procedure

Learn how to reconcile booking data between Billing and Revenue

  1. Navigate to Data Interface > Revenue Sync > Billing to Revenue Booking Report. The Billing to Revenue Booking Reconciliation Report page is displayed.
  2. Specify the following filter conditions:
    • Entity: If you have multiple Zuora Billing entities, select an entity that you want to compare the Revenue data with. If you have only one Billing entity, the entity Id is automatically populated and you can skip this step.

    • Currency: Select the target currency code for which you want to do the reconciliation.

    • RPC Updated Date: If the BOOKING_RECON_BY_RPC_UPDT_ DT profile is set to Yes, the booking reconciliation process will run based on the last updated date of the rate plan charge. Specify the time range for the RPC updated time.

    • Subscription Last Booking Date: If the BOOKING_RECON_BY_RPC_UPDT_ DT profile is set to No, the booking reconciliation process will run based on the last booking date of the subscription. Specify the time range for the SO last booking date.

  3. Click Start Billing to Revenue Reconciliation. If the job is successfully submitted, the corresponding report is displayed in the Billing to Revenue Booking Report History table.
  4. Hover over the job in the table and click icon-view.png . The summary information of the report is then displayed.
  5. To locate the root cause of the discrepancy, in the pop-up window, click Run Detail Report. You are then directed to the Billing to Revenue Booking Report reporting page where you can check the detailed report.
  6. From the Rate Plan Charge Type dropdown list, select the charge type upon which the report will be run. The following options are available for selection:
    • All (default)

    • OneTime

    • Recurring

    • Usage

  7. From the Transaction Currency dropdown list, select the currency upon which the report will be run. The available options are the currencies defined in your Zuora Billing tenant.
  8. Click Run Report to run the report. If the job is successfully submitted, the corresponding report is displayed in the Billing to Revenue Booking Report Layout table.

    For information on what to do next, refer to What to do next.