Skip to main content

Reconcile booking data between Billing and Revenue

Zuora

Reconcile booking data between Billing and Revenue

Billing to Revenue Booking Report allows you to easily identify the booking data mismatch between Zuora Billing and Zuora Revenue Line Staging. This report runs the reconciliation by comparing the data on the Rate Plan Charge object.

Procedure

  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: Select a start date and an end date. The Rate Plan Charge data that fall into this period will be reconciled.
  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. Billing to Revenue Billing Report
  5. To locate the root cause of the discrepancy, you can click the Run Detail Report button in the 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. 

Results

The mismatched transactions are displayed in the Billing to Revenue Booking Report Layout table. The Reason Message column describes the reason for the mismatch. 

What to do next

Submit a request at Zuora Global Support for troubleshooting assistance.

Known limitations

Currently, the following limitations are applicable to this report:

  • The report can only be run against the Rate Plan Charge object.